Free Preparation Discussions
MENU
Microsoft DP-300 Exam Questions
Free Microsoft DP-300 Exam Actual Questions
Note: Premium Questions for DP-300 were last updated On Jun. 09, 2026 (see below)
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 Microsoft SQL server that uses the FileTables and Filestream features. You plan to migrate to Azure SQL Which service 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
SIMULATION
Task 8
You plan to perform performance testing of db1.
You need prevent db1 from reverting to the last known good query plan.
To prevent db1 from reverting to the last known good query plan, you need to disable the automatic plan correction feature for the database.This feature is enabled by default and allows the Query Store to detect and fix plan performance regressions by forcing the last good plan1.However, if you want to test the performance of different plans without interference from the Query Store, you can turn off this feature by using the ALTER DATABASE SCOPED CONFIGURATION statement2.
Here are the steps to disable the automatic plan correction feature for db1:
Connect to db1 using SQL Server Management Studio, Azure Data Studio, or any other tool that supports Transact-SQL statements.
Open a new query window and run the following command:ALTER DATABASE SCOPED CONFIGURATION SET AUTOMATIC_TUNING (FORCE_LAST_GOOD_PLAN = OFF); GO
This command will disable the automatic plan correction feature for db1 and allow the Query Optimizer to choose the best plan based on the current statistics and parameters3.
To verify that the automatic plan correction feature is disabled for db1, you can query the sys.database_scoped_configurations catalog view. The value of the force_last_good_plan column should be 0 for db1.
These are the steps to disable the automatic plan correction feature for db1.
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?
- Select Question Types you want
- Set your Desired Pass Percentage
- Allocate Time (Hours : Minutes)
- Create Multiple Practice tests with Limited Questions
- Customer Support
Richard Williams
16 days agoRonald Harris
22 days agoAdam Nguyen
1 month agoBrian Young
2 months agoBrenda Davis
2 months agoJennifer Morgan
1 month agoCharles Rivera
1 month agoMaria Carter
1 month agoRebecca Edwards
2 months agoKatina
2 months agoKarl
3 months agoOmer
3 months agoLisandra
3 months agoJosephine
3 months agoSunny
4 months agoAnnett
4 months agoVeronika
4 months agoAbel
4 months agoLeonida
5 months agoTracie
5 months agoJosphine
5 months agoGlory
5 months agoRana
6 months agoSabrina
6 months agoElza
6 months agoEliseo
6 months agoBrett
7 months agoAleisha
7 months agoJavier
7 months agoHassie
7 months agoSabrina
8 months agoBulah
8 months agoAmalia
8 months agoNelida
8 months agoMauricio
9 months agoArletta
9 months agoLouvenia
9 months agoJeannine
9 months agoKip
11 months agoDaniel
1 year agoLashaunda
1 year agoParis
1 year agoBeula
1 year agoElbert
1 year agoVi
1 year agoAshlee
1 year agoMerilyn
2 years agoWendell
2 years agoKayleigh
2 years agoHannah
2 years agoLeonora
2 years agoAshlee
2 years agoKenny
2 years agoCharlene
2 years agoGussie
2 years agoFelicidad
2 years agoGeorgeanna
2 years agoDierdre
2 years agoOdette
2 years agoDulce
2 years agoVernice
2 years agoArt
2 years agoGeraldo
2 years agoLindsey
2 years agoJannette
2 years ago