You have an app named App1 that uses two on-premises Microsoft SQL Server databases named DB1 and DB2. You plan to migrate DB1 and DB2 to Azure You need to recommend an Azure solution to host DB1 and DB2. The solution must meet the following requirements: - Support server-side transactions across DB1 and DB2. - Minimize administrative effort to update the solution. What should you recommend?
A. two Azure SQL databases in an elastic pool
B. two databases on the same Azure SQL managed instance
C. two databases on the same SQL Server instance on an Azure virtual machine
D. two Azure SQL databases on different Azure SQL Database servers
Elastic database transactions for Azure SQL Database and Azure SQL Managed Instance allow you to run transactions that span several databases. SQL Managed Instance enables system administrators to spend less time on administrative tasks because the service either performs them for you or greatly simplifies those tasks. Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-transactions-overview?view=azuresql
Question 82
You need to design a highly available Azure SQL database that meets the following requirements: - Failover between replicas of the database must occur without any data loss. - The database must remain available in the event of a zone outage. - Costs must be minimized. Which deployment option should you use?
A. Azure SQL Database Hyperscale
B. Azure SQL Database Premium
C. Azure SQL Database Basic
D. Azure SQL Managed Instance General Purpose
Azure SQL Database Premium tier supports multiple redundant replicas for each database that are automatically provisioned in the same datacenter within a region. This design leverages the SQL Server AlwaysON technology and provides resilience to server failures with 99.99% availability SLA and RPO=0. With the introduction of Azure Availability Zones, we are happy to announce that SQL Database now offers built-in support of Availability Zones in its Premium service tier. Incorrect: Not A: Hyperscale is more expensive than Premium. Not C: Need Premium for Availability Zones. Not D: Zone redundant configuration that is free on Azure SQL Premium is not available on Azure SQL Managed Instance. Reference: https://azure.microsoft.com/en-us/blog/azure-sql-database-now-offers-zone-redundant-premium-databases-and-elastic-pools/
Question 83
HOTSPOT - You are designing a data storage solution to support reporting. The solution will ingest high volumes of data in the JSON format by using Azure Event Hubs. As the data arrives, Event Hubs will write the data to storage. The solution must meet the following requirements: - Organize data in directories by date and time. - Allow stored data to be queried directly, transformed into summarized tables, and then stored in a data warehouse. - Ensure that the data warehouse can store 50 TB of relational data and support between 200 and 300 concurrent read operations. Which service should you recommend for each type of data store? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:
Box 1: Azure Data Lake Storage Gen2 Azure Data Explorer integrates with Azure Blob Storage and Azure Data Lake Storage (Gen1 and Gen2), providing fast, cached, and indexed access to data stored in external storage. You can analyze and query data without prior ingestion into Azure Data Explorer. You can also query across ingested and uningested external data simultaneously. Azure Data Lake Storage is optimized storage for big data analytics workloads. Use cases: Batch, interactive, streaming analytics and machine learning data such as log files, IoT data, click streams, large datasets Box 2: Azure SQL Database Hyperscale Azure SQL Database Hyperscale is optimized for OLTP and high throughput analytics workloads with storage up to 100TB. A Hyperscale database supports up to 100 TB of data and provides high throughput and performance, as well as rapid scaling to adapt to the workload requirements. Connectivity, query processing, database engine features, etc. work like any other database in Azure SQL Database. Hyperscale is a multi-tiered architecture with caching at multiple levels. Effective IOPS will depend on the workload. Compare to: General purpose: 500 IOPS per vCore with 7,000 maximum IOPS Business critical: 5,000 IOPS with 200,000 maximum IOPS Incorrect: * Azure Synapse Analytics Dedicated SQL pool. Max database size: 240 TB - A maximum of 128 concurrent queries will execute and remaining queries will be queued. Reference: https://docs.microsoft.com/en-us/azure/data-explorer/data-lake-query-data https://docs.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-service-capacity-limits
Question 84
You have an app named App1 that uses an on-premises Microsoft SQL Server database named DB1. You plan to migrate DB1 to an Azure SQL managed instance. You need to enable customer managed Transparent Data Encryption (TDE) for the instance. The solution must maximize encryption strength. Which type of encryption algorithm and key length should you use for the TDE protector?
A. RSA 3072
B. AES 256
C. RSA 4096
D. RSA 2048
Question 85
You are planning an Azure IoT Hub solution that will include 50,000 IoT devices. Each device will stream data, including temperature, device ID, and time data. Approximately 50,000 records will be written every second. The data will be visualized in near real time. You need to recommend a service to store and query the data. Which two services can you recommend? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
A. Azure Table Storage
B. Azure Event Grid
C. Azure Cosmos DB for NoSQL
D. Azure Time Series Insights
Question 86
HOTSPOT - You are planning an Azure Storage solution for sensitive data. The data will be accessed daily. The dataset is less than 10 GB. You need to recommend a storage solution that meets the following requirements: • All the data written to storage must be retained for five years. • Once the data is written, the data can only be read. Modifications and deletion must be prevented. • After five years, the data can be deleted, but never modified. • Data access charges must be minimized. What should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Question 87
HOTSPOT - You are designing a data analytics solution that will use Azure Synapse and Azure Data Lake Storage Gen2. You need to recommend Azure Synapse pools to meet the following requirements: • Ingest data from Data Lake Storage into hash-distributed tables. • Implement query, and update data in Delta Lake. What should you recommend for each requirement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Question 88
You have an on-premises storage solution. You need to migrate the solution to Azure. The solution must support Hadoop Distributed File System (HDFS). What should you use?
A. Azure Data Lake Storage Gen2
B. Azure NetApp Files
C. Azure Data Share
D. Azure Table storage
Question 89
DRAG DROP - You have an on-premises app named App1. Customers use App1 to manage digital images. You plan to migrate App1 to Azure. You need to recommend a data storage solution for App1. The solution must meet the following image storage requirements: • Encrypt images at rest. • Allow files up to 50 MB. • Manage access to the images by using Azure Web Application Firewall (WAF) on Azure Front Door. The solution must meet the following customer account requirements: • Support automatic scale out of the storage. • Maintain the availability of App1 if a datacenter fails. • Support reading and writing data from multiple Azure regions. Which service should you include in the recommendation for each type of data? To answer, drag the appropriate services to the correct type of data. Each service may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct answer is worth one point.
Question 90
You are designing an application that will aggregate content for users. You need to recommend a database solution for the application. The solution must meet the following requirements: • Support SQL commands. • Support multi-master writes. • Guarantee low latency read operations. What should you include in the recommendation?
A. Azure Cosmos DB for NoSQL
B. Azure SQL Database that uses active geo-replication
