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: 5)
Microsoft Administering Azure SQL Solutions
Updated on: 12-Feb-2026

Viewing Page 5 of 54
DP-300 PDF 430 Questions

You have an Azure subscription.

You need to deploy an Azure SQL database. The solution must meet the following requirements:

Dynamically scale CPU resources.

Ensure that the database can be paused to reduce costs.

What should you use?

  1. the Business Critical service tier
  2. the serverless compute tier
  3. an elastic pool
  4. the General Purpose service tier

Answer(s): B

Explanation:

Serverless is a compute tier for single databases in Azure SQL Database that automatically scales compute based on workload demand and bills for the amount of compute used per second. The serverless compute tier also automatically pauses databases during inactive periods when only storage is billed and automatically resumes databases when activity returns. The serverless compute tier is available in the General Purpose service tier and currently in preview in the Hyperscale service tier.


Reference:

https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview



HOTSPOT (Drag and Drop is not supported)

You have an Azure subscription.

You need to deploy an Azure SQL managed instance that meets the following requirements:

Optimize latency.

Maximize the memory-to-vCore ratio.

Which service tier and hardware generation should you use? 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: Business Critical
Optimize latency.

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:
* Hyperscale: The Hyperscale service tier is currently only available for Azure SQL Database, and not Azure SQL Managed Instance.

Box 2: Memory optimized premium-series
Maximize the memory-to-vCore ratio.

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 https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale



You have a Microsoft SQL Server 2017 server.

You need to migrate the server to Azure. The solution must meet the following requirements:

Ensure that the latest version of SQL Server is used.

Support the SQL Server Agent service.

Minimize administrative effort.

What should you use?

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

Answer(s): D



HOTSPOT (Drag and Drop is not supported)

You have a Microsoft SQL Server 2017 server that hosts five databases.

You plan to migrate the databases to Azure.

You need to recommend a solution that meets the following requirements:

Automatically scales compute based on the workload demand

Provides per-second billing

What should you include in the recommendation? 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: A single Azure SQL database in the serverless computer tier Automatically scales compute based on the workload demand.
Provides per-second billing.

Serverless is a compute tier for single databases in Azure SQL Database that automatically scales compute based on workload demand and bills for the amount of compute used per second.

Box 2: General Purpose service
The serverless compute tier is available in the General Purpose service tier and currently in preview in the Hyperscale service tier.


Reference:

https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview



You have an on-premises Microsoft SQL Server 2019 database named SQL1 that uses merge replication.

You need to migrate SQL1 to Azure.

Which service should you use?

  1. Azure SQL Edge
  2. Azure SQL Database
  3. SQL Server on Azure Virtual Machines
  4. Azure SQL Managed Instance

Answer(s): C

Explanation:

Merge Replication is only supported by SQL Server.
Incorrect:
Not A: Azure SQL Edge is an optimized relational database engine geared for IoT and IoT Edge deployments.
Not B: Azure SQL Database does not support merge replication.
Not D: Azure SQL Managed Instance does not support merge replication.


Reference:

https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/replication-transactional-overview https://learn.microsoft.com/en-us/sql/relational-databases/replication/merge/merge-replication



You have an on-premises datacenter that contains a 2-TB Microsoft SQL Server 2019 database named DB1.

You need to recommend a solution to migrate DB1 to an Azure SQL managed instance. The solution must minimize downtime and administrative effort.

What should you include in the recommendation?

  1. Log Replay Service (LRS)
  2. log shipping
  3. transactional replication
  4. SQL Data Sync

Answer(s): A

Explanation:

Migration overview: SQL Server to Azure SQL Managed Instance We recommend the following migration tools:

* Log Replay Service
This cloud service is enabled for SQL Managed Instance based on SQL Server log-shipping technology. It's a migration option for customers who can provide full, differential, and log database backups to Azure Storage.
Log Replay Service is used to restore backup files from Azure Blob Storage to SQL Managed Instance.
* Etc.
The following table lists alternative migration tools:
* Transactional replication
Replicate data from source SQL Server database tables to SQL Managed Instance by providing a publisher- subscriber type migration option while maintaining transactional consistency.
* Etc.
Compare migration options
Compare migration options to choose the path that's appropriate to your business needs.
The following table compares the recommended migration options:
* Log Replay Service
- Migrate individual line-of-business application databases.
- More control is needed for database migrations.
Considerations:
- The migration entails making full database backups on SQL Server and copying backup files to Azure Blob Storage. Log Replay Service is used to restore backup files from Azure Blob Storage to SQL Managed Instance.
- Databases being restored during the migration process will be in a restoring mode and can't be used for read or write workloads until the process is complete.
* Etc.
The following table compares the alternative migration options:
* Transactional replication
- Migrate by continuously publishing changes from source database tables to target SQL Managed Instance database tables.
- Do full or partial database migrations of selected tables (subset of a database).
Considerations:
- Setup is relatively complex compared to other migration options.
- Provides a continuous replication option to migrate data (without taking the databases offline).
* Etc.


Reference:

https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/managed-instance/sql-server-to-managed- instance-overview



You have an Azure subscription.

You plan to deploy an instance of SQL Server on Azure Virtual Machines that supports Write Accelerator.

Which virtual machine series should you use?

  1. E-series
  2. G-series
  3. H-series
  4. M-series

Answer(s): D

Explanation:

Enabling Write Accelerator on a specific disk
The next few sections will describe how Write Accelerator can be enabled on Azure Premium Storage VHDs.
Prerequisites
The following prerequisites apply to the usage of Write Accelerator at this point in time:
The disks you want to apply Azure Write Accelerator against need to be Azure managed disks on Premium Storage.
You must be using an M-series VM


Reference:

https://learn.microsoft.com/en-us/azure/virtual-machines/how-to-enable-write-accelerator¨



You have an on-premises Microsoft SQL Server 2019 instance that hosts a database named DB1.

You have an Azure subscription that contains an Azure SQL database named SQLDB1.

You need to replicate DB1 to SQLDB1.

Which type of replication should you use?

  1. transactional
  2. peer-to-peer
  3. snapshot
  4. merge

Answer(s): A

Explanation:

Types of replication
There are different types of replication:



Scenarios

Typical Replication Scenario
Create a transactional replication publication on a SQL Server database.
1. On SQL Server use the New Subscription Wizard or Transact-SQL statements to create a push to subscription to Azure SQL Database.
2. With single and pooled databases in Azure SQL Database, the initial data set is a snapshot that is created by the Snapshot Agent and distributed and applied by the Distribution Agent. With a SQL Managed Instance publisher, you can also use a database backup to seed the Azure SQL Database subscriber.
Data migration scenario
1. Use transactional replication to replicate data from a SQL Server database to Azure SQL Database.
2. Redirect the client or middle-tier applications to update the database copy.
3. Stop updating the SQL Server version of the table and remove the publication.


Reference:

https://learn.microsoft.com/en-us/azure/azure-sql/database/replication-to-sql-database



Viewing Page 5 of 54



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

hicham 5/30/2023 8:57:00 AM

excellent thanks a lot
FRANCE


Suman C 7/7/2023 8:13:00 AM

will post once pass the cka exam
INDIA


Ram 11/3/2023 5:10:00 AM

good content
Anonymous


Nagendra Pedipina 7/13/2023 2:12:00 AM

q:32 answer has to be option c
INDIA


Tamer Barakat 12/7/2023 5:17:00 PM

nice questions
Anonymous


Daryl 8/1/2022 11:33:00 PM

i really like the support team in this website. they are fast in communication and very helpful.
UNITED KINGDOM


Curtis Nakawaki 6/29/2023 9:13:00 PM

a good contemporary exam review
UNITED STATES


x-men 5/23/2023 1:02:00 AM

q23, its an array, isnt it? starts with [ and end with ]. its an array of objects, not object.
UNITED STATES


abuti 7/21/2023 6:24:00 PM

cool very helpfull
Anonymous


Krishneel 3/17/2023 10:34:00 AM

i just passed. this exam dumps is the same one from prepaway and examcollection. it has all the real test questions.
INDIA


Regor 12/4/2023 2:01:00 PM

is this a valid prince2 practitioner dumps?
UNITED KINGDOM


asl 9/14/2023 3:59:00 PM

all are relatable questions
CANADA


Siyya 1/19/2024 8:30:00 PM

might help me to prepare for the exam
Anonymous


Ted 6/21/2023 11:11:00 PM

just paid and downlaod the 2 exams using the 50% sale discount. so far i was able to download the pdf and the test engine. all looks good.
GERMANY


Paul K 11/27/2023 2:28:00 AM

i think it should be a,c. option d goes against the principle of building anything custom unless there are no work arounds available
INDIA


ph 6/16/2023 12:41:00 AM

very legible
Anonymous


sephs2001 7/31/2023 10:42:00 PM

is this exam accurate or helpful?
Anonymous


ash 7/11/2023 3:00:00 AM

please upload dump, i have exam in 2 days
INDIA


Sneha 8/17/2023 6:29:00 PM

this is useful
CANADA


sachin 12/27/2023 2:45:00 PM

question 232 answer should be perimeter not netowrk layer. wrong answer selected
Anonymous


tomAws 7/18/2023 5:05:00 AM

nice questions
BRAZIL


Rahul 6/11/2023 2:07:00 AM

hi team, could you please provide this dump ?
INDIA


TeamOraTech 12/5/2023 9:49:00 AM

very helpful to clear the exam and understand the concept.
Anonymous


Curtis 7/12/2023 8:20:00 PM

i think it is great that you are helping people when they need it. thanks.
UNITED STATES


sam 7/17/2023 6:22:00 PM

cannot evaluate yet
Anonymous


nutz 7/20/2023 1:54:00 AM

a laptops wireless antenna is most likely located in the bezel of the lid
UNITED STATES


rajesh soni 1/17/2024 6:53:00 AM

good examplae to learn basic
INDIA


Tanya 10/25/2023 7:07:00 AM

this is useful information
Anonymous


Nasir Mahmood 12/11/2023 7:32:00 AM

looks usefull
Anonymous


Jason 9/30/2023 1:07:00 PM

question 81 should be c.
CANADA


TestPD1 8/10/2023 12:22:00 PM

question 18 : response isnt a ?
EUROPEAN UNION


ally 8/19/2023 5:31:00 PM

plaese add questions
TURKEY


DIA 10/7/2023 5:59:00 AM

is dumps still valid ?
FRANCE


Annie 7/7/2023 8:33:00 AM

thanks for this
EUROPEAN UNION