32) Data warehouses provide direct and indirect benefits to organizations. Which of the following is an indirect benefit of data warehouses? 33) All of the following are benefits of hosted data warehouses EXCEPT 34) When representing data in a data warehouse, using several dimension tables that are each connected only to a fact table means you are using which warehouse structure? 35) When querying a dimensional database, a user went from summarized data to its underlying details. The function that served this purpose is 36) What is Six Sigma? 37) 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 38) 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) 39) How does the use of cloud computing affect the scalability of a data warehouse? 40) All of the following are true about in-database processing technology EXCEPT 41) A(n) ________ data store (ODS) provides a fairly recent form of customer information file. 42) In ________ oriented data warehousing, operational databases are tuned to handle transactions that update the database. 43) The three main types of data warehouses are data marts, operational __, and enterprise data warehouses. 44) ________ describe the structure and meaning of the data, contributing to their effective use. 45) Most data warehouses are built using ________ database management systems to control and manage the data. 46) A(n) ________ architecture is used to build a scalable and maintainable infrastructure that includes a centralized data warehouse and several dependent data marts. 47) The ________ data warehouse architecture involves integrating disparate systems and analytical resources from multiple sources to meet changing needs or business conditions.
You've reached the end of your free preview.
Want to read all 5 pages?