You have 12 on-premises data sources that contain customer information and consist of Microsoft SQL Server, MySQL, and Oracle databases.You have an Azure subscription.You plan to create an Azure Data Lake Storage account that will consolidate the customer information for analysis and reporting.You need to recommend a solution to automatically copy new information from the data sources to the Data Lake Storage account by using extract, transform and load (ETL). The solution must minimize administrative effort.What should you include in the recommendation?
Answer(s): A
Note: In the world of big data, raw, unorganized data is often stored in relational, non-relational, and other storage systems. However, on its own, raw data doesn’t have the proper context or meaning to provide meaningful insights to analysts, data scientists, or business decision makers.Big data requires a service that can orchestrate and operationalize processes to refine these enormous stores of raw data into actionable business insights. Azure Data Factory is a managed cloud service that’s built for these complex hybrid extract-transform-load (ETL), extract-load-transform (ELT), and data integration projects.
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 11devices 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 have an Azure subscription.You plan to deploy an Azure SQL database named DB1 that will store the maximum daily temperature.You need to recommend a solution to query an external website, retrieve the maximum temperature from the previous 24 hours, and write the temperature to DB1. The solution should minimize costs, development effort, and administrative effort.What should you include in the recommendation?
Answer(s): D
You can connect Azure Functions to Azure SQL Database using Visual Studio Code.Azure Functions lets you connect Azure services and other resources to functions without having to write your own integration code. These bindings, which represent both input and output, are declared within the function definition. Data from bindings is provided to the function as parameters. A trigger is a special type of input binding. Although a function has only one trigger, it can have multiple input and output bindings.
Your company has 50 business units across the globe. The business units operate from 08:00 AM to 06:00 PM from Monday to Friday in their local time zone. Transactions are only processed during business hours.You have an Azure subscription.You plan to deploy an app named App1 that will manage the transactions for the business units. App1 will use a separate Azure SQL database for each business unit.You need to recommend an Azure SQL Database configuration for App1. The solution must meet the following requirements:Support Azure Hybrid Benefit licensing.Minimize costs.What should you recommend?
Answer(s): C
Compare vCore and DTU purchasing modelsThe vCore purchasing model used by Azure SQL Database provides several benefits over the DTU-based purchasing model:* Higher compute, memory, I/O, and storage limits.* Choice of hardware configuration to better match compute and memory requirements of the workload.*-> Pricing discounts for Azure Hybrid Benefit (AHB).* Etc.Note: Azure Elastic Pools:* A deployment option that allows you to share a pool of resources (such as CPU, memory, and storage) across multiple databases.*-> Ideal for scenarios where you have multiple databases with varying levels of usage, and you want to optimize resource utilization and reduce costs.
You have an on-premises Microsoft SQL Server 2016 database named DB1.You have an Azure subscription.You need to migrate DB1 to an Azure SQL database by using the Azure SQL Migration extension for Azure Data Studio.What should you do first?
The Azure SQL migration extension for Azure Data StudioIf your target is Azure SQL Database, make sure you deploy the database schema before you begin the migration.Note: The Azure SQL migration extension for Azure Data Studio enables you to assess, get right-sized Azure recommendations and migrate your SQL Server databases to Azure.The workflow of the migration process is illustrated in the following diagram:Incorrect:Not B: Microsoft SQL Server 2008 and later is supported.
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.