DP-300 Exam Questions

Hotspot Question You have a 50-TB Microsoft SQL Server database named DB1. You need to reduce the time it takes to perform database consistency checks of DB1. Which Transact-SQL co...

You are training a new administrator for your company's Azure data services, which includes database deployed on Azure SQL Database, Azure SQL Managed Instance, and SQL Server on A...

You provision an Azure SQL Managed Instance database named MyDevData. The database will be used by in-house development for application development projects. DevSupport custom data...

MyDB1 is an Azure SQL on Azure virtual machine (VM) database. You identify a long-running query. You want to determine where the operation in the query is causing performance probl...

called whizlabserver1000. You have to create a contained database user in the database based on an Azure AD user. Which of the following would you execute for this requirement? (Ch...

Your company has an on-premises instance of Microsoft SQL Server. This instance contains a database that has a 5 TiB data file. The database requires 10,000 IOPS. You have to port...

settings set for the database for automatic tuning. Your company has a SQL Server 2019 instance hosted on an Azure virtual machine. The machine runs Windows Server 2019. The virtua...

Your company has a SQL Server 2019 instance hosted on an Azure virtual machine. The machine runs Windows Server 2019. The virtual machine has 4 vCPUs and 28 GB of memory. You now h...

You have an Azure Database for MySQL database. You have to identify which database queries are consuming the most resources. Which of the following tool can be used for this requir...

You have an Azure SQL database. You need to identify a long-running query. Here you need to identify which operation in the question is causing a performance issue. Which of the fo...

You have to implement disaster recovery for the database. Below are the key requirements: - During normal operations, there should be at least two readable copies of the database f...

Your company has an Azure SQL Database instance. This database is going to be added to a failover group. It has to be ensured that the database becomes available as quickly as poss...

Your company wants to create an Azure SQL Database. The database will contain a table that would have Employee information. There are columns which contain sensitive information. Y...

You have an instance of SQL Server on Azure Virtual Machine named SQL1. You need to monitor SQL1 and query the metrics by using Kusto query language. The solution must minimize adm...

You have an Azure SQL managed instance named MI1. You need to implement automatic tuning for the databases of MI1. What should you do?

You have an Azure subscription that contains a logical SQL server named Server1. The master database of Server1 contains a user named User1. You need to ensure that User1 can creat...

You have a on-premises Microsoft SQL Server named SQL1 that hosts five databases. You need to migrate the databases to an Azure SQL managed instance. The solution must minimize dow...

You have an Azure subscription that contains the resources shown in the following table. You need to configure a connection between VM1 and MI1. The solution must meet the followin...

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

You have an Azure subscription that contains the resources shown in the following table. App1 experiences transient connection errors and timeouts when it attempts to access db1 af...

You have an Azure subscription that contains an Azure SQL database named SQL1. SQL1 is in an Azure region that does not support availability zones. You need to ensure that you have...

You have an Azure subscription that contains a SQL Server on Azure Virtual Machines instance named SQLVM1. SQLVM1 has the following configurations: - Automated patching is enabled....

Hotspot Question You have a database on a SQL Server on Azure Virtual Machines instance. The current state of Query Store for the database is shown in the following exhibit. Use th...

Hotspot Question You have a SQL Server on Azure Virtual Machines instance named VM1 that hosts a database named DB1. You run the following query. For each of the following statemen...

You have an Azure subscription that contains a SQL Server on Azure Virtual Machines instance named SQLVMI. SQLVM1 hosts a database named DB1. You need to retrieve query plans from...

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

You have 25 Azure SQL databases. You need to implement a centralized database management solution that uses Transact-SQL. What should you include in the solution?

Hotspot Question You have an Azure SQL database named DB1 that contains a table named Table1. You run a query to load data into Table1. The performance metrics of Table1 during the...

Drag and Drop Question You have an Azure subscription that contains an Azure SQL database named SQLDb1. SQLDb1 contains a table named Table1. You plan to deploy an Azure web app na...

Hotspot Question You have a SQL Server on Azure Virtual Machines instance that hosts a 10-TB SQL database named DB1. You need to identify and repair any physical or logical corrupt...

Hotspot Question You have an Azure SQL database named DB1. You need to identify how much unused space in megabytes was allocated to DB1. How should you complete the Transact-SQL qu...

Hotspot Question You have an Azure SQL database. You need to identify whether a delayed query execution is associated to a RESOURCE_SEMAPHORE wait. How should you complete the Tran...

You have an Azure subscription that contains 50 instances of SQL Server on Azure Virtual Machines. The instances host 500 Azure SQL databases. You need to ensure that all the datab...

Drag and Drop Question You have an Azure subscription that contains an Azure SQL managed instance, a database named db1, and an Azure web app named App1. App1 uses db1. You need to...

Drag and Drop Question You have two instances of SQL Server on Azure Virtual Machines named VM1 and VM2. VM1 hosts a database named db1. You plan to create a database availability...

You have an Azure SQL database named DB1 that contains a nonclustered index named index1. End users report slow queries when they use index1. You need to identify the operations th...

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

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

Case Study 1 - Litware, Inc Overview Litware, Inc. is a renewable energy company that has a main office in Boston. The main office hosts a sales department and the primary datacent...

Hotspot Question You have an Azure SQL database named DB1 that contains a table named Orders. The Orders table contains a row for each sales order. Each sales order includes the na...

Hotspot Question You have a SQL Server on Azure Virtual Machines instance that hosts a database named DB1. You need to configure the autogrow and autoshrink settings for DB1. Which...

Hotspot Question You have an Azure SQL logical server. You run the following script. For each of the following statements, select Yes if the statement is true. Otherwise, select No...

Hotspot Question You have an Azure subscription that is linked to an Azure Active Directory (Azure AD) tenant named contoso.com The subscription contains an Azure SQL database name...

Hotspot Question You need to use an Azure Resource Manager (ARM) template to deploy an Azure virtual machine that will host a Microsoft SQL Server instance. The solution must maxim...

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

You have an Azure SQL database named DB1. A user named User1 has an Azure Active Directory (Azure AD) account. You need to provide User1 with the ability to add and remove columns...

You have SQL Server 2019 on an Azure virtual machine that runs Windows Server 2019. The virtual machine has 4 vCPUs and 28 GB of memory. You scale up the virtual machine to 8 vCPUs...

Drag and Drop Question You have a database named db1. The log for db1 contains the following entry. You need to ensure that db1 can process transactions. Which three actions should...

You have an Azure subscription that contains an Azure SQL database. The database contains a table named tablet that uses partitioned columnstores. You need to configure table1 to m...

You have an Azure subscription linked to an Azure Active Directory (Azure AD) tenant. The subscription contains 10 virtual machines that run Windows Server 2019 and host Microsoft...