Microsoft Azure Developer Certification Transition AZ-202 Practice

- (Exam Topic 3)
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 connect selection is worth one point.

- (Exam Topic 3)
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.

- (Exam Topic 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 need to meet the vendor notification requirement.
Solution: Configure notifications in the Azure API Management instance. Does the solution meet the goal?

- (Exam Topic 3)
You are developing an Azure loT Hub Device Provisioning Service as a helper service. You configure zero
-touch device provisioning to an lot Hub. All devices are exactly. You need to configure auto-provisioning for millions of devices in a secure and scalable manner with group enrollment and roles. What should you use? To
answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Solution:


Does this meet the goal?

- (Exam Topic 3)
You host an on-premises ASP.NET Web API at the company headquarters. The Web API is consumed by applications running at the company's branch offices using the Azure Relay service. All the users of the applications are on the same Azure Active Directory (Azure AD).
You need to ensure that the applications can consume the Web API. What should you do?

- (Exam Topic 3)
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 group:

Developers must connect to Dev$erver onry through DevWorkstatioan. To maintain security, DevServer must not accept connections from the internet.
You need to create a private connection between the DevWortcstation and DevServer. Solution: Configure an IP address on each subnet within the same address space. Does the solution meet the goal?

- (Exam Topic 1)
You need to ensure that the upload format issue is resolved. What code should you add at line RU14?
To answer, drag the appropriate code fragments to the correct locations. Each code fragment 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.

Solution:
Box 1: HttpStatusCode.InternalServerError
HttpStatusCode.InternalServerError is equivalent to HTTP status 500. InternalServerError indicates that a generic error has occurred on the server.
Box 2: CannotDeleteFileOrDirectory
HttpResponseMessage.ReasonPhrase Property gets or sets the reason phrase which typically is sent by servers together with the status code.
Scenario: Upload format issue
Employees occasionally report an issue with uploading a receipt using the web application. They report that when they upload a receipt using the Azure File Share, the receipt does not appear in their profile. When this occurs, they delete the file in the file share and use the web application, which returns a 500 Internal Server error page.
References:
https://docs.microsoft.com/en-us/dotnet/api/system.net.httpstatuscode?redirectedfrom=MSDN&view=netframew

Does this meet the goal?

- (Exam Topic 3)
You are creating a bot for a company by using QnA Maker.
You need to ensure that the company can update the bot without third party assistance. What should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Solution:


Does this meet the goal?

- (Exam Topic 3)
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 connect to Azure by using a workstation that has a slow internet connection. You have two Azure file shares. You plan to transfer a series of large files from one container to another container. The workstation does not have sufficient disk space to store the files.
You define the following variables in Azure PowerShell.

You need to simultaneously transfer the large files as efficiently as possible.
Solution: Write a C# application that uses the Azure .NET API method CloudFile.StartCopyAsync to transfer files to the destination container.
Does the solution meet the goal?

- (Exam Topic 3)
A company sells products worldwide and provides customer service in many languages. The company has a customer service email address for customer requests. The language the email is written in needs to be recognized and routed to the appropriate local language department. You need to use the appropriate cognitive service to detect the language of the email. How should you initiate language detection?

- (Exam Topic 3)
You are developing a .NET Core MVC application for customers to research hotels. The application will use Azure Search. The application will search the index using various criteria to local domains to hotels. The index will include search fields for rate, a list of amenities, and distance to the nearest airport.
The application must support the following scenarios for specifying search criteria and organizing results:
• Search the index by using regular expressions.
• Organize results by counts for name-value pairs.
• List hotels within a specified distance to an airport and that fall within a specific price range. You need to configure the Search Para meters class.
Which properties should you configure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Solution:


Does this meet the goal?

- (Exam Topic 3)
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.

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

Does this meet the goal?

- (Exam Topic 3)
You are developing an ASP.NET Core Web API web service. The web service uses Azure Application
Insights for all telemetry and dependency tracking. The web service reads and writes data to a database other than Microsoft SQL Server.
You need to ensure that dependency tracking works for calls to the third-party database.
Which two Dependency Telemetry properties should you store in the database? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

- (Exam Topic 3)
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result these questions
will not appear in the review screen.
You use ASP.NET Core MVC with ADO.NET to develop an application. You implement database sharding for the application by using Azure SQL Database. You establish communication links between the shard databases.
You need to implement a strategy that allows a group of operations that are performed on multiple Azure databases to be rolled back on all databases if any of the operations fail.
Solution:
• Deploy a SQL database instance in an Azure Virtual Machine (VM).
• Establish linked servers to each Azure SQL Database instance from the SQL Server instance in the VM.
• Create a stored procedure in the VM that performs the update operations using a distributed transaction and commits them if successful.
• Run the SQL stored procedure on the SQL Server instance in the VM. Does the solution meet the goal?

- (Exam Topic 5)
You need to troubleshoot the order workflow.
What should you do? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

- (Exam Topic 3)
You are developing an application that consists of an ASP.NET Core Web API website and a WebJob that starts automatically and runs continuously. You are building the deployment process for the application.
You need to ensure that both the website and the WebJob are deployed.
How should you structure the deployment folders? To answer, drag the appropriate path segments to the correct locations. Each path 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.

Solution:


Does this meet the goal?

- (Exam Topic 3)
You develop a gateway solution for a public facing news API. The news API back end is implemented as a RESTfuI service and uses an OpenAPI specification. You need to ensure that you can access the news API by using an Azure API Management service instance.
Which Azure PowerShell command should you run?
A)

B)

C)

D)

- (Exam Topic 3)
A company is developing a gaming platform. Users can join teams to play online and see leaderboards that include player statistics. The solution includes an entity named Team.
You plan to implement an Azure Redis Cache instance to improve the efficiency of data operations for entities that rarely change.
You need to invalidate the cache when team data is changed.
How should you complete the code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Solution:


Does this meet the goal?

- (Exam Topic 1)
You need to resolve the log capacity issue. What should you do?

- (Exam Topic 1)
You need to ensure disaster recovery requirements are met. What code should you add at line PC16?
To answer, drag the appropriate code fragments to the correct locations. Each code fragment 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.

Solution:


Does this meet the goal?

- (Exam Topic 3)
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.

Solution:


Does this meet the goal?

- (Exam Topic 3)
You plan to create a Docker image that runs an ASP.NET Core application named ContosoApp. You have a setup script named setupScript.psl and a series of application files including ConlosoApp.dll.
You need to create a Dockertile document that meets the following requirements:
• Call setupScript.psl when the container is built.
• Run ContosoApp.dll when the container starts.
The Dockerfile document must be created in the same folder where ContosoApp.dll and setupScript.psl are stored.
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.

Solution:


Does this meet the goal?

- (Exam Topic 3)
You have a web app named MainApp. You are developing a triggered App Service background task by using the WebJobs SDK. This task automatically invokes a function in the code whenever any new data is received in a queue.
You need to configure the services.
Which service should you use for each scenario? To answer, drag the appropriate services to the correct scenarios. Each service 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.

Solution:


Does this meet the goal?