Data warehouses are subsets of data marts. T/F
Answer: False
Learn More :
Big Data
- All of the following are true about in-database processing technology EXCEPT
- How does the use of cloud computing affect the scalability of a data warehouse?
- Which of the following statements is more descriptive of active data warehouses in contrast with traditional data warehouses?
- Active 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
- Which of the following online analytical processing (OLAP) technologies does NOT require the precomputation and storage of information?
- When querying a dimensional database, a user went from summarized data to its underlying details. The function that served this purpose is
- 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?
- All of the following are benefits of hosted data warehouses EXCEPT
- Data warehouses provide direct and indirect benefits to using organizations. Which of the following is an indirect benefit of data warehouses?
- In which stage of extraction, transformation, and load (ETL) into a data warehouse are anomalies detected and corrected?
- In which stage of extraction, transformation, and load (ETL) into a data warehouse are data aggregated?
- Which approach to data warehouse integration focuses more on sharing process functionality than data across systems?
- Which data warehouse architecture uses a normalized relational warehouse that feeds multiple data marts?
- Which data warehouse architecture uses metadata from existing data warehouses to create a hybrid logical data warehouse comprised of data from the other warehouses?
- Which of the following BEST enables a data warehouse to handle complex queries and scale up to handle many more requests?
- 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 statements about metadata are true EXCEPT
- Which kind of data warehouse is created separately from the enterprise data warehouse by a department and not reliant on it for updates?
- Operational or transaction databases are product oriented, handling transactions that update the database. In contrast, data warehouses are
- The "single version of the truth" embodied in a data warehouse such as Capri Casinos' means all of the following EXCEPT
- Because the recession has raised interest in low-cost open source software, it is now set to replace traditional enterprise software. T/F
- Data warehouse administrators (DWAs) do not need strong business insight since they only handle the technical aspect of the infrastructure. T/F
- A well-designed data warehouse means that user requirements do not have to change as business needs change. T/F
- The data warehousing maturity model consists of six stages: prenatal, infant, child, teenager, adult, and sage. T/F
- OLTP systems are designed to handle ad hoc analysis and complex queries that deal with many data items. T/F