PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

Which code segments should you include in Target 1 and Target 2 to complete the code?

DRAG DROP
You are developing an ASP.NET Web API for a home inventory management system.
You need to limit access to users with IP addresses based only in the United States.
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.)

Which code segment should you use?

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?

Which code segments should you include in Target 1, Target 2, Target 3…?

DRAG DROP
You are developing a self-hosted WCF service to display data about books. The solution contains a
service named BookService that implements the IBookService interface.
You need to expose the metadata in the service host programmatically.
You have the following code:

Which code segments should you include in Target 1, Target 2, Target 3, Target 4 and Target 5 to build
the service host? (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.)

Which code segment should you use?

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?

Which collection type should you use?

You are developing an application that includes a class named Order. The application will store a
collection of Order objects.
The collection must meet the following requirements:
Use strongly typed members.
Process Order objects in first-in-first-out order.
Store values for each Order object.
Use zero-based indices.
You need to use a collection type that meets the requirements.
Which collection type should you use?

Which code segment should you use?

You are developing an application. The application calls a method that returns an array of integers
named employeeIds. You define an integer variable named employeeIdToRemove and assign a value
to it. You declare an array named filteredEmployeeIds.
You have the following requirements:
Remove duplicate integers from the employeeIds array.
Sort the array in order from the highest value to the lowest value.
Remove the integer value stored in the employeeIdToRemove variable from the employeeIds array.
You need to create a LINQ query to meet the requirements.
Which code segment should you use?

Which two actions should you perform?

You are developing an application that includes the following code segment. (Line numbers are
included for reference only.)

The GetAnimals() method must meet the following requirements:
Connect to a Microsoft SQL Server database.
Create Animal objects and populate them with data from the database.
Return a sequence of populated Animal objects.
You need to meet the requirements.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose
two.)

Which code segment should you insert at line 08?

You are developing an application that uses the Microsoft ADO.NET Entity Framework to retrieve
order information from a Microsoft SQL Server database. The application includes the following
code. (Line numbers are included for reference only.)

The application must meet the following requirements:
Return only orders that have an OrderDate value other than null.
Return only orders that were placed in the year specified in the OrderDate property or in a later
year.
You need to ensure that the application meets the requirements.
Which code segment should you insert at line 08?

How should you complete the relevant code?

DRAG DROP
You are developing a custom collection named LoanCollection for a class named Loan class.
You need to ensure that you can process each Loan object in the LoanCollection collection by using a
foreach loop.
How should you complete the relevant code? (To answer, drag the appropriate code segments to
the correct locations in the answer are
a 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.)