Microsoft Microsoft Certifications AZ-305 Questions & Answers

• Question 251:

  Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while

  others might not have a correct solution.

  After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

  Your company plans to deploy various Azure App Service instances that will use Azure SQL databases. The App Service instances will be deployed at the same time as the Azure SQL databases.

  The company has a regulatory requirement to deploy the App Service instances only to specific Azure regions. The resources for the App Service instances must reside in the same region.

  You need to recommend a solution to meet the regulatory requirement.

  Solution: You recommend creating resource groups based on locations and implementing resource locks on the resource groups.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: B

  Resource locks are not used for compliance purposes. Resource locks prevent changes from being made to resources.

  Reference: https://docs.microsoft.com/en-us/azure/azure-resource-manager/management/lock-resources

• Question 252:

  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.

  A. Azure Table Storage

  B. Azure Event Grid

  C. Azure Cosmos DB SQL API

  D. Azure Time Series Insights

  Correct Answer: CD

  D: Time Series Insights is a fully managed service for time series data. In this architecture, Time Series Insights performs the roles of stream processing, data store, and analytics and reporting. It accepts streaming data from either IoT Hub or Event Hubs and stores, processes, analyzes, and displays the data in near real time.

  C: The processed data is stored in an analytical data store, such as Azure Data Explorer, HBase, Azure Cosmos DB, Azure Data Lake, or Blob Storage.

  Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/scenarios/time-series

• Question 253:

  You have SQL Server on an Azure virtual machine. The databases are written to nightly as part of a batch process. You need to recommend a disaster recovery solution for the data. The solution must meet the following requirements:

  1.

  Provide the ability to recover in the event of a regional outage. Support a recovery time objective (RTO) of 15 minutes.

  2.

  Support a recovery point objective (RPO) of 24 hours.

  3.

  Support automated recovery.

  4.

  Minimize costs.

  What should you include in the recommendation?

  A. Azure virtual machine availability sets

  B. Azure Disk Backup

  C. an Always On availability group

  D. Azure Site Recovery

  Correct Answer: D

  Replication with Azure Site Recover:

  RTO is typically less than 15 minutes.

  RPO: One hour for application consistency and five minutes for crash consistency.

  Reference:

  https://docs.microsoft.com/en-us/azure/site-recovery/site-recovery-sql

• Question 254:

  You are designing an application that will aggregate content for users.

  You need to recommend a database solution for the application. The solution must meet the following requirements:

  1.

  Support SQL commands.

  2.

  Support multi-master writes.

  3.

  Guarantee low latency read operations. What should you include in the recommendation?

  A. Azure Cosmos DB SQL API

  B. Azure SQL Database that uses active geo-replication

  C. Azure SQL Database Hyperscale

  D. Azure Database for PostgreSQL

  Correct Answer: A

  With Cosmos DB's novel multi-region (multi-master) writes replication protocol, every region supports both writes and reads. The multi-region writes capability also enables:

  1.

  Unlimited elastic write and read scalability.

  2.

  99.999% read and write availability all around the world.

  3.

  Guaranteed reads and writes served in less than 10 milliseconds at the 99th percentile.

  Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/distribute-data-globally

• Question 255:

  You plan provision a High Performance Computing (HPC) cluster in Azure that will use a third-party scheduler.

  You need to recommend a solution to provision and manage the HPC cluster node.

  What should you include in the recommendation?

  A. Azure Lighthouse

  B. Azure CycleCloud

  C. Azure Purview

  D. Azure Automation

  Correct Answer: B

  You can dynamically provision Azure HPC clusters with Azure CycleCloud. Azure CycleCloud is the simplest way to manage HPC workloads.

  Note: Azure CycleCloud is an enterprise-friendly tool for orchestrating and managing High Performance Computing (HPC) environments on Azure. With CycleCloud, users can provision infrastructure for HPC systems, deploy familiar HPC schedulers, and automatically scale the infrastructure to run jobs efficiently at any scale. Through CycleCloud, users can create different types of file systems and mount them to the compute cluster nodes to support HPC workloads.

  Reference: https://docs.microsoft.com/en-us/azure/cyclecloud/overview

• Question 256:

  You are designing a large Azure environment that will contain many subscriptions.

  You plan to use Azure Policy as part of a governance solution.

  To which three scopes can you assign Azure Policy definitions? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. management groups

  B. subscriptions

  C. Azure Active Directory (Azure AD) tenants

  D. resource groups

  E. Azure Active Directory (Azure AD) administrative units

  F. compute resources

  Correct Answer: ABD

  Azure Policy evaluates resources in Azure by comparing the properties of those resources to business rules.

  Once your business rules have been formed, the policy definition or initiative is assigned to any scope of resources that Azure supports, such as management groups, subscriptions, resource groups, or individual resources.

  Reference:

  https://docs.microsoft.com/en-us/azure/governance/policy/overview

• Question 257:

  You have an on-premises network and an Azure subscription. The on-premises network has several branch offices.

  A branch office in Toronto contains a virtual machine named VM1 that is configured as a file server. Users access the shared files on VM1 from all the offices.

  You need to recommend a solution to ensure that the users can access the shares files as quickly as possible if the Toronto branch office is inaccessible.

  What should you include in the recommendation?

  A. a Recovery Services vault and Azure Backup

  B. an Azure file share and Azure File Sync

  C. Azure blob containers and Azure File Sync

  D. a Recovery Services vault and Windows Server Backup

  Correct Answer: B

  Use Azure File Sync to centralize your organization's file shares in Azure Files, while keeping the flexibility, performance, and compatibility of an on-premises file server. Azure File Sync transforms Windows Server into a quick cache of your Azure file share.

  You need an Azure file share in the same region that you want to deploy Azure File Sync.

  Reference: https://docs.microsoft.com/en-us/azure/storage/files/storage-sync-files-deployment-guide

• Question 258:

  You have 100 servers that run Windows Server 2012 R2 and host Microsoft SQL Server 2012 R2 instances. The instances host databases that have the following characteristics:

  1.

  The largest database is currently 3 TB. None of the databases will ever exceed 4 TB.

  2.

  Stored procedures are implemented by using CLR.

  You plan to move all the data from SQL Server to Azure.

  You need to recommend an Azure service to host the databases. The solution must meet the following requirements:

  Whenever possible, minimize management overhead for the migrated databases. Minimize the number of database changes required to facilitate the migration. Ensure that users can authenticate by using their Active Directory credentials.

  What should you include in the recommendation?

  A. Azure SQL Database single databases

  B. Azure SQL Database Managed Instance

  C. Azure SQL Database elastic pools

  D. SQL Server 2016 on Azure virtual machines

  Correct Answer: 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.

  References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/transact-sql-tsql-differences-sql-server#clr https://docs.microsoft.com/en-gb/azure/azure-sql/database/transact-sql-tsql-differences-sql-server#transact-sql-syntax-not-supported-in-azure-sql-database

• Question 259:

  Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while

  others might not have a correct solution.

  After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

  Your company has deployed several virtual machines (VMs) on-premises and to Azure. Azure ExpressRoute has been deployed and configured for on-premises to Azure connectivity.

  Several VMs are exhibiting network connectivity issues.

  You need to analyze the network traffic to determine whether packets are being allowed or denied to the VMs.

  Solution: Use the Azure Traffic Analytics solution in Azure Log Analytics to analyze the network traffic.

  Does the solution meet the goal?

  A. Yes

  B. No

  Correct Answer: B

  Instead use Azure Network Watcher to run IP flow verify to analyze the network traffic.

  Reference: https://docs.microsoft.com/en-us/azure/network-watcher/network-watcher-monitoring-overview https://docs.microsoft.com/en-us/azure/network-watcher/network-watcher-ip-flow-verify-overview

• Question 260:

  Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while

  others might not have a correct solution.

  After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

  Your company has deployed several virtual machines (VMs) on-premises and to Azure. Azure ExpressRoute has been deployed and configured for on-premises to Azure connectivity.

  Several VMs are exhibiting network connectivity issues.

  You need to analyze the network traffic to determine whether packets are being allowed or denied to the VMs.

  Solution: Use the Azure Advisor to analyze the network traffic.

  Does the solution meet the goal?

  A. Yes

  B. No

  Correct Answer: B

  Instead use Azure Network Watcher to run IP flow verify to analyze the network traffic.

  Note: Advisor is a personalized cloud consultant that helps you follow best practices to optimize your Azure deployments. It analyzes your resource configuration and usage telemetry and then recommends solutions that can help you improve

  the cost effectiveness, performance, high availability, and security of your Azure resources.

  With Advisor, you can:

  Get proactive, actionable, and personalized best practices recommendations. Improve the performance, security, and high availability of your resources, as you identify opportunities to reduce your overall Azure spend. Get recommendations

  with proposed actions inline.

  Reference:

  https://docs.microsoft.com/en-us/azure/advisor/advisor-overview