Hi,

The exam is tough but the guide from www.exams.ws was really helpful to get through the exam. Thanks to the dumpers too for contributing the braindumps.

1.         You are developing an application that queries a table named Products in a Microsoft SQL Server database. The query will be stored in a string variable named FTQuery. The query includes the following SQL code.

SELECT * FROM Products For XML AUTO

You must iterate the query results and populate an HTML table with product information. You must ensure that your application processes the results as quickly as possible. What should you do?

A.   Use a SqlDataAdapter object and set its SelectCommand property to FTQuery. Use the Fill method of the SqlDataAdapter object to read the data into a DataSet object. Loop through the associated rows to read the data.

B.    Use a SqlDataAdapter object and set its SelectCommand property to FTQuery. Use the Fill method of the SqlDataAdapter object to read the data into a DataSet object. Use the ReadXml method of the DataSet object to read the data.

C.    Set the SqlCommand object’s Command Text to FTQuery. Use the ExecuteReader method of the SqlCommand object to create a SqlDataReader object. Use the Read method of the SqlDataReader object to read the data.

D.   Set the SqlCommand object’s Command Text to FTQuery. Use the ExecuteXmlReader method of the SqlCommand object to create a XmlReader object. Use the XmlReader object to read the data.

Answer: D

2.         You are creating an XML Web service that tracks employee information. The service contains a Web method named RetrieveFolksTecEmployees. The service also contains a base class named Employee and two classes named Manager and Engineer, which are derived from Employee. RetrieveFolksTecEmployees takes a roleID as input that specifies the type of employee to retrieve, either Manager or Engineer. RetrieveFolksTecEmployees returns an array type Employee that contains all employees that are in the specified role. You want to ensure that Manager and Engineer object types can be returned from RetrieveFolksTecEmployees. What should you do?

A.   Set the TypeName property of the XmlType attribute to Employee for both Manager and Engineer.

B.    Apply two XmlInclude attributes to RetrieveFolksTecEmployees, one of type Manager and one of type Engineer.

C.    Apply an XmlRoot attribute to the Employee class
Apply an XmlAttribute attribute to the Manager and Engineer classes.

D.   Apply an XmlRoot attribute to the Employee class
Apply an XmlElement attribute to the Manager and Engineer classes.

Answer: B

3.         You are creating an XML Web service named ListBoxService. This service provides content, such as states, countries, and geographical regions, for use in drop-down list boxes. ListBoxService contains a Web method named RetrieveRegionsListBox. This method runs a DataSet object that contains every geographical region in the world. RetrieveRegionsListBox calls a Microsoft SQL Server database to load the DataSet object with region data. You want to minimize the amount of time the method takes to return to the caller. What should you do?

A.   Use a stored procedure to return the data.

B.    Store each DataSet object by using the Session object.

C.    Set the BufferResponse property of the WebMethod attribute to false.

D.   Set the CacheDuration property of the WebMethod attribute to an interval greater than zero.

Answer: D

4.         You have a .NET Remoting object named FolksTecOrder. The FolksTecOrder class allows remote client applications to submit orders in batches. Each FolksTecOrder object holds state information that is specific to each remote client application. The FolksTecOrder class has overloaded constructors for initializing an object. You want to develop a server application to host FolksTecOrder objects. What should you do?

A.   Create a Windows service, and register FolksTecOrder as a client-activated object.

B.    Create a Windows service, and register FolksTecOrder as a server-activated Singleton object.

C.    Host FolksTecOrder in Internet Information Services (IIS) and create a Web.config file to register FolksTecOrder as a server-activated SingleCall object.

D.   Host FolksTecOrder in Internet Information Services (IIS) and create a Web.config file to register FolksTecOrder as a server-activated object with an infinite lease.

Answer: A

5.         You Microsoft SQL Server database named FolksTecBackOrders that contains a table that consists of more than 1 million rows. You need to develop an application that reads each row in the table and writes the data to a flat file. The application will run only once each day. You want the application to process the data as quickly as possible. Which class should you use to retrieve the data?

A. DataSet

B. DataTable

C. DataReader

D. DataAdapter

Answer: C