DP-300 Exam 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 storag...

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?

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 Micro...

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 da...

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?

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 instan...

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?

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 nee...

Hotspot Question 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...

Hotspot Question You have an Azure subscription. You need to deploy an Azure SQL managed instance that meets the following requirements: - Optimize latency. - Maximize the memory-t...

Hotspot Question 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 da...

Drag and Drop Question 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 t...

Drag and Drop Question You have an Azure subscription that contains an Azure SQL database named DB1. You plan to perform a classification scan of DB1 by using Azure Purview. You ne...

Hotspot Question You have an Azure subscription that contains a group named Group1 and an Azure SQL managed instance that hosts a database named DB1. You need to ensure that Group1...

You have an instance of SQL Server on Azure Virtual Machines named VM1. You plan to schedule a SQL Server Agent job that will rebuild indexes of the databases hosted on VM1. You ne...

You have an Azure subscription that contains an instance of SQL Server on an Azure virtual machine named SQLVM1 and a user named User1. SQLVM1 hosts a database named DB1. You need...

Your on-premises network contains a server that hosts a 60-TB database named DB1. The network has a 10-Mbps internet connection. You need to migrate DB1 to Azure. The solution must...

You have an Azure SQL database named DB1. You need to encrypt DB1. The solution must meet the following requirements: - Encrypt data in motion. - Support comparison operators. - Pr...

You have an instance of SQL Server on Azure Virtual Machines. You need to ensure that a user named User1 can configure proxy accounts for SQL Server Agent jobs. The solution must u...

You have an Azure SQL database named DB1. DB1 has a table named Table1 that contains the following columns. You plan to enable Always Encrypted for Table1. Which two columns suppor...

You have an Azure subscription. You create a logical SQL server that hosts four databases. Each database will be used by a separate customer. You need to ensure that each customer...

You have an Azure subscription that contains an instance of SQL Server on an Azure virtual machine named VM1 and an Azure Active Directory Domain Services (Azure AD DS) domain that...

Hotspot Question You have an Azure subscription that contains a logical SQL server. The server hosts two databases named db1 and db2 and an Azure AD service principal named app1. Y...

Hotspot Question You have an Azure subscription that contains an Azure SQL managed instance named SQL1. You use the Microsoft Power BI service. You need to configure connectivity f...

Hotspot Question You have an Azure subscription. You need to deploy a logical SQL server by using PowerShell. The solution must ensure that the logical SQL server can create Azure...

Drag and Drop Question You have an Azure key vault named Vault1 and a SQL server on Azure Virtual Machines instance named SQL1. SQL1 hosts a database named DB1. You need to configu...

You have an Azure subscription that contains an Azure SQL database named db1. You need to implement SQL insights for db1. Which two resources should you create first? Each correct...

You have the following resources: - 15 SQL Server on Azure Virtual Machines instances - 20 Azure SQL databases You need to recommend a solution to centrally monitor the resources f...

Hotspot Question You have an Azure subscription that contains an instance of SQL Server on Azure Virtual Machines named SQLVM1 and a user named User1. SQLVM1 hosts a database named...

You have an Azure subscription that contains an Azure SQL managed instance named SQLMI1 and a Log Analytics workspace named Workspace1. You need to collect performance metrics for...

Hotspot Question You have an Azure SQL database named DB1 in the General Purpose service tier. You need to monitor DB1 by using SQL Insights. What should you include in the solutio...

You have an Azure SQL database named DB1 in the General Purpose service tier. The performance metrics for DB1 are shown in the following exhibit. You need to reduce the Log IO perc...

Hotspot Question You have an Azure SQL managed instance named SQLMI1 that hosts multiple databases. You need to monitor the performance of SQLMI1 and identify which database uses t...

Hotspot Question You have an Azure subscription that contains an instance of SQL Server on Azure Virtual Machines. The virtual machine hosts a database named DB1. You need to monit...

You have an Azure SQL database named DB1. You need to query the fragmentation information of data and indexes for the tables in DB1. Which command should you run?

You have an Azure subscription that contains an Azure SQL database. The database contains a table named table1. You execute the following Transact-SQL statements. You need to reduc...

Drag and Drop Question You create a new Azure SQL managed instance named SQL1 and enable Database Mail extended stored procedures. You need to ensure that SQL Server Agent jobs run...

You have a Microsoft SQL Server 2019 database named DB1 and an Azure SQL managed instance named SQLMI1. You need to move a SQL Server Agent job from DB1 to SQLMI1. Which job attrib...

Drag and Drop Question You create an Azure SQL managed instance and a job that performs backups. You need to configure the job to notify a distribution group by email when the job...

You have an Azure SQL managed instance. You need to configure the SQL Server Agent service to email job notifications. Which statement should you execute?

You deploy an instance of SQL Server on Azure Virtual Machines named VM1. You need to create a SQL Server Agent job that will rebuild indexes of the databases hosted on VM1. The so...

Hotspot Question You need to deploy an Azure SQL Database elastic pool by using a Bicep template. How should you complete the template? To answer, select the appropriate options in...

You have an Azure AD tenant and a logical Microsoft SQL server named SQL1 that hosts several Azure SQL databases. You plan to assign Azure AD users permissions to the databases aut...

You have an Azure subscription. You plan to deploy an instance of SQL Server on Azure Virtual Machines by using an Azure Marketplace image. You need to register the SQL Server IaaS...

You have an Azure subscription that contains 20 Azure SQL databases. You create a Transact-SQL statement to perform index maintenance on a database. You need to schedule the statem...

Hotspot Question You have an Azure subscription. You need to deploy a logical SQL server by using an Azure Resource Manager (ARM) template. The solution must ensure that the server...

Hotspot Question You configure backups for an Azure SQL database as shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statemen...

You have an Azure SOI database named SQLDb1 that contains the resources shown in the following table. Column1 contains JSON data. You need to compress Column1. The solution must mi...

You have an Azure subscription that contains two instances of SQL Server on Azure Virtual Machines named VM1 and VM2. Both instances run Microsoft SQL Server 2019 CU8. You need to...

You plan to deploy two instances of SQL Server on Azure virtual machines in a highly available configuration that will use an Always On availability group. You need to recommend a...