- All Exams Instant Download
What should you do?
You have an Azure SQL managed instance named SQLMI1 that hosts 10 databases. You need to implement alerts by using Azure Monitor. The solution must meet the following requirements: ✑ Minimize costs. ✑ Aggregate Intelligent Insights telemetry from each database. What should you do?A . From the Diagnostic settings of...
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 ResearchSrvOLB . Deploy and configure an Azure Backup server.C . Configure the Advanced Data...
What should you do after a failover of SalesSQLDb1 to ensure that the database remains accessible to SalesSQLDb1App1?
What should you do after a failover of SalesSQLDb1 to ensure that the database remains accessible to SalesSQLDb1App1?A . Configure SalesSQLDb1 as writable.B . Update the connection strings of SalesSQLDb1App1.C . Update the firewall rules of SalesSQLDb1.D . Update the users in SalesSQLDb1.View AnswerAnswer: C Explanation: Scenario: SalesSQLDb1 uses database...
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 windowing function should you use to perform the streaming aggregation of the sales data?
Topic 3, A Datum 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...
You have the following Azure Resource Manager template
HOTSPOT You have the following Azure Resource Manager template. 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: A screenshot of a computer Description automatically generated with low confidence
Which two actions should you perform?
You are designing a star schema for a dataset that contains records of online orders. Each record includes an order date, an order due date, and an order ship date. You need to ensure that the design provides the fastest query times of the records when querying for arbitrary date...
Which Azure Storage functionality should you include in the solution?
You need to design a data retention solution for the Twitter feed data records. The solution must meet the customer sentiment analytics requirements. Which Azure Storage functionality should you include in the solution?A . time-based retentionB . change feedC . lifecycle managementD . soft deleteView AnswerAnswer: C Explanation: The lifecycle...
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 StorageB . Azure Event HubsC . 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...
What should you do?
You have an Azure SQL database named db1 on a server named server1. You need to modify the MAXDOP settings for db1. What should you do?A . Connect to db1 and run the sp_configure command.B . Connect to the master database of server1 and run the sp_configure command.C . Configure...
