Microsoft Azure Developer Certification Transition

Here you have the best Microsoft AZ-202 practice exam questions

  • You have 61 total questions to study from
  • Each page has 5 questions, making a total of 13 pages
  • You can navigate through the pages using the buttons at the bottom
  • This questions were last updated on December 16, 2025
  • This site is not affiliated with or endorsed by Microsoft.
Question 1 of 61
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.
Exam AZ-202: Question 1 - Image 1
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:
Exam AZ-202: Question 1 - Image 2
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 Exam AZ-202: Question 1 - Image 3
Question 2 of 61
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:
Exam AZ-202: Question 2 - Image 1
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/ Exam AZ-202: Question 2 - Image 2
Question 3 of 61
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:
Exam AZ-202: Question 3 - Image 1
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 Exam AZ-202: Question 3 - Image 2
Question 4 of 61
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: B, C

Question 5 of 61
DRAG DROP -
You have an Azure subscription.
You must create a file share with a quota of 2,048 GB. You create the following variables:
Exam AZ-202: Question 5 - Image 1
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:
Correct Answer: