You manage a SQL Server 2019 on an Azure VM that is part of a hybrid architecture. The VM is behind a load balancer with another VM. You need to apply a critical SQL Server security patch without dropping the availability of the application. What should you do?

Use Azure SQL Database's built-in patching mechanism

Remove one VM from the load balancer, patch it, then re-add it and repeat for the other VM

Patch the primary VM first, then the secondary VM

Apply the patch to both VMs simultaneously during off-peak hours

A DBA needs to manually apply a critical SQL Server security patch to a SQL Server on Azure VM. What is the first step they should take?

Use the Azure portal to apply the patch

Use Azure SQL Database patching

Connect to the VM using RDP or Bastion

A company runs SQL Server on Azure VMs in a high-availability configuration using Always On Availability Groups. They need to apply security patches to the SQL Server and Windows OS without causing a failover or downtime. They also want to automate the patching process. Which approach should you recommend?

Patch all replicas at the same time

Skip patching to avoid downtime

Use Azure Update Management to patch all VMs at once

Patch each replica sequentially, starting with the secondary replicas, and then perform a manual failover to patch the primary

An organization uses Azure DevOps and wants to deploy SQL Server on Azure VMs as part of a CI/CD pipeline. They need a method that can be integrated into a pipeline and executed from the command line. Which tool should they use?

SQL Server Management Studio (SSMS)

Microsoft Certified:Azure Database Administrator Associate

Domain 1Objective 1

Plan and Deploy Azure SQL Solutions DP-300 Practice Questions (Page 3)

Part of the Plan and implement data platform resources domain, which accounts for 15–20% of the DP-300 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~6–13 in this domain), expect 2–4 from this objective — we provide 31 practice questions to prepare you well beyond it. (estimate)

31questions here

7free pages

9concepts

15–20%of the exam

Questions 11–15

11application · medium
You manage a SQL Server 2019 on an Azure VM that is part of a hybrid architecture. The VM is behind a load balancer with another VM. You need to apply a critical SQL Server security patch without dropping the availability of the application. What should you do?
Select an answer first
12foundation · easy
A DBA needs to manually apply a critical SQL Server security patch to a SQL Server on Azure VM. What is the first step they should take?
Select an answer first
13expert · hard
A company runs SQL Server on Azure VMs in a high-availability configuration using Always On Availability Groups. They need to apply security patches to the SQL Server and Windows OS without causing a failover or downtime. They also want to automate the patching process. Which approach should you recommend?
Select an answer first
14foundation · easy
A company wants to use Azure to manage and monitor their on-premises SQL Server instances through the Azure portal. Which service should they implement?
Select an answer first
15foundation · easy
An organization uses Azure DevOps and wants to deploy SQL Server on Azure VMs as part of a CI/CD pipeline. They need a method that can be integrated into a pipeline and executed from the command line. Which tool should they use?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-300

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-300” is a trademark of its owner, used for identification only.

Plan and Deploy Azure SQL Solutions DP-300 Practice Questions (Page 3)

Questions 11–15

You manage a SQL Server 2019 on an Azure VM that is part of a hybrid architecture. The VM is behind a load balancer with another VM. You need to apply a critical SQL Server security patch without dropping the availability of the application. What should you do?

A DBA needs to manually apply a critical SQL Server security patch to a SQL Server on Azure VM. What is the first step they should take?

A company wants to use Azure to manage and monitor their on-premises SQL Server instances through the Azure portal. Which service should they implement?

An organization uses Azure DevOps and wants to deploy SQL Server on Azure VMs as part of a CI/CD pipeline. They need a method that can be integrated into a pipeline and executed from the command line. Which tool should they use?

Keep studying — Plan and implement data platform resources