AZ-305: Designing Microsoft Azure Infrastructure SolutionsDemo

Your on-premises network contains a file server named Server1 that stores 500 GB of data.

You need to use Azure Data Factory to copy the data from Server1 to Azure Storage. You add a new data factory.

What should you do next?

You have an Azure subscription. The subscription contains a tiered app named App1 that is distributed across multiple containers hosted in Azure Container Instances.

You need to deploy an Azure Monitor monitoring solution for App. The solution must meet the following requirements:

• Support synthetic transaction monitoring for traffic between the App1 components.
• Minimize development effort.

What should you include in the solution?

You have an Azure subscription that includes 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 Azure services could accomplish this goal? Each correct answer provides a complete solution.

NOTE: Each correct selection is worth one point.

You need to design an architecture that captures user creation and role assignments. The captured data must be stored in Azure Cosmos DB.

Which services should be included in the design?

Each service may be used once, more than once, or not at all.

You have an application used by 6,000 users to validate their vacation requests. The application maintains its own credential store.

Users must provide a username and password to access the application. The application does NOT support identity providers.

You plan to upgrade the application to use single sign-on (SSO) authentication by using an Azure Active Directory (Azure AD) application registration.

Which SSO method should you use?

You need to recommend a solution for generating a monthly report of all new Azure Resource Manager (ARM) resource deployments in your Azure subscription.

What should the recommendation include?

You have an on-premises Microsoft SQL Server named SQL1 that hosts 50 databases.

You plan to migrate SQL1 to Azure SQL Managed Instance.

You need to carry out an offline migration of SQL1. The solution must minimize administrative effort.

What should you include in the solution?

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

• Database updates will be exported periodically to a staging area in Azure Blob storage.
• Data from blob storage will be cleansed and transformed by a highly parallelized load process.
• The transformed data will be loaded into a data warehouse.
• Each update batch will refresh an online analytical processing (OLAP) model in a managed serving layer.
• The managed serving layer will serve thousands of end users.

You need to implement the data warehouse and serving layers. What should you use?

You have 12 on-premises data sources containing customer information, consisting of Microsoft SQL Server, MySQL, and Oracle databases.

You have an Azure subscription.

You plan to create an Azure Data Lake Storage account to consolidate the customer information for analysis and reporting.

You need to recommend a solution that automatically copies 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?

You need to recommend a solution that generates a monthly report of every new Azure Resource Manager (ARM) resource deployment in your Azure subscription.

What should you include in the recommendation?

You have 100 Microsoft SQL Server Integration Services (SSIS) packages configured to use 10 on-premises SQL Server databases as their destinations.

You plan to migrate the 10 on-premises databases to Azure SQL Database.

You need to recommend a solution to create Azure-SQL Server Integration Services (SSIS) packages. The solution must ensure that the packages can target the SQL Database instances as their destinations.

What should you include in the recommendation?

You are designing an app that will use Azure Cosmos DB to aggregate sales from multiple countries.

You need to recommend an API for the app. The solution must meet these requirements:

• Support SQL queries.
• Support geo-replication.
• Store and access data relationally.

Which API should you recommend?

You plan to deploy an application named App1 that will run in containers on Azure Kubernetes Service (AKS) clusters. The AKS clusters will be located across four Azure regions.

You need to recommend a storage solution that ensures updated container images are automatically replicated to every Azure region that hosts the AKS clusters.

Which storage solution should you recommend?

You plan to migrate App1 to Azure.

You need to recommend a network-connectivity solution for the Azure Storage account that will host the App1 data. The solution must satisfy the security and compliance requirements.

What should you include in the recommendation?

You are building a multi-tier application named App1 to run on Azure virtual machines. App1 reaches peak utilization from 8 AM to 9 AM and from 4 PM to 5 PM on weekdays.

Deploy infrastructure for App1 that meets these requirements:

• Support virtual machines deployed across four availability zones in two Azure regions.
• Reduce costs by accumulating CPU credits during low-utilization periods.

What is the minimum number of virtual networks to deploy, and which virtual machine size should be used?

You have an Azure web app named App1 and an Azure key vault named KV1. App1 stores database connection strings in KV1.

App1 performs these request types against KV1:

• Get
• List
• Wrap
• Delete
• Unwrap

• Backup
• Decrypt
• Encrypt

You are evaluating service continuity for App1. If the Azure region hosting KV1 becomes unavailable, identify:

• Where KV1 will fail over
• Which request type will be unavailable during the failover

You are designing an application that aggregates content for users.

You need to recommend a database solution for the application. The solution must satisfy these requirements:

• Support SQL commands.
• Support multi-master writes.
• Guarantee low-latency read operations.

What should you include in the recommendation?

You have an Azure Active Directory (Azure AD) tenant that is synchronized with an on-premises Active Directory domain.

You have an internal web app named WebApp1 that is hosted on-premises. WebApp1 uses Integrated Windows authentication.

Some users work remotely and do NOT have VPN access to the on-premises network.

You need to give the remote users single sign-on (SSO) access to WebApp1.

Which two features should you include in the solution? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

You are designing an app hosted on Azure virtual machines that run Ubuntu. The app will use a third-party email service to send email messages to users. The email service requires the app to authenticate by using an API key.

You need to recommend an Azure Key Vault solution for storing and accessing the API key while minimizing administrative effort.

What should you recommend using to store and access the key?

You have an Azure subscription containing a virtual network named VNET1 and 10 virtual machines connected to VNET1.

Design a solution to manage the virtual machines from the internet that meets these requirements:

• Authenticate incoming connections with Azure Multi-Factor Authentication (MFA) before network connectivity is permitted.
• Use TLS for incoming connections and TCP port 443.
• Support both RDP and SSH.

What should the solution include?

You are designing an Azure order-processing system that will contain the Azure resources shown in the following table.

The order-processing system will use the following transaction flow:

• A customer will place an order by using App1.
• When the order is received, App1 will generate a message to check product availability at vendor 1 and vendor 2.
• An integration component will process the message and then trigger either Function1 or Function2, depending on the order type.
• When a vendor confirms product availability, Function1 or Function2 will generate a status message for App1.
• All transaction steps will be logged to storage1.

Which resource type should you recommend for the integration component?

Your company develops a web service deployed to an Azure virtual machine named VM1. The web service enables an API to access real-time data from VM1. The current virtual-machine deployment is shown in the Deployment exhibit.

The chief technology officer (CTO) sends this email message: “Our developers have deployed the web service to a virtual machine named VM1. Testing has confirmed that the API is accessible from VM1 and VM2. Our partners must be able to connect to the API over the Internet. Partners will use this data in applications that they develop.”

You deploy an Azure API Management (APIM) service. The relevant API Management configuration is shown in the API exhibit.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

You are developing a sales application that will include several Azure cloud services and manage different transaction components. Different cloud services will process customer orders, billing, payment, inventory, and shipping.

You need to recommend a solution that lets the cloud services asynchronously exchange transaction information by using XML messages.

What should you include in the recommendation?