CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. DP-300

Free DP-300 Exam Braindumps (page: 40)

Page 40 of 76
PDF with 352 Questions

You have an Azure SQL database named DB1 in the General Purpose service tier.
The performance metrics for DB1 are shown in the following exhibit.


You need to reduce the Log IO percentage. The solution must minimize costs.
What should you do?

  1. Change Service tier to Business Critical.
  2. Increase the number of vCores.
  3. Perform a checkpoint operation.
  4. Change Recovery model to Simple.

Answer(s): A



You have an Azure SQL database named DB1 that contains a nonclustered index named index1.
End users report slow queries when they use index1.

You need to identify the operations that are being performed on the index.
Which dynamic management view should you use?

  1. Sys.dm_exec_query_plan_stats
  2. Sys.dm_db_index_physical_stats
  3. Sys.dm_db_index_operational_stats
  4. Sys.dm_db_index_useage_stats

Answer(s): D



HOTSPOT (Drag and Drop is not supported)
You have an Azure SQL managed instance named SQLMI1 that hosts multiple databases.
You need to monitor the performance of SQLMI1 and identify which database uses the most memory and the most disk I/O.

Which objects should you query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

  1. See Explanation section for answer.

Answer(s): A

Explanation:



HOTSPOT (Drag and Drop is not supported)
You have an Azure subscription that contains an instance of SQL Server on Azure Virtual Machines. The virtual machine hosts a database named DB1.

You need to monitor DB1 by using Extended Events. The solution must meet the following requirements:

•Capture raw event data and store the data in Azure Storage.
•Minimize the performance impact of capturing extended events.

How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Page 40 of 76



Post your Comments and Discuss Microsoft DP-300 exam with other Community members:

laks commented on December 26, 2024
so far seems good
UNITED STATES
upvote

Jack commented on October 24, 2024
Muito bom as perguntas
Anonymous
upvote

TheUser commented on October 23, 2024
So far seems good
Anonymous
upvote

anonymus commented on October 23, 2024
master database differential backup is not supported in sql server
EUROPEAN UNION
upvote

Ntombi commented on October 17, 2024
i find the questions helpful for my exam preparation
Anonymous
upvote

Ntombi commented on October 17, 2024
The questions help me to see if I understood what I have learned
Anonymous
upvote

ntombi commented on October 17, 2024
writing exam at the end of the month
Anonymous
upvote

Raby commented on August 13, 2024
Wonderful work guys. The PDF version helped me pass. Thank you
EUROPEAN UNION
upvote