AZ-305 practice questions 71–80

1. Question 71 · 232 in bank

   DRAG DROP - You plan to import data from your on-premises environment to Azure. The data is shown in the following table.

   

   What should you recommend using to migrate the data? To answer, drag the appropriate tools to the correct data sources. Each tool may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Select and Place:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Box 1: Data Migration Assistant - The Data Migration Assistant (DMA) helps you upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database. DMA recommends performance and reliability improvements for your target environment and allows you to move your schema, data, and uncontained objects from your source server to your target server. Incorrect: AzCopy is a command-line utility that you can use to copy blobs or files to or from a storage account. Box 2: Azure Cosmos DB Data Migration Tool Azure Cosmos DB Data Migration Tool can used to migrate a SQL Server Database table to Azure Cosmos. Reference: https://docs.microsoft.com/en-us/sql/dma/dma-overview https://docs.microsoft.com/en-us/azure/cosmos-db/cosmosdb-migrationchoices

   Source: Adapted from community discussion — NotMeAnyWay

   References

   • Microsoft Learn
   • Microsoft Learn
   • azure.microsoft.com documentation
   • Microsoft Learn

   

   Next question

2. Question 72 · 232 in bank

   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?

   • AMicrosoft SQL Server Migration Assistant (SSMA)
   • BData Migration Assistant (DMA)
   • CAzCopy
   • DAzure Data Factory

   Show answer

   Answer: D

   Explanation

   D. Azure Data Factory You should recommend using Azure Data Factory for this scenario. Azure Data Factory is a cloud-based data integration service that allows you to create, schedule, and manage data pipelines. In this case, you can create a pipeline to automatically extract data from the Azure Blob Storage, transform the data if needed, and load it into the Azure SQL Database on a monthly basis. This will help you generate the required monthly reports from the access logs.

   Source: Adapted from community discussion — NotMeAnyWay

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

3. Question 73 · 232 in bank

   Select 2

   You have an Azure subscription. Your on-premises network contains a file server named Server1. Server1 stores 5 ׀¢׀’ 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.

   • ACreate an Azure Blob Storage account that is configured for the Cool default access tier. Create a blob container, copy the files to the blob container, and set each file to the Archive access tier.
   • BCreate a general-purpose v1 storage account. Create a blob container and copy the files to the blob container.
   • CCreate a general-purpose v2 storage account that is configured for the Cool default access tier. Create a file share in the storage account and copy the files to the file share.
   • DCreate a general-purpose v2 storage account that is configured for the Hot default access tier. Create a blob container, copy the files to the blob container, and set each file to the Archive access tier.
   • ECreate a general-purpose v1 storage account. Create a fie share in the storage account and copy the files to the file share.

   Show answer

   Answer: AD

   Explanation

   I believe the correct answers are A and D, since the archive tier is the cheapest for storing data. In addition, a maximum of 15 hours may be required to rehydrate the data from an archive tier; the requirements are met.

   Source: Adapted from community discussion — mse89

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

4. Question 74 · 232 in bank

   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 Azure You 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?

   • Atwo Azure SQL databases in an elastic pool
   • Btwo databases on the same Azure SQL managed instance
   • Ctwo databases on the same SQL Server instance on an Azure virtual machine
   • Dtwo Azure SQL databases on different Azure SQL Database servers

   Show answer

   Answer: B

   Explanation

   https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-transactions-overview?view=azuresql A server-side distributed transactions using Transact-SQL are available only for Azure SQL Managed Instance. Distributed transaction can be executed only between Managed Instances that belong to the same Server trust group. In this scenario, Managed Instances need to use linked server to reference each other.

   Source: Adapted from community discussion — Gowind

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   Next question

5. Question 75 · 232 in bank

   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?

   • AAzure SQL Database Hyperscale
   • BAzure SQL Database Premium
   • CAzure SQL Database Basic
   • DAzure SQL Managed Instance General Purpose

   Show answer

   Answer: B

   Explanation

   Sept 25, 2023. There are 2 errors in jellybiscuit's comment: 1) the scenario calls for Zone redundancy (handle a zone outage). It does not require Geo redundancy 2) Managed Instances now allow Zone Redundant (ZRS), Geo Redundant (GRS), and Geo Zone Redundant (GZRS). It depends on the Region, but the scenario does not include a Region. https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/automated-backups-overview?view=azuresql So both MI & SQL DB Premium will work, but SQL DB premium is considerably less expensive. I tried both in the Azure Pricing Calculator (Zone redudant & different sizes). SQL DB Premium is always far cheaper than Managed Instance. Azure Pricing Calculator: https://azure.microsoft.com/en-us/pricing/calculator/

   Source: Adapted from community discussion — AdventureChick

   References

   • Microsoft Learn
   • azure.microsoft.com documentation
   • Microsoft Learn
   • azure.microsoft.com documentation
   • Microsoft Learn

   Next question

6. Question 76 · 232 in bank

   HOTSPOT - 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:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Box 1: General purpose v2 with Hot access tier for blobs Note: * All the data written to storage must be retained for five years. * Data access charges must be minimized Hot 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 lock As 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. Reference: 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

   Source: Adapted from community discussion — mse89

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   

   Next question

7. Question 77 · 232 in bank

   HOTSPOT - 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 300 concurrent 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:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Box 1: Azure Data Lake Storage Gen2 Azure 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 datasets Box 2: Azure SQL Database Hyperscale Azure 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 IOPS Incorrect: * Azure Synapse Analytics Dedicated SQL pool. Max database size: 240 TB - A maximum of 128 concurrent queries will execute and remaining queries will be queued. Reference: 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

   Source: Adapted from community discussion — Snownoodles

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   

   Next question

8. Question 78 · 232 in bank

   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?

   • ARSA 3072
   • BAES 256
   • CRSA 4096
   • DRSA 2048

   Show answer

   Answer: A

   Explanation

   A. RSA 3072 RSA 3072 provides a higher level of encryption strength compared to RSA 2048. While RSA 4096 offers even stronger encryption, it is not supported by Azure SQL Database and Azure SQL Managed Instance for TDE protectors. By choosing RSA 3072 for the TDE protector, you ensure strong encryption for your Azure SQL Managed Instance while complying with the platform's requirements. This will help protect sensitive data and maintain compliance with relevant security standards and regulations.

   Source: Adapted from community discussion — NotMeAnyWay

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   Next question

9. Question 79 · 232 in bank

   Select 2

   You have an Azure subscription that contains an Azure Blob Storage account named store1. You have an on-premises file server named Server1 that runs Windows Server 2016. Server1 stores 500 GB of company files. You need to store a copy of the company files from Server1 in store1. Which two possible Azure services achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

   • Aan Azure Logic Apps integration account
   • Ban Azure Import/Export job
   • CAzure Data Factory
   • Dan Azure Analysis services On-premises data gateway
   • Ean Azure Batch account

   Show answer

   Answer: BC

   Explanation

   A. an Azure Logic Apps integration account no, this is an integration service with visual flows with If-Then style logic. It does not support a way to import data from on-premise to blobstorage B. an Azure Import/Export job Agree, with other people here. C. Azure Data Factory Agree, is a way of importing data, but looking at 500GB it is a bit of overkill D. an Azure Analysis services On-premises data gateway not a data import option E. an Azure Batch account Is part of Azure Batch service and involve HPC job scheduling etc. but is not a way of importing or exporting data from on-premise to Azure Note: For 500GB we would probably use AzCopy instead. If it was a Typo and actually 500TB we would use Azure Data Box Heavy or maybe the Azure Import/Export Service if you provide your own drives.

   Source: Adapted from community discussion — sw1000

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   Next question

10. Question 80 · 232 in bank

    Select 2

    You are planning an Azure IoT Hub solution that will include 50,000 IoT devices. Each device will stream data, including temperature, device ID, and time data. Approximately 50,000 records will be written every second. The data will be visualized in near real time. You need to recommend a service to store and query the data. Which two services can you recommend? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

    • AAzure Table Storage
    • BAzure Event Grid
    • CAzure Cosmos DB for NoSQL
    • DAzure Time Series Insights

    Show answer

    Answer: CD

    Explanation

    A. Azure Table Storage -> Throughput: scalability limit of 20,000 operations/s. -> Not enough for this question B. Azure Event Grid -> It is only a broker, not a storage solution Therefore, C and D are right Refs: https://learn.microsoft.com/en-us/azure/cosmos-db/table/ https://learn.microsoft.com/en-us/azure/event-grid/overview

    Source: Adapted from community discussion — rgargar78

    References

    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

AZ-305 practice, question 71. 232 questions available.