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: 35)

Page 35 of 76
PDF with 352 Questions

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?

  1. Attach two mirrored 4-TB SSDs.
  2. Attach a stripe set that contains four 1-TB SSDs.
  3. Attach a RAID-5 array that contains five 1-TB SSDs.
  4. Attach a single 4-TB SS

Answer(s): B


Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/storage-configuration?tabs=windows2016



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?

  1. Run the DBCC SQLPERF command.
  2. Run the DBCC DBREINDEX command.
  3. Modify the automatic tuning settings for db1.
  4. Modify the Query Store settings for db1.

Answer(s): C


Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-overview



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.

  1. Enable query optimizer fixes.
  2. Enable Resource Governor.
  3. Enable parameter sniffing.
  4. Create a workload group.
  5. Configure In-memory OLTP.
  6. Run the Database Engine Tuning Advisor.
  7. Reduce the Max Degree of Parallelism value.

Answer(s): B,D


Reference:

https://docs.microsoft.com/en-us/sql/relational-databases/resource-governor/resource-governor?view=sql-server-ver15



You have an Azure SQL database named db1 on a server named server1.
The Intelligent Insights diagnostics log identifies queries that cause performance issues due to tempDB contention.
You need to resolve the performance issues.
What should you do?

  1. Implement memory-optimized tables.
  2. Run the DBCC FLUSHPROCINDB command.
  3. Replace the sequential index keys with nonsequential keys.
  4. Run the DBCC DBREINDEX command.

Answer(s): A

Explanation:

TempDB contention troubleshooting:
The diagnostics log outputs tempDB contention details. You can use the information as the starting point for troubleshooting. There are two things you can pursue to alleviate this kind of contention and increase the throughput of the overall workload: You can stop using the temporary tables. You also can use memory- optimized tables.


Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-troubleshoot-performance#tempdb-contention



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