Free DP-300 Exam Braindumps (page: 37)

Page 37 of 76

You have an Azure SQL Database server named sqlsrv1 that hosts 10 Azure SQL databases. The databases perform slower than expected.
You need to identify whether the performance issue relates to the use of tempdb by Azure SQL databases on sqlsrv1.
What should you do?

  1. Run Query Store-based queries
  2. Review information provided by SQL Server Profiler-based traces
  3. Review information provided by Query Performance Insight
  4. Run dynamic management view-based queries

Answer(s): D

Explanation:

Microsoft Azure SQL Database and Azure SQL Managed Instance enable a subset of dynamic management views to diagnose performance problems, which might be caused by blocked or long-running queries, resource bottlenecks, poor query plans, and so on.
This include edentifying tempdb performance issues:
When identifying IO performance issues, the top wait types associated with tempdb issues is PAGELATCH_* (not PAGEIOLATCH_*).


Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/monitoring-with-dmvs



DRAG DROP (Drag and Drop is not supported)
You are building an Azure virtual machine.
You allocate two 1-TiB, P30 premium storage disks to the virtual machine. Each disk provides 5,000 IOPS.

You plan to migrate an on-premises instance of Microsoft SQL Server to the virtual machine. The instance has a database that contains a 1.2-TiB data file. The database requires 10,000 IOPS.

You need to configure storage for the virtual machine to support the database.

Which three objects should you create in sequence? To answer, move the appropriate objects from the list of objects to the answer area and arrange them in the correct order.
Select and Place:

  1. See Explanation section for answer.

Answer(s): A

Explanation:




Follow these same steps to create striped virtual disk:

-Create Log Storage Pool.
-Create Virtual Disk
-Create Volume

Box 1: a storage pool

Box 2: a virtual disk that uses stripe layout
Disk Striping: Use multiple disks and stripe them together to get a combined higher IOPS and Throughput limit. The combined limit per VM should be higher than the combined limits of attached premium disks.
Box 3: a volume


Reference:

https://hanu.com/hanu-how-to-striping-of-disks-for-azure-sql-server/



HOTSPOT (Drag and Drop is not supported)
You need to use an Azure Resource Manager (ARM) template to deploy an Azure virtual machine that will host a Microsoft SQL Server instance. The solution must maximize disk I/O performance for the SQL Server database and log files.

How should you complete the template? 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:



You have an Azure SQL managed instance named MI1.
You need to implement automatic tuning for the databases of MI1.
What should you do?

  1. Use The REST API to call the patch operation and modify the AutomaticTuningServerMode property.
  2. From the Azure portal, configure automatic tuning.
  3. Use Transact-SQL to enable the FORCE_LAST_GOOD_PLAN option.

Answer(s): C



Page 37 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