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 7 )

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

You have an Azure SQL Database elastic pool that contains 10 databases.

You receive the following alert.

Msg 1132, Level 16, state 1, Line 1
The elastic pool has reached its storage limit. The storage used for the elastic pool cannot exceed (76800) MBs.

You need to resolve the alert. The solution must minimize administrative effort.

Which three actions can you perform? Each correct answer presents a complete solution.

Note: Each correct selection is worth one point.

  1. Increase the maximum storage of the elastic pool.
  2. Delete data from a database.
  3. Remove a database from the pool.
  4. Enable data compression.
  5. Shrink individual databases.

Answer(s): A,D,E



You have an Azure subscription.

You need to deploy a new Azure SQL database by using Azure Command-Line Interface (CLI).

Which three parameters are required?

  1. --name, --edition, and --capacity
  2. --name, --tier, and --min-capacity
  3. --name, --resource-group, and --server
  4. --name, --licence-type, and --capacity

Answer(s): C

Explanation:

az sql db create
Create a database
Syntax: az sql db create --name
--resource-group
--server
Plus many additonal optional parameters.
Required Parameters
--name -n
Name of the Azure SQL Database.
--resource-group -g
Name of resource group. You can configure the default group using az configure --defaults group=<name>.
--server -s
Name of the Azure SQL Server. You can configure the default using az configure --defaults sql- server=<name>.
Example:
echo "Creating $database on $server..."
az sql db create --resource-group $resourceGroup --server $server --name $database --sample-name AdventureWorksLT --edition GeneralPurpose --family Gen5 --capacity 2 --zone-redundant true # zone redundancy is only supported on premium and business critical service tiers


Reference:

https://learn.microsoft.com/en-us/cli/azure/sql/db



HOTSPOT (Drag and Drop is not supported)

You have an Azure subscription.

You plan to migrate 10 on-premises Microsoft SQL Server instances to Azure.

You need to ensure that the migrated environment can be managed by using multiserver administration and supports master/target (MSX/TSX) jobs.

The solution must minimize administrative effort.

Which SQL deployment options should you select as the master server (MSX) and the target server (TSX)? 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: SQL Managed Instance
MSX

Make a Master Server
Applies to: SQL Server, Azure SQL Managed Instance
On Azure SQL Managed Instance, most, but not all SQL Server Agent features are currently supported.

To make a master server
1. Connect to the Database Engine.

2. From the Standard bar, click New Query.

3. Copy and paste the following example into the query window and click Execute. This example enlists the current server into the AdventureWorks1 master server. The location for the current server is Building 21, Room 309, Rack 5.

USE msdb ;
GO

EXEC dbo.sp_msx_enlist N'AdventureWorks1',
N'Building 21, Room 309, Rack 5' ;
GO

Box 2: SQL Managed Instance

TSX

Make a Target Server
Applies to: SQL Server, Azure SQL Managed Instance
On Azure SQL Managed Instance, most, but not all SQL Server Agent features are currently supported.


Reference:

https://learn.microsoft.com/en-us/sql/ssms/agent/make-a-master-server https://learn.microsoft.com/en-us/sql/ssms/agent/make-a-target-server



You have two on-premises Microsoft SQL Server 2019 instances named SQL1 and SQL2.

You need to migrate the databases hosted on SQL1 to Azure. The solution must meet the following requirements:

The service that hosts the migrated databases must be able to communicate with SQL2 by using linked server connections.
Administrative effort must be minimized.

What should you use to host the databases?

  1. a single Azure SQL database
  2. SQL Server on Azure Virtual Machines
  3. Azure SQL Managed Instance
  4. an Azure SQL Database elastic pool

Answer(s): C

Explanation:

Linked servers enable the SQL Server Database Engine and Azure SQL Managed Instance to read data from the remote data sources and execute commands against the remote database servers (for example, OLE DB data sources) outside of the instance of SQL Server.
Linked servers are available in SQL Server Database Engine and Azure SQL Managed Instance. They are not enabled in Azure SQL Database singleton and elastic pools.


Reference:

https://learn.microsoft.com/en-us/sql/relational-databases/linked-servers/linked-servers-database-engine



HOTSPOT (Drag and Drop is not supported)

You have an on-premises Microsoft SQL Server 2016 instance that hosts a database named db1. You have an Azure subscription that contains an Azure SQL managed instance named MI1.

You plan to perform an online migration of db1 to MI1 by using Azure Database Migration Service.

You need to create the backups for the migration. The solution must minimize the number of backup files created.

Which type of backups should you create, and how should you store the backups? 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: Full and transaction log
Known issues/migration limitations with online migrations to Azure SQL Managed Instance

Backup requirements
Backup media

Make sure to take every backup on a separate backup media (backup files). Azure Database Migration Service doesn't support backups that are appended to a single backup file. Take full, differential and log backups to separate backup files.

Box 2: Write each backup to a separate file


Reference:

https://learn.microsoft.com/en-us/azure/dms/known-issues-azure-sql-db-managed-instance-online






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

Join the DP-300 Discussion