Microsoft Azure Developer Advanced Solutions - AZ-201 Exam Practice Test
Member 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 place 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.
You need to develop an Azure Function that ingests data from the modified workbook and place 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.
Correct Answer: C,E
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
You develop software solutions for a web services company. You have the following code. (Line numbers are for reference only.)
You need to implement an immediate response customer support solution for the company's website.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
You need to implement an immediate response customer support solution for the company's website.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation
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.
Margie's Travel is an international travel and bookings management service. The company is expanding into restaurant bookings. You are tasked with implementing Azure Search for the restaurants listed in their solution.
You create the index in Azure Search.
You need to import the restaurant data into the Azure Search service by using the Azure Search .NET SDK.
Solution:
1. Create a SearchlndexClient object to connect to the search index.
2. Create a DataContainer that contains the documents which must be added.
3. Create a DataSource instance and set its Container property to the DataContainer.
4. Call the Documents.Suggest method of the SearchlndexClient and pass the DataSource.
Does the solution meet the goal?
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.
Margie's Travel is an international travel and bookings management service. The company is expanding into restaurant bookings. You are tasked with implementing Azure Search for the restaurants listed in their solution.
You create the index in Azure Search.
You need to import the restaurant data into the Azure Search service by using the Azure Search .NET SDK.
Solution:
1. Create a SearchlndexClient object to connect to the search index.
2. Create a DataContainer that contains the documents which must be added.
3. Create a DataSource instance and set its Container property to the DataContainer.
4. Call the Documents.Suggest method of the SearchlndexClient and pass the DataSource.
Does the solution meet the goal?
Correct Answer: B
Vote an answer
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?
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?
Correct Answer: D
Vote an answer
You need to secure the access to the Delivery API.
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.
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.
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 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?
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?
Correct Answer: A
Vote an answer
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.
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.
Correct 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