Simulation AZ-202 Study Guides 2021

NEW QUESTION 1
You are developing an Azure Function App by using Visual Studio. The app will process orders Queue Storage.
You need to review the Azure Function App code shown below.

Answer:

Explanation:

NEW QUESTION 2
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 have the following resource groups:

Developers must conned to DevServer only through DevWorkstation. To maintain security, DevServer must not accept connections (rom the internet.
You need to create a private connection between the DevWorkstation and DevServer.
Solution: Configure a VNet-to-VNet VPN connection between the two private Virtual Networks using VPN gati allow connectivity between the DevServer and the DevWorkstation using their private IP addresses.
Does the solution meet the goal?

• A. Yes
• B. No

Answer: B

NEW QUESTION 3
You are developing a NET Core on premises application that updates multiple Azure SQL Database instances. The application must log all update commands attempted to a separate Azure SQL Database instance named AuditDb.
You define an outer TransactionScope with a loop to enumerate and run the SQL commands on each customer database connection and an inner TransactionScope to record transactions attempted within the outer TransactionScope to the AuditDb database.
You need to develop a method to perform the updates to the databases. The solution must meet the following requirements:
• All rows written to the AuditDb database must be committed even if the outer transaction fails.
• If an error occurs writing to the AuditDb database, the outer transaction must be rolled back.
• If an error occurs writing to the Customer databases, only the outer transaction must be rolled back.
• Values for TransactionScopeOption must be specified for the customer databases.
• Values for TransactionScopeOption must be specified for the AuditDb database. Which TransactionScopeOption values should you use?

• A. Suppress for CustomerTranScopeOption and Required for AuditTranScopeOption
• B. Required for the CustomerTranScopeOption and RequiresNew for the AuditTranScopeOption
• C. RequiresNew for the CustomerTranScopeOption and RequiresNew for the AuditTranScopeOption
• D. RequiresNew for CustomerTranScopeOption and Suppress for AuditTranScopeOption

Answer: A

NEW QUESTION 4
You use Azure Table storage to store customer information for an application. The data contains customer details and is partitioned by last name. You need to create a query that returns all customers with the last name Smith. Which code segment should you use?

• A. TableQuery.GeneratePilterCondition("LastName", QueryComparisons.Equal, "Smith")
• B. TableQuery.GeneratefilterCondition("PartitionKey", QueryComparison
• C. Equal, "Smith")
• D. TableQue.GenerateFilterCondition("PartitionKey", Equals, "Smith")
• E. TableQuer
• F. GenerateFilterCondition("LastName", Equals, "Smith")

Answer: D

NEW QUESTION 5
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 meet the LabelMaker application security requirement.
Solution: Create a Microsoft Azure Active Directory service principal and assign it to the Azure Kubernetes Service (AKS) cluster.
Does the solution meet the goal?

• A. Yes
• B. No

Answer: A

NEW QUESTION 6
You are implementing an order processing system. A point of sale application publishes orders to topics in an Azure Service Bus queue. The label property for the topic includes the following data:

The system has the following requirements for subscriptions:

You need to implement filtering and maximize throughput while evaluating filters.
Which filter types should you implement? To answer, drag the appropriate filter types to the correct subscriptions. Each filter type 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.

Answer:

Explanation: FutureOrders: SQLFilter HighPriortyOrders: CorrelationFilter CorrelationID only InternationalOrders: SQLFilter
Country NOT USA requires an SQL Filter
HighQuantityOrders: SQLFilter
Need to use relational operators so an SQL Filter is needed. AllOrders: No Filter
SQL Filter: SQL Filters - A SqlFilter holds a SQL-like conditional expression that is evaluated in the broker against the arriving messages' user-defined properties and system properties. All system properties must be prefixed with sys. in the conditional expression. The SQL-language subset for filter conditions tests for the existence of properties (EXISTS), as well as for null-values (IS NULL), logical NOT/AND/OR, relational operators, simple numeric arithmetic, and simple text pattern matching with LIKE.
Correlation Filters - A CorrelationFilter holds a set of conditions that are matched against one or more of an arriving message's user and system properties. A common use is to match against the CorrelationId property, but the application can also choose to match against ContentType, Label, MessageId, ReplyTo, ReplyToSessionId, SessionId, To, and any user-defined properties. A match exists when an arriving message's value for a property is equal to the value specified in the correlation filter. For string expressions, the comparison is case-sensitive. When specifying multiple match properties, the filter combines them as a logical AND condition, meaning for the filter to match, all conditions must match.
Boolean filters - The TrueFilter and FalseFilter either cause all arriving messages (true) or none of the arriving messages (false) to be selected for the subscription.
References:
https://docs.microsoft.com/en-us/azure/service-bus-messaging/topic-filters

NEW QUESTION 7
You are developing a multi-tenant ASP.NET Core application that will be hosted on Azure. The application will support multiple database platforms, including Azure SQL and on-premises SQL Server instances.
You need to ensure that the application supports distributed transactions.
Which technologies should you use? To answer, drag the appropriate technologies to the correct scenarios. Each technology 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.

Answer:

Explanation: Box 1: Elastic Database Client Library
Sharded database applications in Azure: With this scenario, the data tier uses the Elastic Database client library or self-sharding to horizontally partition the data across many databases in SQL DB.
Box 2: MSDTC
Eelastic database transactions cannot stretch across on premises SQL Server and Azure SQL Database. For distributed transactions on premises, continue to use MSDTC.
References:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-transactions-overview

NEW QUESTION 8
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.

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

NEW QUESTION 9
A company backs up all manufacturing data to Azure Blob Storage. Admins move blobs from hot storage to archive tier storage every month.
You must automatically move blocks to Archive tier after they have not been accessed for 180 days. The path for any item that is not archived must be placed in an existing queue. This operation must be performed automatically once a month. You set the value of TierAgeInDays to 180.
How should you configure the Logic App? To answer, drag the appropriate triggers or action blocks to the correct trigger or action slots. Each trigger or action block 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.

Answer:

Explanation: Box 1: Recurrence Box 2: Insert Entity
Box 3 (if true): Tier Blob
Box 4: (if false): Leave blank. References:
https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-perform-data-operations

NEW QUESTION 10
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?

• A. Yes
• B. No

Answer: B

NEW QUESTION 11
You need to ensure that security requirements are met.
What value should be used for the ConnectionString field on line DB03 in the Database class? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Answer:

Explanation: Box 1: Integrated Security=SSPI
Integrated security: For all data source types, connect using the current user account. For SqlClient you can use Integrated Security=true; or Integrated Security=SSPI;
Scenario: All access to Azure Storage and Azure SQL database must use the application’s Managed Service Identity (MSI)
Box 2: Encrypt = True
Scenario: All data must be protected in transit. References:
https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/connection-string-syntax

Topic 2, Chatbot
Background
Best for You Organics Company is a global restaurant franchise that has multiple locations. The company wants to enhance user experiences and vendor integrations. The company plans to implement automated mobile ordering and delivery services.
Best For You Organics hosts an Azure web app at the URL https://www.bestforyouorganics.com.
Users can use the web app to browse restaurant locations, menu items, nutritional, information, and company information. The company developed and deployed a cross-platform mobile app.
Requirements
You must develop a chartbot by using the Bot Builder SDK and Language Understanding Intelligence Service (LUIS). The chatbot must allow users to order food for pickup or delivery.
The chatbot must meet the following requirements:
Ensure that chatbot endpoint can be accessed only by the Bot Framework connector.
Use natural language processing and speech recognition so that users can interact with the chatbot by using text and voice. Processing must be server-based.
Alert users about promotions at local restaurants.
Enable users to place an order for delivery or pickup by using their voice.
Greet the user upon sigh-in by displaying a graphical interface that contains action buttons.
The chatbot greeting interface must match the formatting of the following example:

Vendor API
Vendors receive and provide updates for the restaurant inventory and delivery services by using Azure API Management hosted APIs. Each vendor uses their own subscription to access each of the APIs.
APIs must meet the following conditions:
API usage must not exceed 5,000 calls and 50,000 kilobytes of bandwidth per hour per vendor.
If a vendor is nearing the number of calls or bandwidth limit, the API must trigger email notifications to the vendor.
APIs must prevent API usage spikes on a per-subscription basis by limiting the call rate to 100 calls per minute.
The Inventory API must be written by using ASP.NET Core and Node.js.
The API must be updated to provide an interface to Azure SQL Database. Database objects must be managed by using code.
The Delivery API must be protected by using the OAuth 2.0 protocol with Azure Active Directory (Azure AD) when called from the Azure web app. You register the Delivery API and web app in Azure AD. You enable OAuth 2.0 in the web app.
The delivery API must update the Products table, the Vendor transactions table, and the Billing table in a single transaction.
The Best For You Organics Company architecture team has created the following diagram depicting the expected deployments into Azure:

Delivery API
The Delivery API intermittently throws the following exception:

Chatbot greeting
The chatbot’s greeting does not show the user’s name. You need to debug the chatbot locally.
Language processing
Users report that the bot fails to understand when a customer attempts to order dishes that use Italian names. Relevant portions of the app files are shown below. Line numbers are included for reference only and include a two-character prefix that denotes the specific file to which they belong.
Startup.cs

NEW QUESTION 12
You have a web application that runs on a single Azure virtual machine (VM) instance. The application performs time-consuming and CPU-intensive workloads. During peak hours, the application runs more slowly and the user experience is degraded.
You need to improve the performance of the application while minimizing costs.
Which two actions should you perform? Each correct answer presents a complete solution.
NOTE Each correct selection is worth one point.

• A. Create and set up additional VM instances as additional web servers to host the application.
• B. Change the VM type to the Compute Optimized F-Series size.
• C. Set up and configure a central Redis Cache server and implement caching on web servers.
• D. Set up and configure an Azure Queue in a storage accoun
• E. Configure the web application to add tasks to the queue.
• F. Set up and configure an Azure Service Bus Queu
• G. Configure the web application to add tasks to the queue.

Answer: B

NEW QUESTION 13
A company has a series of mobile games on Azure with an online community. The moderators need to filter offens.ve text, and additional .terns such as
The company wants to implement a solution using Azure Content Moderation. You need to select API or Azure service options for the solution.
Which two APIs or Azure service should you use? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

• A. Azure Bot Service
• B. Custom Term List API
• C. Language Understanding Intelligence System (LUIS) API
• D. Text Moderation API
• E. Text Analytics API

Answer: CD

NEW QUESTION 14
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 authentication events are triggered and processed according to the policy.
Solution: Create a new Azure Event Grid subscription for all authentication that delivers messages to an Azure Event Hub. Use the subscription to process signout events.
Does the solution meet the goal?

• A. Yes
• B. No

Answer: B

Explanation: Use a separate Azure Event Grid topics and subscriptions for sign-in and sign-out events.
Scenario: Authentication events are used to monitor users signing in and signing out. All authentication events must be processed by Policy service. Sign outs must be processed as quickly as possible.

NEW QUESTION 15
You need to ensure that the solution can meet the scaling requirements for Policy Service. Which Azure Application Insights data model should you use?

• A. an Application Insights metric
• B. an Application Insights dependency
• C. an Application Insights trace
• D. an Application Insights event

Answer: D

NEW QUESTION 16
You maintain an existing Azure SQL Database instance. Management of the database is performed by an external party. All cryptographic keys are stored in an Azure Key Vault.
You must ensure that the external party cannot access the data in the SSN column of the Person table.
Will each protection method meet the requirement? To answer, drag the appropriate responses to the correct protection methods. Each response 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.

Answer:

Explanation:

NEW QUESTION 17
You need to implement the purchase requirement. What should you do?

• A. Use the Bot FrameworkREST API attachment operations to send the user's voice and the Speech Service API to recognize intents.
• B. Use the Direct line REST API to send the user's voice and the Speech Service API to recognize intents.
• C. Use the Speech Service API to send the user's voice and the Bot Framework REST API conversation operations to recognize intents.
• D. Use the Bot Framework REST API conversation operations to send the user's voice and the Speech Service API to recognize intents.

Answer: D

Explanation: Scenario: Enable users to place an order for delivery or pickup by using their voice.
You must develop a chatbot by using the Bot Builder SDK and Language Understanding Intelligence Service (LUIS). The chatbot must allow users to order food for pickup or delivery.
The Bot Framework REST APIs enable you to build bots that exchange messages with channels configured in the Bot Framework Portal, store and retrieve state data, and connect your own client applications to your bots. All Bot Framework services use industry-standard REST and JSON over HTTPS.
The Speech Service API is used to recognize intents. References:
https://docs.microsoft.com/en-us/azure/bot-service/rest-api/bot-framework-rest-connector-concepts?view=azure- https://docs.microsoft.com/en-us/azure/cognitive-services/speech-service/how-to-recognize-intents-from-speech

NEW QUESTION 18
You develop an IoT solution by using Node.js. The solution is ready to deploy to the production environment.
You must implement the device twin capabilities of Azure IoT Hub. You must register a sensor named Sensor00. The IoT Hub name is Hub01.
You need to register the endpoint with ContosoHub01 so that you can configure them from your solution. Which four commands should you use to develop the solution? To answer, move the appropriate commands from the list of commands to the answer area and arrange them in the correct order.

Answer:

Explanation: Step 1: az extension add --name azure-cli-iot-ext
Run the following command in the command-line environment where you are using the Azure CLI to install the IoT extension:
az extension add --name azure-cli-iot-ext Step 2: az iot hub device-identity create
--hub-name {Hub01}
--device-id Sensor00
Create a new device identity called myDeviceId and retrieve the device connection string with these commands:
az iot hub device-identity create --device-id myDeviceId --hub-name {Your IoT Hub name}
az iot hub device-identity show-connection-string --device-id myDeviceId --hub-name {Your IoT Hub name}
-o table
Step 3: az iot hub device-identity show-connection-string
--hub-name {Hub01}
--device-id Sensor00
--output table Step 4:
Create the service app
In this section, you create a Node.js console app that adds location metadata to the device twin. npm install azure-iothub --save
References:
https://docs.microsoft.com/en-us/azure/iot-hub/iot-hub-node-node-twin-getstarted

NEW QUESTION 19
You are developing an IoT solution. The solution requires bidirectional communication between a .NET application and Azure IoT Hub.
You need to obtain connection information for a single test device.
Which three commands should you use to develop the solution? To answer, move the appropriate commands from the list of commands to the answer area and arrange them in the correct order.
NOTE: Each correct selection is worth one point.

Answer:

Explanation: Run the following command in the command-line environment where you are using the Azure CLI to install the IoT extension:
Step 1: az extension add
--name <iot-extension-name>
Run the following command in the command-line environment where you are using the Azure CLI to install the IoT extension:
az extension add --name azure-cli-iot-ext Step 2: az iot hub device-identity create
--hub-name <iot-hub-name>
--device-id <device-id>
Create a new device in the IoT Hub “DemoHub”
Command: az iot hub device-identity create --hub-name DemoHub --device-id testDevice Step 3: az iot hub device-identity show-connection-string
--hub-name { iot-hub-name }
--device-id <device-id> References:
https://github.com/MicrosoftDocs/azure-docs/blob/master/includes/iot-hub-get-started-create-device-identity.md

NEW QUESTION 20
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 meet the vendor notification requirement.
Solution: Create and apply a custom outbound Azure API Management policy. Does the solution meet the goal?

• A. Yes
• B. No

Answer: A

Explanation: Scenario:
If a vendor is nearing the number of calls or bandwidth limit, the API must trigger email notifications to the vendor.
(API usage must not exceed 5,000 calls and 50,000 kilobytes of bandwidth per hour per vendor.)
In Azure API Management (APIM), policies are a powerful capability of the system that allow the publisher to change the behavior of the API through configuration. Policies are a collection of Statements that are executed sequentially on the request or response of an API. Popular Statements include format conversion from XML to JSON and call rate limiting to restrict the amount of incoming calls from a developer. Many more policies are available out of the box.
References:
https://docs.microsoft.com/en-us/azure/api-management/api-management-howto-policies