HOTSPOT - You are designing a data pipeline that will integrate large amounts of data from multiple on-premises Microsoft SQL Server databases into an analytics platform in Azure. The pipeline will include the following actions: • Database updates will be exported periodically into a staging area in Azure Blob storage. • Data from the blob storage will be cleansed and transformed by using a highly parallelized load process. • The transformed data will be loaded to a data warehouse. • Each batch of updates will be used to refresh an online analytical processing (OLAP) model in a managed serving layer. • The managed serving layer will be used by thousands of end users. You need to implement the data warehouse and serving layers. What should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Question 102
You have SQL Server on an Azure virtual machine. The databases are written to nightly as part of a batch process. You need to recommend a disaster recovery solution for the data. The solution must meet the following requirements: - Provide the ability to recover in the event of a regional outage. - Support a recovery time objective (RTO) of 15 minutes. - Support a recovery point objective (RPO) of 24 hours. - Support automated recovery. - Minimize costs. What should you include in the recommendation?
Replication with Azure Site Recover: - RTO is typically less than 15 minutes. - RPO: One hour for application consistency and five minutes for crash consistency. Incorrect Answers: B: Too slow. C: Always On availability group RPO: Because replication to the secondary replica is asynchronous, there's some data loss. Reference: https://docs.microsoft.com/en-us/azure/site-recovery/site-recovery-sql
Question 103
HOTSPOT - You plan to deploy the backup policy shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point. Hot Area:
Question 104
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You need to deploy resources to host a stateless web app in an Azure subscription. The solution must meet the following requirements: - Provide access to the full .NET framework. Provide redundancy if an Azure region fails. - Grant administrators access to the operating system to install custom application dependencies. Solution: You deploy two Azure virtual machines to two Azure regions, and you create an Azure Traffic Manager profile. Does this meet the goal?
Azure Traffic Manager is a DNS-based traffic load balancer that enables you to distribute traffic optimally to services across global Azure regions, while providing high availability and responsiveness.
Question 105
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You need to deploy resources to host a stateless web app in an Azure subscription. The solution must meet the following requirements: - Provide access to the full .NET framework. - Provide redundancy if an Azure region fails. - Grant administrators access to the operating system to install custom application dependencies. Solution: You deploy two Azure virtual machines to two Azure regions, and you deploy an Azure Application Gateway. Does this meet the goal?
App Gateway will balance the traffic between VMs deployed in the same region. Create an Azure Traffic Manager profile instead.
Question 106
HOTSPOT - You plan to create an Azure Storage account that will host file shares. The shares will be accessed from on-premises applications that are transaction intensive. You need to recommend a solution to minimize latency when accessing the file shares. The solution must provide the highest-level of resiliency for the selected storage tier. What should you include in the recommendation? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:
Box 1: Premium - Premium: Premium file shares are backed by solid-state drives (SSDs) and provide consistent high performance and low latency, within single-digit milliseconds for most IO operations, for IO-intensive workloads. Incorrect Answers: - Hot: Hot file shares offer storage optimized for general purpose file sharing scenarios such as team shares. Hot file shares are offered on the standard storage hardware backed by HDDs. - Transaction optimized: Transaction optimized file shares enable transaction heavy workloads that don't need the latency offered by premium file shares. Transaction optimized file shares are offered on the standard storage hardware backed by hard disk drives (HDDs). Transaction optimized has historically been called "standard", however this refers to the storage media type rather than the tier itself (the hot and cool are also "standard" tiers, because they are on standard storage hardware). Box 2: Zone-redundant storage (ZRS): Premium Azure file shares only support LRS and ZRS. Zone-redundant storage (ZRS): With ZRS, three copies of each file stored, however these copies are physically isolated in three distinct storage clusters in different Azure availability zones. Reference: https://docs.microsoft.com/en-us/azure/storage/files/storage-files-planning
Question 107
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You need to deploy resources to host a stateless web app in an Azure subscription. The solution must meet the following requirements: - Provide access to the full .NET framework. - Provide redundancy if an Azure region fails. - Grant administrators access to the operating system to install custom application dependencies. Solution: You deploy an Azure virtual machine scale set that uses autoscaling. Does this meet the goal?
Instead, you should deploy two Azure virtual machines to two Azure regions, and you create a Traffic Manager profile. Note: Azure Traffic Manager is a DNS-based traffic load balancer that enables you to distribute traffic optimally to services across global Azure regions, while providing high availability and responsiveness. Reference: https://docs.microsoft.com/en-us/azure/traffic-manager/traffic-manager-overview
Question 108
HOTSPOT - You need to recommend an Azure Storage account configuration for two applications named Application1 and Application2. The configuration must meet the following requirements: - Storage for Application1 must provide the highest possible transaction rates and the lowest possible latency. - Storage for Application2 must provide the lowest possible storage costs per GB. - Storage for both applications must be available in an event of datacenter failure. - Storage for both applications must be optimized for uploads and downloads. What should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:
Box 1: BlobStorage with Premium Performance,... Application1 requires high transaction rates and the lowest possible latency. We need to use Premium, not Standard. Box 2: General purpose v2 with Standard Performance,.. General Purpose v2 provides access to the latest Azure storage features, including Cool and Archive storage, with pricing optimized for the lowest GB storage prices. These accounts provide access to Block Blobs, Page Blobs, Files, and Queues. Recommended for most scenarios using Azure Storage. Reference: https://docs.microsoft.com/en-us/azure/storage/common/storage-account-upgrade
Question 109
HOTSPOT - You plan to develop a new app that will store business critical data. The app must meet the following requirements: - Prevent new data from being modified for one year. - Maximize data resiliency. - Minimize read latency. What storage solution should you recommend for the app? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:
Box 1: Standard general-purpose v2 Standard general-purpose v2 supports immutable storage. In general Standard general-purpose v2 is the preferred Microsoft recommendation. Box 2: Zone-redundant storage (ZRS) ZRS is more resilient compared to LRS. Note: RA-GRS is even more resilient, but it is not an option here. Reference: https://docs.microsoft.com/en-us/azure/storage/blobs/storage-blob-immutable-storage
Question 110
You plan to deploy 10 applications to Azure. The applications will be deployed to two Azure Kubernetes Service (AKS) clusters. Each cluster will be deployed to a separate Azure region. The application deployment must meet the following requirements: - Ensure that the applications remain available if a single AKS cluster fails. - Ensure that the connection traffic over the internet is encrypted by using SSL without having to configure SSL on each container. Which service should you include in the recommendation?
Azure Front Door supports SSL. Azure Front Door, which focuses on global load-balancing and site acceleration, and Azure CDN Standard, which offers static content caching and acceleration. The new Azure Front Door brings together security with CDN technology for a cloud-based CDN with threat protection and additional capabilities. Reference: https://docs.microsoft.com/en-us/azure/frontdoor/front-door-overview
