- All Exams Instant Download
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 ....
What should you do after a failover of SalesSQLDb1 to ensure that the database remains accessible to SalesSQLDb1App1?
What should you do after a failover of SalesSQLDb1 to ensure that the database remains accessible to SalesSQLDb1App1?A . Configure SalesSQLDb1 as writable. B. Update the connection strings of SalesSQLDb1App1. C. Update the firewall rules of SalesSQLDb1. D. Update the users in SalesSQLDb1.View AnswerAnswer: C Explanation: Scenario: SalesSQLDb1 uses database...
What should you use?
Your on-premises network contains a server that hosts a 60-TB database named DB 1. The network has a 10-Mbps internet connection. You need to migrate DB 1 to Azure. The solution must minimize how long it takes to migrate the database. What should you use?A . Azure Migrate B. Data...
