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

Administering Relational Databases on Microsoft Azure Questions and Answers

Question 25

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.

Question 26

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?

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

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

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

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

Question 27

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.

Question 28

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?

CREATE LOGIN and the FROM WINDOWS clause

CREATE USER and the FROM CERTIFICATE clause

CREATE USER and the FROM LOGIN clause

CREATE USER and the ASYMMETRIC KEY clause

CREATE USER and the FROM EXTERNAL PROVIDER clause