Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Home
Microsoft
Microsoft Certified: Azure Database Administrator Associate
DP-300
Administering Relational Databases on Microsoft Azure Questions and Answers

Pass the Microsoft Certified: Azure Database Administrator Associate DP-300 Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.

Exam DP-300 Premium Access

View all detail and faqs for the DP-300 exam

Go to Exam

796 Students Passed

85% Average Score

96% Same Questions

Viewing page 3 out of 13 pages

Viewing questions 21-30 out of questions

Questions # 21:

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 # 21

Options:

Answer

Answer:

Explanation

Automating Azure SQL DB index and statistics maintenance using Azure Automation:

1. Create Azure automation account (Step 1)

2. Import SQLServer module (Step 2)

3. Add Credentials to access SQL DB

This will use secure way to hold login name and password that will be used to access Azure SQL DB

4. Add a runbook to run the maintenance (Step 3)

Steps: 1. Click on "runbooks" at the left panel and then click "add a runbook"

2. Choose "create a new runbook" and then give it a name and choose "Powershell" as the type of the runbook and then click on "create"

5. Schedule task (Step 4)

Steps:1. Click on Schedules2. Click on "Add a schedule" and follow the instructions to choose existing schedule or create a new schedule.

[Reference:, https://techcommunity.microsoft.com/t5/azure-database-support-blog/automating-azure-sql-db-index-and-statistics-maintenance-using/ba-p/368974, , ]

Questions # 22:

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 # 22

Options:

Answer

Answer:

Explanation

Azure Database Migration service

Box 1: Premium 4-VCore

Scenario: Migrate the SERVER1 databases to the Azure SQL Database platform.

Minimize downtime during the migration of the SERVER1 databases.

Premimum 4-vCore is for large or business critical workloads. It supports online migrations, offline migrations, and faster migration speeds.

[Reference:, https://azure.microsoft.com/pricing/details/database-migration/, , https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-azure-sql-online, , , ]

Questions # 23:

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 # 23

Options:

Answer

Answer:

Explanation

Scenario: Authenticate database users by using Active Directory credentials.

The configuration steps include the following procedures to configure and use Azure Active Directory authentication.

Create and populate Azure AD.

Optional: Associate or change the active directory that is currently associated with your Azure Subscription.

Create an Azure Active Directory administrator. (Step 1)

Configure your client computers.

Create contained database users in your database mapped to Azure AD identities. (Step 2)

Connect to your database by using Azure AD identities. (Step 3)

[Reference:, https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview, , , ]

Questions # 24:

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:

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.

Answer

Questions # 25:

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:

dynamic data masking

Conditional Access in Azure

service principals

row-level security (RLS)

Answer

Explanation

[Reference:, https://docs.microsoft.com/en-us/sql/relational-databases/security/row-level-security?view=sql-server-ver15, , ]

Questions # 26:

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:

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

Answer

Explanation

Scenario: Authenticate database users by using Active Directory credentials.

(Create a new Azure SQL database named ResearchDB1 on a logical server named ResearchSrv01.)

Authenticate the user in SQL Database or SQL Data Warehouse based on an Azure Active Directory user:

CREATE USER [Fritz@contoso.com] FROM EXTERNAL PROVIDER;

[Reference:, https://docs.microsoft.com/en-us/sql/t-sql/statements/create-user-transact-sql, , , ]

Questions # 27:

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:

sys.dm_pdw_nodes_tran_locks

sys.dm_exec_compute_node_errors

sys.dm_exec_requests

sys.dm_cdc_errors

sys.dm_pdw_nodes_os_wait_stats

sys.dm_tran_locks

Answer

A, E

Explanation

SalesSQLDb1 experiences performance issues that are likely due to out-of-date statistics and frequent blocking queries.

A: Use sys.dm_pdw_nodes_tran_locks instead of sys.dm_tran_locks from Azure Synapse Analytics (SQL Data Warehouse) or Parallel Data Warehouse.

E: Example:

The following query will show blocking information.

SELECT

t1.resource_type,

t1.resource_database_id,

t1.resource_associated_entity_id,

t1.request_mode,

t1.request_session_id,

t2.blocking_session_id

FROM sys.dm_tran_locks as t1

INNER JOIN sys.dm_os_waiting_tasks as t2

ON t1.lock_owner_address = t2.resource_address;

Note: Depending on the system you’re working with you can access these wait statistics from one of three locations:

sys.dm_os_wait_stats: for SQL Server

sys.dm_db_wait_stats: for Azure SQL Database

sys.dm_pdw_nodes_os_wait_stats: for Azure SQL Data Warehouse

[Reference:, https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-tran-locks-transact-sql, , ]

Questions # 28:

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.

Question # 28

Options:

Answer

Answer:

Explanation

[Reference:, https://docs.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-azure-key-vault-configure?tabs=azure-powershell, , , ]

Questions # 29:

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

Options:

Configure SalesSQLDb1 as writable.

Update the connection strings of SalesSQLDb1App1.

Update the firewall rules of SalesSQLDb1.

Update the users in SalesSQLDb1.

Answer

Explanation

Scenario: SalesSQLDb1 uses database firewall rules and contained database users.

Questions # 30:

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?