- All Exams Instant Download
What should you include in the plan?
You need to provide an implementation plan to configure data retention for ResearchDB1. The solution must meet the security and compliance requirements. What should you include in the plan?A . Configure the Deleted databases settings for ResearchSrvOL B. Deploy and configure an Azure Backup server. C. Configure the Advanced Data...
What should you include in the solution?
HOTSPOT You have an Azure SQL database named DB 1 in the General Purpose service tier. You need to monitor DB 1 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...
What should you do to ensure that the query uses the execution plan which executes in the least amount of time?
You have SQL Server on an Azure virtual machine that contains a database named DB1. You view a plan summary that shows the duration in milliseconds of each execution of query 1178902 as shown in the following exhibit: What should you do to ensure that the query uses the execution...
How should you complete the Transact-SQL query?
HOTSPOT You have an Azure SQL database named D61. You need to identify how much unused space in megabytes was allocated to DB1. How should you complete the Transact-SQL query? To answer select the appropriate options m the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer:...
Which command should you run?
HOTSPOT You have an Azure SQL managed instance. You need to restore a database named DB1 by using Transact-SQL. Which command should you run? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Text Description automatically generated
Which four actions should you perform in sequence?
DRAG DROP You have a resource group named App1Dev that contains an Azure SQL Database server named DevServer1. DevServer1 contains an Azure SQL database named DB1. The schema and permissions for DB1 are saved in a Microsoft SQL Server Data Tools (SSDT) database project. You need to populate a new...
How should you complete the Transact CSQL statement?
HOTSPOT You have an Azure SQL database. You need to identify whether a delayed query execution is associated to a RESOURCE wait. How should you complete the Transact CSQL statement? To answer, select the appropriate option in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer:...
Which type of disk should you use for each workload?
DRAG DROP You have an Azure subscription. You plan to deploy a new Azure virtual machine that will host a Microsoft SQL Server instance. You need to configure the disks on the virtual machine. The solution must meet the following requirements: • Minimize latency for transaction logs. • Minimize the...
What should you use?
You have a on-premises Microsoft SQL Server named SQL1 that hosts five databases. You need to migrate the databases to an Azure SQL managed instance. The solution must minimize downtime and prevent data loss. What should you use?A . log shipping B. Always On availability groups C. Database Migration Assistant...
Which metric should you monitor?
You manage an enterprise data warehouse in Azure Synapse Analytics. Users report slow performance when they run commonly used queries. Users do not report performance changes for infrequently used queries. You need to monitor resource utilization to determine the source of the performance issues. Which metric should you monitor?A ....
