Q1. - (Topic 4) 

You are developing a library management application that uses the ADO.NET Entity Framework against a SQL Server database. The application has a method that returns check outs filtered by date. 

The Book class is shown below. 

You must filter the data on the SQL server before it is returned to the application server. 

You need to return books checked out more recently than the entered date. 

Which code segment should you use? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

View Answer

Q2. DRAG DROP - (Topic 1) 

Flight information data provided by Margie's Travel is updated both locally and remotely. When the data is synced, all changes need to be merged together without causing any data loss or corruption. 

You need to implement the Sync() method in the MargiesTravelSync.es file. 

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

View Answer

Q3. - (Topic 1) 

Transformed historical flight information provided by the RemoteDataStream() method must be written to the response stream as a series of XML elements named Flight within a root element named Flights. Each Flight element has a child element named FlightName that contains the flight name that starts with the two-letter airline prefix. 

You need to implement the StreamHistoricalFlights() method so that it minimizes the amount of memory allocated. 

Which code segment should you use as the body of the StreamHistoricalFlights() method in the HistoricalDataLoader.es file? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

View Answer

Q4. HOTSPOT - (Topic 4) 

You are developing an ASP.NET MVC application. It is ready for deployment to the production web server. 

A local SQL Express .MDF file was used by the application during development 

The deployment has the following requirements: 

. The deployment must merge the assemblies on the local machine with those on the host. . The deployment must publish the local database to the remote Microsoft SQL server. 

You need to configure the web package settings for deployment. 

Which settings should you use? (To answer, select the appropriate setting or settings in the answer area.) 

View Answer

Q5. - (Topic 3) 

You need to update the ImportBooks() method to use database transactions. 

Which code segment should you use? 

A. SqlConnection.BeginTransaction(IsolationLevel.RepeatableRead); 

B. SqlConnection.BeginTransaction(IsolationLeve.ReadUnconvnited); 

C. SqlConneetion.BeginTransaction(IsolationLevel.Serializable); 

D. SqlConnection.BeginTransaction(IsolationLevel.Snapshot); 

View Answer

Q6. - (Topic 4) 

You are developing an ASP.NET MVC application. The application is a loan 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 loans along with rate information. Lazy loading has been disabled. 

The Loan class is shown below. 

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

A. Option A 

B. Option B 

C. Option C 

D. Option D 

View Answer

Q7. - (Topic 1) 

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 A 

B. Option B 

C. Option C 

D. Option D 

View Answer

Q8. - (Topic 4) 

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? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

View Answer

Q9. DRAG DROP - (Topic 4) 

You are developing a .NET application that uses the HttpClient type to access an ASP.NET Web API application. 

You need to add a header to specify that data is returned as JSON. You have the following code: 

Which code segments should you include in Target 1 and Target 2 to complete the code? (To answer, drag the appropriate code segments to the correct targets 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) 

View Answer

Q10. - (Topic 1) 

Errors occasionally occur when saving data using the FlightInfoContext ADO.NET Entity Framework context. Updates to the data are being lost when an error occurs. 

You need to ensure that data is still saved when an error occurs by retrying the operation. No more than five retries should be performed. 

Which code segment should you use as the body of the SaveChanges() method in the FlightInfoContext.es file? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

View Answer