According to the Official Syllabus of Actual Microsoft DP-300 Exam

Microsoft DP-300 Exam

Administering Relational Databases on Microsoft Azure

Total Questions: 176

Based on Official Syllabus Topics of Actual Microsoft DP-300 Exam

During the preparation for your Azure Database Administrator Associate certification Exam, you may get confused about the question types, exam pattern, and time allotted for Microsoft exams. Study4Certify helps you eliminate these doubts through its actual Microsoft DP-300 exam questions. We made sure you can easily pass the Microsoft Administering Relational Databases on Microsoft Azure Exam by using DP-300 practice questions. You can use your smartphone, laptop, or tablet to prepare Azure Database Administrator Associate exam questions in PDF format anytime, anywhere. The evaluation of preparation is one of the most important parts to remove your mistakes and successfully prepare for the Microsoft DP-300 exam. The Microsoft Azure Database Administrator Associate practice questions help you to strengthen your weaker points, and get familiar with the actual exam questions. They are available at a cheap price along with some Free Microsoft DP-300 exam questions

How Do These Free Questions Help You Prepare for the Real Microsoft DP-300 Exam?

Make Yourself Familiar with the Actual Microsoft Exam Syllabus, Format, and Question Types

Keep yourself updated with the official information about the syllabus and format of the exam to develop an effective study plan. This information can make you familiar with the questions and topics that will appear on the actual Microsoft DP-300 exam. Don't waste time and focus on the learning content expected in the actual exam.

Evaluate Your Preparation for the Actual DP-300 Exam

Manage your daily work to ensure that you have enough time every day to study the Administering Relational Databases on Microsoft Azure exam questions. Sit in a quiet environment and study hard every day to complete the entire DP-300 exam syllabus. Everyone knows it is impossible to study in just one morning and pass the DP-300 exam the next day. If you want to pass your exam with excellent marks on the first attempt, prepare with the Microsoft DP-300 practice questions exam every day.

Microsoft DP-300 Exam Questions

Question 1 

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?

A: the Azure portal
 

B: Extended Events
 

C: Query Store
 

D: dynamic management views

 

Answer: C

Question 2 

You have an Azure SQL managed instance.

You need to gather the last execution of a query plan and its runtime statistics. The solution must minimize the impact on currently running queries.

What should you do?

A: Generate an estimated execution plan.
 

B: Generate an actual execution plan.
 

C: Run sys.dm_exec_query_plan_scacs.
 

D: Generate Live Query Statistics.

 

Answer: C 

 

Question 3 

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.

A: Enable query optimizer fixes.
 

B: Enable Resource Governor.
 

C: Enable parameter sniffing.
 

D: Create a workload group.
 

E: Configure In-memory OLTP.
 

F: Run the Database Engine Tuning Advisor.
 

G: Reduce the Max Degree of Parallelism value.
 

Answer: B, C 

 

Question 4 

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?

A: RuntheDBCC SQLPERF command.
 

B: Run the dbcc dbreindex command.
 

C: Modify the automatic tuning settings for db1.
 

D: Modify the Query Store settings for db1.
 

Answer: C 

 

Question 5 

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?

A: Attach two mirrored 4-TB SSDs.
 

B: Attach a stripe set that contains four 1-TB SSDs.
 

C: Attach a RAID-5 array that contains five 1-TB SSDs.
 

D: Attach a single 4-TB SSD.
 

Answer: B 

 

Get Full Access for Microsoft DP-300 questions with 50% exclusive Discount

Get All Questions DemoImgs1