Exit demo DP-300 Administering Relational Databases on Microsoft Azure PDF format · free preview

Microsoft DP-300 - Questions & Answers

Free preview · every answer includes a full explanation

Product page: https://prepkeys.com/dp-300.html

Question 1
Single choice

You are evaluating the business goals.

Which feature should you use to provide customers with the required level of access based on their service agreement?

A.

dynamic data masking

B.

Conditional Access in Azure

C.

service principals

D.

row-level security (RLS)

Question 2
Single choice

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?

A.

Configure the Deleted databases settings for ResearchSrv01.

B.

Deploy and configure an Azure Backup server.

C.

Configure the Advanced Data Security settings for ResearchDB1.

D.

Configure the Manage Backups settings for ResearchSrv01.

Question 3
Single choice

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?

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_writer to the new schema.

D.

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

Question 4
Multiple choice

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.

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 5
Single choice

What should you do after a failover of SalesSQLDb1 to ensure that the database remains accessible to SalesSQLDb1App1?

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.

Question 6
Single choice

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?

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

Question 7
Drag & drop

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.

Question 8
Drag & drop

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.

Question 9
Drag & drop

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.

Question 10
Hotspot

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.

Showing 10 of 376 questions · Unlock the full set