Question 1

Databases that receive real-time transaction data are called Online Transaction Processing OTLP) systems.

Accepted Answer

Online Transaction Processing (OLTP) systems are designed to handle real-time transaction data.

Question 2

According to a study conducted by MIT Sloan Management Review and IBM, top performing companies use BI and business analytics for both tactical financial insights
e.g. forecasting, budgeting and supply chain management) as well as strategic issues like developing competitive advantages.

Accepted Answer

The study conducted by MIT Sloan Management Review and IBM found that top performing companies use BI and business analytics for both tactical financial insights and strategic issues like developing competitive advantages.

Question 3

Because the high costs of a data warehouse can make them too expensive for a company to operate, some organizations turn to an alternative, called an analytical database.

Accepted Answer

The answer of Because the high costs of a data...

Question 4

Because of the very large amount of data and the costs associated with BI applications, small and mid-sized companies with limited IT staff and budgets sometimes use a new BI architecture called BI in the cloud.

Accepted Answer

This statement is true. Small and mid-sized companies may use BI in the cloud as a cost-effective solution.

Question 5

Specialized software used to analyze large data sets to find patterns, correlation, trends, or other meaningful relationships are called data mining tools.

Accepted Answer

Data mining tools are specifically designed to analyze and discover patterns, relationships and trends within large data sets.

Question 6

Data warehouses are designed as online analytical processing OLAP) systems, meaning that the data can be queried and analyzed much more efficiently than OLTP application databases.

Accepted Answer

Data warehouses are optimized for OLAP, which allows for faster querying and analysis of data compared to OLTP databases designed for transactional processing.

Question 7

Because the high costs of a data warehouse can make them too expensive for a company to operate, some organizations turn to an alternative, called a data mart.

Accepted Answer

This statement is true. Data marts are a smaller and more focused version of a data warehouse, usually designed for a specific business unit or department within a company. They are often less expensive and quicker to implement than a full data warehouse.

Question 8

Because of the very large amount of data and the costs associated with BI applications, small and mid-sized companies with limited IT staff and budgets sometimes use a new BI architecture called Pre-defined BI models.

Accepted Answer

Pre-defined BI models are not a new BI architecture but rather a strategy or approach that can be used within existing BI architectures to simplify and reduce costs for small and mid-sized companies.

Question 9

In large companies, being able to locate and retrieve documents from previous years can be extremely challenging, not to mention the logistical challenge associated with warehousing large amounts of paper. Increasingly, companies that face these challenges are turning to Document Management Systems DMS).

Accepted Answer

The statement suggests that companies are turning to Document Management Systems (DMS) to solve the challenges associated with locating and retrieving documents from previous years and warehousing large amounts of paper.

Question 10

The key advantage of an active data warehouse ADW) is that it is less expensive to install and operate.

Accepted Answer

This statement is false. The key advantage of an active data warehouse (ADW) is that it provides real-time or near real-time access to data and enables continuous analysis and decision-making, which can lead to increased efficiency and competitiveness for businesses. However, implementing and operating an ADW can be more expensive than a traditional data warehouse due to the need for advanced technology, specialized skills, and ongoing maintenance and support.

Question 11

Specialized software used to analyze large data sets to find patterns, correlation, trends, or other meaningful relationships are pattern recognition applications.

Accepted Answer

The answer of Specialized software used to analyze large data...

Question 12

According to a study conducted by MIT Sloan Management Review and IBM top-performing organizations use analytics five times more than lower performers.

Accepted Answer

The statement is true according to the study conducted by MIT Sloan Management Review and IBM. Top-performing organizations were found to use analytics five times more than lower performers.

Question 13

Tweets and Facebook status updates are typical examples of "structured data" stored in databases.

Accepted Answer

Tweets and Facebook status updates are considered "unstructured data" because they do not follow a predefined data model and are not organized in a fixed format.

Question 14

An advantage of Document Management Systems DMS) is that they help organizations cut labor costs by automating business processes.

Accepted Answer

Document Management Systems (DMS) help automate tasks such as routing documents for review and approval, reducing the need for manual intervention and saving time and labor costs.

Question 15

Unstructured analytic analysis is a process used to analyze an organization's non-structured data that comes from word processing documents, social media, text messages, audio, faxes, memos, call center or claims notes, and so on.

Accepted Answer

Unstructured analytic analysis refers to methods used to analyze unstructured data, which includes the types of data mentioned, but the term itself is not accurate. The correct term is "unstructured data analysis" or "analysis of unstructured data," focusing on extracting insights from data that does not fit into traditional database structures.

Question 16

Aberdeen's 2012) survey of 176 organizations worldwide found that the volume of physical paper) documents is increasing by approximately 30% per year.

Accepted Answer

The survey found that the volume of physical paper documents is increasing by approximately 30% per year.

Question 17

An active data warehouse ADW) is a relatively new OLAP system that is updated in real-time, providing the most current data available for analysis and decision support apps.

Accepted Answer

An active data warehouse (ADW) is designed to be updated in real-time, allowing for up-to-date data for analysis and decision-making. This is in contrast to traditional data warehouses, which are generally updated on a periodic basis.

Question 18

Aberdeen's 2012) survey of 176 organizations worldwide found that the volume of physical paper) documents is declining by approximately 30% per year thanks to increased use of digitalization and growing concern for the environment.

Accepted Answer

Aberdeen's 2012 survey did not specifically find that the volume of physical paper documents is declining by approximately 30% per year due to digitalization and environmental concerns. The rate of decline in paper usage can vary widely among different organizations and industries, and such a specific figure may not accurately represent general trends without current, comprehensive data.

Question 19

Text mining is a process used to analyze an organization's non-structured data that comes from word processing documents, social media, text messages, audio, faxes, memos, call center or claims notes, and so on.

Accepted Answer

Text mining is indeed a process used to analyze an organization's non-structured data that comes from various sources.

Question 20

"Big Data" is a recent trend in the field of Business Intelligence BI) that involves mining very large data sets that come from billions upon billions of recorded transactions, social media interactions and records of individual user online activities.

Accepted Answer

This statement accurately describes Big Data as a trend in Business Intelligence that involves analyzing large sets of data from various sources such as transactions and social media interactions.

Quiz 3: Database, Data Warehouse, and Data Mining