New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: Board70

Download Latest DP-300 Questions

Page: 10 / 11
Question 40

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.

Options:

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

Question 41

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.

Options:

Question 42

You need to provide an implementation plan to configure data retention for ResearchDB1. The solution must meet the security and compliance requirements.

What should you include in the plan?

Options:

A.

Configure the Deleted databases settings for ResearchSrvOL

B.

Deploy and configure an Azure Backup server.

C.

Configure the Advanced Data Security settings for ResearchDBL

D.

Configure the Manage Backups settings for ResearchSrvOL

Question 43

You need to recommend a solution to ensure that the customers can create the database objects. The solution must meet the business goals.

What should you include in the recommendation?

Options:

A.

For each customer, grant the customer ddl_admin to the existing schema.

B.

For each customer, create an additional schema and grant the customer ddl_admin to the new schema.

C.

For each customer, create an additional schema and grant the customer db_writerto the new schema.

D.

For each customer, grant the customer db_writerto the existing schema.

Page: 10 / 11
Exam Code: DP-300
Exam Name: Administering Relational Databases on Microsoft Azure
Last Update: Dec 22, 2024
Questions: 341
DP-300 pdf

DP-300 PDF

$28.5  $94.99
DP-300 Engine

DP-300 Testing Engine

$33  $109.99
DP-300 PDF + Engine

DP-300 PDF + Testing Engine

$43.5  $144.99