Amazon
Avaya
Cisco
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL
Juniper
Microsoft
NVIDIA
Okta
Palo Alto Networks
Salesforce
All Vendors
  1. Home
  2. Microsoft
  3. DP-300

Microsoft DP-300 Exam (page: 4)
Microsoft Administering Azure SQL Solutions
Updated on: 12-Feb-2026

Viewing Page 4 of 54
DP-300 PDF 430 Questions

DRAG DROP (Drag and Drop is not supported)

You have an Azure subscription.

You plan to deploy a new Azure virtual machine that will host a Microsoft SQL Server instance.

You need to configure the disks on the virtual machine. The solution must meet the following requirements:

Minimize latency for transaction logs.

Minimize VM allowed IO.

Which type of disk should you use for each workload? To answer, drag the appropriate disk types to the correct workloads. Each disk type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

Note: Each correct selection is worth one point.

Select and Place:

  1. See Explanation section for answer.

Answer(s): A

Explanation:





Box 1: Premium SSD

Storage: Performance best practices for SQL Server on Azure VMs. Place tempdb on the local ephemeral SSD (default D:\) drive for most SQL Server workloads that are not part of Failover Cluster Instance (FCI) after choosing the optimal VM size.

Select Premium SSD instead of Standard SSD for better performance.

Box 2: Ultra Disk
For the log drive plan for capacity and test performance versus cost while evaluating the premium P30 - P80 disks
If submillisecond storage latency is required, use Azure ultra disks for the transaction log. For M-series virtual machine deployments consider write accelerator over using Azure ultra disks.


Reference:

https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance-guidelines-best- practices-storage



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



You have a SQL Server on Azure Virtual Machines instance named SQLVM1 that was deployed by using an Azure Marketplace SQL Server 2019 Enterprise image.

You need to change the Microsoft SQL Server instance on SQLVM1 to the Standard edition. The solution must ensure licensing compliance.

What should you do first?

  1. From the SQL Server Installation Center on SQLVM1, run the Edition Upgrade wizard.
  2. From SQLVM1, uninstall the SQL Server instance.
  3. From the SQL Server Installation Center on SQLVM1, run the Repair wizard.
  4. From the Azure portal, reconfigure SQLVM1.

Answer(s): B

Explanation:

In-place change of SQL Server edition on Azure VM
The edition of SQL Server is determined by the product key, and is specified during the installation process using the installation media. The edition dictates what features are available in the SQL Server product. You can change the SQL Server edition with the installation media and either downgrade to reduce cost or upgrade to enable more features.
Downgrade an edition
To downgrade the edition of SQL Server, you need to completely uninstall SQL Server, and reinstall it again with the desired edition setup media.
1. Back up all databases, including the system databases.
2. Move system databases (master, model, and msdb) to a new location.
3. Completely uninstall SQL Server and all associated services.
4. Restart the virtual machine.
5. Install SQL Server by using the media with the desired edition of SQL Server.
6. Install the latest service packs and cumulative updates.
7. Replace the new system databases that were created during installation with the system databases that you previously moved to a different location.
8. After the SQL Server edition is downgraded, modify the edition property of the SQL Server virtual machine in the Azure portal. This will update the metadata and billing associated with this VM.


Reference:

https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/change-sql-server-edition



Your on-premises network contains a Microsoft SQL Server 2016 server that hosts a database named db1.

You have an Azure subscription.

You plan to migrate db1 to an Azure SQL managed instance.

You need to create the SQL managed instance. The solution must minimize the disk latency of the instance.

Which service tier should you use?

  1. Business Critical
  2. Hyperscale
  3. General Purpose
  4. Premium

Answer(s): A

Explanation:

Service tier characteristics
SQL Managed Instance has two service tiers: General Purpose and Business Critical.
Storage IO latency (approximate)
General Purpose: 5-10 ms
Business Critical: 1-2 ms
Incorrect:
Not B: The Hyperscale service tier is currently only available for Azure SQL Database, and not Azure SQL Managed Instance.


Reference:

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



Viewing Page 4 of 54



Share your comments for Microsoft DP-300 exam with other users:

Vey 5/27/2023 12:06:00 AM

highly appreciate for your sharing.
CAMBODIA


Tshepang 8/18/2023 4:41:00 AM

kindly share this dump. thank you
Anonymous


Jay 9/26/2023 8:00:00 AM

link plz for download
UNITED STATES


Leo 10/30/2023 1:11:00 PM

data quality oecd
Anonymous


Blessious Phiri 8/13/2023 9:35:00 AM

rman is one good recovery technology
Anonymous


DiligentSam 9/30/2023 10:26:00 AM

need it thx
Anonymous


Vani 8/10/2023 8:11:00 PM

good questions
NEW ZEALAND


Fares 9/11/2023 5:00:00 AM

good one nice revision
Anonymous


Lingaraj 10/26/2023 1:27:00 AM

i love this thank you i need
Anonymous


Muhammad Rawish Siddiqui 12/5/2023 12:38:00 PM

question # 142: data governance is not one of the deliverables in the document and content management context diagram.
SAUDI ARABIA


al 6/7/2023 10:25:00 AM

most answers not correct here
Anonymous


Bano 1/19/2024 2:29:00 AM

what % of questions do we get in the real exam?
UNITED STATES


Oliviajames 10/25/2023 5:31:00 AM

i just want to tell you. i took my microsoft az-104 exam and passed it. your program was awesome. i especially liked your detailed questions and answers and practice tests that made me well-prepared for the exam. thanks to this website!!!
UNITED STATES


Divya 8/27/2023 12:31:00 PM

all the best
UNITED STATES


KY 1/1/2024 11:01:00 PM

very usefull document
Anonymous


Arun 9/20/2023 4:52:00 PM

nice and helpful questions
INDIA


Joseph J 7/11/2023 2:53:00 PM

i found the questions helpful
UNITED STATES


Meg 10/12/2023 8:02:00 AM

q 105 . ans is d
INDIA


Navaneeth S 7/14/2023 7:57:00 AM

i have interest to get a sybase iq dba certification
UNITED STATES


Aish 10/11/2023 5:27:00 AM

want to pass exm.
INDIA


Anonymous 6/12/2023 7:23:00 AM

are the answers correct?
INDIA


Kris 7/7/2023 9:43:00 AM

good morning, could you please upload this exam again, i need it to test my knowledge in sd-wan with version 7.0.
Anonymous


Meghraj mali 10/7/2023 1:47:00 PM

very nice question
CANADA


Noel 11/1/2022 9:14:00 PM

i have learning disability and this exam dumps allowed me to focus on the actual questions and not worry about notes and the those other study materials.
SOUTH AFRICA


Jas 10/25/2023 6:01:00 PM

165 should be apt
UNITED STATES


Neetu 6/22/2023 8:41:00 AM

please upload the dumps, real need of them
Anonymous


Mark 10/24/2023 1:34:00 AM

any recent feeedback?
UNITED STATES


Gopinadh 8/9/2023 4:05:00 AM

question number 2 is indicating you are giving proper questions. observe and change properly.
Anonymous


Santhi 1/1/2024 8:23:00 AM

passed today.40% questions were new.litwere case study,lots of new questions on afd,ratelimit,tm,lb,app gatway.got 2 set series of questions which are not present here.questions on azure cyclecloud, no.of vnet/vms required for implimentation,blueprints assignment/management group etc
INDIA


Raviraj Magadum 1/12/2024 11:39:00 AM

practice test
INDIA


sivaramakrishnan 7/27/2023 8:12:00 AM

want the dumps for emc content management server programming(cmsp)
Anonymous


Aderonke 10/23/2023 1:52:00 PM

brilliant and helpful
UNITED KINGDOM


Az 9/16/2023 2:43:00 PM

q75. azure files is pass
SWITZERLAND


ketty 11/9/2023 8:10:00 AM

very helpful
Anonymous