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

Page 25 of 76
PDF with 369 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






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

DP-300 Exam Discussions & Posts