Microsoft Fabric Analytics Engineer Associate DP-600
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
As part of the AnalyticsPOC project, you need to determine the most suitable type of data store for the workspace. The chosen data store must meet the following criteria:
- Support for semi-structured and unstructured data.
- Capability to store files in Parquet format that comply with Delta Lake specifications.
- Accessibility for read operations using either T-SQL or Python.
- Provision of row-level security (RLS) specifically for T-SQL queries.
- Capability to handle both raw data and cleansed data transformations.
Which type of data store would you recommend?
Exam-Like
A
a data lake
B
a warehouse
C
a lakehouse
D
an external Hive metastore
Explanation:
A lakehouse is the most appropriate choice considering the requirements. It supports semi-structured and unstructured data and is designed to handle files stored in Parquet format meeting Delta Lake specifications. Lakehouses also provide native support for T-SQL and Python read access and row-level security (RLS). They facilitate the transformation and integration of both raw and cleansed data, fulfilling all specified technical and security requirements.
Comments
Loading comments...