Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Microsoft AZ-202

Microsoft AZ-202 Exam Practice Questions (P. 1)

  • Full Access (61 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #1
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

Question #2
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/

Question #3
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

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
    A group conversation subscription
  2. B
    An Excel table input binding
  3. C
    A group subscription
  4. D
    An Excel table output binding
  5. E
    An auth token input binding

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

Question #5
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:

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:
Explanation
Step 1:

Create a resource group -
A resource group is a logical container in which Azure resources are deployed and managed. If you don't already have an Azure resource group, you can use the az group create command to create one.
The following example creates a resource group named myResourceGroup in the East US location: az group create --name myResourceGroup --location eastus
Step 2:

Create a storage account -
The following example creates a storage account named mystorageaccount<random number> by using the az storage account create command, and then puts the name of that storage account in the $STORAGEACCT variable.
STORAGEACCT=$(az storage account create \
--resource-group "myResourceGroup" \
--name "mystorageacct$RANDOM" \
--location eastus \
--sku Standard_LRS \
--query "name" | tr -d '"')
Step 3:

Get the storage account key -
Storage account keys control access to resources in a storage account. The keys are automatically created when you create a storage account. You can get the storage account keys for your storage account by using the az storage account keys list command:
STORAGEKEY=$(az storage account keys list \
--resource-group "myResourceGroup" \
--account-name $STORAGEACCT \
--query "[0].value" | tr -d '"')
Step 4:
Now, you can create your Azure file share. Create file shares by using the az storage share create command. This example creates an Azure file share named myshare: az storage share create \
--account-name $STORAGEACCT \
--account-key $STORAGEKEY \
--name "myshare"
References:
https://docs.microsoft.com/en-us/azure/storage/files/storage-how-to-use-files-cli

Next Questions

All Pages