Microsoft AZ-202 Exam Actual Questions

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

Correct Answer:
Box 1: Use a transaction scope -
The TransactionScope class establishes an ambient transaction in .NET. (An "ambient transaction" is one that lives in the current thread.) All connections opened within the TransactionScope participate in the transaction. If different databases participate, the transaction is automatically elevated to a distributed transaction.
Box 2: New-AzureRmSqlServerCommunicationLink
New-AzureRmSqlServerCommunicationLink: Use this cmdlet to create a new communication relationship between two logical servers in Azure SQL DB. The relationship is symmetric which means both servers can initiate transactions with the other server.
References:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-transactions-overview

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

Correct Answer:
Box 1: ProcessAsync();
Box 2: await cloudBlobContainer.CreatAsync();
If you specify that a method is an async method by using the async modifier, you enable the following two capabilities.
The marked async method can use await to designate suspension points. The await operator tells the compiler that the async method can't continue past that point until the awaited asynchronous process is complete. In the meantime, control returns to the caller of the async method.
The suspension of an async method at an await expression doesn't constitute an exit from the method, and finally blocks don't run.
The marked async method can itself be awaited by methods that call it.
References:
https://docs.microsoft.com/en-us/dotnet/csharp/programming-guide/concepts/async/

DRAG DROP -
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:

Correct Answer:
Optimistic concurrency means allowing concurrency conflicts to happen, and then reacting appropriately if they do.
For the PUT method, If-Match can be used to prevent the lost update problem. It can check if the modification of a resource that the user wants to upload will not override another change that has been done since the original resource was fetched. If the request cannot be fulfilled, the 412 (Precondition Failed) response is returned.
References:
https://developer.mozilla.org/en-US/docs/Web/HTTP/Headers/If-Match

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.

Correct Answer: BC 🗳️
B: Azure Functions supports trigger, input, and output bindings for external files. These bindings create API connections to SaaS providers, or use existing API connections from your Function App's resource group.
References:
https://docs.microsoft.com/en-us/azure/azure-functions/functions-bindings-external-file