Microsoft Azure Developer Certification Transition - AZ-202 Exam Practice Test
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.

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.

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
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.

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.

Correct Answer:

Explanation:

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
You develop a news and blog content delivery app for Windows devices.
A notification must arrive on a user's device when there is a new article available for them to view.
You need to implement push notifications.
How should you complete the code segment? To answer, select the appropriate options in the answer area.
NOTE: Each connect selection is worth one point.

You develop a news and blog content delivery app for Windows devices.
A notification must arrive on a user's device when there is a new article available for them to view.
You need to implement push notifications.
How should you complete the code segment? To answer, select the appropriate options in the answer area.
NOTE: Each connect selection is worth one point.

Correct Answer:

HOTSPOT
Contoso, Ltd. hosts the following ASP.NET workloads in Azure:

Users of the Sales software report mismatches between shown inventory at the time of sale and actual availability. Transactions across the two systems result in inconsistent reads and writes. You encapsulate Sales order creation and Inventory status updates in elastic transactions.
You need to recommend changes to code and the databases to support transactions.
Which actions should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Contoso, Ltd. hosts the following ASP.NET workloads in Azure:

Users of the Sales software report mismatches between shown inventory at the time of sale and actual availability. Transactions across the two systems result in inconsistent reads and writes. You encapsulate Sales order creation and Inventory status updates in elastic transactions.
You need to recommend changes to code and the databases to support transactions.
Which actions should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.
You need to ensure that the SecurityPin security requirements are met.
Solution; Using the Azure Portal, add Data Masking to the SecurityPin column, and exclude the dbo user. Add a SQL security policy with a filter predicate based on the user identity.
Does the solution meet the goal?
You need to ensure that the SecurityPin security requirements are met.
Solution; Using the Azure Portal, add Data Masking to the SecurityPin column, and exclude the dbo user. Add a SQL security policy with a filter predicate based on the user identity.
Does the solution meet the goal?
Correct Answer: A
Vote an answer
DRAG DROP
You are developing a .NET Core model-view controller (MVC) application hosted on Azure for a health care system that allows providers access to their information.
You develop the following code:

You define a role named SysAdmin.
You need to ensure that the application meets the following authorization requirements:
* Allow the ProviderAdmin and SysAdmin roles access to the Partner controller regardless of whether the user holds an editor claim of partner.
* Limit access to the Manage action of the controller to users with an editor claim of partner who are also members of the SysAdmin role.
How should you complete the code? To answer, drag the appropriate code segments to the correct locations. Each code segment may be used once, more than once, or not at all.
You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

You are developing a .NET Core model-view controller (MVC) application hosted on Azure for a health care system that allows providers access to their information.
You develop the following code:

You define a role named SysAdmin.
You need to ensure that the application meets the following authorization requirements:
* Allow the ProviderAdmin and SysAdmin roles access to the Partner controller regardless of whether the user holds an editor claim of partner.
* Limit access to the Manage action of the controller to users with an editor claim of partner who are also members of the SysAdmin role.
How should you complete the code? To answer, drag the appropriate code segments to the correct locations. Each code segment may be used once, more than once, or not at all.
You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:

Box 1:
Allow the ProviderAdmin and SysAdmin roles access to the Partner controller regardless of whether the user holds an editor claim of partner.
Box 2:
Limit access to the Manage action of the controller to users with an editor claim of partner who are also members of the SysAdmin role.
You are configuring Azure Redis Cache for a production web application.
The web application and Azure Redis Cache must be able to withstand a catastrophic t configuration changes. You create a storage account to persist cache data if needed You need to implement a solution.
What should you do?
The web application and Azure Redis Cache must be able to withstand a catastrophic t configuration changes. You create a storage account to persist cache data if needed You need to implement a solution.
What should you do?
Correct Answer: A
Vote an answer
You develop software solutions for a media services company. You plan to analyze a collection of video files by using Azure Video Indexer.
You need to only generate audio transcripts from the files, as quickly as possible, without incurring extra costs.
To which value should you set the Azure Video Indexer streammgPreset option?
You need to only generate audio transcripts from the files, as quickly as possible, without incurring extra costs.
To which value should you set the Azure Video Indexer streammgPreset option?
Correct Answer: C
Vote an answer
You are expanding an existing on-premises application to connect to several applications in the cloud. You have the following requirements:
* Automate various business processes and send data to multiple SaaS and
* Use workflows and a publish-subscribe model
* Prohibit changes to the on-premises application
You need to create a solution.
What should you use?
* Automate various business processes and send data to multiple SaaS and
* Use workflows and a publish-subscribe model
* Prohibit changes to the on-premises application
You need to create a solution.
What should you use?
Correct Answer: D
Vote an answer