Module 3 Quiz
How does the use of cloud computing affect the scalability of a data warehouse?
Hardware resources are dynamically allocated as use increases.
Which kind of data warehouse is created separately from the enterprise data warehouse by a department and not reliant on it for updates?
Independent data mart
Which of the following BEST enables a data warehouse to handle complex queries and scale up to handle many more requests?
Parallel Processing
What is Six Sigma?
a methodology aimed at reducing the number of defects in a business process
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)
data lake.
Which data warehouse architecture uses metadata from existing data warehouses to create a hybrid logical data warehouse comprised of data from the other warehouses?
federated architecture
All of the following are benefits of hosted data warehouses EXCEPT
greater control of data.
Which data warehouse architecture uses a normalized relational warehouse that feeds multiple data marts?
hub-and-spoke data warehouse architecture
Data warehouses provide direct and indirect benefits to organizations. Which of the following is an indirect benefit of data warehouses?
improved customer service
All of the following are true about in-database processing technology EXCEPT
it is the same as in-memory storage technology.
Oper marts are created when operational data needs to be analyzed
multidimensionally.
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
speed of data transfer.
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?
star schema
Operational or transaction databases are product oriented, handling transactions that update the database. In contrast, data warehouses are
subject-oriented and nonvolatile.
A Web client that connects to a Web server, which is in turn connected to a BI application server, is reflective of a
three-tier architecture.
Why is a performance management system superior to a performance measurement system?
because measurement alone has little use without action
________ 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.
Enterprise information integration (EII)
In which stage of extraction, transformation, and load (ETL) into a data warehouse are anomalies detected and corrected?
cleanse
When querying a dimensional database, a user went from summarized data to its underlying details. The function that served this purpose is
drill down.
Which approach to data warehouse integration focuses more on sharing process functionality than data across systems?
enterprise application integration
