Question 1

Which of the following online analytical processing (OLAP) technologies does NOT require the precomputation and storage of information?

Accepted Answer

A)  MOLAP 
B)  ROLAP 
C)  HOLAP 
D)  SQL 
A)  MOLAP 
B)  ROLAP 
C)  HOLAP 
D)  SQL

Question 2

The "single version of the truth" embodied in a data warehouse such as Capri Casinos' means all of the following EXCEPT

Accepted Answer

A)  decision makers get to see the same results to queries. 
B)  decision makers have the same data available to support their decisions. 
C)  decision makers get to use more dependable data for their decisions. 
D)  decision makers have unfettered access to all data in the warehouse. 
A)  decision makers get to see the same results to queries. 
B)  decision makers have the same data available to support their decisions. 
C)  decision makers get to use more dependable data for their decisions. 
D)  decision makers have unfettered access to all data in the warehouse.

Question 3

More data, coming in faster and requiring immediate conversion into decisions, means that organizations are confronting the need for real-time data warehousing (RDW). How would you define real-time data warehousing?

Accepted Answer

Real-time data warehousing, al

Question 4

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

Metadata are data about data.

Question 5

Mention briefly some of the recently popularized concepts and technologies that will play a significant role in defining the future of data warehousing.

Accepted Answer

• Sourcing (mechanisms for acquisition o

Question 6

Two-tier data warehouse/BI infrastructures offer organizations more flexibility but cost more than three-tier ones.

Accepted Answer

A) True 
 B)False

Question 7

In ________ oriented data warehousing, operational databases are tuned to handle transactions that update the database.

Accepted Answer

The answer of In ________ oriented data warehousing, operational databases...

Question 8

The hub-and-spoke data warehouse model uses a centralized warehouse feeding dependent data marts.

Accepted Answer

A) True 
 B)False

Question 9

How does the use of cloud computing affect the scalability of a data warehouse?

Accepted Answer

A)  Cloud computing vendors bring as much hardware as needed to users' offices. 
B)  Hardware resources are dynamically allocated as use increases. 
C)  Cloud vendors are mostly based overseas where the cost of labor is low. 
D)  Cloud computing has little effect on a data warehouse's scalability. 
A)  Cloud computing vendors bring as much hardware as needed to users' offices. 
B)  Hardware resources are dynamically allocated as use increases. 
C)  Cloud vendors are mostly based overseas where the cost of labor is low. 
D)  Cloud computing has little effect on a data warehouse's scalability.

Question 10

All of the following are benefits of hosted data warehouses EXCEPT

Accepted Answer

A)  smaller upfront investment. 
B)  better quality hardware. 
C)  greater control of data. 
D)  frees up in-house systems. 
A)  smaller upfront investment. 
B)  better quality hardware. 
C)  greater control of data. 
D)  frees up in-house systems.

Question 11

Online ________ is arguably the most commonly used data analysis technique in data warehouses.

Accepted Answer

analytical

Question 12

________ is a mechanism for pulling data from source systems to satisfy a request for information. It is an evolving tool space that promises real-time data integration from a variety of sources, such as relational databases, Web services, and multidimensional databases.

Accepted Answer

Enterprise

Question 13

All of the following are true about in-database processing technology EXCEPT

Accepted Answer

A)  it pushes the algorithms to where the data is. 
B)  it makes the response to queries much faster than conventional databases. 
C)  it is often used for apps like credit card fraud detection and investment risk management. 
D)  it is the same as in-memory storage technology. 
A)  it pushes the algorithms to where the data is. 
B)  it makes the response to queries much faster than conventional databases. 
C)  it is often used for apps like credit card fraud detection and investment risk management. 
D)  it is the same as in-memory storage technology.

Question 14

What is the definition of a data mart?

Accepted Answer

A data mart is a subset of a data wareho

Question 15

Large companies, especially those with revenue upwards of $500 million consistently reap substantial cost savings through the use of hosted data warehouses.

Accepted Answer

A) True 
 B)False

Question 16

In the MultiCare case, how was data warehousing able to reduce septicemia mortality rates in MultiCare hospitals?

Accepted Answer

•The Adaptive Data Warehouseᵗᵐ organized

Question 17

The role responsible for successful administration and management of a data warehouse is the ________, who should be familiar with high-performance software, hardware, and networking technologies, and also possesses solid business insight.

Accepted Answer

data wareh

Question 18

One way an operational data store differs from a data warehouse is the recency of their data.

Accepted Answer

A) True 
 B)False

Question 19

Data warehouses are subsets of data marts.

Accepted Answer

A) True 
 B)False

Question 20

Online ________ is a term used for a transaction system that is primarily responsible for capturing and storing data related to day-to-day business functions such as ERP, CRM, SCM, and point of sale.

Accepted Answer

transactio

Which of the following online analytical processing (OLAP) technologies does NOT require the precomputation and storage of information?

The "single version of the truth" embodied in a data warehouse such as Capri Casinos' means all of the following EXCEPT

More data, coming in faster and requiring immediate conversion into decisions, means that organizations are confronting the need for real-time data warehousing (RDW). How would you define real-time data warehousing?

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?

Mention briefly some of the recently popularized concepts and technologies that will play a significant role in defining the future of data warehousing.

Two-tier data warehouse/BI infrastructures offer organizations more flexibility but cost more than three-tier ones.

In ________ oriented data warehousing, operational databases are tuned to handle transactions that update the database.

The hub-and-spoke data warehouse model uses a centralized warehouse feeding dependent data marts.

How does the use of cloud computing affect the scalability of a data warehouse?

All of the following are benefits of hosted data warehouses EXCEPT

Online ________ is arguably the most commonly used data analysis technique in data warehouses.

________ is a mechanism for pulling data from source systems to satisfy a request for information. It is an evolving tool space that promises real-time data integration from a variety of sources, such as relational databases, Web services, and multidimensional databases.

All of the following are true about in-database processing technology EXCEPT

What is the definition of a data mart?

Large companies, especially those with revenue upwards of $500 million consistently reap substantial cost savings through the use of hosted data warehouses.

In the MultiCare case, how was data warehousing able to reduce septicemia mortality rates in MultiCare hospitals?

The role responsible for successful administration and management of a data warehouse is the ________, who should be familiar with high-performance software, hardware, and networking technologies, and also possesses solid business insight.

One way an operational data store differs from a data warehouse is the recency of their data.

Data warehouses are subsets of data marts.

Online ________ is a term used for a transaction system that is primarily responsible for capturing and storing data related to day-to-day business functions such as ERP, CRM, SCM, and point of sale.

An Overview of Business Intelligence, Analytics, and Decision Support

Foundations and Technologies for Decision Making

Business Reporting, Visual Analytics, and Business Performance Management

Data Mining

Techniques for Predictive Modeling

Text Analytics, Text Mining, and Sentiment Analysis

Web Analytics, Web Mining, and Social Analytics

Model-Based Decision Making: Optimization and Multi-Criteria Systems

Modeling and Analysis: Heuristic Search Methods and Simulation

Automated Decision Systems and Expert Systems

Knowledge Management and Collaborative Systems

Big Data and Analytics

Business Analytics: Emerging Trends and Future Impacts

Filters

Exam 3: Data Warehousing

Which of the following online analytical processing (OLAP) technologies does NOT require the precomputation and storage of information?

The "single version of the truth" embodied in a data warehouse such as Capri Casinos' means all of the following EXCEPT

More data, coming in faster and requiring immediate conversion into decisions, means that organizations are confronting the need for real-time data warehousing (RDW). How would you define real-time data warehousing?

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?

Mention briefly some of the recently popularized concepts and technologies that will play a significant role in defining the future of data warehousing.

Two-tier data warehouse/BI infrastructures offer organizations more flexibility but cost more than three-tier ones.

In ________ oriented data warehousing, operational databases are tuned to handle transactions that update the database.

The hub-and-spoke data warehouse model uses a centralized warehouse feeding dependent data marts.

How does the use of cloud computing affect the scalability of a data warehouse?

All of the following are benefits of hosted data warehouses EXCEPT

Online ________ is arguably the most commonly used data analysis technique in data warehouses.

________ is a mechanism for pulling data from source systems to satisfy a request for information. It is an evolving tool space that promises real-time data integration from a variety of sources, such as relational databases, Web services, and multidimensional databases.

All of the following are true about in-database processing technology EXCEPT

What is the definition of a data mart?

Large companies, especially those with revenue upwards of $500 million consistently reap substantial cost savings through the use of hosted data warehouses.

In the MultiCare case, how was data warehousing able to reduce septicemia mortality rates in MultiCare hospitals?

The role responsible for successful administration and management of a data warehouse is the ________, who should be familiar with high-performance software, hardware, and networking technologies, and also possesses solid business insight.

One way an operational data store differs from a data warehouse is the recency of their data.

Data warehouses are subsets of data marts.

Online ________ is a term used for a transaction system that is primarily responsible for capturing and storing data related to day-to-day business functions such as ERP, CRM, SCM, and point of sale.

An Overview of Business Intelligence, Analytics, and Decision Support

Foundations and Technologies for Decision Making

Business Reporting, Visual Analytics, and Business Performance Management

Data Mining

Techniques for Predictive Modeling

Text Analytics, Text Mining, and Sentiment Analysis

Web Analytics, Web Mining, and Social Analytics

Model-Based Decision Making: Optimization and Multi-Criteria Systems

Modeling and Analysis: Heuristic Search Methods and Simulation

Automated Decision Systems and Expert Systems

Knowledge Management and Collaborative Systems

Big Data and Analytics

Business Analytics: Emerging Trends and Future Impacts

Filters