FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

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

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

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

A) extraction,transformation,and load
B) enterprise application integration
C) enterprise information integration
D) enterprise function integration

E) A) and B)
F) A) and C)

Correct Answer

verified

Show Answer

Question 23

Short Answer

Review LaterAdd Note

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

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.

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

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

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

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

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

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

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)

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

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

Data warehouses are subsets of data marts.

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

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.

All of the following are benefits of hosted data warehouses EXCEPT

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