A company is designing a solution that uses Azure Databricks. The solution must be resilient to regional Azure datacenter outages. You need to recommend the redundancy type for the solution. What should you recommend? A. Read-access geo-redundant storage B. Locally-redundant storage C. Geo-redundant storage D. Zone-redundant storage Explanation: If your storage account has GRS enabled, […]

A company is developing a mission-critical line of business app that uses Azure SQL Database Managed Instance. You must design a disaster recovery strategy for the solution/ You need to ensure that the database automatically recovers when full or partial loss of the Azure SQL Database service occurs in the primary region. What should you […]

You are developing a solution that performs real-time analysis of IoT data in the cloud. The solution must remain available during Azure service updates. You need to recommend a solution. Which two actions should you recommend? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. A. Deploy an […]

You plan to use Azure SQL Database to support a line of business app. You need to identify sensitive data that is stored in the database and monitor access to the data. Which three actions should you recommend? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. A. […]

A company stores sensitive information about customers and employees in Azure SQL Database. You need to ensure that the sensitive data remains encrypted in transit and at rest. What should you recommend? A. Transparent Data Encryption B. Always Encrypted with secure enclaves C. Azure Disk Encryption D. SQL Server AlwaysOn Incorrect Answers: A: Transparent Data […]

You are designing an Azure Data Factory pipeline for processing data. The pipeline will process data that is stored in general-purpose standard Azure storage. You need to ensure that the compute environment is created on-demand and removed when the process is completed. Which type of activity should you recommend? A. Databricks Python activity B. Data […]

A company has an application that uses Azure SQL Database as the data store. The application experiences a large increase in activity during the last month of each year. You need to manually scale the Azure SQL Database instance to account for the increase in data write operations. Which scaling method should you recommend? A. […]

You are designing an Azure SQL Data Warehouse. You plan to load millions of rows of data into the data warehouse each day. You must ensure that staging tables are optimized for data loading. You need to design the staging tables. What type of tables should you recommend? A. Round-robin distributed table B. Hash-distributed table […]

A company manufactures automobile parts. The company installs IoT sensors on manufacturing machinery. You must design a solution that analyzes data from the sensors. You need to recommend a solution that meets the following requirements: Data must be analyzed in real-time. Data queries must be deployed using continuous integration. Data must be visualized by using […]

You are designing a data processing solution that will implement the lambda architecture pattern. The solution will use Spark running on HDInsight for data processing. You need to recommend a data storage technology for the solution. Which two technologies should you recommend? Each correct answer presents a complete solution. NOTE: Each correct selection is worth […]