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

Page 25 of 76
PDF with 352 Questions

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?

  1. SQL Profiler
  2. Extended Events
  3. Query Store
  4. dynamic management views

Answer(s): D

Explanation:

Use the dynamic management view sys.dm_exec_requests to track currently executing queries and the associated worker time.
Incorrect:
Not C: DMVs that track Query Store and wait statistics show results for only successfully completed and timed-out queries.


Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/identify-query-performance-issues



You have an Azure SQL database named DB1.
You need to display the estimated execution plan of a query by using the query editor in the Azure portal. What should you do first?

  1. Run the SET SHOWPLAN_ALL Transact-SQL statement.
  2. For DB1, set QUERY_CAPTURE_MODE of Query Store to All.
  3. Run the SET FORCEPLAN Transact-SQL statement.
  4. Enable Query Store for DB1.

Answer(s): A

Explanation:

The SET SHOWPLAN_ALL command causes Microsoft SQL Server not to execute Transact-SQL statements. Instead, SQL Server returns detailed information about how the statements are executed and provides estimates of the resource requirements for the statements.


Reference:

https://docs.microsoft.com/en-us/sql/t-sql/statements/set-showplan-all-transact-sql?view=sql-server-ver15



HOTSPOT (Drag and Drop is not supported)
You have an Azure SQL database.
You have a query and the associated execution plan as 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:

  1. See Explanation section for answer.

Answer(s): A

Explanation:


Box 1: Key Lookup
The Key Lookup cost is 99% so that is the performance bottleneck.

Box 2: nonclustered index
The key lookup on the clustered index is used because the nonclustered index does not include the required columns to resolve the query. If you add the required columns to the nonclustered index, the key lookup will not be required.



You have an instance of SQL Server on Azure Virtual Machines that has a database named DB1.
You plan to implement Azure SQL Data Sync for DB1.
Which isolation level should you configure?

  1. SERIALIZABLE
  2. SNAPSHOT
  3. READ UNCOMMITTED
  4. READ COMMITTED

Answer(s): B

Explanation:

Data Sync general requirements include:
* Snapshot isolation must be enabled for both Sync members and hub.


Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-data-sql-server-sql-database



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