- All Exams Instant Download
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 audit log destination should you use to meet the monitoring requirements?
Which audit log destination should you use to meet the monitoring requirements?A . Azure Storage B. Azure Event Hubs C. Azure Log AnalyticsView AnswerAnswer: C Explanation: Scenario: Use a single dashboard to review security and audit data for all the PaaS databases. With dashboards can bring together operational data that...
You have an Azure SQL database named DB1
HOTSPOT You have an Azure SQL database named DB1. The automatic tuning options for DB1 are configured as shown in the following exhibit. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation:...
What should you include in the plan?
You need to provide an implementation plan to configure data retention for ResearchDB1. The solution must meet the security and compliance requirements. What should you include in the plan?A . Configure the Deleted databases settings for ResearchSrvOL B. Deploy and configure an Azure Backup server. C. Configure the Advanced Data...
What should you implement?
You have an Azure subscription that contains the resources shown in the following table. You need to configure a connection between VM1 and MIL The solution must meet the following requirements: • The connection must be encrypted. • Network latency must be minimized. What should you implement?A . virtual network...
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:...
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 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...
What should you do?
You have a SQL pool in Azure Synapse that contains a table named dbo.Customers. The table contains a column name Email. You need to prevent nonadministrative users from seeing the full email addresses in the Email column. The users must see values in a format of [email protected] instead. What should...
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...
