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

A(n)________ architecture is used to build a scalable and maintainable infrastructure that includes a centralized data warehouse and several dependent data marts.

(Short Answer)

4.8/5

(29)

Question 21

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

(Short Answer)

4.9/5

(42)

Question 22

Which approach to data warehouse integration focuses more on sharing process functionality than data across systems?

(Multiple Choice)

4.8/5

(42)

Question 23

Organizations seldom devote a lot of effort to creating metadata because it is not important for the effective use of data warehouses.

(True/False)

4.9/5

(39)

Question 24

Most data warehouses are built using ________ database management systems to control and manage the data.

(Short Answer)

4.9/5

(27)

Question 25

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

(Multiple Choice)

4.9/5

(38)

Question 26

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

(True/False)

4.8/5

(29)

Question 27

Data ________ comprises data access,data federation,and change capture.

(Short Answer)

4.8/5

(36)

Question 28

In which stage of extraction,transformation,and load (ETL)into a data warehouse are anomalies detected and corrected?

(Multiple Choice)

4.9/5

(37)

Question 29

Which data warehouse architecture uses a normalized relational warehouse that feeds multiple data marts?

(Multiple Choice)

4.7/5

(33)

Question 30

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.

(Short Answer)

4.8/5

(26)

Question 31

Because of performance and data quality issues,most experts agree that the federated architecture should supplement data warehouses,not replace them.

(True/False)

4.7/5

(32)

Question 32

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

(True/False)

4.8/5

(31)

Question 33

A large storage location that can hold vast quantities of data (mostly unstructured)in its native/raw format for future/potential analytics consumption is referred to as a(n)

(Multiple Choice)

4.8/5

(40)

Question 34

All of the following are benefits of hosted data warehouses EXCEPT

(Multiple Choice)

4.9/5

(31)

Question 35

________ modeling is a retrieval-based system that supports high-volume query access.

(Short Answer)

4.8/5

(32)

Question 36

When querying a dimensional database,a user went from summarized data to its underlying details.The function that served this purpose is

(Multiple Choice)

4.8/5

(31)

Question 37

A Web client that connects to a Web server,which is in turn connected to a BI application server,is reflective of a

(Multiple Choice)

4.8/5

(39)

Question 38

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

(Multiple Choice)

4.8/5

(43)

Question 39

Data warehouses are subsets of data marts.

(True/False)

4.9/5

(35)

Question 40

Showing 21 - 40 of 70

A(n)________ architecture is used to build a scalable and maintainable infrastructure that includes a centralized data warehouse and several dependent data marts.

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

Which approach to data warehouse integration focuses more on sharing process functionality than data across systems?

Organizations seldom devote a lot of effort to creating metadata because it is not important for the effective use of data warehouses.

Most data warehouses are built using ________ database management systems to control and manage the data.

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

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

Data ________ comprises data access,data federation,and change capture.

In which stage of extraction,transformation,and load (ETL)into a data warehouse are anomalies detected and corrected?

Which data warehouse architecture uses a normalized relational warehouse that feeds multiple 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.

Because of performance and data quality issues,most experts agree that the federated architecture should supplement data warehouses,not replace them.

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

A large storage location that can hold vast quantities of data (mostly unstructured)in its native/raw format for future/potential analytics consumption is referred to as a(n)

All of the following are benefits of hosted data warehouses EXCEPT

________ modeling is a retrieval-based system that supports high-volume query access.

When querying a dimensional database,a user went from summarized data to its underlying details.The function that served this purpose is

A Web client that connects to a Web server,which is in turn connected to a BI application server,is reflective of a

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

Data warehouses are subsets of data marts.

An Overview of Business Intelligence,analytics,and Data Science

Descriptive Analytics I: Nature of Data,statistical Modeling,

Predictive Analytics I: Data Mining Process, methods, and Algorithms

Predictive Analytics II: Text, web, and Social Media Analytics

Prescriptive Analytics: Optimization and Simulation

Big Data Concepts and Tools

Future Trends,privacy and Managerial Considerations in Analytics

Filters