Here you have the best Microsoft 70-487 practice exam questions
You are developing a library to support multiple ASP.NET MVC web applications on a shared server. The library provides implementations of security algorithms.
If a problem with any of the security algorithms is discovered, a new version of the library must be created and deployed. Application downtime during the update must be minimized.
You need to ensure that the new version of the library will be used by all applications as soon as possible.
What should you do?
To ensure that the new version of the library will be used by all applications as soon as possible and to minimize application downtime, the best approach is to install the security assembly in the Global Assembly Cache (GAC). The GAC allows for the centralized management of assemblies, enabling multiple applications to share the same library. When an update is needed, updating the assembly in the GAC ensures that all applications using this common library will immediately benefit from the update without requiring individual application deployments, thereby minimizing downtime.
You are developing an application in Visual Studio 2012 to display student information. The application contains the following Entity Framework model.
The application contains a WCF data service named DirectoryService.svc.
You need to create a query expression to display all of the grades for students whose first name is "John"
How should you build the expression?
To build the query expression to display all of the grades for students whose first name is 'John', you should use the '$filter' query option to filter the students by their first name and '$expand' to include their grades in the response. Therefore, 'http://localhost:54946/DirectoryService.svc/Students?$filter=FirstName eq 'John' &$expand=Grades' is the correct format. This ensures that the query fetches all students named 'John' and includes their associated grades.
DRAG DROP -
You are developing a WCF Data Services service in Visual Studio to display movie information from a SQL Server database that changes every 24 hours. The service is defined in the following class.
The application contains the following Entity Framework model.
The service must only return data for movies that are currently in theaters.
You need to add a method to the MovieService class to filter the data.
How should you build the method? (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.)
Select and Place:
Query interceptor methods, which are called when processing an HTTP GET request, must return a lambda expression that determines whether an instance of the interceptor's entity set should be returned by the query results. This expression is used by the data service to further refine the requested operation. The following is an example definition of a query interceptor.
// Define a query interceptor for the Orders entity set.
[QueryInterceptor("Orders")]
public Expression
References:
https://docs.microsoft.com/en-us/dotnet/framework/data/wcf/interceptors-wcf-data-services
You are developing an ASP.NET MVC application that reads and writes data from a SQL Server database.
You need to prevent the application from reading data that is locked by other transactions. You also need to prevent exclusive range locks.
Which isolation level should you use?
To prevent the application from reading data that is locked by other transactions and to avoid exclusive range locks, the appropriate isolation level is RepeatableRead. It ensures that any data read during a transaction will not be changed by other transactions until the transaction is complete, thus preventing nonrepeatable reads. Unlike Serializable, RepeatableRead does not place range locks, satisfying both requirements of the question.
DRAG DROP -
You are developing a Windows Azure based web application that provides users the ability to rent training videos. The application is deployed to hosted services in Asia and Europe.
The web application must meet the following requirements:
✑ Video files are large and must be able to be streamed.
✑ Streaming videos requires low latency network connections.
✑ Rental data contains structured information about the user and the video.
✑ Rental permissions are checked every five seconds during video playback.
You need to recommend a storage architecture for the application.
What should you do? (To answer, drag the appropriate technologies to the correct location or locations in the answer area. Each technology 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.)
Select and Place:
