Data Engineering on Microsoft Azure — Question 75

You have an Azure Synapse Analytics workspace that contains an Apache Spark pool named SparkPool1. SparkPool1 contains a Delta Lake table named SparkTable1.

You need to recommend a solution that supports Transact-SQL queries against the data referenced by SparkTable1. The solution must ensure that the queries can use partition elimination.

What should you include in the recommendation?

Answer options

• A. a partitioned table in a dedicated SQL pool
• B. a partitioned view in a dedicated SQL pool
• C. a partitioned index in a dedicated SQL pool
• D. a partitioned view in a serverless SQL pool

Correct answer: D

Explanation

The correct answer is D because a partitioned view in a serverless SQL pool allows for querying data with partition elimination, optimizing performance. Options A, B, and C refer to a dedicated SQL pool, which does not support direct querying of Delta Lake tables, making them unsuitable for the requirement.