You store web access logs data in Azure Blob Storage.You plan to generate monthly reports from the access logs.You need to recommend an automated process to upload the data to Azure SQL Database every month.What should you include in the recommendation?
Answer(s): D
You can create Data Factory pipelines that copies data from Azure Blob Storage to Azure SQL Database. The configuration pattern applies to copying from a file-based data store to a relational data store.Required steps:Create a data factory.Create Azure Storage and Azure SQL Database linked services.Create Azure Blob and Azure SQL Database datasets.Create a pipeline contains a Copy activity.Start a pipeline run.Monitor the pipeline and activity runs.
https://docs.microsoft.com/en-us/azure/data-factory/tutorial-copy-data-dot-net
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?
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.
https://learn.microsoft.com/en-us/azure/azure-functions/functions-add-output-binding-azure-sql-vs-code
HOTSPOT (Drag and Drop is not supported)You plan to use Azure SQL as a database platform.You need to recommend an Azure SQL product and service tier that meets the following requirements:● Automatically scales compute resources based on the workload demand● Provides per second billingWhat 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: A single Azure SQL DatabaseAzure SQL productServerless 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 for single databases in Azure SQL Database is parameterized by a compute autoscaling range and an auto-pause delay.Box 2: General PurposeService tierThe serverless compute tier is available in the General Purpose service tier and currently in preview in the Hyperscale service tier.
https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview
HOTSPOT (Drag and Drop is not supported)You need to design a storage solution for an app that will store large amounts of frequently used data. The solution must meet the following requirements:-Maximize data throughput.-Prevent the modification of data for one year.-Minimize latency for read and write operations.Which Azure Storage account type and storage service 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: BlockBlobStorageBlock Blob is a premium storage account type for block blobs and append blobs. Recommended for scenarios with high transactions rates, or scenarios that use smaller objects or require consistently low storage latency.Box 2: BlobImmutable storage for Azure Blob Storage enables users to store business-critical data in a WORM (Write Once, Read Many) state. While in a WORM state, data cannot be modified or deleted for a user-specified interval. By configuring immutability policies for blob data, you can protect your data from overwrites and deletes.
https://docs.microsoft.com/en-us/azure/storage/blobs/archive-blob https://docs.microsoft.com/en-us/azure/storage/blobs/immutable-storage-overview
You have 100 servers that run Windows Server and host Microsoft SQL Server 2014 instances. The instances host databases that have the following characteristics:-Stored procedures are implemented by using CLR.-The largest database is currently 3 TB. None of the databases will ever exceed 4 TB.You plan to move all the data from SQL Server to Azure.You need to recommend a service to host the databases. The solution must meet the following requirements:-Whenever possible, minimize management overhead for the migrated databases.-Ensure that users can authenticate by using Azure AD credentials.-Minimize the number of database changes required to facilitate the migration.What should you include in the recommendation?
Answer(s): B
SQL Managed Instance allows existing SQL Server customers to lift and shift their on-premises applications to the cloud with minimal application and database changes. At the same time, SQL Managed Instance preserves all PaaS capabilities (automatic patching and version updates, automated backups, high availability) that drastically reduce management overhead and TCO.
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance
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.