You have SQL Server on an Azure virtual machine that contains a database named DB1.You have an application that queries DB1 to generate a sales report.You need to see the parameter values from the last time the query was executed.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.
You need to identify the cause of the performance issues on SalesSQLDb1.Which two dynamic management views should you use? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.
You have SQL Server 2019 on an Azure virtual machine that runs Windows Server 2019. The virtual machine has 4 vCPUs and 28 GB of memory.You scale up the virtual machine to 16 vCPUSs and 64 GB of memory.You need to provide the lowest latency for tempdb.What is the total number of data files that tempdb should contain?
HOTSPOT -You have SQL Server on an Azure virtual machine that contains a database named DB1.The database reports a CHECKSUM error.You need to recover the database.How should you complete the statements? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:
HOTSPOT -You have SQL Server on an Azure virtual machine that contains a database named Db1.You need to enable automatic tuning for Db1.How should you complete the statements? To answer, select the appropriate answer in the answer area.NOTE: Each correct selection is worth one point.Hot Area:
You need to implement authentication for ResearchDB1. The solution must meet the security and compliance requirements.What should you run as part of the implementation?
