DP-300 Practice Test practice questions, page 13 of 15, with answer review and explanations.
Question 61
You have an Azure subscription. You need to deploy an instance of SQL Server on Azure Virtual Machines. The solution must meet the following requirements: • Custom performance configuration, such as IOPS, capacity, and throughout, must be supported. • Costs must be minimized. Which type of disk should you include in the solution?
Premium SSD v2
Premium SSD
Standard SSD
Ultra SSD
Question 62
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.
General Purpose Standard
Business Critical Memory Optimized Premium
General Purpose Premium
Business Critical Premium
Business Critical Standard
Question 63
SIMULATION - You need to configure db1 to pause automatically after one hour of inactivity. To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
Question 64
SIMULATION - You need to ensure that any enhancements made to the Query Optimizer through patches are available to db1 and db2 on sql12345678. To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
Question 65
SIMULATION - You plan to create an automation runbook that will create database users in db1 from Azure AD identities. You need to configure sql12345678 to support the creation of new database users. To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.