Spring Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Microsoft Certified: Azure Database Administrator Associate DP-300 Exam Questions and Answers PDF

Page: 7 / 11
Total 366 questions

Administering Relational Databases on Microsoft Azure Questions and Answers

Question 25

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 26

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 27

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?

Options:

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 28

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?

Options:

A.

dynamic data masking

B.

Conditional Access in Azure

C.

service principals

D.

row-level security (RLS)

Page: 7 / 11
Total 366 questions