Graded Quiz: An Introduction To Data Warehouses, Data Marts, And Data Lakes » Week 1 » Getting Started With Data Warehousing And BI Analytics

Q: What is a data warehouse? Choose the best answer.

Correct: A data warehouse is a system that aggregates data from one or more sources into a single, central, consistent data store to support various data analytics requirements.

Q: What data warehouse vendors offer “on premises and cloud” services?

Correct: IBM Db2 Warehouse is widely recognized for its scalability, massively parallel processing capabilities, petaflop speeds, security features, and 99.99% service uptime. IBM Db2 Warehouse provides a containerized, scale-out data warehousing solution. You can move workloads where needed, including the public cloud, private cloud, or on premises with minimal or no changes required.

Q: What are data marts used for?

Correct: Data marts are designed to provide specific support for making tactical decisions. As such, data marts are focused only on the most relevant data, which saves end users the time and effort that would otherwise be spent searching the data warehouse for insights.

Q: What are data lake benefits?

Correct: Can store all data types including unstructured data, such as documents and emails, semi-structured data, such as JSON and XML files, and structured data from relational databases.

Q: What are the benefits of a data warehouse?

Correct: A single source of truth empowers users to leverage all the company's data and access that data more efficiently. Separating database operations from data analytics generally improves data access performance, leading to faster business insights.

Q: Where have we started hosting data warehouses in the last decade?

Correct: In the last decade or so, with exponential amounts of data being generated and stored in the cloud, Cloud Data Warehouses, frequently called CDWs, have gained popularity, where organizations don't purchase hardware or install warehousing software. Instead, organizations access data warehouses as a scalable, pay-as-you-go service.