
Answer-first summary for fast verification
Answer: a lakehouse
The correct answer is A - a lakehouse. A lakehouse supports the use of dataflows to load and append data, and it allows Delta tables to be V-Order optimized and compacted automatically. Azure SQL databases and KQL databases do not support Delta tables in the required manner, and a generic warehouse does not necessarily support V-Order optimization automatically.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
You are working with source data stored in a folder on your local computer. Your goal is to develop a solution that leverages Microsoft Fabric to load this data into a data store. The solution must fulfill the following criteria:
What type of data store should you use to meet these requirements?
A
a lakehouse
B
an Azure SQL database
C
a warehouse
D
a KQL database