Question 1

_________________ refers to refers to an organization's ability to get information to the people who need it to make decisions or react appropriately to business events.

Accepted Answer

The answer of _________________ refers to refers to an organization's...

Question 2

Data in databases are said to be volatile because data is constantly being added or updated by new transactions.

Accepted Answer

A) True 
 B)False

Question 3

Because of _____________, data from databases are transferred to a data warehouse so that they are ready for quick responses to inquiries.

Accepted Answer

The answer of Because of _____________, data from databases are...

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 Pre-defined BI models.

Accepted Answer

A) True 
 B)False

Question 5

The data life cycle is a model that illustrates the way in which data moves through an organization.

Accepted Answer

A) True 
 B)False

Question 6

An) _____________________ is a database for transaction processing systems that uses data warehouse concepts to provide clean data. It is used for short-term decisions involving mission-critical applications rather than for the medium- and long-term decisions associated with the regular data warehouse.

Accepted Answer

A)  Analytical database 
B)  Data backup system 
C)  Operational data store 
D)  Data mart

Question 7

There are three kinds of enterprise data: Transactional data, Master data and Analytical data.

Accepted Answer

A) True 
 B)False

Question 8

In terms of the major functions performed by a DBMS, data maintenance refers to which of the following?

Accepted Answer

A)  Correcting, standardizing, and verifying the integrity of the data. 
B)  Integrating, matching, or linking data from disparate sources. 
C)  Enhancing data using information from internal and external data sources. 
D)  Checking and controlling data integrity over time.

Question 9

MDM consolidates data from various data sources into a master reference file, which then feeds data back to the applications, thereby creating accurate and consistent data across the enterprise.

Accepted Answer

A) True 
 B)False

Question 10

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

A) True 
 B)False

Question 11

Because of volatility, data from databases are transferred to a ________________ so that they are ready for quick responses to inquiries.

Accepted Answer

A)  Statistical engine 
B)  Data repository 
C)  Data cloud 
D)  Data warehouse

Question 12

Because of data _______________ in a database that is constantly being updated with real-time transactions, data must be exported to a data warehouse prior to data mining, use by DSS apps and business intelligence analyses.

Accepted Answer

A)  Chaos 
B)  Errors 
C)  Volatility 
D)  Security

Question 13

Data warehouses and data marts are optimized for all of the following except:

Accepted Answer

A)  OLTP - Online Transaction Processing 
B)  Data mining 
C)  Business Intelligence BI) 
D)  Decision support

Question 14

Data __________________ integrate data from multiple databases and data silos and organize them for complex analysis, knowledge discovery, and to support decision making.

Accepted Answer

The answer of Data __________________ integrate data from multiple databases...

Question 15

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 _____________.

Accepted Answer

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

Question 16

Data warehouses that integrate data from databases across an entire organization are called _________________.

Accepted Answer

A)  Data marts 
B)  Enterprise data warehouses EDW) 
C)  Transaction data warehouses TDW) 
D)  Universal data warehouses UDW)

Question 17

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

A) True 
 B)False

Question 18

What are the two basic types of databases?

Accepted Answer

A)  Simple and complex 
B)  Static and dynamic 
C)  Centralized and distributed. 
D)  Transaction and analytical

Question 19

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

Accepted Answer

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

Question 20

A _________________ database stores all related files in one physical location.

Accepted Answer

The answer of A _________________ database stores all related files...

Exam 3: Database, Data Warehouse, and Data Mining

_________________ refers to refers to an organization's ability to get information to the people who need it to make decisions or react appropriately to business events.

Data in databases are said to be volatile because data is constantly being added or updated by new transactions.

Because of _____________, data from databases are transferred to a data warehouse so that they are ready for quick responses to inquiries.

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.

The data life cycle is a model that illustrates the way in which data moves through an organization.

There are three kinds of enterprise data: Transactional data, Master data and Analytical data.

In terms of the major functions performed by a DBMS, data maintenance refers to which of the following?

MDM consolidates data from various data sources into a master reference file, which then feeds data back to the applications, thereby creating accurate and consistent data across the enterprise.

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

Because of volatility, data from databases are transferred to a ________________ so that they are ready for quick responses to inquiries.

Because of data _______________ in a database that is constantly being updated with real-time transactions, data must be exported to a data warehouse prior to data mining, use by DSS apps and business intelligence analyses.

Data warehouses and data marts are optimized for all of the following except:

Data __________________ integrate data from multiple databases and data silos and organize them for complex analysis, knowledge discovery, and to support decision making.

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 warehouses that integrate data from databases across an entire organization are called _________________.

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.

What are the two basic types of databases?

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

A _________________ database stores all related files in one physical location.