- All Exams Instant Download
What should you include in the solution?
You have an Azure SQL database. You need to implement a disaster recovery solution that meets the following requirements: • Minimizes how long it takes to recover the database if a datacenter fails • Minimizes administrative effort What should you include in the solution?A . Azure Backup B. active geo-replication...
What should you include in the recommendation?
You are developing an application that uses Azure Data Lake Storage Gen 2. You need to recommend a solution to grant permissions to a specific application for a limited time period. What should you include in the recommendation?A . role assignments B. account keys C. shared access signatures (SAS) D....
What should you do?
You are monitoring an Azure Stream Analytics job. You discover that the Backlogged input Events metric is increasing slowly and is consistently non-zero. You need to ensure that the job can handle all the events. What should you do?A . Remove any named consumer groups from the connection and use...
What should you include in the solution?
You have an Azure SQL database named DB1. You need to encrypt DB1. The solution must meet the following requirements; • Encrypt data in motion. • Support comparison operators. • Provide randomized encryption. What should you include in the solution?A . Always Encrypted B. column-level encryption C. Transparent Data Encryption...
Which windowing function should you use to perform the streaming aggregation of the sales data?
Which windowing function should you use to perform the streaming aggregation of the sales data?A . Sliding B. Hopping C. Session D. TumblingView AnswerAnswer: D Explanation: Scenario: The sales data, including the documents in JSON format, must be gathered as it arrives and analyzed online by using Azure Stream Analytics....
Which type of storage accounts should you use for the backups?
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...
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 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 masking B. Conditional Access in Azure C. service principals D. 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 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...
Which two objects should you include in the solution?
You are designing a security model for an Azure Synapse Analytics dedicated SQL pool that will support multiple companies. You need to ensure that users from each company can view only the data of their respective company. Which two objects should you include in the solution? Each correct answer presents...
