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

© examsiri.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]. ______


  • To reduce the log IO load of the operation, the query must be updated to use [answer choice] table. ______


Go to Question: