A company has many applications. Each application is supported by separate on-premises databases. You must migrate the databases to Azure SQL Database. You have the following requirements: Organize databases into groups based on database usage. Define the maximum resource limit available for each group of databases. You need to recommend technologies to scale the databases […]

A company is evaluating data storage solutions. You need to recommend a data storage solution that meets the following requirements: Minimize costs for storing blob objects. Optimize access for data that is infrequently accessed. Data must be stored for at least 30 days. Data availability must be at least 99 percent. What should you recommend? […]

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 […]