DP-300 Certification Practice Question #144

Question

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.

Accepted Answer

The exhibit shows Data IO hitting 100% during the load operation. Row 2 is more definitive: In-Memory OLTP **non-durable** (SCHEMA_ONLY) tables generate no transaction log writes, directly eliminating log IO load — this is a well-established Azure SQL optimization. For Row 1, the most common exam answer is "perform query tuning" as optimizing the INSERT statement (e.g., using batches via the non-durable table) reduces overall query duration; "scale the resource" is plausible but less targeted. The combination of query tuning + in-memory non-durable table is the exam's intended answer per the provided discussion and the official guidance.

More DP-300 practice questions