AZ-202

Question 1

A company is developing a software as a service (SaaS) solution in Azure for other business to manage customers. The solution includes the following Azure SQL Database instances. Customer data exists in all databases. Customers may request that the company remove data that relates to the customer. If a customer makes a deletion request, all details from the customer must be removed from the solution. All deletions for a customer must occur in one distributed transaction that includes the CRM, ERP, and Marketing databases. You need to activate support for transactions over multiple databases on the same logical server and activate support for transactions over multiple servers. Which actions and Azure PowerShell command should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:

Question 2

A construction company creates three-dimensional models from photographs and design diagrams of buildings. The company plans to store high-resolution photographs and blueprint files in Azure Blob Storage. The files are currently stored in the construction company's office. You are developing a tool to connect to Azure Storage, create container, and then upload the files. The tool must remain responsive to the end user while it is running and performing remote I/O operations. It must also wait for methods to complete before continuing. You need to complete the configuration. How should you complete the code? To answer, select the appropriate options in the answer area. NOTE: Each correct solution is worth one point. Hot Area:

Question 3

You are creating a collaborative image hosting platform as an ASP.NET MVC web application. Users add, update, and modify images on the platform. Images are stored in Azure Blob storage. More than one user at a time must be able to modify the same image. You need to implement optimistic concurrency for uploading images. Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. NOTE: Each correct solution is worth one point. Select and Place:

Question 4

Members of the finance department for a company review and make changes to a Microsoft Excel workbook that is hosted on OneDrive. The workbook contains projected costs and revenue for a project. You need to develop an Azure Function that ingests data from the modified workbook and places it into a Microsoft Word document. Which two objects should you implement? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

1. A group conversation subscription
2. An Excel table input binding
3. A group subscription
4. An Excel table output binding
5. An auth token input binding

Question 5

You have an Azure subscription. You must create a file share with a quota of 2,048 GB. You create the following variables: In which order should you arrange the Azure CLI commands to develop the solution? To answer, move all the commands from the list of commands to the answer area and arrange them in the correct order. Select and Place: