- All Exams Instant Download
You plan to perform performance testing of db1
SIMULATION Task 8 You plan to perform performance testing of db1. You need prevent db1 from reverting to the last known good query plan.View AnswerAnswer: To prevent db1 from reverting to the last known good query plan, you need to disable the automatic plan correction feature for the database. This...
Which three actions should you perform in sequence?
DRAG DROP You need to apply 20 built-in Azure Policy definitions to all new and existing Azure SQL Database deployments in an Azure subscription. The solution must minimize administrative effort. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to...
Which three backups should you restore in sequence?
DRAG DROP You have SQL Server on an Azure virtual machine that contains a database named DB1. DB1 is 30 TB and has a 1-GB daily rate of change. You back up the database by using a Microsoft SQL Server Agent job that runs Transact-SQL commands. You perform a weekly...
Topic 5, Lab / Simulation Tasks
Topic 5, Lab / Simulation Tasks SIMULATION Task 1 In an Azure SQL database named db1, you need to enable page compression on the PK_SalesOrderHeader_SalesOrderlD clustered index of the SalesLT.SalesOrderHeader table.View AnswerAnswer: To enable page compression on the PK_SalesOrderHeader_SalesOrderlD clustered index of the SalesLT.SalesOrderHeader table in db1, you can use...
You need to ensure that any enhancements made to the Query Optimizer through patches are available to dbl and db2 on sql37006895
SIMULATION Task 6 You need to ensure that any enhancements made to the Query Optimizer through patches are available to dbl and db2 on sql37006895.View AnswerAnswer: To ensure that any enhancements made to the Query Optimizer through patches are available to dbl and db2 on sql37006895, you need to enable...
Which restore option should you use on the secondary replica?
You have SQL Server on Azure virtual machines in an availability group. You have a database named DB1 that is NOT in the availability group. You create a full database backup of DB1. You need to add DB1 to the availability group. Which restore option should you use on the...
What should you do first?
You have an Azure virtual machine based on a custom image named VM1. VM1 hosts an instance of Microsoft SQL Server 2019 Standard. You need to automate the maintenance of VM1 to meet the following requirements: Automate the patching of SQL Server and Windows Server. Automate full database backups and...
Which four actions should you perform in sequence?
DRAG DROP You need to implement statistics maintenance for SalesSQLDb1. The solution must meet the technical requirements. Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. View AnswerAnswer: Explanation:...
Which three actions should you perform in sequence?
DRAG DROP You have an Azure SQL database that contains a table named Employees. Employees contains a column named Salary. You need to encrypt the Salary column. The solution must prevent database administrators from reading the data in the Salary column and must provide the most secure encryption. Which three...
Which Azure Storage functionality should you include in the solution?
Topic 4, Contoso Ltd Clothing Store You need to design a data retention solution for the Twitter feed data records. The solution must meet the customer sentiment analytics requirements. Which Azure Storage functionality should you include in the solution?A . time-based retentionB . change feedC . lifecycle managementD . soft...
