Microsoft Azure Data Engineer Associate - DP-203
Get started today
Ultimate access to all questions.
You have an Azure Synapse Analytics workspace with an Apache Spark pool named SparkPool1. This pool contains a Delta Lake table named SparkTable1.
You need to recommend a solution that enables querying the data in SparkTable1 using Transact-SQL and ensures that the queries can utilize partition elimination.
What should you include in the recommendation?
You have an Azure Synapse Analytics workspace with an Apache Spark pool named SparkPool1. This pool contains a Delta Lake table named SparkTable1.
You need to recommend a solution that enables querying the data in SparkTable1 using Transact-SQL and ensures that the queries can utilize partition elimination.
What should you include in the recommendation?
Exam-Like
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
Comments
Loading comments...