Complete the code to identify the main storage type of a data warehouse.
A data warehouse primarily stores data in a [1] format optimized for analysis.
A data warehouse stores data in a structured format, which means data is organized and formatted for easy querying and analysis.
Complete the code to identify the type of data stored in a data lake.
A data lake stores [1] data, including structured, semi-structured, and unstructured formats.
Data lakes store all types of data: structured, semi-structured, and unstructured, allowing for flexible data ingestion.
Fix the error in the statement about data processing in data warehouses.
Data warehouses require data to be [1] before storage to ensure quality and consistency.
Data warehouses require data to be cleaned (processed and transformed) before storage to maintain quality and consistency.
Fill both blanks to describe the main difference in schema handling between data warehouses and data lakes.
Data warehouses use [1] schema, while data lakes use [2] schema.
Data warehouses use schema-on-write, meaning data is structured before storing. Data lakes use schema-on-read, meaning data is structured when read.
Fill all three blanks to complete the comparison of data access and cost between data warehouses and data lakes.
Data warehouses provide [1] access with [2] cost, while data lakes offer [3] access with lower cost.
Data warehouses provide fast access but at a higher cost due to optimized storage and processing. Data lakes offer flexible access to various data types at a lower cost.