Microsoft Microsoft Certifications AZ-305 Questions & Answers

• Question 11:

  What two parameters would you recommend set up to ensure that the new IPSCustomers database will scale to meet the workload demands?

  A. Define the maximum of CPU cores

  B. Define the maximum resource limit per group of databases

  C. Define the maximum of Database Transaction Units

  D. Define the maximum of the allocated storage

  E. Define the maximum size for a database

  Correct Answer: CE

• Question 12:

  A company is planning on deploying an application onto Azure. The application will be based on the .Net core programming language. The application would be hosted using Azure Web apps. Below is part of the various requirements for the application

  Give the ability to correlate Azure resource usage and the performance data with the actual application configuration and performance data Give the ability to visualize the relationships between application components Give the ability to track requests and exceptions to specific lines of code from within the application Give the ability to actually analyse how uses return to an application and see how often they only select a particular drop-down value

  Which of the following service would be best suited for fulfilling the requirement of “Give the ability to correlate Azure resource usage and the performance data with the actual application configuration and performance data” ?

  A. Azure Application Insights

  B. Azure Service Map

  C. Azure Log Analytics

  D. Azure Activity Log

  Correct Answer: C

• Question 13:

  A company has an on-premises file server cbflserver that runs Windows Server 2019.

  Windows Admin Center manages this server. The company owns an Azure subscription.

  You need to provide an Azure solution to prevent data loss if the file server fails.

  Solution: You decide to register Windows Admin Center in Azure and then configure Azure Backup.

  Would this meet the requirement?

  A. Yes

  B. No

  Correct Answer: A

• Question 14:

  You have an Azure subscription that contains an Azure Kubernetes Service (AKS) instance named AKS1. AKS1 hosts microservice-based APIs that are configured to listen on non-default HTTP ports.

  You plan to deploy a Standard tier Azure API Management instance named APIM1 that will make the APIs available to external users.

  You need to ensure that the AKS1 APIs are accessible to APIM1. The solution must meet the following requirements:

  Implement MTLS authentication between APIM1 and AKS1.

  Minimize development effort.

  Minimize costs.

  What should you do?

  A. Implement an external load balancer on AKS1.

  B. Redeploy APIM1 to the virtual network that contains AKS1.

  C. Implement an ExternalName service on AKS1.

  D. Deploy an ingress controller to AKS1.

  Correct Answer: D

  Reference: https://learn.microsoft.com/en-us/azure/api-management/api-management-kubernetes

• Question 15:

  You need to recommend a solution to generate a monthly report of all the new Azure Resource Manager resource deployment in your subscription. What should you include in the recommendation?

  A. Azure Analysis Services

  B. Application Insights

  C. Azure Monitor action groups

  D. Azure Log Analytics

  Correct Answer: D

  Activity logs are kept for 90 days. You can query for any range of dates, as long as the starting date isn't more than 90 days in the past. Through activity logs, you can determine:

  1.

  what operations were taken on the resources in your subscription who started the operation

  2.

  when the operation occurred

  3.

  the status of the operation

  4.

  the values of other properties that might help you research the operation

  Reference: https://docs.microsoft.com/en-us/azure/azure-resource-manager/management/view-activity-logs https://docs.microsoft.com/en-us/azure/automation/change-tracking

• Question 16:

  HOTSPOT

  You are building an Azure web app that will store the Personally Identifiable Information (PII) of employees.

  You need to recommend an Azure SQL. Database solution for the web app. The solution must meet the following requirements:

  Maintain availability in the event of a single datacenter outage.

  Support the encryption of specific columns that contain PII.

  Automatically scale up during payroll operations.

  Minimize costs.

  What should you include in the recommendations? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: Business Critical service tier and Serverless computer tier.

  Business Critical

  OLTP applications with high transaction rate and low IO latency. Offers highest resilience to failures and fast failovers using multiple synchronously updated replicas.

  Availability: 3 replicas, 1 Read Scale-out, zone-redundant HA, full local storage

  Note: Azure SQL Database is based on SQL Server Database Engine architecture that is adjusted for the cloud environment to ensure high availability even in cases of infrastructure failures. There are three architectural models that are used

  in Azure SQL Database:

  General Purpose/Standard

  Business Critical/Premium

  Hyperscale

  Incorrect:

  *

  General Purpose and Serverless computer tier Offers budget oriented balanced compute and storage options. No Read Scale-out.*

  *

  Hyperscale service tier and Provisioned compute tier Expensive.

  Most business workloads. Autoscaling storage size up to 100 TB, fast vertical and horizontal compute scaling, fast database restore.

  Box 2: Always Encrypted PII data needs to be tightly protected. In Azure, Most of the PaaS services already have a server-side encryption to protect data at rest like Transparent data encryption for Azure SQL Databases. For client side encryption, we can accomplish this natively with an encryption technology called Always encrypted for Azure SQL Database or any SQL Server datastore. There are several data tokenization solutions out in the marketplace which can tokenize this data as well but its only effective for small strings and integers. However, if your data contains large text columns which has PII information then these tokenization solutions are not so effective and can become a bottleneck. Example: Call center voice transcripts which may have sensitive information like a SSN or a Creditcard number etc. That's where Always encrypted can handle this effectively out of the box.

  Reference: https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale https://medium.com/@raghavender7/protecting-sensitive-pii-data-in-azure-sql-databases-5c83bca473fc

• Question 17:

  HOTSPOT

  You are designing a data pipeline that will integrate large amounts of data from multiple on-premises Microsoft SQL Server databases into an analytics platform in Azure. The pipeline will include the following actions:

  1.

  Database updates will be exported periodically into a staging area in Azure Blob storage.

  2.

  Data from the blob storage will be cleansed and transformed by using a highly parallelized load process.

  3.

  The transformed data will be loaded to a data warehouse.

  4.

  Each batch of updates will be used to refresh an online analytical processing (OLAP) model in a managed serving layer.

  5.

  The managed serving layer will be used by thousands of end users.

  You need to implement the data warehouse and serving layers.

  What should you use? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Reference: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-overview-what-is https://learn.microsoft.com/en-us/azure/architecture/example-scenario/data/data-warehouse

• Question 18:

  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?

  A. Azure Data Factory

  B. Azure Data Explorer

  C. Azure Data Share

  D. Azure Data Studio

  Correct Answer: A

• Question 19:

  You need to deploy resources to host a stateless web app in an Azure subscription. The solution must meet the following requirements:

  1.

  Provide access to the full .NET framework.

  2.

  Provide redundancy if an Azure region fails.

  3.

  Grant administrators access to the operating system to install custom application dependencies.

  Solution: You deploy an Azure virtual machine scale set that uses autoscaling.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: B

  Instead, you should deploy two Azure virtual machines to two Azure regions, and you create a Traffic Manager profile

• Question 20:

  Your on-premises datacenter contains a server that runs Linux and hosts a Java app named App1. App1 has the following characteristics:

  App1 is an interactive app that users access by using HTTPS connections.

  1.

  The number of connections to App1 changes significantly throughout the day.

  2.

  App1 runs multiple concurrent instances.

  3.

  App1 requires major changes to run in a container.

  4.

  You plan to migrate App1 to Azure.

  You need to recommend a compute solution for App1. The solution must meet the following requirements:

  1.

  The solution must run multiple instances of App1.

  2.

  The number of instances must be managed automatically depending on the load.

  3.

  Administrative effort must be minimized.

  What should you include in the recommendation?

  A. Azure Batch

  B. Azure App Service

  C. Azure Kubernetes Service (AKS)

  D. Azure Virtual Machine Scale Sets

  Correct Answer: B

  Azure Virtual Machine Scale Sets let you create and manage a group of load balanced VMs. The number of VM instances can automatically increase or decrease in response to demand or a defined schedule. Scale sets provide the following key benefits:

  Easy to create and manage multiple VMs Provides high availability and application resiliency by distributing VMs across availability zones or fault domains Allows your application to automatically scale as resource demand changes Works at large-scale

  Incorrect:

  * Azure Kubernetes Service (AKS)

  Azure Kubernetes Service (AKS) requires more administrative effort-

  Note:

  You can scale applications in Azure Kubernetes Service (AKS).

  Windows and Linux based AKS clusters are supported.

  Cluster node and pod scaling

  As demand for resources change, the number of cluster nodes or pods that run your services automatically scales up or down. You can adjust both the horizontal pod autoscaler or the cluster autoscaler to adjust to demands and only run

  necessary resources.

  Azure Linux nodes

  The Azure Linux container host for AKS is an open-source Linux distribution created by Microsoft, and it's available as a container host on Azure Kubernetes Service (AKS). The Azure Linux container host for AKS provides reliability and

  consistency from cloud to edge across the AKS, AKS-HCI, and Arc products. You can deploy Azure Linux node pools in a new cluster, add Azure Linux node pools to your existing Ubuntu clusters, or migrate your Ubuntu nodes to Azure

  Linux nodes.

  Reference:

  https://learn.microsoft.com/en-us/azure/virtual-machine-scale-sets/overview

  https://learn.microsoft.com/en-us/azure/aks/intro-kubernetes