Free Microsoft DP-300 Practice Questions & Answers 2026 Part2

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?

Which audit log destination should you use to meet the monitoring requirements?

You have an Azure SQL Database server named sqlsrv1 that hosts 10 Azure SQL databases.The databases perform slower than expected.You need to identify whether the performance issue relates to the use of tempdb on sqlsrv1.What should you do?

Which DMV shows for I/O statistics for each data and log file (one row per data or log file)?

You have an Always On availability group deployed to Azure virtual machines. The availability group contains a database named DB1 and has two nodes named SQL1 and SQL2. SQL1 is the primary replica. You need to initiate a full backup of DB1 on SQL2. Which statement should you run? BACKUP DATABASE supports only copy-only full backups of databases, files, or filegroups when it's executed on secondary replicas. Copy-only backups don't impact the log chain or clear the differential bitmap. Incorrect Answers: A: Differential backups are not supported on secondary replicas. The software displays this error because the secondary replicas support copy-only database backups. https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/active-secondaries-backup-on-secondary-replicas-always-on-availability-groups

You have an Azure subscription linked to a Microsoft Entra tenant. The subscription contains 10 virtual machines that run Windows Server 2019 and host Microsoft SQL Server 2019 instances.You need to ensure that you can manage the SQL Server instances by using a single user account.What should you do first?

You have a Microsoft SQL Server 2019 instance in an on-premises datacenter. The instance contains a 4-TB database named DB1.You plan to migrate DB1 to an Azure SQL Database managed instance.What should you use to minimize downtime and data loss during the migration?

You have the following Azure Data Factory pipelines:Ingest Data from System1Ingest Data from System2Populate DimensionsPopulate FactsIngest Data from System1 and Ingest Data from System2 have no dependencies. Populate Dimensions must execute after Ingest Data from System1 and Ingest Data from System2. Populate Facts must execute after the Populate Dimensions pipeline. All the pipelines must execute every eight hours.What should you do to schedule the pipelines for execution?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have the on-premises networks shown in the following table.You have an Azure subscription that contains an Azure SQL Database server named SQL1.SQL1 contains two databases named DB1 and DB2.You need to configure access to DB1 and DB2. The solution must meet the following requirements:- Ensure that DB1 can be accessed only by users in Branch1.- Ensure that DB2 can be accessed only by users in Branch2.Solution: You connect to DB1 and run the following command.EXECUTE sp_set_firewall_rule 'Allow db1 users', '131.107.10.0','131.107.10.255'You connect to DB2 and run the following command.EXECUTE sp_set_database_firewall_rule 'Allow db2 users','131.107.11.0', '131.107.11.255'Does this meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have an Azure Synapse Analytics dedicated SQL pool that contains a table named Table1.You have files that are ingested and loaded into an Azure Data Lake Storage Gen2 container named container1.You plan to insert data from the files into Table1 and transform the data. Each row of data in the files will produce one row in the serving layer of Table1.You need to ensure that when the source data files are loaded to container1, the DateTime is stored as an additional column in Table1.Solution: You use an Azure Synapse Analytics serverless SQL pool to create an external table that has an additional DateTime column.Does this meet the goal?

You have an 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 downtime and prevent data loss.What should you use?

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 vCPUSs and 64 GB of memory. You need to provide the lowest latency for tempdb. What is the total number of data files that tempdb should contain? The number of files depends on the number of (logical) processors on the machine. As a general rule, if the number of logical processors is less than or equal to eight, use the same number of data files as logical processors. If the number of logical processors is greater than eight, use eight data files and then if contention continues, increase the number of data files by multiples of 4 until the contention is reduced to acceptable levels or make changes to the workload/code. https://docs.microsoft.com/en-us/sql/relational-databases/databases/tempdb-database

You plan to deploy an app that includes an Azure SQL database and an Azure web app. The app has the following requirements:- The web app must be hosted on an Azure virtual network.- The Azure SQL database must be assigned a private IP address.- The Azure SQL database must allow connections only from the virtualnetwork.You need to recommend a solution that meets the requirements.What should you include in the recommendation?

You have an Azure virtual machine based on a custom image named VM1.VM1 hosts an instance of Microsoft SQL Server 2019 Standard.You need to automate the maintenance of VM1 to meet the following requirements:Automate the patching of SQL Server and Windows Server.Automate full database backups and transaction log backups of the databases on VM1.Minimize administrative effort.What should you do first?

You have eight on-premises servers that have Microsoft SQL Server 2022 installed. Each server contains multiple databases.You plan to migrate the on-premises databases to Azure.You need to analyze the servers to identify which Azure SQL services can be used to host the databases.Which two tools can you use? Each correct answer presents a complete solution.Note: Each correct selection is worth one point.

You're building an Airflow DAG that consists of multiple interdependent ETL pipelines. How can you ensure they execute in the correct order and avoid conflicts?

You have an Azure SQL database. The database contains a table of analytical data that must be retained.You need to implement a data compression solution that maximizes a reduction in storage.Which type of compression should you use?

You have an Azure subscription that contains an Azure SQL database. The database contains a table named table1 that uses partitioned columnstores.You need to configure table1 to meet the following requirements:Each partition must be compressed.The compression ratio must be maximized.You must be able to index the compressed data.What should you use?

You have a Microsoft SQL Server 2019 instance in an on-premises datacenter. The instance contains a 4-TB database named DB1.You plan to migrate DB1 to an Azure SQL Database managed instance.What should you use to minimize downtime and data loss during the migration?

You have a SQL pool in Azure Synapse that contains a table named dbo.Customers. The table contains a column name Email.You need to prevent nonadministrative users from seeing the full email addresses in the Email column. The users must see values in a format of aXXX@XXXX.com instead.What should you do?

You're working with a large Spark DataFrame and need to perform an aggregation operation (e.g., can you improve the performance of the aggregation? SUM, COUNT). How

You have an Azure subscription.You need to deploy an instance of SQL Server on Azure Virtual Machines. The solution must meet the following requirements:Custom performance configuration, such as IOPS, capacity, and throughout, must be supported.Costs must be minimized.Which type of disk should you include in the solution?

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?

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?

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?

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 16 vCPUSs and 64 GB of memory.You need to provide the lowest latency for tempdb.What is the total number of data files that tempdb should contain?

You have an Azure SQL Database elastic pool that contains 10 databases.You receive the following alert.Msg 1132, Level 16, state 1, Line 1The 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.

You have 20 Azure SQL databases provisioned by using the vCore purchasing model.You plan to create an Azure SQL Database elastic pool and add the 20 databases.Which three metrics should you use to size the elastic pool to meet the demands of your workload? Each correct answerpresents part of the solution.NOTE: Each correct selection is worth one point.

You have an on-premises Microsoft SQL Server instance named SQL1 that hosts multiple databases.You have an Azure subscription that contains an Azure SQL managed instance named SQLMI1.You need to perform an offline migration of the SQL1 databases to SQLMI1 by using Azure Data Studio.What should you install on SQL1?

Your on-premises network contains a server that hosts a 60-TB database named DB 1. The network has a 10-Mbps internet connection. You need to migrate DB 1 to Azure. The solution must minimize how long it takes to migrate the database. What should you use?

You are planning disaster recovery for the failover group of an Azure SQL Database managed instance. Your company's SLA requires that the database in the failover group become available as quickly as possible if a major outage occurs. You set the Read/Write failover policy to Automatic. What are two results of the configuration? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.