You have an Azure subscription.Your on-premises network contains a file server named Server1. Server1 stores 5 TB of company files that are accessed rarely.You plan to copy the files to Azure Storage.You need to implement a storage solution for the files that meets the following requirements:The files must be available within 24 hours of being requested.Storage costs must be minimized.Which two possible storage solutions achieve this goal? Each correct answer presents a complete solution.Note: Each correct selection is worth one point.
Answer(s): A,D
To minimize costs: The Archive tier is optimized for storing data that is rarely accessed and stored for at least 180 days with flexible latency requirements (on the order of hours).
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 AzureYou 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?
Answer(s): B
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.
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?
Correct:* Azure SQL Database Business Critical (if Premium and Serverless not options, as Business Critical is more expensive)* Azure SQL Database Premium (if not Database Serverless is an option. Premium is more expensive than Serverless)* Azure SQL Database ServerlessOrder of cost:1. Azure SQL Database Serverless (least expensive)2. Azure SQL Database Premium3. Azure SQL Database Business Critical (most expensive)Incorrect:* Azure SQL Database Basic* Azure SQL Database Hyperscale* Azure SQL Database Standard* Azure SQL Managed Instance Business Critical* Azure SQL Managed Instance General PurposeNote on correct answers:* Azure SQL Database PremiumAzure 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.* Azure SQL Database ServerlessNow your new and existing serverless Azure SQL Databases allow for zone redundant configuration. This feature utilizes Azure Availability Zones to replicate databases across multiple physical locations within an Azure region. By selecting zone redundancy, you can make your serverless databases resilient to a much larger set of failures, including catastrophic datacenter outages – without any changes of the application logic.Note: The SQL Database serverless compute tier optimizes price-performance and simplifies performance management for single databases with intermittent, unpredictable usage by auto-scaling compute and billing for compute used per second.Serverless is a compute tier for single databases in Azure SQL Database that automatically scales compute based on workload demand and bills for the amount of compute used per second. The serverless compute tier also automatically pauses databases during inactive periods when only storage is billed and automatically resumes databases when activity returnsNote on incorrect answers:* Azure SQL Database BasicNeed Premium for Availability Zones.* Azure SQL Database HyperscaleHyperscale is more expensive than Premium/ Database Serverless.* Azure SQL Managed Instance Business CriticalAzure SQL Managed Instance Business Critical is more expensive.* Azure SQL Managed Instance General PurposeZone redundant configuration that is free on Azure SQL Premium is not available on Azure SQL Managed Instance.Note: There are two high availability architectural models:* Standard availability model that is based on a separation of compute and storage. It relies on high availability and reliability of the remote storage tier. This architecture targets budget-oriented business applications that can tolerate some performance degradation during maintenance activities.* Premium availability model that is based on a cluster of database engine processes. It relies on the fact that there is always a quorum of available database engine nodes. This architecture targets mission-critical applications with high IO performance, high transaction rate and guarantees minimal performance impact to your workload during maintenance activities.Note: Zone-redundant configuration for the general purpose service tier is offered for both serverless and provisioned compute. This configuration utilizes Azure Availability Zones to replicate databases across multiple physical locations within an Azure region.By selecting zone-redundancy, you can make yournew and existing serverless and provisioned generalpurpose single databases and elastic pools resilient to a much larger set of failures, including catastrophic datacenter outages, without any changes of the application logic.
HOTSPOT (Drag and Drop is not supported)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.Hot Area:
Answer(s): A
Box 1: General purpose v2 with Hot access tier for blobsNote:* All the data written to storage must be retained for five years.* Data access charges must be minimizedHot tier has higher storage costs, but lower access and transaction costs.Incorrect:Not Archive: Lowest storage costs, but highest access, and transaction costs. Not Cool: Lower storage costs, but higher access and transaction costs.Box 2: Storage account resource lockAs an administrator, you can lock a subscription, resource group, or resource to prevent other users in your organization from accidentally deleting or modifying critical resources. The lock overrides any permissions the user might have.
https://docs.microsoft.com/en-us/azure/storage/blobs/access-tiers-overview https://docs.microsoft.com/en-us/azure/azure-resource-manager/management/lock-resources
HOTSPOT (Drag and Drop is not supported)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 300concurrent 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 Gen2Azure 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 datasetsBox 2: Azure SQL Database HyperscaleAzure 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 IOPSIncorrect:* Azure Synapse Analytics Dedicated SQL pool.Max database size: 240 TBA maximum of 128 concurrent queries will execute and remaining queries will be queued.
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
Post your Comments and Discuss Microsoft AZ-305 exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the AZ-305 content, but please register or login to continue.