Microsoft DP-300 Administering Relational Databases on Microsoft Azure Exam Practice Test

Page:    1 / 14   
Total 176 questions

Question 1

You have SQL Server on an Azure virtual machine.

You need to add a 4-TB volume that meets the following requirements:

Maximizes IOPs

Uses premium solid state drives (SSDs)

What should you do?



Answer : B

Question 2

You have an Azure SQL database named db1 on a server named server1.

The Intelligent Insights diagnostics log identifies that several tables are missing indexes.

You need to ensure that indexes are created for the tables.

What should you do?



Answer : C

Question 3

You have an Azure SQL managed instance named SQL1 and two Azure web apps named App1 and App2.

You need to limit the number of IOPs that App2 queries generate on SQL1.

Which two actions should you perform on SQL1? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.



Answer : B, C

Question 4

You have an Azure SQL managed instance.

You need to gather the last execution of a query plan and its runtime statistics. The solution must minimize the impact on currently running queries.

What should you do?



Answer : C

Question 5

You have an Azure SQL Database managed instance.

The instance starts experiencing performance issues.

You need to identify which query is causing the issue and retrieve the execution plan for the query. The solution must minimize administrative effort.

What should you use?



Answer : C

Page:    1 / 14   
Total 176 questions