Introducing The New!
Surepassexam Collection
Get Unlimited Access to all
Surepassexam's PREMIUM files
Q1. DRAG DROP - (Topic 4)
You are developing a self-hosted WCF service that returns stock market information.
The service must be discoverable by any client application.
You need to build the service host.
How should you build the host? (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.)
Answer:
Q2. - (Topic 1)
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: B,F
Q3. - (Topic 4)
You are developing an ASP.NET MVC application that reads and writes data from a SQL Server database.
You need to maintain data integrity in all situations that use transactions.
A. ReadUncommitted
B. Repeatable
C. Serializable
D. ReadCommitted
Answer: C
Q4. - (Topic 1)
Transformed historical flight information provided by the RemoteDataStream() method must be written to the response stream as a series of XML elements named Flight within a root element named Flights. Each Flight element has a child element named FlightName that contains the flight name that starts with the two-letter airline prefix.
You need to implement the StreamHistoricalFlights() method so that it minimizes the amount of memory allocated.
Which code segment should you use as the body of the StreamHistoricalFlights() method in the HistoricalDataLoader.es file?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: D
Explanation: http://msdn.microsoft.com/en-us/library/system.xml.linq.xstreamingelement.aspx and http://msdn.microsoft.com/en-us/library/bb551307.aspx
Q5. - (Topic 1)
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
Q6. - (Topic 4)
You are developing a library management application that uses the ADO.NET Entity Framework against a SQL Server database. The application has a method that returns check outs filtered by date.
The Book class is shown below.
You must filter the data on the SQL server before it is returned to the application server.
You need to return books checked out more recently than the entered date.
Which code segment should you use?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: A
Explanation:
The difference is that IQueryable<T> is the interface that allows LINQ-to-SQL (LINQ.-to-anything really) to work. So if you further refine your query on an IQueryable<T>, that query will be executed in the database, if possible.
For the IEnumerable<T> case, it will be LINQ-to-object, meaning that all objects matching the original query will have to be loaded into memory from the database.
Q7. HOTSPOT - (Topic 4)
You are supporting an application that uses the ADO.NET Entity Framework to query and access data.
The latest version of Entity Framework contains bug fixes that will improve performance. You need to update Entity Framework.
Which Visual Studio 2012 menu item should you choose? (To answer, select the appropriate menu item in the answer area.)
Answer:
Q8. 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.)
Answer:
Q9. - (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
Answer: A
Q10. DRAG DROP - (Topic 2)
You need to modify the ExecuteCommandProcedure() method to meet the technical requirements.
Which code segment should you use?
Answer:
Q11. - (Topic 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
Q12. - (Topic 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?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: D
Explanation: * 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”.
Q13. - (Topic 3)
You need to choose the appropriate data access technology for the cookbook area of the web application.
Which data access technology should you choose?
A. WCF Data Services
B. LINQ to SQL
C. Entity Framework
D. ADO.NET
Answer: A
Explanation: * Scenario: The cookbook functionality is contained within a client-side application that must connect to the server using HTTP and requires access to the data using JavaScript.
* WCF Data Services (formerly known as "ADO.NET Data Services") is a component of the
.NET Framework that enables you to create services that use the Open Data Protocol (OData) to expose and consume data over the Web or intranet by using the semantics of representational state transfer (REST). OData exposes data as resources that are addressable by URIs. Data is accessed and changed by using standard HTTP verbs of GET, PUT, POST, and DELETE
* WCF Data Services uses the OData protocol for addressing and updating resources. In this way, you can access these services from any client that supports OData. OData enables you to request and write data to resources by using well-known transfer formats: Atom, a set of standards for exchanging and updating data as XML, and JavaScript Object Notation (JSON), a text-based data exchange format used extensively in AJAX application.
Q14. - (Topic 4)
You are developing a WCF service that compares several data sources. The service takes a long time to complete.
The service must meet the following requirements:
. The client must be able to continue processing while the service is running. . The service must initiate communication with the client application when processing is complete.
You need to choose a message pattern to meet the requirements.
Which message pattern should you choose?
A. One Way
B. Streaming
C. Duplex
D. Request/Reply
Answer: C
Q15. DRAG DROP - (Topic 4)
You are creating a WCF service.
The service endpoints must be exposed to the Windows Azure Service Bus. The service bus has a namespace named RestaurantSB. The key provider is "owner".
You need to modify the web.config file to expose the endpoints.
How should you modify the file? (To answer, drag the appropriate attributes to the correct location or locations in the answer area. Each attribute 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.)
Answer:
Q16. DRAG DROP - (Topic 4)
You are developing an ASP.NET Web API action method.
The action method must return the following JSON in the message body.
{"Name": "Fabrikam", "VendorId" :9823, Items": ["Dogs", "Cats") >
You need to return an anonymous object that is serialized to JSON.
What should you do? (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.)
Answer: