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

May 4, 2023 No Comments READ MORE +

What should you recommend?

HOTSPOT You need to recommend the appropriate purchasing model and deployment option for the 30 new databases. The solution must meet the technical requirements and the business requirements. What should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point....

May 4, 2023 No Comments READ MORE +

What should you do?

You have SQL Server on an Azure virtual machine. You need to add a 4-TB volume that meets the following requirements: ✑ Maximizes IOPs ✑ Uses premium solid state drives (SSDs) What should you do?A . Attach two mirrored 4-TB SSDs. B. Attach a stripe set that contains four 1-TB...

May 4, 2023 No Comments READ MORE +

Which configuration setting should you modify and which value should you configure?

HOTSPOT You have an Azure SQL database named db1 on a server named server1. You use Query Performance Insight to monitor db1. You need to modify the Query Store configuration to ensure that performance monitoring data is available as soon as possible. Which configuration setting should you modify and which...

May 3, 2023 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:...

May 3, 2023 No Comments READ MORE +

What should you do?

You need to implement a solution to notify the administrators. The solution must meet the monitoring requirements. What should you do?A . Create an Azure Monitor alert rule that has a static threshold and assign the alert rule to an action group. B. Add a diagnostic setting that logs QueryStoreRuntimeStatistics...

May 3, 2023 No Comments READ MORE +

What should you include in the recommendation?

You have an on-premises multi-tier application named App1 that includes a web tier, an application tier, and a Microsoft SQL Server tier. All the tiers run on Hyper-V virtual machines. Your new disaster recovery plan requires that all business-critical applications can be recovered to Azure. You need to recommend a...

May 3, 2023 No Comments READ MORE +

Which metric should you monitor?

Your company uses Azure Stream Analytics to monitor devices. The company plans to double the number of devices that are monitored. You need to monitor a Stream Analytics job to ensure that there are enough processing resources to handle the additional load. Which metric should you monitor?A . Input Deserialization...

May 3, 2023 No Comments READ MORE +

How should you complete the Transact-SQL statement?

HOTSPOT You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and an Azure Data Lake Storage Gen2 account named Account1. You plan to access the files in Account1 by using an external table. You need to create a data source in Pool1 that you can reference when you...

May 3, 2023 No Comments READ MORE +

What you do?

You have an Azure subscription that contains the resources shown in the following table. App1 experiences transient connection errors and timeouts when it attempts to access db1 after extended periods of inactivity. You need to modify db1 to resolve the issues experienced by Appl as soon as possible, without considering...

May 3, 2023 No Comments READ MORE +