20:00

PDF|

Guide for Administering Relational Databases on Microsoft Azure

Quiz Administering Relational Databases on Microsoft Azure

Free Test
/ 10

Quiz

1/10
HOTSPOT

You are planning the migration of the SERVER1 databases. The solution must meet the business
requirements.

What should you include in the migration plan? To answer, select the appropriate options in the
answer area.

NOTE: Each correct selection is worth one point.




Certification Exam Administering Relational Databases on Microsoft Azure Microsoft Microsoft-DP-300 3-853511265
Select the answer
1 correct answer
Certification Exam Administering Relational Databases on Microsoft Azure Microsoft Microsoft-DP-300 2-3979073211

Quiz

2/10
DRAG DROP

You need to configure user authentication for the SERVER1 databases. The solution must meet the
security and compliance requirements.

Which three actions should you perform in sequence? To answer, move the appropriate actions from
the list of actions to the answer area and arrange them in the correct order.



Certification Exam Administering Relational Databases on Microsoft Azure Microsoft Microsoft-DP-300 4-1137161577
Select the answer
1 correct answer
Certification Exam Administering Relational Databases on Microsoft Azure Microsoft Microsoft-DP-300 5-613194857

Quiz

3/10
HOTSPOT

You need to implement the monitoring of SalesSQLDb1. The solution must meet the technical
requirements.

How should you collect and stream metrics? To answer, select the appropriate options in the answer
area.

NOTE: Each correct selection is worth one point.





Certification Exam Administering Relational Databases on Microsoft Azure Microsoft Microsoft-DP-300 6-822211643
Select the answer
1 correct answer
Certification Exam Administering Relational Databases on Microsoft Azure Microsoft Microsoft-DP-300 7-497040449

Quiz

4/10
You need to identify the cause of the performance issues on SalesSQLDb1.
Which two dynamic management views should you use? Each correct answer presents part of the
solution.
NOTE: Each correct selection is worth one point.
Select the answer
2 correct answers
A.
sys.dm_pdw_nodes_tran_locks
B.
sys.dm_exec_compute_node_errors
C.
sys.dm_exec_requests
D.
sys.dm_cdc_errors
E.
sys.dm_pdw_nodes_os_wait_stats
F.
sys.dm_tran_locks

Quiz

5/10
HOTSPOT

You need to recommend a configuration for ManufacturingSQLDb1 after the migration to Azure. The
solution must meet the business requirements.

What should you include in the recommendation? To answer, select the appropriate options in the
answer area.

NOTE: Each correct selection is worth one point.





Certification Exam Administering Relational Databases on Microsoft Azure Microsoft Microsoft-DP-300 9-1715126331
Select the answer
1 correct answer
Certification Exam Administering Relational Databases on Microsoft Azure Microsoft Microsoft-DP-300 8-1430308255

Quiz

6/10
You need to implement authentication for ResearchDB1. The solution must meet the security and
compliance requirements.
What should you run as part of the implementation?
Select the answer
1 correct answer
A.
CREATE LOGIN and the FROM WINDOWS clause
B.
CREATE USER and the FROM CERTIFICATE clause
C.
CREATE USER and the FROM LOGIN clause
D.
CREATE USER and the ASYMMETRIC KEY clause
E.
CREATE USER and the FROM EXTERNAL PROVIDER clause

Quiz

7/10
HOTSPOT

You need to recommend the appropriate purchasing model and deployment option for the 30 new
databases. The solution must meet the technical requirements and the business requirements.

What should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.


Certification Exam Administering Relational Databases on Microsoft Azure Microsoft Microsoft-DP-300 11-423410266
Select the answer
1 correct answer
Certification Exam Administering Relational Databases on Microsoft Azure Microsoft Microsoft-DP-300 10-1496372516

Quiz

8/10
DRAG DROP

You need to implement statistics maintenance for SalesSQLDb1. The solution must meet the
technical requirements.

Which four actions should you perform in sequence? To answer, move the appropriate actions from
the list of actions to the answer area and arrange them in the correct order.





Certification Exam Administering Relational Databases on Microsoft Azure Microsoft Microsoft-DP-300 12-2042637898
Select the answer
1 correct answer
Certification Exam Administering Relational Databases on Microsoft Azure Microsoft Microsoft-DP-300 13-155107962

Quiz

9/10
What should you do after a failover of SalesSQLDb1 to ensure that the database remains accessible
to SalesSQLDb1App1?
Select the answer
1 correct answer
A.
Configure SalesSQLDb1 as writable.
B.
Update the connection strings of SalesSQLDb1App1.
C.
Update the firewall rules of SalesSQLDb1.
D.
Update the users in SalesSQLDb1.

Quiz

10/10
DRAG DROP

You create all of the tables and views for ResearchDB1.

You need to implement security for ResearchDB1. The solution must meet the security and
compliance requirements.

Which three actions should you perform in sequence? To answer, move the appropriate actions from
the list of actions to the answer area and arrange them in the correct order.



Certification Exam Administering Relational Databases on Microsoft Azure Microsoft Microsoft-DP-300 16-927299209
Select the answer
1 correct answer
Certification Exam Administering Relational Databases on Microsoft Azure Microsoft Microsoft-DP-300 15-1640015122
Looking for more questions?Buy now

Administering Relational Databases on Microsoft Azure Practice test unlocks all online simulator questions

Thank you for choosing the free version of the Administering Relational Databases on Microsoft Azure practice test! Further deepen your knowledge on Microsoft Simulator; by unlocking the full version of our Administering Relational Databases on Microsoft Azure Simulator you will be able to take tests with over 261 constantly updated questions and easily pass your exam. 98% of people pass the exam in the first attempt after preparing with our 261 questions.

BUY NOW

What to expect from our Administering Relational Databases on Microsoft Azure practice tests and how to prepare for any exam?

The Administering Relational Databases on Microsoft Azure Simulator Practice Tests are part of the Microsoft Database and are the best way to prepare for any Administering Relational Databases on Microsoft Azure exam. The Administering Relational Databases on Microsoft Azure practice tests consist of 261 questions and are written by experts to help you and prepare you to pass the exam on the first attempt. The Administering Relational Databases on Microsoft Azure database includes questions from previous and other exams, which means you will be able to practice simulating past and future questions. Preparation with Administering Relational Databases on Microsoft Azure Simulator will also give you an idea of the time it will take to complete each section of the Administering Relational Databases on Microsoft Azure practice test . It is important to note that the Administering Relational Databases on Microsoft Azure Simulator does not replace the classic Administering Relational Databases on Microsoft Azure study guides; however, the Simulator provides valuable insights into what to expect and how much work needs to be done to prepare for the Administering Relational Databases on Microsoft Azure exam.

BUY NOW

Administering Relational Databases on Microsoft Azure Practice test therefore represents an excellent tool to prepare for the actual exam together with our Microsoft practice test . Our Administering Relational Databases on Microsoft Azure Simulator will help you assess your level of preparation and understand your strengths and weaknesses. Below you can read all the quizzes you will find in our Administering Relational Databases on Microsoft Azure Simulator and how our unique Administering Relational Databases on Microsoft Azure Database made up of real questions:

Info quiz:

  • Quiz name:Administering Relational Databases on Microsoft Azure
  • Total number of questions:261
  • Number of questions for the test:50
  • Pass score:80%

You can prepare for the Administering Relational Databases on Microsoft Azure exams with our mobile app. It is very easy to use and even works offline in case of network failure, with all the functions you need to study and practice with our Administering Relational Databases on Microsoft Azure Simulator.

Use our Mobile App, available for both Android and iOS devices, with our Administering Relational Databases on Microsoft Azure Simulator . You can use it anywhere and always remember that our mobile app is free and available on all stores.

Our Mobile App contains all Administering Relational Databases on Microsoft Azure practice tests which consist of 261 questions and also provide study material to pass the final Administering Relational Databases on Microsoft Azure exam with guaranteed success. Our Administering Relational Databases on Microsoft Azure database contain hundreds of questions and Microsoft Tests related to Administering Relational Databases on Microsoft Azure Exam. This way you can practice anywhere you want, even offline without the internet.

BUY NOW