You have an Azure SQL database named sqldb1.You need to minimize the amount of space used by the data and log files of sqldb1.What should you run?
Answer(s): A
DBCC SHRINKDATABASE shrinks the size of the data and log files in the specified database.Incorrect Answers:D: To shrink one data or log file at a time for a specific database, execute the DBCC SHRINKFILE command.
https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-shrinkdatabase-transact-sql
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 by Azure SQL databases in sqlsrv1.What should you do?
Answer(s): D
Microsoft Azure SQL Database and Azure SQL Managed Instance enable a subset of dynamic management views to diagnose performance problems, which might be caused by blocked or long-running queries, resource bottlenecks, poor query plans, and so on.This include edentifying tempdb performance issues:When identifying IO performance issues, the top wait types associated with tempdb issues is PAGELATCH_* (not PAGEIOLATCH_*).
https://docs.microsoft.com/en-us/azure/azure-sql/database/monitoring-with-dmvs
DRAG DROP (Drag and Drop is not supported)You are building an Azure virtual machine.You allocate two 1-TiB, P30 premium storage disks to the virtual machine. Each disk provides 5,000 IOPS.You plan to migrate an on-premises instance of Microsoft SQL Server to the virtual machine. The instance has a database that contains a 1.2-TiB data file. The database requires 10,000 IOPS.You need to configure storage for the virtual machine to support the database.Which three objects should you create in sequence? To answer, move the appropriate objects from the list of objects to the answer area and arrange them in the correct order.Select and Place:
Follow these same steps to create striped virtual disk:Create Log Storage Pool.Create Virtual DiskCreate VolumeBox 1: a storage poolBox 2: a virtual disk that uses stripe layoutDisk Striping: Use multiple disks and stripe them together to get a combined higher IOPS and Throughput limit. The combined limit per VM should be higher than the combined limits of attached premium disks.Box 3: a volume
https://hanu.com/hanu-how-to-striping-of-disks-for-azure-sql-server/
HOTSPOT (Drag and Drop is not supported)You need to use an Azure Resource Manager (ARM) template to deploy an Azure virtual machine that will host a Microsoft SQL Server instance. The solution must maximize disk I/O performance for the SQL Server database and log files.How should you complete the template? To answer, select the appropriate options in the answer area.Note: Each correct selection is worth one point.Hot Area:
Box 1: NoneSet host caching to none for log file disks.Box 2: ReadOnlySet host caching to read-only for data file disks.Do not enable read/write caching on disks that contain SQL Server data or log files.
https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance- guidelines-best-practices-storage
You have an Azure SQL managed instance named MI1.You need to implement automatic tuning for the databases of MI1.What should you do?
Answer(s): C
For Azure SQL Managed Instance, the supported option FORCE_LAST_GOOD_PLAN can only be configured through T-SQL.Enable automatic tuning on serverOn the server level you can choose to inherit automatic tuning configuration from "Azure Defaults" or not to inherit the configuration. Azure defaults are FORCE_LAST_GOOD_PLAN enabled, CREATE_INDEX disabled, and DROP_INDEX disabled.
https://docs.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-enable
Post your Comments and Discuss Microsoft DP-300 exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the DP-300 content, but please register or login to continue.