- All Exams Instant Download
You need to configure your user account as the Azure AD admin for the server named sql3700689S
SIMULATION Task 2 You need to configure your user account as the Azure AD admin for the server named sql3700689S.View AnswerAnswer: To configure your user account as the Azure AD admin for the server named sql3700689S, you can use the Azure portal or the Azure CLI. Here are the steps...
What should you do?
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 . Halve the value of Data Flush Interval.B . Double the value of Statistics Collection Interval.C . Halve the value of Statistics Collection Interval.D...
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:...
What should you include in the recommendation?
You need to recommend a solution to ensure that the performance of DB3 is optimized after the migration to Azure SQL Database. The solution must meet availability requirements. What should you include in the recommendation?A . Resource GovernorB . a custom resource poolC . vertical scalingD . horizontal scalingView AnswerAnswer:...
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 type of compression provides the greatest space reduction for the database?
Topic 6, Misc. Questions You have an Azure SQL database that contains a table named factSales. FactSales contains the columns shown in the following table. FactSales has 6 billion rows and is loaded nightly by using a batch process. Which type of compression provides the greatest space reduction for the...
Which three actions should you perform in sequence?
DRAG DROP You have an Azure SQL database that contains a table named Employees. Employees contains a column named Salary. You need to encrypt the Salary column. The solution must prevent database administrators from reading the data in the Salary column and must provide the most secure encryption. Which three...
Which windowing function should you use to perform the streaming aggregation of the sales data?
Topic 3, ADatum Corporation Overview 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...
What should you use as the event_file target?
You need to identify the event_file target for monitonng DB3 after the migration to Azure SQL Database. The solution must meet the management requirements. What should you use as the event_file target?A . an Azure SQL databaseB . an Azure Blob Storage containerC . a SQL Server filegroupD . an...
You need to configure high availability for dbl
SIMULATION Task 12 You need to configure high availability for dbl. The solution must tolerate the loss of an Azure datacenter without data loss or the need to modify application connection strings.View AnswerAnswer: To configure high availability for dbl, you can use the failover groups feature of Azure SQL Database....
