Data Warehouses and Data Lakes Quiz

What is the purpose of a data warehouse?

• To only store data from spreadsheets

• To query and analyze historical data

• To integrate data from relational databases only

• To store live data that is constantly updated

Answer explanation

The purpose of a data warehouse is to query and analyze historical data, not just to store data from spreadsheets, integrate data from relational databases only, or store live data that is constantly updated.

What does ETL stand for in the context of data warehouses?

• Enhance, Transfer, Load

• Edit, Test, Launch

• Extract, Transform, Load

• Extract, Test, Load

Answer explanation

In the context of data warehouses, ETL stands for Extract, Transform, Load, where data is extracted from various sources, transformed into a suitable format, and loaded into a data warehouse for analysis.

What is the key characteristic of OLAP (Online Analytical Processing)?

• Storing data in a live database

• Storing only current data

• Querying large multi-dimensional datasets speedily

• Aggregating data in real-time

Answer explanation

Querying large multi-dimensional datasets speedily is the key characteristic of OLAP (Online Analytical Processing).

What is the purpose of the 'Transform' step in ETL?

• Extract data from databases

• Load the data in the correct format

• Clean and shape the data ready for storage

• Access the data from various sources

Answer explanation

Clean and shape the data ready for storage

What is the main difference between MOLAP and ROLAP?

• MOLAP is used for real-time data, ROLAP is used for historical data

• MOLAP directly represents OLAP cubes, ROLAP stores data in relational tables

• MOLAP uses SQL for aggregated queries, ROLAP uses arrays

• MOLAP stores data in relational tables, ROLAP uses multi-dimensional arrays

Answer explanation

MOLAP directly represents OLAP cubes, ROLAP stores data in relational tables

What is the purpose of a Star Schema in a data warehouse?

• To store only primary fact tables

• To store dimension tables in a normalized form

• To organize data by numerous qualities

• To store values to be analyzed and reference other tables

Answer explanation

To store values to be analyzed and reference other tables

What is the main characteristic of a Snowflake Schema?

• It is used for storing unstructured data

• It is used for real-time data analysis

• It has a primary fact table and dimension tables that are normalized

• It has a primary fact table and dimension tables that are not normalized

Answer explanation

Snowflake Schema has a primary fact table and dimension tables that are normalized, reducing redundancy and improving data integrity.

What is the purpose of a Data Lake?

• To store structured data only

• To store data in a normalized form

• To store data in a live database

• To store a great variety of data at large scale

Answer explanation

To store a great variety of data at large scale

What is the key characteristic of schema-on-read in Data Lakes?

• Data is shaped into the required format during storage

• Data is stored in a live database

• Data is stored in a structured format

• Data is erased and overwritten frequently

Answer explanation

Data is shaped into the required format during storage

What is required to build a Data Lake?

• A live database and SQL queries

• A structured schema for data storage

• A data warehouse solution

• A cloud storage platform and analytics tools

Answer explanation

A cloud storage platform and analytics tools are required to build a Data Lake, allowing for scalable storage and data analysis capabilities.