FEFreeExamDumps.in

Data Engineering on Microsoft Azure

Topic 1

Question 77

DP-203 voucher + Udemy course (lifetime access) = ₹3,500 for Indian ID card holders.

Details →

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?

  • 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