Practice Free DP-300 Exam Online Questions
You have an Azure SQL managed instance named MI1.
You need to implement automatic tuning for the databases of MI1.
What should you do?
- A . Use the REST API to call the patch operation and modify the AutomaticTuningServerMode property.
- B . Use Transact-SQL to enable the force_last_good_plan option.
- C . From the Azure portal, configure automatic tuning.
HOTSPOT
You have an Azure SQL database named DB1 in the General Purpose service tier.
You need to monitor D81 by using SQL insights.
What should you include in the solution? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You have an Azure subscription that contains a Basic SKU Azure SQL database named DB1.
You need to configure the long-term retention of backups for DB1. The solution must maximize how long the backups are retained.
Which retention period should you configure?
- A . 180 days
- B . 365 days
- C . five years
- D . 10 years
You have an Azure Synapse Analytics workspace named WS1 that contains an Apache Spark pool named Pool1.
You plan to create a database named DB1 in Pool1.
You need to ensure that when tables are created in DB1, the tables are available automatically as external tables to the built-in serverless SQL pool.
Which format should you use for the tables in DB1?
- A . JSON
- B . CSV
- C . Parquet
- D . ORC
You have an Azure SQL managed instance named SQL1 and two Azure web apps named App1 and App2.
You need to limit the number of IOPs that App2 queries generate on SQL1.
Which two actions should you perform on SQL1? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
- A . Enable query optimizer fixes.
- B . Enable Resource Governor.
- C . Enable parameter sniffing.
- D . Create a workload group.
- E . Configure In-memory OLTP.
- F . Run the Database Engine Tuning Advisor.
- G . Reduce the Max Degree of Parallelism value.
You have an Azure SQL managed instance named SQL1 and two Azure web apps named App1 and App2.
You need to limit the number of IOPs that App2 queries generate on SQL1.
Which two actions should you perform on SQL1? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
- A . Enable query optimizer fixes.
- B . Enable Resource Governor.
- C . Enable parameter sniffing.
- D . Create a workload group.
- E . Configure In-memory OLTP.
- F . Run the Database Engine Tuning Advisor.
- G . Reduce the Max Degree of Parallelism value.
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 after extended periods of inactivity.
You need to modify db1 to resolve the issues experienced by Appl as soon as possible, without considering immediate costs
What you do?
- A . Increase the number of vCores allocated to db1.
- B . Decrease the auto-pause delay for db1.
- C . Disable auto-pause delay for db1.
- D . Enable automatic tuning for db1.
You have an Azure SQL database named db1 on a server named server1.
The Intelligent Insights diagnostics log identifies that several tables are missing indexes.
You need to ensure that indexes are created for the tables.
What should you do?
- A . RuntheDBCC SQLPERF command.
- B . Run the dbcc dbreindex command.
- C . Modify the automatic tuning settings for db1.
- D . Modify the Query Store settings for db1.
HOTSPOT
You have an Azure subscription that contains a resource group named RG1. RG1 contains an Azure SQL Server named Server1 in the West US Azure region.
You need to ensure that any Azure services deployed to RG1 can access Server1.
How should you complete the Azure Command-Line Interface <CU) command? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You are designing a dimension table in an Azure Synapse Analytics dedicated SQL pool.
You need to create a surrogate key for the table. The solution must provide the fastest query performance.
What should you use for the surrogate key?
- A . an IDENTITY column
- B . a GUID column
- C . a sequence object