Microsoft 70-487 Dumps | Updated Microsoft 70-487 Dumps PDF for IT Candidates

Question No 1 

You need to recommend a data access technology to the contractor to retrieve data from the new data source. Which data access technology should you recommend?

A. LINQ to XML
B. ADO.NET Entity Framework
C. ADO.NET DataSets
D. WCF Data Services

Answer: D 


Question No 2 

Data provided by Consolidated Messenger is cached in the HttpContext.Cache object. You need to ensure that the cache is correctly updated when new data arrives. What should you do?

A. Ensure that the EffectivePrivateBytesLimit value is greater than the size of the database file.
B. Change the sliding expiration of the cache item to 12 hours.
C. Use the SqlCacheDependency type configured with a connection string to the database file.
D. Use the CacheDependency type configured to monitor the SFTP target folder.

Answer: D 


Question No 3 

You need to load flight information provided by Consolidated Messenger. Which should you use?

A. SQL Server Data Transformation Services (DTS)
B. EntityTransaction and EntityCommand
C. Office Open XML
D. OleDbConnection and OleDbDataReader

Answer: D 


Question No 4 

You need to load flight information provided by Consolidated Messenger. What should you use?

A. Office Open XML
B. COM interop
C. OleDbConnection and OleDbDataReader
D. EntityConnection and EntityDataReader

Answer: C 


Question No 5 

Historical flight information data will be stored in Windows Azure Table Storage using the FlightInfo class as the table entity. There are millions of entries in the table. Queries for historical flight information specify a set of airlines to search and whether the query should return only late flights. Results should be ordered by flight name. You need to specify which properties of the FlightInfo class should be used at the partition and row keys to ensure that query results are returned as quickly as possible. What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

A. Use the WasLate property as the row key.
B. Use the Airline property as the row key.
C. Use the WasLate property as the partition key
D. Use the Arrival property as the row key.
E. Use the Airline property as the partition key.
F. Use the Flight property as the row key.

Answer: BF