Microsoft 70-487 Exam Practice Test Instant Access

Question 1

You need to implement the Get() method in the bookstore Web API application to be able to find books by using an ad hoc query.

Which method should you use?

AOption A

BOption B

COption C

DOption D

Answer : D

Question 2

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

Which code segment should you use?

ASqlConnection.BeginTransaction(IsolationLevel.RepeatableRead);

BSqlConnection.BeginTransaction(IsolationLeve.ReadUnconvnited);

CSqlConneetion.BeginTransaction(IsolationLevel.Serializable);

DSqlConnection.BeginTransaction(IsolationLevel.Snapshot);

Answer : B

* scenario: The ImportBooks() method must keep a copy of the data that can be accessed while new books are being imported without blocking reads.

* ReadUncommitted

A dirty read is possible, meaning that no shared locks are issued and no exclusive locks are honored.

Question 3

You need to create an OData filter expression that returns books that match the following characteristics:

Published after 1/1/2000

Have "Science" as the first word

Which filter statement should you use?

AOption A

BOption B

COption C

DOption D

Answer : D

* gt

Greater than

Example:

filter= Entry_No gt 610

Query on GLEntry service. Returns entry numbers 611 and higher.

* startswith

filter=startswith(Name, 'S')

Query on Customer service. Returns all customers names beginning with ''S''.

Question 4

The PurchaseOrders.xml file contains all of the purchase orders for the day.

You need to query the XML file for all of the billing addresses.

Which code segment should you use?

AOption A

BOption B

COption C

DOption D

Answer : D

Question 5

You are preparing to write the data access code for the children's book area of the web site.

You need to review the requirements and identify the appropriate data access technology.

What should you do?

AUse ADO.NET Entity Framework.

BUse a Web Service.

CUse the WCF Data Services.

DUse LINQ to SQL.

Answer : A

Question 6

You need to configure the server to self-host the bookstore's Web API application.

Which code segment should you use?

AOption A

BOption B

COption C

DOption D

Answer : C

MapHttpRoute Method

Maps the specified route template.

Use the option with 'api/...

Question 7

You need to choose the appropriate data access strategy for the college textbook area of the web application.

Which data access technology should you implement?

AADO.NET

BEntity Data Model (EDM)

CWCF Data Services

DLINQ to SQL

Answer : A

* Scenario: The college textbook area of the web application must get data from a daily updated CSV file.

* ADO.NET reads the CSV file in a very similar way as table in database.

Microsoft 70-487 Developing Microsoft Azure and Web Services Exam Practice Test