Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. DP-300

Microsoft DP-300 Exam Questions
Administering Microsoft Azure SQL Solutions (Page 10 )

Updated On: 17-Feb-2026
Page 10 of 85
PDF with 430 Questions

HOTSPOT (Drag and Drop is not supported)

You have two on-premises servers that run Windows Server 2019 and host a Microsoft SQL server 2017 Always On availability group named AG1. AG1 contains a single database named DB1.

You have an Azure subscription. The subscription contains a virtual machine named VM1 that runs Linux.

You need to migrate DB1 to a SQL Server 2019 instance on VM1. The solution must minimize the downtime of DB1 during the migration.

What should you do? To answer, select the appropriate options in the answer area.

Note: Each correct selection is worth one-point.

Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:





Box 1: Add a secondary replica to AG1.
Migrate an availability group to SQL Server on Azure VM

To ensure the migrated server is synchronized with the source server, stop the SQL Server service on every replica in the availability group, starting with secondary replicas (in SQL Server Configuration Manager > Services) while ensuring the disks hosting SQL data are online.

Incorrect:
* Upgrade to SQL Server 2019
No need to upgrade to SQL Server 2019

* Create a SQL Server 2019 Always ON available group on VM1.
You do that afterwards.
After the migration, enable Always On availability groups for the database.

Box 2: Azure Migrate
You can migrate your SQL Server Always On availability group to SQL Server on Azure VMs using the Azure Migrate: Server Migration tool. Using the migration tool, you will be able to migrate each replica in the availability group to an Azure VM hosting SQL Server, as well as the cluster metadata, availability group metadata and other necessary high availability components.


Reference:

https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/virtual-machines/sql-server-availability- group-to-sql-on-azure-vm



DRAG DROP (Drag and Drop is not supported)

You have an Azure SQL database named DB1.

You need to create a partitioned table in DB1.

Which three objects should you create in sequence? To answer, move the appropriate objects from the list of objects to the answer area and arrange them in the correct order.

Select and Place:

  1. See Explanation section for answer.

Answer(s): A

Explanation:






Create partitioned tables and indexes
Creating a partitioned table or index typically happens in three or four parts:

1. Optionally create a filegroup or filegroups and corresponding data files that will hold the partitions specified by the partition scheme. The main reason to place partitions on multiple filegroups is to ensure you can independently perform backup and restore operations on filegroups. If this is not required, you may choose to assign all partitions to a single filegroup, using either an existing filegroup, such as PRIMARY, or a new filegroup with related data file(s). In nearly all scenarios, you will achieve all benefits of partitioning whether or not you use multiple filegroups.

2. Create a partition function that maps the rows of a table or index into partitions based on the values of a specified column. You can use a single partition function to partition multiple objects. (Step 1)

3. Create a partition scheme that maps the partitions of a partitioned table or index to one filegroup or to multiple filegroups. You can use a single partition scheme to partition multiple objects. (Step 2)

4. Create or alter a table or index and specify the partition scheme as the storage location, along with the column that will serve as the partitioning column. (Step 3)

Aligns all indexes of the table that are partitioned with the same partition scheme.
When a table and its indexes are aligned, you can move partitions in and out of partitioned tables more effectively, because your data is partitioned in the same way.

Step 1: a partition function

Step 2: a partition scheme

Step 3: an aligned index


Reference:

https://learn.microsoft.com/en-us/sql/relational-databases/partitions/create-partitioned-tables-and-indexes



DRAG DROP (Drag and Drop is not supported)

You have an Azure subscription that contains an instance of SQL Server on Azure Virtual Machines named SQLVM1 and a virtual machine named Server1 that runs Windows Server. SQLVM1 and Server1 are joined to an Active Directory Domain Services (AD DS) domain. Server1 hosts a file share named Share1.

You need to ensure that a SQL Server Agent job step on SQLVM1 can access the files in Share1. The solution must use the principle of least privilege.

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.

Select and Place:

  1. See Explanation section for answer.

Answer(s): A

Explanation:






Step 1: Create a credential
You must create a credential before you create a proxy if one is not already available.

Note: SQL Server Agent uses Proxies to define the security context for job steps. Basically, a proxy is an object that provides SQL Server Agent access to stored credentials for a Windows user.
When running a job step that is configured to use a proxy, SQL Server Agent impersonates the credentials defined in the proxy, and then runs the job step using that security context.

Step 2: Create a proxy
A SQL Server Agent proxy account defines a security context in which a job step can run. Each proxy corresponds to a security credential. To set permissions for a particular job step, create a proxy that has the required permissions for a SQL Server Agent subsystem, and then assign that proxy to the job step.

Step 3: Assign the proxy to the job step


Reference:

https://learn.microsoft.com/en-us/answers/questions/613796/ssis-proxy-and-credential-manager https://learn.microsoft.com/en-us/sql/ssms/agent/create-a-sql-server-agent-proxy



You have an Azure subscription.

You need to deploy an instance of SQL Server on Azure Virtual Machines. The solution must meet the following requirements:

Custom performance configuration, such as IOPS, capacity, and throughout, must be supported.

Costs must be minimized.

Which type of disk should you include in the solution?

  1. Premium SSD v2
  2. Premium SSD
  3. Standard SSD
  4. Ultra SSD

Answer(s): A

Explanation:

Differences between Premium SSD and Premium SSD v2
Unlike Premium SSDs, Premium SSD v2 doesn't have dedicated sizes. You can set a Premium SSD v2 to any supported size you prefer, and make granular adjustments to the performance without downtime. Premium SSD v2 doesn't support host caching but, benefits significantly from lower latency, which addresses some of the same core problems host caching addresses. The ability to adjust IOPS, throughput, and size at any time also means you can avoid the maintenance overhead of having to stripe disks to meet your needs.


Reference:

https://learn.microsoft.com/en-us/azure/virtual-machines/disks-types



You have an on-premises datacenter that contains a 14-TB Microsoft SQL Server database.

You plan to create an Azure SQL managed instance and migrate the on-premises database to the new instance.

Which three service tiers support the SQL managed instance? Each correct answer presents a complete solution.

Note: Each correct selection is worth one point.

  1. General Purpose Standard
  2. Business Critical Memory Optimized Premium
  3. General Purpose Premium
  4. Business Critical Premium
  5. Business Critical Standard

Answer(s): A,B,C

Explanation:

Hardware configurations have different characteristics, as described in the following table:


Reference:

https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits






Post your Comments and Discuss Microsoft DP-300 exam dumps with other Community members:

Join the DP-300 Discussion