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?
Answer(s): A
TDE protector can only be an asymmetric, RSA, or RSA HSM key. The supported key lengths are 2048 bytes and 3072 bytes.
https://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-overview
HOTSPOT (Drag and Drop is not supported)You have an Azure subscription that contains the storage accounts shown in the following table.You plan to implement two new apps that have the requirements shown in the following table.Which storage accounts should you recommend using for each app? To answer, select the appropriate options in the answer area.Note: Each correct selection is worth one point.Hot Area:
Box 1: Storage1 and storage3 onlyNeed to use Standard accounts.Data stored in a premium block blob storage account cannot be tiered to hot, cool, or archive using Set Blob Tier or using Azure Blob Storage lifecycle managementBox 2: Storage1 and storage4 onlyAzure File shares requires Premium accounts. Only Storage1 and storage4 are premium.
https://docs.microsoft.com/en-us/azure/storage/blobs/access-tiers-overview#feature-support https://docs.microsoft.com/en-us/azure/storage/files/storage-how-to-create-file-share?tabs=azure-portal#basic s
HOTSPOT (Drag and Drop is not supported)You are designing a storage solution that will ingest, store, and analyze petabytes (PBs) of structured, semi-structured, and unstructured text data. The analyzed data will be offloaded to Azure Data Lake Storage Gen2 for long-term retention.You need to recommend a storage and analytics solution that meets the following requirements:● Stores the processed data● Provides interactive analytics● Supports manual scaling, built-in autoscaling, and custom autoscalingWhat 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:
Azure Data ExplorerKQLAzure Data Explorer stores and analyzes petabytes of structured, semi-structured, and unstructured data using Kusto Query Language (KQL). It supports manual scaling, built-in optimized autoscaling, and custom autoscaling.https://learn.microsoft.com/en-us/azure/data-explorer/manage-cluster-horizontal-scaling https://learn.microsoft.com/en-us/azure/synapse-analytics/plan-manage-costs
HOTSPOT (Drag and Drop is not supported)Your on-premises network contains an Active Directory Domain Services (AD DS) forest. The forest contains servers that run Windows Server. The servers contain file shares that replicate by using Distributed File System (DFS) Replication.You have multiple remote Windows 11 devices that connect to the on-premises network by using Point-to-Site (P2S) VPN and access the file shares by using drive mappings.You have an Azure subscription. The subscription contains virtual machines that run Windows Server and are configured as domain controllers. The virtual machines replicate to the on-premises forest. The forest syncs with a Microsoft Entra tenant that is linked to the Azure subscription.You plan to migrate the on-premises file shares to the Azure virtual machines.You need to recommend a solution for replicating the file shares to Azure and providing the Windows 11 devices with access to the shares. The solution must ensure that the devices can access the shares by using mapped drive letters via TCP port 445.What should you use to replicate the shares, and what should the devices use to the access the shares? To answer, select the appropriate options in the answer area.Note: Each correct selection is worth one point.Hot Area:
Box 1: Azure File SyncReplicateAzure File Sync is fully supported on DFS Namespace servers, you can install the Azure File Sync agent on one or more DFS Namespace member servers to sync data between the server endpoints and the cloud endpoint.Box 2: SMB over QUICAccessSMB over QUIC offers an "SMB VPN" for telecommuters, mobile device users, and high security organizations. The server certificate creates a TLS 1.3-encrypted tunnel over the internet-friendly UDP port 443 instead of the legacy TCP port 445. All SMB traffic, including authentication and authorization within the tunnel is never exposed to the underlying network. SMB behaves normally within the QUIC tunnel, meaning the user experience doesn't change. SMB features like multichannel, signing, compression, continuous availability, directory leasing, and so on, work normally.A file server administrator must opt in to enabling SMB over QUIC. It isn't on by default and a client can't force a file server to enable SMB over QUIC. Windows SMB clients still use TCP by default and will only attempt SMB over QUIC if the TCP attempt first fails or if intentionally requiring QUIC using NET USE /TRANSPORT:QUIC or New-SmbMapping -TransportType QUIC.
https://learn.microsoft.com/en-us/windows-server/storage/file-server/smb-over-quic https://learn.microsoft.com/en-us/azure/storage/file-sync/file-sync-planning#distributed-file-system-dfs
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?
Answer(s): B
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 your new and existing serverless and provisioned general purpose single databases and elastic pools resilient to a much larger set of failures, including catastrophic datacenter outages, without any changes of the application logic.
https://azure.microsoft.com/en-us/blog/azure-sql-database-now-offers-zone-redundant-premium-databases-an d-elastic-pools/https://docs.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla
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.