- All Exams Instant Download
Which counter should you monitor for real-time processing to meet the technical requirements?
Topic 3, ADatum Corporation This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that...
You have an Azure subscription that contains two Azure SQL managed instances named SQLMI1 and SQLMI2. SQLM2 contains a database named DB1 and a user named User1.
You have an Azure subscription that contains two Azure SQL managed instances named SQLMI1 and SQLMI2. SQLM2 contains a database named DB1 and a user named User1. User1 drops DB1. You need to perform a point-in-time restore of DB1 to SQLMI2.A . Azure CLI B. Transact-SQL C. The Azure portal...
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 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...
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 deployment option and pricing tier should you configure?
You have an Azure SQL database named DB1. You need to ensure that DB1 will support automatic failover without data loss if a datacenter fails. The solution must minimize costs. Which deployment option and pricing tier should you configure?A . Azure SQL Database Premium B. Azure SQL Database serverless C....
Which output mode should you use?
You plan to build a structured streaming solution in Azure Databricks. The solution will count new events in fiveminute intervals and report only events that arrive during the interval. The output will be sent to a Delta Lake table. Which output mode should you use?A . complete B. append C....
Which switch should you use to switch between languages?
You are creating a new notebook in Azure Databricks that will support R as the primary language but will also support Scala and SQL. Which switch should you use to switch between languages?A . \[<language>] B. %<language> C. \[<language>] D. @<language>View AnswerAnswer: B Explanation: Reference: You can override the default...
Which three actions should you perform in sequence?
Topic 5, Misc. Questions DRAG DROP You have two instances of SQL Server on Azure virtual Machines named VM1 and VM2. VM1 hosts a database named dbl. You plan to create a database availability group (DAG) for dbl. The solution must use certificate authentication between VM1 and VM2. You need...
Which two accounts should you create?
You have an Azure AD tenant and a logical Microsoft SQL server named SQL1 that hosts several Azure SQL databases. You plan to assign Azure AD users permissions to the databases automatically by using Azure Automation. You need to create the required Automation accounts. Which two accounts should you create?...
