Question 168

You have an Azure subscription that contains an Azure Synapse Analytics dedicated SQL pool named Pool1. Pool1 receives new data once every 24 hours. You have the following function. You have the following query. The query is executed once every 15 minutes and the @parameter value is set to the current date. You need to minimize the time it takes for the query to return results. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

• ACreate an index on the avg_f column.
• BConvert the avg_c column into a calculated column.
• CCreate an index on the sensorid column.
• DEnable result set caching.
• EChange the table distribution to replicate.