Exam DP-300 topic 3 question 40 discussion

Actual exam question from Microsoft's DP-300

Question #: 40
Topic #: 3

HOTSPOT
-

You have an Azure SQL database named DB1 that contains a table named Table1.

You run a query to load data into Table1.

The performance metrics of Table1 during the load operation are shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by kkkiet at Feb. 22, 2023, 8:13 a.m.

Comments

Submit Cancel

Gocsan

Highly Voted 2 years, 3 months ago

You are loading data into Table1, which means there is some inserts going on. Note that insert statements is also considered a query. Not sure why the first answer is perform query tuning. It should be scale resource in order to reduce the time insert data into Table1.

upvoted 8 times

voodoo_sh

5 months, 2 weeks ago

Thinking the same, if there is plain INSERT without any additional joins, etc., then there may be nothing to tune. So: Scale the resource In-memory non durable This approach minimizes the impact on the transaction log by using memory-optimized tables that do not persist data to disk, thus reducing the IO load.

upvoted 1 times

...