Free Microsoft DP-300 Practice Questions & Answers 2026 Part3

You have a version-8.0 Azure Database for MySQL database.You need to identify which database queries consume the most resources.Which tool should you use?

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 maximizeperformance.Which type of compression provides the greatest space reduction for the database?

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?

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 a specific virtual network.You need to recommend a solution that meets the requirements.What should you include in the recommendation?

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 minimize how long it takes to migrate the database.What 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 need to replicate DB1 to SQLDB1.Which type of replication should you use?

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: In an Azure Synapse Analytics pipeline, you use a Get Metadata activity that retrieves the DateTime of the files.Does this meet the goal?

What should you use to migrate the PostgreSQL database?

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 instance. The solution must minimize downtime and administrative effort.What should you include in the recommendation?

You have an Azure Data Factory pipeline that performs an incremental load of source data to an Azure Data Lake Storage Gen2 account.Data to be loaded is identified by a column named LastUpdatedDate in the source table.You plan to execute the pipeline every four hours.You need to ensure that the pipeline execution meets the following requirements:- Automatically retries the execution when the pipeline run fails dueto concurrency or throttling limits.- Supports backfilling existing data in the table.Which type of trigger should you use?

You have an Azure subscription that contains an Azure SQL database named DB1.You configure a new data sync group as shown in the exhibit. (Click the Exhibit tab.)You need to minimize how long it takes to perform the first sync.What should you do?

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 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 Microsoft SQL server that uses the FileTables and Filestream features. You plan to migrate to Azure SQL Which service should you use?

What is the minimum time for auto-failover?

You have an Azure subscription.You need to deploy an Azure SQL database by using a BACPAC file.Which command should you run?

Which of the following is true for both Change Data Capture and Change Tracking?

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 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?

Which of these is NOT a reason to use normalization?

You have a data warehouse in Azure Synapse Analytics.You need to ensure that the data in the data warehouse is encrypted at rest.What should you enable?

You have an Azure SQL managed instance.You need to gather the last execution of a query plan and its runtime statistics. The solution must minimize the impact on currently running queries.What should you do?

Which of the following statements best describes the process of schema inference in the context of big data processing?

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?

What is the role of an Operator in an Apache Airflow DAG?A To schedule DAG runs based on time or external triggers

You need to provide an implementation plan to configure data retention for ResearchDB1. The solution must meet thesecurity and compliance requirements.What should you include in the plan?

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 an Azure Stream Analytics job.You need to ensure that the job has enough streaming units provisioned.You configure monitoring of the SU % Utilization metric.Which two additional metrics should you monitor? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

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 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? The partition count for an event hub in a dedicated Event Hubs cluster can be increased after the event hub has been created. https://docs.microsoft.com/en-us/azure/event-hubs/event-hubs-features#partitions

You have an on-premises datacenter that contains a 14-TB Microsoft SQL Server database.You plan to create an Azure SQL managed instance and migrate the on-premises database to the new instance.Which three service tiers support the SQL managed instance? Each correct answer presents a complete solution.Note: Each correct selection is worth one point.

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 Server is used.Support the SQL Server Agent service.Minimize administrative effort.What should you use?

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

When writing a DataFrame to a CSV file, what potential issues should you consider and how can you address them?

You have an Azure subscription.You plan to provision a single Azure SQL database.You need to ensure that the database supports the autoscaling of compute resources.Which service tier should you choose?

What is the difference between the Standard version and the Premium version of Azure Key Vault?

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?

Which windowing function should you use to perform the streaming aggregation of the sales data?