Microsoft Exam DP-203 Topic 2 Question 97 Discussion

Actual exam question for Microsoft's DP-203 exam

Question #: 97
Topic #: 2

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.

Show Suggested Answer

Suggested Answer: A, B

by Basilia at Aug 26, 2024, 11:17 PM

Limited Time Offer

25%

Off

Get Premium DP-203 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Aleisha

12 days ago

Indexing the columns? Sounds like a real snoozefest. I'd rather just wait for the results to come back and then take a nap. Who needs performance when you've got time on your hands?

upvoted 0 times

...

Lindsay

14 days ago

E) Change the table distribution to replicate is an interesting option, but I'm not sure it would be the most effective in this case. Replicating the table might be overkill.

upvoted 0 times

...

Jerry

16 days ago

D) Enable result set caching is a good idea too, especially since the query is executed every 15 minutes and the data is updated daily. This can help reduce the time to return results.

upvoted 0 times

...

2 months ago

The correct answers are A) Create an index on the avg_f column, and C) Create an index on the sensorid column. Indexing the columns used in the query can significantly improve query performance.

upvoted 0 times