Microsoft Certified: Azure Database Administrator Associate DP-300 Passing Score

Administering Relational Databases on Microsoft Azure Questions and Answers

Question 9

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, , , , , , , Basic Concept: This question tests secure database administration, where the control must match the data state, access boundary, identity model, or compliance requirement., Why D is Correct: Row-Level Security filters rows returned by queries based on a predicate function, allowing different users or tenants to see different subsets of the same tables. This fits the case because the requested outcome is: Which feature should you use to provide customers with the required level of access based on their service agreement? The selected feature addresses that outcome directly rather than relying on a workaround., Why A is Wrong: Dynamic Data Masking obscures sensitive values in query results for non-privileged users, but it does not restrict which rows are returned. Masking can hide column values, but it cannot enforce different row visibility by customer tier or service agreement., Why B is Wrong: Conditional Access in Azure is a security-related control, but its value depends on whether the requirement is identity, encryption, auditing, network isolation, or data exposure reduction. It does not satisfy the required identity, encryption, firewall, auditing, or data-exposure boundary described in the scenario: Which feature should you use to provide customers with the required level of access based on their service agreement?, Why C is Wrong: service principals is a security-related control, but its value depends on whether the requirement is identity, encryption, auditing, network isolation, or data exposure reduction. It protects or manages a different security layer, so the required database access or protection behavior would still be incomplete., ]

Question 10

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.

Basic Concept: This question tests high availability and disaster recovery design for Azure SQL, SQL Server on Azure VMs, and regional failure scenarios.

Why B is Correct: Update the connection strings of SalesSQLDb1App1. is part of the availability or recovery design space, but the correct choice must satisfy the specified failover, restore, quorum, RPO, or RTO requirement. In this scenario, the important constraint is: What should you do after a failover of SalesSQLDb1 to ensure that the database remains accessible to SalesSQLDb1App1? Update the connection strings of SalesSQLDb1App1. satisfies that constraint without adding an unrelated service or manual process.

Why A is Wrong: Configure SalesSQLDb1 as writable. is part of the availability or recovery design space, but the correct choice must satisfy the specified failover, restore, quorum, RPO, or RTO requirement. It is not wrong technology in general, but it is the wrong HA/DR control for this scenario ' s failure model.

Why C is Wrong: Update the firewall rules of SalesSQLDb1. is part of the availability or recovery design space, but the correct choice must satisfy the specified failover, restore, quorum, RPO, or RTO requirement. It handles a different resilience pattern and would not deliver the failover or recovery behavior required here.

Why D is Wrong: Update the users in SalesSQLDb1. is part of the availability or recovery design space, but the correct choice must satisfy the specified failover, restore, quorum, RPO, or RTO requirement. It is not wrong technology in general, but it is the wrong HA/DR control for this scenario ' s failure model.

Question 11

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.

Options:

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 Schedules

2. 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, , , ]

Question 12

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:

Answer:

Explanation:

[Reference:, https://docs.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-azure-key-vault-configure?tabs=azure-powershell, , , , , , , , Basic Concept: This question tests secure database administration, where the control must match the data state, access boundary, identity model, or compliance requirement., Why the selected answer is Correct: The selected values fit this scenario because they apply the required Azure SQL configuration at the correct scope and sequence: You need to implement security for ResearchDB1., Why the alternate choices are Wrong: The alternate selections apply to different administrative stages or different scopes. In a hotspot or drag-drop task, order and scope are part of the answer, so a technically valid Azure feature can still be wrong if it is placed in the wrong step., ]

Online DP-300 Questions Video
Microsoft Certified: Azure Database Administrator Associate DP-300 Passing Score
Changed DP-300 Exam Questions
Pearson DP-300 New Attempt
Microsoft DP-300 Questions Answers
Microsoft Certified: Azure Database Administrator Associate DP-300 Exam Questions and Answers PDF
Free Access Microsoft DP-300 New Release
Microsoft Certified: Azure Database Administrator Associate DP-300 Microsoft Study Notes
Microsoft Certified: Azure Database Administrator Associate DP-300 Syllabus Exam Questions Answers
New Release DP-300 Microsoft Certified: Azure Database Administrator Associate Questions
Get More Microsoft Exams Free Access

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

Microsoft Certified: Azure Database Administrator Associate DP-300 Passing Score

Administering Relational Databases on Microsoft Azure Questions and Answers

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

CompTIA

Fortinet

Microsoft

Salesforce