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?