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

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

You have an Azure subscription.

You need to deploy an Azure SQL database by using a BACPAC file.

Which command should you run?

  1. az sql db create
  2. az sql db op
  3. az sql db import
  4. az sql db copy

Answer(s): C

Explanation:

Import a BACPAC file into a database in SQL Database using the Azure CLI Example:
echo "Importing sample database from $container to $database..." az sql db import --admin-password $password --admin-user $login --storage-key $key --storage-key-type StorageAccessKey --storage-uri https://$storage.blob.core.windows.net/$container/$bacpac --name $database --resource-group $resourceGroup --server $server


Reference:

https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/import-from-bacpac-cli



HOTSPOT (Drag and Drop is not supported)

You have an Azure subscription.

You deploy resources by using the following Bicep template.



For each of the following statements, select Yes if the statement is true, otherwise select No.

Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:





Box 1: Yes
Yes - Server1 will support mixed authentication.

A. The azureADOnlyAuthentication (bool) property is not present.
If set to true then Azure Active Directory only Authentication enabled.
Mixed authentication will be supported.
Box 2: No
No - Database1 will scale dynamically based on the load.
We see sku tier is Standard.
Azure SQL databases with the Standard tier do not support autoscale. Autoscale is a feature available in the Serverless compute tier of Azure SQL Database, where resources scale automatically based on workload demands. The Standard tier, part of the provisioned compute model, requires manual scaling or the use of Elastic Pools for resource sharing and scaling.
Box 3: No
No - Server1 will be created as an Azure SQL managed instance.
The first line of the BICEP template would have to be like:
resource managedInstance 'Microsoft.Sql/managedInstances@2021-11-01-preview' = {


Reference:

https://learn.microsoft.com/en-us/azure/templates/microsoft.sql/managedinstances?pivots=deployment- language-bicep https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/create-bicep-quickstart



HOTSPOT (Drag and Drop is not supported)

You have two Azure SQL databases named SQLDB1 and SQLDB2 in the Hyperscale service tier. SQLDB1 was set to the Hyperscale service tier when the database was created. SQLDB2 was changed from the Business Critical service tier to the Hyperscale service tier during the last 14 days.

You need to change SQLDB1 and SQLDB2 to the Business Critical service tier. The solution must minimize the administrative effort.

What should you do first? 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: Export the data
On SQLDB1

For databases that don't qualify for reverse migration [See Limitations for reverse migration below], the only way to migrate from Hyperscale to a non-Hyperscale service tier is to export/import using a bacpac file or other data movement technologies (Bulk Copy, Azure Data Factory, Azure Databricks, SSIS, etc.)

Box 2: Set the Service tier to General Purpose.
On SQLDB2

Reverse migrate a database from Hyperscale
You can migrate an existing Hyperscale database in Azure SQL Database to the General Purpose service tier using the Azure portal, the Azure CLI, PowerShell, or Transact-SQL.

Reverse migration to the General Purpose service tier allows customers who have recently converted an existing database in Azure SQL Database to Hyperscale to move back in an emergency, should Hyperscale not meet their needs.
While reverse migration is initiated by a service tier change, it's essentially a size-of-data move between different architectures.

Limitations for reverse migration
Reverse migration is available under the following conditions:

*-> Reverse migration is only available within 45 days of the original migration to Hyperscale. *-> Databases originally created in the Hyperscale service tier aren't eligible for reverse migration.
* Etc.


Reference:

https://learn.microsoft.com/en-us/azure/azure-sql/database/reverse-migrate-from-hyperscale



You have five on-premises servers that have Microsoft SQL Server 2022 Enterprise installed. Each server contains multiple database that store data for web apps and are backed up by using a third-party backup solution.

You plan to migrate the databases to Azure.

You need to recommend a solution to host the databases. The solution must meet the following requirements:

Compute and storage resources must be shared across the databases.

Costs must be minimized.

What should you include in the recommendation?

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

Answer(s): D

Explanation:

Migration overview: SQL Server to Azure SQL Database
SQL Server VM alternative
Your business might have requirements that make SQL Server on Azure Virtual Machines a more suitable target than Azure SQL Database.
If one of the following conditions applies to your business, consider moving to a SQL Server virtual machine (VM) instead:
*-> You require direct access to the operating system or file system, such as to install third-party or custom agents on the same virtual machine with SQL Server.
* You have strict dependency on features that are still not supported, such as FileStream/FileTable, PolyBase, and cross-instance transactions.
* You need to stay at a specific version of SQL Server (2012, for example).
* Your compute requirements are much lower than a managed instance offers (one vCore, for example), and database consolidation isn't an acceptable option.


Reference:

https://learn.microsoft.com/en-us/data-migration/sql-server/database/overview



View Related Case Study

You need to recommend a process to automate the management of DB3. The solution must meet the management requirements.

What should be the first step of the process?

  1. Configure Microsoft Entra authentication for the logical server that hosts DB3.
  2. Configure a private endpoint for connectivity to DB3.
  3. Create database-scoped credentials in DB3.
  4. Create a database that has database-scoped credentials.

Answer(s): C

Explanation:

Use database-scoped credentials
You can use a database-scoped credential in the job database and in each target server/database for authentication. In the past, database-scoped credentials were the only option available with elastic jobs.
Scenario: . Management Requirements
ADatum identifies the following post-migration management requirements:
In Azure SQL Database, automate the management of DB3 by using elastic jobs that have database-scoped credentials.


Reference:

https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-jobs-tutorial






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

Join the DP-300 Discussion