Designing and Implementing Enterprise-Scale Analytics Using Microsoft Azure and Power BI — Question 171

You have an Azure subscription that contains an Azure Synapse Analytics serverless SQL pool named Pool1.

You plan to deploy a data lake that will record the history of transactions executed against Pool1.

You need to recommend which type of file to use to store the history. The solution must ensure that the history is written in the scope of the related transaction.

Which file type should you recommend?

Answer options

• A. JSON
• B. Avro
• C. Delta
• D. Parquet

Correct answer: D

Explanation

The correct answer is D, Parquet, as it is designed for efficient data storage and retrieval, making it suitable for analytics and maintaining transaction history. JSON and Avro are less efficient for analytics purposes, while Delta is primarily used for managing large-scale data lakes and may not align with the requirement of transaction-specific history.