Q1. - (Topic 1) 

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 

View Answer

Q2. - (Topic 4) 

You are planning to migrate websites from IIS 6 to IIS 7.5. You do not have access to SSH or a VPN. 

You need to select a deployment tool to securely migrate the websites. 

Which tool should you use? 

A. RoboCopy 

B. Web Deploy 

C. Microsoft command-line FTP 

D. xCopy 

View Answer

Q3. - (Topic 3) 

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? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

View Answer

Q4. - (Topic 4) 

You are developing an ASP.NET MVC application. 

Deployment administrators do not have access to Visual Studio 2102, but will have the 

elevated permissions required to deploy the application to the servers. You need to select a deployment tool for use by the deployment administrators. Which tool should you use? 

A. Publish Web Site Tool 

B. Web Deployment Package 

C. One-Click Publish 

D. Deployment Package Editor 

View Answer

Q5. - (Topic 4) 

You are designing an ASP.NET Web API application. 

You need to select an HTTP verb to allow blog administrators to moderate a comment. 

Which HTTP verb should you use? 

A. GET 

B. POST 

C. DELETE 

D. PUT 

View Answer

Q6. DRAG DROP - (Topic 4) 

You are developing a WCF service. 

You need to configure the web.config file to ensure that metadata is exposed only via the 

MEX protocol. 

You have the following markup: 

Which XML elements should you include in Target 1, Target 2, Target 3 and Target 4 to complete the markup? (To answer, drag the appropriate XML elements to the correct targets in the answer area. Each XML element 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.) 

View Answer

Q7. - (Topic 3) 

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

B. DataSet 

C. DataTable 

D. Data View 

View Answer

Q8. - (Topic 4) 

You are developing an ASP.NET MVC application that displays a report. The report includes large images that are stored in a database. Members of the EntityClient namespace are used to access the database through the ADO.NET Entity Framework data model. 

You need to prevent memory exceptions while generating a report using the EntityDataRcader type. 

Which CommandBehavior type should you use? 

A. FastForwardReadOnly 

B. SequentialAccess 

C. SingleResult 

D. SingleRow 

View Answer

Q9. - (Topic 1) 

You are adding a new REST service endpoint to the FlightDataController controller. It 

returns flights from the consolidated data sources only for flights that are late. 

You need to write a LINQ to Entities query to extract the required data. 

Which code segment should you use? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

View Answer

Q10. DRAG DROP - (Topic 4) 

You are developing a WCF Data Services service in Visual Studio 2012 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.) 

View Answer