BenchMark Quizzes by MDFT Pro

Choose the Correct Data Store Type

You work for MDFT Pro, a training agency that needs to manage their training data. You have source data in a folder on a local computer. You need to create a solution that will use Fabric to populate a data store.

The solution must meet the following requirements:

Support the use of dataflows to load and append data to the data store
Ensure that Delta tables are V-Order optimized and compacted automatically

Which type of data store should you use?

Choose the correct answer from the options below.

Explanations for each answer:

A lakehouse is correct.
An Azure SQL database is incorrect. Azure SQL databases do not support Delta tables or V-Order optimization, and they are not designed for dataflow operations in Fabric.
A warehouse is incorrect. While warehouses can store data, they do not support Delta tables with V-Order optimization and automatic compaction features.
A KQL database is incorrect. KQL databases are designed for log and time-series data analytics, not for general data storage with Delta tables and dataflow operations.

Learn more about lakehouses in Fabric:

Lakehouses in Fabric

Exam Preparation Quiz

Choose the Correct Data Store Type