What should you do?

Topic 3, Misc. Questions You have an Azure SQL database named sqldb1. You need to minimize the possibility of Query Store transitioning to a read-only state. What should you do?A . Double the value of Data Flush intervalB . Decrease by half the value of Data Flush IntervalC . Double...

March 25, 2021 No Comments READ MORE +

How should you complete the statement?

HOTSPOT You have an Azure SQL database named db1. You need to retrieve the resource usage of db1 from the last week. How should you complete the statement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box...

March 24, 2021 No Comments READ MORE +

You are evaluating the role assignments

HOTSPOT You are evaluating the role assignments. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: Yes DBAGroup1 is member of the Contributor role. The Contributor role grants full access...

March 24, 2021 No Comments READ MORE +

Which three actions should you perform in sequence?

DRAG DROP You need to configure user authentication for the SERVER1 databases. The solution must meet the security and compliance requirements. Which three 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...

March 23, 2021 No Comments READ MORE +

What should you include in the migration plan?

HOTSPOT You are planning the migration of the SERVER1 databases. The solution must meet the business requirements. What should you include in the migration plan? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Azure Database Migration service...

March 23, 2021 No Comments READ MORE +

How should you collect and stream metrics?

HOTSPOT You need to implement the monitoring of SalesSQLDb1. The solution must meet the technical requirements. How should you collect and stream metrics? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: The server, the elastic...

March 22, 2021 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 22, 2021 No Comments READ MORE +

Which two options should you enable?

You have SQL Server on an Azure virtual machine that contains a database named DB1. DB1 contains a table named CustomerPII. You need to record whenever users query the CustomerPII table. Which two options should you enable? Each correct answer presents part of the solution. NOTE: Each correct selection is...

March 22, 2021 No Comments READ MORE +

Does this meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you...

March 22, 2021 No Comments READ MORE +

Which three actions should you perform in sequence?

DRAG DROP You have SQL Server on an Azure virtual machine named SQL1. SQL1 has an agent job to back up all databases. You add a user named dbadmin1 as a SQL Server Agent operator. You need to ensure that dbadmin1 receives an email alert if a job fails. Which...

March 22, 2021 No Comments READ MORE +