Test Index

Administering Relational Databases on Microsoft Azure (DP-300) Test 3

© examsnet.com

Question : 28 of 33

Marks: +1, -0

HOTSPOT
You have an Azure SQL database named DB1 that contains a table named Table 1.
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.
Hot Area:

To reduce how long it takes to complete the query you must [answer choice]. ______
scale the resource
use an elastic pool
perform query tuning
To reduce the log IO load of the operation, the query must be updated to use [answer choice] table. ______
a temporary
an In-Memory OTLP durable
an In-Memory OTLP non durable

Go to Question:

Prev Question

Next Question