Free Microsoft 70-487 Exam Dumps Questions & Answers

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

Correct Answer:

Explanation

You need to choose the appropriate data access technology for the children's book area of the web application.
Which data access technology should you choose?

• A.  LINQ to SQL
• B.  ADO.NET Entity Framework
• C.  WCF Data Services
• D.  Web Service

You are developing a web application by using Microsoft ASP.NET MVC.
The web application will show a list of cars and their associated prices. The list can be filtered by car model by
using a drop-down list. Access to the web application will be anonymous.
The car model list is stored as an .xml file on the application server. The car prices list is stored on a SQL
Server server.
You need to recommend a caching strategy for each scenario:
* If a user selects a car model from the drop-down list, and then closes the browser, the same model must
be selected automatically when the user reopens the web application from the same browser.
* If the car model list is updated, the drop-down list must be refreshed upon the next page reload.
* If the car prices list is updated, the prices list must be refreshed upon the next page reload.
What should you recommend? To answer, drag the appropriate caching strategies to the correct scenarios.
Each caching strategy 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

Box 1: outputCache
outputCache declaratively controls the output caching policies of an ASP.NET page or a user control
contained in a page.
Box 2: CacheDependency
CacheDependency establishes a dependency relationship between an item stored in an ASP.NET application's
Cache object and a file, cache key, an array of either, or another CacheDependency object. The
CacheDependency class monitors the dependency relationships so that when any of them changes, the cached
item will be automatically removed.
Box 3: SqlCacheDependency
SQL cache dependency enables you to cache pages that are dependent on data from SQL Server tables. You
can configure SQL Server and ASP.NET tocache page requests, reducing server workload, until the data on
which the page depends has been updated in SQL Server. SQL cache dependency is useful for data such as
product catalogs or customer registration information that remains comparatively static.
outputCache CacheDependency
References:
https://msdn.microsoft.com/en-us/library/system.web.caching.cachedependency(v=vs.110).aspx

You deploy an ASP.NET Core web application to Azure App Services. You are using Azure Event Hubs to
collect the telemetry data for the application.
You need to configure Event Hubs to automatically deliver the telemetry data stream to a persistent data store.
Solution: Configure Event Hubs Capture to deliver data to Azure Data Lake Store.
Does the solution meet the goal?

• A.  Yes
• B.  No

You need to return the list of the top 100 books for the GetTopBooks() method.
Which type should you use to retrieve the data?

• A.  Data View
• B.  SqlDataReader
• C.  DataSet
• D.  DataTable