Microsoft
DP-203 · Question #360
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 suppo
The correct answer is D. a partitioned view in a serverless SQL pool. https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external- tables?tabs=hadoop
Submitted by kavita_s· Mar 30, 2026Develop data processing
Question
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?
Options
- Aa partitioned table in a dedicated SQL pool
- Ba partitioned view in a dedicated SQL pool
- Ca partitioned index in a dedicated SQL pool
- Da partitioned view in a serverless SQL pool
How the community answered
(36 responses)- A8% (3)
- B6% (2)
- C3% (1)
- D83% (30)
Explanation
https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external- tables?tabs=hadoop
Topics
#serverless SQL pool#Delta Lake#partition elimination#partitioned view
Community Discussion
No community discussion yet for this question.