DP-203 · Question #292
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 follo
Sign in or unlock DP-203 to reveal the answer and full explanation for question #292. The question stem and answer options stay visible for context.
Question
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.
Exhibit
Options
- 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.
Unlock DP-203 to see the answer
You've previewed enough free DP-203 questions. Unlock DP-203 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.