Online Access Free 070-487 Practice Test

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

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 an ASP.NET MVC application. The application is an order processing system that uses
the ADO.NET Entity Framework against a SQL Server database. It has a controller that loads a page that
displays all orders along with customer information. Lazy loading has been disabled.
The Order class is shown below.

You need to return the orders and customer information in a single round trip to the database.
Which code segment should you use?

• A.Option B
• B.Option A
• C.Option C
• D.Option D

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 have developed a .NET Standard Library.
You need to produce a NuGet package.
Solution: Run the msbuild command with the publish target specified.
Does the solution meet the goal?

• A.No
• B.Yes

You deploy a RESTful ASP.NET Web API to manage order processing.
You are developing an Azure App Services Web App to consume the API and allow customers to order
products. You use the HttpClient object to process order entries. The API throws SocketException errors when
the Web App experiences a high volume of concurrent users.
You need to resolve the errors.
What should you do?

• A.Create a new HttpClient instance for each API request and use asynchronous method calls.
• B.Implement a Using statement block when declaring the HttpClient object.
• C.Increase the value of the Timeout property when declaring the HttpClient object.
• D.Use the static modifier to declare the HttpClient object.

You are adding a new REST service endpoint to the FlightDataController controller that returns the total
number of seats for each airline.
You need to write a LINQ to Entities query to extract the required data.
Which code segment should you use?

• A.Option B
• B.Option A
• C.Option C
• D.Option D