DP-500 Question #150: Real Exam Question with Answer & Explanation

Question

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?

Options

• AJSON
• BAvro
• CDelta
• DParquet

Explanation

To ensure transaction history is written within the scope of related transactions in a data lake with Azure Synapse Analytics, Delta Lake format should be recommended due to its ACID properties.

Common mistakes.

• A. JSON files do not inherently support ACID transactions, making them unsuitable for ensuring transactional integrity for data lake history.
• B. Avro files are a row-based binary format but do not natively provide transactional capabilities required for atomically writing transaction history.
• D. Parquet files are a columnar storage format optimized for analytical queries but lack built-in ACID transaction support, which is necessary for the specified requirement.

Concept tested. Data Lake transaction support (ACID)

Reference. https://learn.microsoft.com/en-us/azure/architecture/data-guide/scenarios/transaction-delta-lake

No community discussion yet for this question.