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...

March 28, 2024 No Comments READ MORE +

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...

March 28, 2024 No Comments READ MORE +

What should you do?

You have an Azure SQL Database server named sqlsrv1 that hosts 10 Azure SQL databases. The databases perform slower than expected. You need to identify whether the performance issue relates to the use of tempdb on sqlsrv1. What should you do?A . Run Query Store-based queriesB . Review information provided...

March 28, 2024 No Comments READ MORE +

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:...

March 27, 2024 No Comments READ MORE +

Which statement should you run?

You have an Always On availability group deployed to Azure virtual machines. The availability group contains a database named DB1 and has two nodes named SQL1 and SQL2. SQL1 is the primary replica. You need to initiate a full backup of DB1 on SQL2. Which statement should you run?A ....

March 27, 2024 No Comments READ MORE +

What should you do?

You have 50 Azure SQL databases. You need to notify the database owner when the database settings, such as the database size and pricing tier, are modified in Azure. What should you do?A . Create a diagnostic setting for the activity log that has the Security log enabled.B . For...

March 27, 2024 No Comments READ MORE +

What should you include in the backup strategy?

You have 10 Azure virtual machines that have SQL Server installed. You need to implement a backup strategy to ensure that you can restore specific databases to other SQL Server instances. The solution must provide centralized management of the backups. What should you include in the backup strategy?A . Automated...

March 27, 2024 No Comments READ MORE +

Which database option should set?

You deploy a database to an Azure SQL Database managed instance. You need to prevent read queries from blocking queries that are trying to write to the database. Which database option should set?A . PARAMETERIZATION to FORCEDB . PARAMETERIZATION to SIMPLEC . Delayed Durability to ForcedD . READ_COMMITTED_SNAPSHOT to ONView...

March 27, 2024 No Comments READ MORE +

How should you complete the statements?

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. View AnswerAnswer:...

March 27, 2024 No Comments READ MORE +

You need to generate an email alert to [email protected] when CPU percentage utilization for db1 is higher than average

Task 9 You need to generate an email alert to [email protected] when CPU percentage utilization for db1 is higher than average.View AnswerAnswer: To generate an email alert to [email protected] when CPU percentage utilization for db1 is higher than average, you can use the Azure portal to create an alert rule...

March 27, 2024 No Comments READ MORE +