What should you do?

You manage 100 Azure SQL managed instances located across 10 Azure regions. You need to receive voice message notifications when a maintenance event affects any of the 10 regions. The solution must minimize administrative effort. What should you do?A . From the Azure portal, create a service health alert. B....

April 25, 2023 No Comments READ MORE +

What should you do to schedule the pipelines for execution?

You have the following Azure Data Factory pipelines: ✑ Ingest Data from System1 ✑ Ingest Data from System2 ✑ Populate Dimensions ✑ Populate Facts Ingest Data from System1 and Ingest Data from System2 have no dependencies. Populate Dimensions must execute after Ingest Data from System1 and Ingest Data from System2....

April 25, 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:...

April 24, 2023 No Comments READ MORE +

What should you include in the recommendation?

You need to recommend an availability strategy for an Azure SQL database. The strategy must meet the following requirements: ✑ Support failovers that do not require client applications to change their connection strings. ✑ Replicate the database to a secondary Azure region. ✑ Support failover to the secondary region. What...

April 24, 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...

April 24, 2023 No Comments READ MORE +

What should you create?

You have a single availability set that contains two SQL Server on Azure Virtual Machines instances. The instances were deployed by using an Azure Marketplace SQL Server 2019 Enterprise image that has the latest cumulative updates applied. The instances are configured as the nodes of a failover cluster instance (FCI)...

April 24, 2023 No Comments READ MORE +

Which Azure Storage functionality should you include in the solution?

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 retention B. change feed C. lifecycle management D. soft deleteView AnswerAnswer: C Explanation: The lifecycle...

April 24, 2023 No Comments READ MORE +

What should you include in the migration plan?

Topic 1, Litware Existing Environment Network Environment The manufacturing and research datacenters connect to the primary datacenter by using a VPN. The primary datacenter has an ExpressRoute connection that uses both Microsoft peering and private peering. The private peering connects to an Azure virtual network named HubVNet. Identity Environment Litware...

April 24, 2023 No Comments READ MORE +

Which two dynamic management views should you use?

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.A . sys.dm_pdw_nodes_tran_locks B. sys.dm_exec_compute_node_errors C. sys.dm_exec_requests D. sys.dm_cdc_errors E. sys.dm_pdw_nodes_os_wait_stats F. sys.dm_tran_locksView AnswerAnswer: A,E...

April 24, 2023 No Comments READ MORE +

What should you include in the recommendation?

HOTSPOT You need to recommend a configuration for ManufacturingSQLDb1 after the migration to Azure. The solution must meet the business requirements. What should you include in the recommendation? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Scenario:...

April 23, 2023 No Comments READ MORE +