05.You have an on-premises app named App1 that stores data in an on-premises Microsoft SQL Server 2016 database named DB1. You plan to deploy additional instances of App1 to separate Azure regions.Each region will have a separate instance of App1 and DB1. The separate instances of DB1 will sync by using Azure SQL Data SynC. You need to recommend a database service for the deployment. The solution must minimize administrative effort.What should you include in the recommendation?Each correct answer presents p

02.You receive numerous alerts from Azure Monitor for an Azure SQL databasE. You need to reduce the number of alerts. You must only receive alerts if there is a significant change in usage patterns for an extended perioD.Which two actions should you perform?Each correct answer presents part of the solution.

You have an Azure Data Lake Storage Gen2 account named account1 that stores logs as shown in the following table. You do not expect that the logs will be accessed during the retention periods. You need to recommend a solution for account1 that meets the following requirements: Automatically deletes the logs at the end of each retention period Minimizes storage costs What should you include in the recommendation? To answer, select the appropriate options in the answer area. Each correct selection is worth o

You have the following Azure Resource Manager template. For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.

You create a new Azure SQL managed instance named SQL1 and enable Database Mail extended stored You need to ensure that SQ Server Agent jobs running on SQL 1 can notify when a failure Occurs Which three actions should you perform in sequence 7 TO answer. move the appropriate actions from the list Of actions to answer area and arrange them in correct order.

You have 10 Azure virtual machines that have SQL Server installed. You need to implement a backup strategy to ensure that you can restore specific databases to other SQL Server instances. The solution must provide centralized management of the backups. What should you include in the backup strategy?

09.Reference Scenario:click hereYou have a new Azure SQL databasE. The database contains a column that stores confidential information.You need to track each time values from the column are returned in a query. The tracking information must be stored for 365 days from the date the query was executeD.Which three actions should you perform?Each correct answer presents part of the solution.

You have SQL Server on an Azure virtual machine that contains a database named DB1. You have an application that queries DB1 to generate a sales report. You need to see the parameter values from the last time the query was executed. Which two actions should you perform? Each correct answer presents part of the solution. Each correct selection is worth one point.

You have a new Azure SQL database. The database contains a column that stores confidential information. You need to track each time values from the column are returned in a query. The tracking information must be stored for 365 days from the date the query was executed. Which three actions should you perform? Each correct answer presents part of the solution. Each correct selection is worth one point.

You have a new Azure SQL database named DB1 on an Azure SQL server named AzSQL1. The only user who was created is the server administrator. You need to create a contained database user in DB1 who will use Azure Active Directory (Azure AD) for authentication. Which three 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.

You are planning disaster recovery for the failover group of an Azure SQL Database managed instance. Your company’s SLA requires that the database in the failover group become available as quickly as possible if a major outage occurs. You set the Read/Write failover policy to Automatic. What are two results of the configuration? Each correct answer presents a complete solution. Each correct selection is worth one point.

04.Reference Scenario:click hereYou plan to move two 100-GB databases to AzurE. You need to dynamically scale resources consumption based on workloads. The solution must minimize downtime during scaling operations. What should you use?

07.Reference Scenario:click hereYou have a Microsoft SQL Server 2019 instance in an on-premises datacenter. The instance contains a 4-TB database named DB1. You plan to migrate DB1 to an Azure SQL Database managed instancE.What should you use to minimize downtime and data loss during the migration?

03.You are building a database backup solution for a SQL Server database hosted on an Azure virtual machinE.In the event of an Azure regional outage, you need to be able to restore the database backups. The solution must minimize costs.Which type of storage accounts should you use for the backups?

You have SQL Server on Azure virtual machines in an availability group. You have a database named DB1 that is NOT in the availability group. You create a full database backup of DB1. You need to add DB1 to the availability group. Which restore option should you use on the secondary replica?

You plan to perform batch processing in Azure Databricks once daily. Which type of Databricks cluster should you use?

06.Reference Scenario:click hereYou have a version-8.0 Azure Database for MySQL databasE. You need to identify which database queries consume the most resources. Which tool should you use?

You have an Azure subscription that is linked to a hybrid Azure Active Directory (Azure AD) tenant. The subscription contains an Azure Synapse Analytics SQL pool named Pool1. You need to recommend an authentication solution for Pool1. The solution must support multi-factor authentication (MFA) and database-level authentication. Which authentication solution or solutions should you include in the recommendation? To answer, select the appropriate options in the answer area. Each correct selection is worth on

This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have an Azure Data Lake Storage account that contains a staging zone. You need

You have an Azure SQL database named DB1. You have a table name Table1 that has 20 columns of type CHAR(400). Row compression for Table1 is enabled. During a database audit, you discover that none of the fields contain more than 150 characters. You need to ensure that you can apply page compression to Table1. What should you do?

08.Reference Scenario:click hereYou have SQL Server on an Azure virtual machine that contains a database named DB1. DB1 contains a table named CustomerPII.You need to record whenever users query the CustomerPII tablE. Which two options should you enable?Each correct answer presents part of the solution

You have SQL Server 2019 on an Azure virtual machine that runs Windows Server 2019. The virtual machine has 4 vCPUs and 28 GB of memory. You scale up the virtual machine to 16 vCPUSs and 64 GB of memory. You need to provide the lowest latency for tempdb. What is the total number of data files that tempdb should contain?

You have an Azure Synapse Analytics Apache Spark pool named Pool1. You plan to load JSON files from an Azure Data Lake Storage Gen2 container into the tables in Pool1. The structure and data types vary by file. You need to load the files into the tables. The solution must maintain the source data types. What should you do?

01.You need to implement a solution to notify the administrators. The solution must meet the monitoring requirements. What should you do?