
Answer-first summary for fast verification
Answer: a lakehouse
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.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
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:
Which type of data store would you recommend?
A
a data lake
B
a warehouse
C
a lakehouse
D
an external Hive metastore