Implementing Analytics Solutions Using Microsoft Fabric — Question 17

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?

Answer options

Correct answer: A

Explanation

The correct choice is A, a lakehouse, as it is designed to handle both structured and unstructured data while supporting Delta tables with automatic optimization and compaction. The other options, such as an Azure SQL database, warehouse, and KQL database, do not inherently support the same level of integration with dataflows and Delta table management as a lakehouse does.