Fabric Lakehouse vs Warehouse Storage Quiz

1. In Lakehouse, what is the purpose of the Gold layer in medallion architecture?

Store raw ingested data

Provide business-ready, aggregated datasets for reporting

Store intermediate transformation logic

Archive historical data

2. For a use case involving real-time analytics on semi-structured IoT data, which Fabric storage should you choose?

Warehouse for strict schema enforcement

Lakehouse for flexibility and Delta Lake ACID support

Both equally suitable

Neither; use external storage

3. Which Lakehouse feature allows you to query historical versions of your data?

Partition pruning

Schema evolution

Time travel (Delta Lake versioning)

Data lineage tracking

4. In Microsoft Fabric Warehouse, what enables fast analytical queries on large datasets?

Delta Lake transactions

Column-oriented storage and indexing

Unstructured data support

Streaming ingestion

5. What is the Silver layer in a medallion architecture Lakehouse used for?

Raw data ingestion

Cleaned and validated data ready for transformation

Final business-ready aggregations

Machine learning feature engineering

6. Which statement best describes the relationship between Lakehouse and Warehouse in Microsoft Fabric?

They are mutually exclusive; choose one for your workspace

They can coexist in the same workspace for different analytics needs

Warehouse is deprecated in favor of Lakehouse

Lakehouse is only for data scientists, Warehouse for analysts

7. What is partition pruning and why is it important in Lakehouse queries?

Removing duplicate partitions; reduces storage

Skipping irrelevant data partitions; improves query performance

Merging small partitions; simplifies metadata

Archiving old partitions; saves costs

8. Warehouses in Fabric enforce which type of schema approach?

Schema-on-read

Schema-on-write

Schema-less

Dynamic schema

9. What is the main benefit of using Delta Lake format in a Lakehouse?

Eliminates the need for data governance

Provides ACID guarantees and time-travel capabilities

Increases query speed by 10x

Automatically deduplicates data

10. Which query language is primarily used for both Lakehouse and Warehouse in Microsoft Fabric?

PySpark only

T-SQL

Scala

R

11. What is the primary difference between a Lakehouse and a Warehouse in Microsoft Fabric?

Lakehouse stores structured data only; Warehouse stores unstructured data

Lakehouse combines data lake flexibility with warehouse structure; Warehouse enforces strict schema

Lakehouse is cheaper; Warehouse offers better performance

Lakehouse uses Parquet; Warehouse uses CSV format

12. Which of the following is a native Fabric object type for Warehouse storage?

Delta table

SQL table in a Warehouse

Parquet file

Streaming table

13. What does the Bronze layer in a Lakehouse medallion architecture contain?

Heavily curated, business-ready data

Raw, ingested data with minimal transformation

Aggregated summary tables

Machine learning model outputs

14. When should you choose a Warehouse over a Lakehouse?

When data schema is well-defined and query performance is critical

When working with streaming data sources

When you need flexibility in data formats

When minimizing storage is the priority

15. In Microsoft Fabric, which feature ensures data consistency and reliability in Lakehouse tables?

Partitioning

Delta Lake ACID transactions

Vectorized execution

Column-oriented storage

16. What is a key advantage of Lakehouse for data engineers working with semi-structured data?

Schema-on-read flexibility without sacrificing ACID transactions

Faster query performance than Warehouses

Lower storage costs

Automatic data compression

17. Warehouses in Microsoft Fabric are optimized for which type of workload?

Real-time streaming ingestion

Analytical queries on structured, pre-defined schemas

Machine learning model training

Unstructured data exploration

18. Which Lakehouse feature allows you to query both raw and refined data in a single workspace?

Medallion architecture with Bronze, Silver, Gold layers

Schema enforcement

Partition pruning

Vectorized execution

19. In a Warehouse, what is the default table format used for storage?

Delta Lake

Parquet

Native Warehouse format (column-oriented)

Apache Iceberg

20. Which storage format does Microsoft Fabric Lakehouse primarily use for data files?

Delta Lake format

Parquet with Delta Lake metadata