Microsoft Developing Microsoft Azure and Web Services - 070-487 Exam Practice Test
You are creating a streamed Windows Communication Foundation (WCF) service.
You implement the following service methods.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
You implement the following service methods.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Correct Answer:
Explanation
To enable streaming, define the OperationContract appropriately and enable streaming at the transport level.
To stream data, the OperationContract for the service must satisfy two requirements:
References: https://docs.microsoft.com/en-us/dotnet/framework/wcf/feature-details/how-to-enable-streaming
You add a .NET application to a Docker container and deploy the container to Azure Service Fabric. You use
a corporate base image that includes Microsoft SQL Server for storing data.
You deploy the application to development and staging environments. No issues are reported. You deploy the
application to your production environment. Data is not persisted in the production environment.
You need to resolve the issue.
What should you do?
a corporate base image that includes Microsoft SQL Server for storing data.
You deploy the application to development and staging environments. No issues are reported. You deploy the
application to your production environment. Data is not persisted in the production environment.
You need to resolve the issue.
What should you do?
Correct Answer: C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
The GetExternalOrder() method in the ExternalQueueService service is throwing a runtime error. The method
must query the database for a record that matches the orderNum parameter passed to the method.
You need to modify the queryString string to retrieve the record.
With which code segment should you replace line EQ64?
must query the database for a record that matches the orderNum parameter passed to the method.
You need to modify the queryString string to retrieve the record.
With which code segment should you replace line EQ64?
Correct Answer: D
Vote an answer
You need to parse flight information from Blue Yonder Airlines. The content of the XML file is shown below.
Some airlines do not specify the timezone of the arrival time. If the timezone is not specified, then it should be
interpreted per the business requirements.
You need to implement the LoadFlights() and Parse() methods of the BlueYonderLoader class.
What should you do? (To answer, drag the appropriate code segments to the correct location in the answer
area. Each 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.)
Some airlines do not specify the timezone of the arrival time. If the timezone is not specified, then it should be
interpreted per the business requirements.
You need to implement the LoadFlights() and Parse() methods of the BlueYonderLoader class.
What should you do? (To answer, drag the appropriate code segments to the correct location in the answer
area. Each 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.)
Correct Answer:
Explanation
Topic 3, Online Bookstore
Background
You are developing an online bookstore web application that will be used by your company's customers.
Technical Requirements
General requirements:
* The web store application must be an ASP.NET MVC application written in Visual Studio.
* The application must connect to a Microsoft SQL database.
* The GetTop100Books() method is mission critical and must return data as quickly as possible. It should
take advantage of fast, forward-only, read-only methods of reading data.
* The ImportBooks() method must keep a copy of the data that can be accessed while new books are
being imported without blocking reads.
* The Create MonthlyTotalsReport() method must lock the data and prevent others from updating or
inserting new rows until complete.
* The college textbook area of the web application must get data from a daily updated CSV file.
* The children's book area of the web application must get data directly from a local database. It must use
a connection string. It must also support access to the stored procedures on the database. Further, it is
required to have strongly typed objects. Finally, it will require access to databases from multiple vendors
and needs to support more than one-to-one mapping of database tables.
* The cookbook functionality is contained within a client-side application that must connect to the server
using HTTP and requires access to the data using JavaScript.
* The BookApiController class must have a method that is able to perform ad-hoc queries using OData.
The RESTful API of the bookstore must expose the following endpoints.
Application Structure
PurchaseOrders.xml
FeaturedBooks.xml
You are developing a WCF service.
You need to implement transport security by using NTLM authentication and NetTcpBindings.
Which configuration values should you use? (To answer, drag the appropriate configuration values to the
correct location or locations in the answer area. Each configuration value 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.)
You need to implement transport security by using NTLM authentication and NetTcpBindings.
Which configuration values should you use? (To answer, drag the appropriate configuration values to the
correct location or locations in the answer area. Each configuration value 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.)
Correct Answer:
Explanation
You develop a Universal Windows Platform (UWP) application for Windows 10 Internet of Things (IoT)
Core.
The application uses Entity Framework Core and a SQLite database to store data.
You use the SQLite EF Core database provider to migrate data from an on-premises database to SQLite. The
migration process throws an exception.
You need to resolve the exception.
What are two possible ways to achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
Core.
The application uses Entity Framework Core and a SQLite database to store data.
You use the SQLite EF Core database provider to migrate data from an on-premises database to SQLite. The
migration process throws an exception.
You need to resolve the exception.
What are two possible ways to achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
Correct Answer: B,C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
You plan to create several .NET applications that will read from Microsoft SQL Server 2014 databases by
using Microsoft ADO.NET.
The relevant requirements for the applications are described in the following table.
Typically, the applications will read thousands of rows of data at a time.
You need to identify which object to use to retrieve data for each application. The solution must minimize the
amount of memory used on the application server.
What should you identify? To answer, select the appropriate options in the answer area.
using Microsoft ADO.NET.
The relevant requirements for the applications are described in the following table.
Typically, the applications will read thousands of rows of data at a time.
You need to identify which object to use to retrieve data for each application. The solution must minimize the
amount of memory used on the application server.
What should you identify? To answer, select the appropriate options in the answer area.
Correct Answer:
Explanation
App1: DataReader
App2: DataReader
App3: DataAdapter
Need to use a DataAdapter since the data could be modified.
Note:
You can use the ADO.NET DataReader to retrieve a read-only, forward-only stream of data from a database.
Results are returned as the query executes, and are stored in the network buffer on the client until you request
them using the Read method of the DataReader. Using the DataReader can increase application performance
both by retrieving data as soon as it is available, and (by default) storing only one row at a time in memory,
reducing system overhead.
A DataAdapter is used to retrieve data from a data source and populate tables within a DataSet. The
DataAdapter also resolves changes made to the DataSet back to the data source. The DataAdapter uses the
Connection object of the .NET Framework data provider to connect to a data source, and it uses Command
objects to retrieve data from and resolve changes to the data source.
References: https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/dataadapters-and-datareaders
You develop a Windows Communication Foundation (WCF) Simple Object Access Protocol (SOAP) web
service to manage loans. The service is deployed and hosted on-premises. The service includes the following
code:
The service has the following requirements:
* Allow access by third-parties without requiring intrusive changes to the corporate network infrastructure.
* Include a local endpoint and an endpoint projected through Azure WCF Relay. Both endpoints must use the
same contract implementation and transport method.
* The relay endpoint address must resolve to: lm://loanmanager.servicebus.windows.net/loans
You begin to update the service code. You reference the Service Bus NuGet package from the service project
You need to configure the endpoints.
How should you complete the code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
service to manage loans. The service is deployed and hosted on-premises. The service includes the following
code:
The service has the following requirements:
* Allow access by third-parties without requiring intrusive changes to the corporate network infrastructure.
* Include a local endpoint and an endpoint projected through Azure WCF Relay. Both endpoints must use the
same contract implementation and transport method.
* The relay endpoint address must resolve to: lm://loanmanager.servicebus.windows.net/loans
You begin to update the service code. You reference the Service Bus NuGet package from the service project
You need to configure the endpoints.
How should you complete the code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
You are designing an ASP.NET Web API application.
You need to select an HTTP verb to allow blog administrators to remove a comment.
Which HTTP verb should you use?
You need to select an HTTP verb to allow blog administrators to remove a comment.
Which HTTP verb should you use?
Correct Answer: D
Vote an answer
You need to load flight information provided by Consolidated Messenger.
Which should you use?
Which should you use?
Correct Answer: A
Vote an answer
You are developing an order processing application that uses the ADO.NET Entity Framework against a SQL
Server database. Lazy loading has been disabled. The application displays orders and their associated order
details. Order details are filtered based on the category of the product in each order.
The Order class is shown below.
The OrderDetail class is shown below.
The Product class is shown below.
The Category class is shown below.
You need to return orders with their filtered list of order details included in a single round trip to the database.
Which code segment should you use?
Server database. Lazy loading has been disabled. The application displays orders and their associated order
details. Order details are filtered based on the category of the product in each order.
The Order class is shown below.
The OrderDetail class is shown below.
The Product class is shown below.
The Category class is shown below.
You need to return orders with their filtered list of order details included in a single round trip to the database.
Which code segment should you use?
Correct Answer: D
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
You need to configure the Windows Azure service definition to enable Consolidated Messenger to upload
files.
What should you do? (To answer, drag the appropriate configuration items to the correct location or locations.
Each configuration item 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.)
files.
What should you do? (To answer, drag the appropriate configuration items to the correct location or locations.
Each configuration item 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.)
Correct Answer:
Explanation
The GetExternalOrders() method must use members of the EntityClient namespace to query the database for
all records in the InboundQueue entity.
You need to modify the GetExternalOrders() method to return the correct data.
What should you do? (To answer, drag the appropriate code segments to the correct location or locations in the
answer area. 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.)
all records in the InboundQueue entity.
You need to modify the GetExternalOrders() method to return the correct data.
What should you do? (To answer, drag the appropriate code segments to the correct location or locations in the
answer area. 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.)
Correct Answer:
Explanation
You need to deploy the application to the Windows Azure production environment to meet the business
requirements.
What should you do? (To answer, select the appropriate button in the answer area.)
requirements.
What should you do? (To answer, select the appropriate button in the answer area.)
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.
You develop a REST API that uses Node.js. The API will store data in Azure Cosmos DB. You plan to deploy
the API to a new Azure App Services Web App. You create a new Web App by using the Azure portal.
The API must be deployed by using SFTP.
You need to provide the proper deployment credentials to deploy the API.
Solution: Use your Azure Cosmos DB master key and resource token.
Does the solution meet the goal?
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 develop a REST API that uses Node.js. The API will store data in Azure Cosmos DB. You plan to deploy
the API to a new Azure App Services Web App. You create a new Web App by using the Azure portal.
The API must be deployed by using SFTP.
You need to provide the proper deployment credentials to deploy the API.
Solution: Use your Azure Cosmos DB master key and resource token.
Does the solution meet the goal?
Correct Answer: A
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).