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

Xuan

16 days ago

I believe enabling result set caching could also be beneficial in reducing query time. It's worth considering.

upvoted 0 times

...

Juliann

17 days ago

I agree with Bok. Creating an index on the avg_f column will definitely help minimize query time.

upvoted 0 times

...

Bok

22 days ago

I think we should create an index on the avg_f column to improve query performance.

upvoted 0 times

...

Belen

23 days 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

...