Free Microsoft DP-300 Practice Questions & Answers 2026 Part1

You are designing a streaming data solution that will ingest variable volumes of data.You need to ensure that you can change the partition count after creation.Which service should you use to ingest the data?

You need to migrate an on-premises Microsoft SQL Server database to an Azure SQL Database. The solution must minimize downtime.What should you do?

What is the maximum time period that differential backups can be stored for Azure SQL Database on the General Purpose tier?

Which counter should you monitor for real-time processing to meet the technical requirements?

You need to recommend a solution that will enable remote developers to access DB1 and DB2. The solution must support the planned changes and meet the security requirements.What should you include in the recommendation?

You have an on-premises Microsoft SQL server that uses the FileTables and Filestream features. You plan to migrate to Azure SQL Which service should you use?

You have an on-premises Microsoft SQL Server 2019 server that hosts a database named DB1.You have an Azure subscription that contains an Azure SQL managed instance named SQLMI1 and a virtual network named VNET1. SQLMI1 resides on VNET1. The on-premises network connects to VNET1 by using an ExpressRoute connection.You plan to migrate DB1 to SQLMI1 by using Azure Database Migration Service.You need to configure VNET1 to support the migration.What should you do?

You have an Azure SQL database named DB1.You have a table name Table1 that has 20 columns of type CHAR(400). Row compression for Table1 is enabled.During a database audit, you discover that none of the fields contain more than 150 characters.You need to ensure that you can apply page compression to Table1.What should you do?

You have an Azure Databricks workspace named workspace1 in the Standard pricing tier. Workspace1 contains an all-purpose cluster named cluster1.You need to reduce the time it takes for cluster1 to start and scale up. The solution must minimize costs.What should you do first?

In a CI/CD pipeline, what is a key consideration when integrating Cloudera Data Engineering (CDE. service API calls for deploying Spark jobs, specifically regarding security?

What should you do after a failover of SalesSQLDb1 to ensure that the database remains accessible to SalesSQLDb1App1?

Which counter should you monitor for real-time processing to meet the technical requirements?

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 Microsoft SQL Server instance on SQLVM1 to the Standard edition. The solution must ensure licensing compliance.What should you do first?

You have four Azure subscriptions. Each subscription contains multiple Azure SQL databases. You need to update the column and index statistics for the databases. What should you use?

You have an Azure subscription that contains an Azure SQL managed instance named SQLMl1.You need to configure SQLMl1 to use the Business Critical service tier.Which PowerShell cmdlet should you run?

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?

You have an Azure SQL managed instance. You need to enable SQL Agent Job email notifications. What should you do?

Based on the PaaS prototype, which Azure SQL Database compute tier should you use?

You have an on-premises Microsoft SQL Server 2022 instance that hosts a 60-TB production database named DB1.You plan to migrate DB1 to Azure.You need to recommend a hosting solution for DB1.Which Azure SQL Database service tier should you use to host DB1?

You need to identify the cause of the performance issues on SalesSQLDb1. Which two dynamic management views should you use? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

You have an Azure SQL database that contains a table named factSales. FactSales contains the columns shown in the following table.FactSales has 6 billion rows and is loaded nightly by using a batch process. You must provide the greatest reduction in space for the database and maximize performance.Which type of compression provides the greatest space reduction for the database?

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 are planning a solution that will use Azure SQL Database. Usage of the solution will peak from October 1 to January 1 each year.During peak usage, the database will require the following:24 cores500 GB of storage124 GB of memoryMore than 50,000 IOPSDuring periods of off-peak usage, the service tier of Azure SQL Database will be set to Standard.Which service tier should you use during peak usage?

You have an on-premises Microsoft SQL Server database named DB1.You plan to migrate DB1 to an Azure SQL database named DB2 by using the Data Migration Assistant (DMA).What will be migrated?

I want to do an online upgrade to SQL Server 2019 Standard. Which of the following can I NOT upgrade from?

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 answer presents part of the solution.NOTE: Each correct selection is worth one point.

You have SQL Server on an Azure virtual machine that contains a database named DB1. You view a plan summary that shows the duration in milliseconds of each execution of query 1178902 as shown in the following exhibit: What should you do to ensure that the query uses the execution plan which executes in the least amount of time?

You need to recommend an availability strategy for an Azure SQL database. The strategy must meet thefollowing requirements:Support failovers that do not require client applications to change their connection strings.Replicate the database to a secondary Azure region.Support failover to the secondary region.What should you include in the recommendation?

When using Apache Airflow to schedule quality checks, which strategy helps ensure that checks are only run on the most recent data partition?A Use the LatestOnlyOperator to skip tasks that are not the latest in a series of executions.

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?

Which of the following Stored Procedures can be used in Azure SQL Database to list the database roles?

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 a dedicated SQL pool to create an external table that has an additional DateTime column.Does this meet the goal?

What is the best practice for handling DAG dependencies in Apache Airflow when one DAG's output is another DAG's input?

You have a Microsoft SQL Server 2019 database named DB1 that uses the following database-level and instance-level features.✑ Clustered columnstore indexes✑ Automatic tuning✑ Change tracking✑ PolyBaseYou plan to migrate DB1 to an Azure SQL database.What feature should be removed or replaced before DB1 can be migrated?