Question 1

Real-time data warehousing can be used to support the highest level of decision making sophistication and power.The major feature that enables this in relation to handling the data is

Accepted Answer

A) country of (data)origin. 
B) nature of the data. 
C) speed of data transfer. 
D) source of the data.

Question 2

The ________ data warehouse architecture involves integrating disparate systems and analytical resources from multiple sources to meet changing needs or business conditions.

Accepted Answer

The answer of The ________ data warehouse architecture involves integrating...

Question 3

Properly integrating data from various databases and other disparate sources is a trivial process.

Accepted Answer

A) True 
 B)False

Question 4

The data warehousing maturity model consists of six stages: prenatal,infant,child,teenager,adult,and sage.

Accepted Answer

A) True 
 B)False

Question 5

Because the recession has raised interest in low-cost open source software,it is now set to replace traditional enterprise software.

Accepted Answer

A) True 
 B)False

Question 6

Mehra (2005)indicated that few organizations really understand metadata,and fewer understand how to design and implement a metadata strategy.How would you describe metadata?

Accepted Answer

The answer of Mehra (2005)indicated that few organizations really understand...

Question 7

Which kind of data warehouse is created separately from the enterprise data warehouse by a department and not reliant on it for updates?

Accepted Answer

A) sectional data mart 
B) public data mart 
C) independent data mart 
D) volatile data mart

Question 8

The "islands of data" problem in the 1980s describes the phenomenon of unconnected data being stored in numerous locations within an organization.

Accepted Answer

A) True 
 B)False

Question 9

Without middleware,different BI programs cannot easily connect to the data warehouse.

Accepted Answer

A) True 
 B)False

Question 10

Oper marts are created when operational data needs to be analyzed

Accepted Answer

A) linearly. 
B) in a dashboard. 
C) unidimensionally. 
D) multidimensionally.

Question 11

What is Six Sigma?

Accepted Answer

A) a letter in the Greek alphabet that statisticians use to measure process variability 
B) a methodology aimed at reducing the number of defects in a business process 
C) a methodology aimed at reducing the amount of variability in a business process 
D) a methodology aimed at measuring the amount of variability in a business process

Question 12

The BPM development cycle is essentially a one-shot process where the requirement is to get it right the first time.

Accepted Answer

A) True 
 B)False

Question 13

Which data warehouse architecture uses metadata from existing data warehouses to create a hybrid logical data warehouse comprised of data from the other warehouses?

Accepted Answer

A) independent data marts architecture 
B) centralized data warehouse architecture 
C) hub-and-spoke data warehouse architecture 
D) federated architecture

Question 14

________,or "The Extended ASP Model," is a creative way of deploying information system applications where the provider licenses its applications to customers for use as a service on demand (usually over the Internet).

Accepted Answer

The answer of ________,or "The Extended ASP Model," is a...

Question 15

Data warehouse administrators (DWAs)do not need strong business insight since they only handle the technical aspect of the infrastructure.

Accepted Answer

A) True 
 B)False

Question 16

What is the definition of a data mart?

Accepted Answer

The answer of What is the definition of a data...

Question 17

Which of the following BEST enables a data warehouse to handle complex queries and scale up to handle many more requests?

Accepted Answer

A) use of the Web by users as a front-end 
B) parallel processing 
C) Microsoft Windows 
D) a larger IT staff

Question 18

User-initiated navigation of data through disaggregation is referred to as "drill up."

Accepted Answer

A) True 
 B)False

Question 19

________ (also called in-database analytics)refers to the integration of the algorithmic extent of data analytics into data warehouse.

Accepted Answer

The answer of ________ (also called in-database analytics)refers to the...

Question 20

________ is a mechanism that integrates application functionality and shares functionality (rather than data)across systems,thereby enabling flexibility and reuse.

Accepted Answer

The answer of ________ is a mechanism that integrates application...

Exam 3: Descriptive Analytics II: Business Intelligence and Data Warehousing

Real-time data warehousing can be used to support the highest level of decision making sophistication and power.The major feature that enables this in relation to handling the data is

The ________ data warehouse architecture involves integrating disparate systems and analytical resources from multiple sources to meet changing needs or business conditions.

Properly integrating data from various databases and other disparate sources is a trivial process.

The data warehousing maturity model consists of six stages: prenatal,infant,child,teenager,adult,and sage.

Because the recession has raised interest in low-cost open source software,it is now set to replace traditional enterprise software.

Mehra (2005)indicated that few organizations really understand metadata,and fewer understand how to design and implement a metadata strategy.How would you describe metadata?

Which kind of data warehouse is created separately from the enterprise data warehouse by a department and not reliant on it for updates?

The "islands of data" problem in the 1980s describes the phenomenon of unconnected data being stored in numerous locations within an organization.

Without middleware,different BI programs cannot easily connect to the data warehouse.

Oper marts are created when operational data needs to be analyzed

What is Six Sigma?

The BPM development cycle is essentially a one-shot process where the requirement is to get it right the first time.

Which data warehouse architecture uses metadata from existing data warehouses to create a hybrid logical data warehouse comprised of data from the other warehouses?

________,or "The Extended ASP Model," is a creative way of deploying information system applications where the provider licenses its applications to customers for use as a service on demand (usually over the Internet).

Data warehouse administrators (DWAs)do not need strong business insight since they only handle the technical aspect of the infrastructure.

What is the definition of a data mart?

Which of the following BEST enables a data warehouse to handle complex queries and scale up to handle many more requests?

User-initiated navigation of data through disaggregation is referred to as "drill up."

________ (also called in-database analytics)refers to the integration of the algorithmic extent of data analytics into data warehouse.

________ is a mechanism that integrates application functionality and shares functionality (rather than data)across systems,thereby enabling flexibility and reuse.