- All Exams Instant Download
What is a possible cause of the error?
You have an Azure Data Factory pipeline that is triggered hourly. The pipeline has had 100% success for the past seven days. The pipeline execution fails, and two retries that occur 15 minutes apart also fail. The third failure returns the following error. What is a possible cause of the...
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...
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 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 service tier should you use during peak usage?
You are planning a solution that will use Azure SQL Database. Usage of the solution will peak from October 1 to January 1 each year. During peak usage, the database will require the following: ✑ 24 cores ✑ 500 GB of storage ✑ 124 GB of memory ✑ More than...
Which counter should you monitor for real-time processing to meet the technical requirements?
Which counter should you monitor for real-time processing to meet the technical requirements?A . SU% UtilizationB . CPU% utilizationC . Concurrent usersD . Data Conversion ErrorsView AnswerAnswer: B Explanation: Scenario: Real-time processing must be monitored to ensure that workloads are sized properly based on actual usage patterns. To monitor the...
What should you create?
You have an Azure subscription that contains a server named Server1. Server1 hosts two Azure SQL databases named DB1 and DB2. You plan to deploy a Windows app named App1 that will authenticate to DB2 by using SQL authentication. You need to ensure that App1 can access DB2. The solution...
Which two additional metrics should you monitor?
You have an Azure Stream Analytics job. You need to ensure that the job has enough streaming units provisioned. You configure monitoring of the SU % Utilization metric. Which two additional metrics should you monitor? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one...
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...
You have a Microsoft SQL Server database named DB1 that contains a table named Table1
HOTSPOT You have a Microsoft SQL Server database named DB1 that contains a table named Table1. The database role membership for a user named User1 is shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in...
