Microsoft Fabric Analytics Engineer Associate DP-600
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.