- All Exams Instant Download
Which two options should you enable?
You 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. NOTE: Each correct selection is...
You have a legacy application written for Microsoft SQL Server 2012. The application will be the only application that accesses db1 You need to ensure that db1 is compatible with all the features and syntax of SQL Server 2012
SIMULATION Task 11 You have a legacy application written for Microsoft SQL Server 2012. The application will be the only application that accesses db1 You need to ensure that db1 is compatible with all the features and syntax of SQL Server 2012.View AnswerAnswer: To ensure that db1 is compatible with...
Which two actions should you perform?
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...
Which restore option should you use on the secondary replica?
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...
Which three actions should you perform in sequence?
DRAG DROP You have SQL Server on an Azure virtual machine named SQL1. SQL1 has an agent job to back up all databases. You add a user named dbadmin1 as a SQL Server Agent operator. You need to ensure that dbadmin1 receives an email alert if a job fails. Which...
Which three objects should you create in sequence?
DRAG DROP You are building an Azure virtual machine. You allocate two 1-TiB, P30 premium storage disks to the virtual machine. Each disk provides 5,000 IOPS. You plan to migrate an on-premises instance of Microsoft SQL Server to the virtual machine. The instance has a database that contains a 1.2-TiB...
You need to generate an email alert to [email protected] when CPU percentage utilization for db1 is higher than average
SIMULATION Task 9 You need to generate an email alert to [email protected] when CPU percentage utilization for db1 is higher than average.View AnswerAnswer: To generate an email alert to [email protected] when CPU percentage utilization for db1 is higher than average, you can use the Azure portal to create an alert...
Which feature should you use to provide customers with the required level of access based on their service agreement?
You are evaluating the business goals. Which feature should you use to provide customers with the required level of access based on their service agreement?A . dynamic data maskingB . Conditional Access in AzureC . service principalsD . row-level security (RLS)View AnswerAnswer: D Explanation: Reference: https://docs.microsoft.com/en-us/sql/relational-databases/security/row-level-security?view=sql-server-ver15
Which type of backup should you use?
You need to recommend a backup solution to restore DB3. The solution must meet the availability requirements. Which type of backup should you use?A . transaction logB . point-in-time restore (PITR)C . differentialD . long-term retention (LTR)View AnswerAnswer: C
To what should you set each parameter?
HOTSPOT You plan to deploy Instance1 by using the following script. You need to specify the licenseType and storagenedundancy parameters. The deployment must meet the availability requirements and the business requirements for DB1 and DB2. To what should you set each parameter? To answer, select the appropriate options in the...
