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

Page 26 of 76
PDF with 369 Questions

HOTSPOT (Drag and Drop is not supported)
You have SQL Server on an Azure virtual machine.
You review the query plan shown in the following exhibit.


For each of the following statements, select yes if the statement is true. Otherwise, select no.

NOTE: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:


Reference:

https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store



A data engineer creates a table to store employee information for a new application. All employee names are in the US English alphabet. All addresses are locations in the United States. The data engineer uses the following statement to create the table.


You need to recommend changes to the data types to reduce storage and improve performance. Which two actions should you recommend? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

  1. Change Salary to the money data type.
  2. Change PhoneNumber to the float data type.
  3. Change LastHireDate to the datetime2(7) data type.
  4. Change PhoneNumber to the bigint data type.
  5. Change LastHireDate to the date data type.

Answer(s): A,E



You have an Azure SQL database. You identify a long running query.
You need to identify which operation in the query is causing the performance issue.

What should you use to display the query execution plan in Microsoft SQL Server Management Studio (SSMS)?

  1. Live Query Statistics
  2. an estimated execution plan
  3. an actual execution plan
  4. Client Statistics

Answer(s): A

Explanation:

SQL Server Management Studio provides the ability to view the live execution plan of an active query. This live query plan provides real-time insights into the query execution process as the controls flow from one query plan operator to another. The live query plan displays the overall query progress and operator-level run-time execution statistics such as the number of rows produced, elapsed time, operator progress, etc. Because this data is available in real time without needing to wait for the query to complete, these execution statistics are extremely useful for debugging query performance issues.


Reference:

https://docs.microsoft.com/en-us/sql/relational-databases/performance/display-an-actual-execution-plan



You have a version-8.0 Azure Database for MySQL database.
You need to identify which database queries consume the most resources. Which tool should you use?

  1. Query Store
  2. Metrics
  3. Query Performance Insight
  4. Alerts

Answer(s): A

Explanation:

The Query Store feature in Azure Database for MySQL provides a way to track query performance over time. Query Store simplifies performance troubleshooting by helping you quickly find the longest running and most resource-intensive queries. Query Store automatically captures a history of queries and runtime statistics, and it retains them for your review. It separates data by time windows so that you can see database usage patterns. Data for all users, databases, and queries is stored in the mysql schema database in the Azure Database for MySQL instance.


Reference:

https://docs.microsoft.com/en-us/azure/mysql/concepts-query-store






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

DP-300 Exam Discussions & Posts