Question 1.
You use a function to maintain a table named Categories in a Microsoft SQL Server database. 

The function creates a DataTable object named Categories in a DataSet object named categoriesDataSet.

These two objects capture all insertions, updates and deletions to the Categories table.

The function instantiates a SqlDataAdapter object named ITDataAdapter. This object is configured to select, insert, update and delete rows in the Categories DataTable object.

You need to update the database to include the changes in the Categories DataTable object and capture all data errors in a batch after all rows have been processed.

Which code segment should you use?

A. 	Try
		ITDataAdapter.Update (CategoriesDataSet, “Categories”)
	Catch mySqlException as SqlException
		Dim myDataRow( ) As DataRow = _
			CategoriesDataSet.Tables (0).GetErrors ( )
	End Try
		‘ Code to process errors goes here.
B. 	ITDataAdapter.ContinueUpdateOnError = True
	Try
		ITDataAdapter.Update (CategoriesDataSet, “Categories”)
	Catch mySqlException as SqlException
		Dim myDataRow( ) As DataRow = _
			CategoriesDataSet.Tables (0) .GetErrors ( )
	End Try
‘ 		Code to process errors goes here.
C. 	ITDataAdapter.Update (CategoriesDataSet, “Categories”)
		If categoriesDataSet.Tables(0).HasErrors Then
			Dim myDataRow ( ) As DataRow = _
				CategoriesDataSet.Tables(0).GetErrors ( )
				   ‘ Code to process errors goes here.
	End If
D. 	ITDataAdapter.ContinueUpdateOnError = True
	ITDataAdapter.Update (CategoriesDataSet, “Categories”)
	If categoriesDataSet.Tables (0).HasErrors Then
			Dim myDataRow ( ) As DataRow = _
				CategoriesDataSet.Tables(0).GetErrors ( )
				‘ Code to process errors goes here.
	End If

Answer: D

Explanation:
Line 1: 
ITDataAdapter.ContinueUpdateOnError = True The DataAdapter.ContinueUpdateOnError property gets or sets a value that specifies whether to generate an exception, or the row in error when an error is encountered during a row update. The value true is used to continue the update without generating an exception.. The default is false. In this scenario the value of this property must be true. We don’t want exceptions.

Line 2: 
ITDataAdapter.Update (CategoriesDataSet, “Categories”) We update the database. All updated rows in the Dataset are updated in the database as well.

Line 3:
If categoriesDataSet.Tables (0).HasErrors Then We check if there exist any errors in the dataset with the HasErrors method.

Line 4, 5, 6: 
We collect the rows with errors with the GetErrors method.

Option A, B:
We don’t want the errors that occur while processing rows to not generate exceptions. Instead we want to collect the rows where errors occurred. The Try….Catch construct is useless here.

Option C:
By default an error to update, insert or delete a row causes an exception. We must set the DataAdapter property ContinueUpdateOnError to True.

Reference: 
.NET Framework Class Library, DataAdapter.ContinueUpdateOnError Property [Visual Basic]

Question 2.
Your company frequently receives product information from external vendors in the form of XML data.

You receive XML document files, an .xdr schema file, and an .xsd schema file.

You need to write code that will create a typed DataSet object on the basis of product information. Your code will be used in several Visual studio .NET applications to speed up data processing.
You need to create this code as quickly as possible.

What should you do?

A. Create the code manually.
B. Use XmlSerializer.Serialize to generate the code.
C. Use the XmlSerializer.Deserialize to generate the code.
D. Use the Xml Schema Definition tool (Xsd.exe) to generate the code.

Answer: D

Explanation: 
The XML Schema Definition tool generates XML schema or common language runtime classes from XDR, XML, and XSD files, or from classes in a runtime assembly. The code would be produced quickly.

Option A:
Manually creating code would be tedious..

Option B:
The XmlSerializer.Serialize is used to produce XML documents from objects. It is the wrong way around.

Option C:
At run time XML documents can be deserialized into run time objects with the XmlSerializer.Deserialize method. However, we would have to manually produce this code.

Reference: 
.NET Framework Tools, XML Schema Definition Tool (Xsd.exe)
.NET Framework Class Library, XmlSerializer Class [Visual Basic]

Question 3.
You create a DataSet object named XYZProductsDataset that contains product information from a Microsoft SQL Server database. This object has a primary key on a column named ProductID.
You want to create a new DataSet object that has the same structure as XYZProductsDataset, including the primary key. You want the new DataSet object to be empty of data.

Which code segment should you use?

A. 	Dim NewDataSet As DataSet = XYZProductsDataset.Clone
B. 	Dim NewDataSet As DataSet = XYZProductsDataset.Copy
C. 	Dim NewDataSet as New DataSet ( )
	newDataSet.Tables.Add (“XYZProductsDataset”)
D. 	Dim newDataSet as New Dataset ( )
	newDataSet.Tables.Add (XYZProductsDataset.Tables (0))

Answer: A

Explanation:
DataSet.Clone method copies the structure of the DataSet, including all DataTable schemas, relations, and constraints. It does not copy any data.

Option B:
DataSet.Copy method Copies both the structure and data for this DataSet.

Option C:
A Dataset it cannot be added as a table.

Option D:
We want the new dataset be same as the old. Here we just copy a single table.

Reference: 
.NET Framework Class Library, DataSet.Clone Method [Visual Basic]

Question 4.
Your Microsoft SQL Server database contains a table named XYZOrders. Due to recent increase in product sale. XYZOrders now contains more than 500,000 rows.
You need to develop an application to produce a report of all orders in the table. You need to ensure that the application processes the data as quickly as possible.
Which code segment should you use?.

A. 	Dim myOleDbConnection As New OleDbConnection _ 
		(“Data Source=(local);”_ 
		& “Initial Catalog=XYZ;”_ 
		& “Integrated Security=true”) 
	Dim myOleDbCommand As New OleDbCommand_ 
		(“SELECT * FROM XYZOrders” , myOleDbConnection) 
	Dim ordersData Reader As OleDbDataReader 
	MyOleDbconnection.Open() 
	OrdersDataReader = myOleDbcommand.ExecuteReader
B. 	Dim myOleDbConnection As New OleDbConnection _
		 (“provider=sqloleDb;Data Source=(local);”_ 
		& “Initial Catalog=XYZ;” _ 
		& “Integrated Security=true”) 
	Dim myOleDbCommand As New OleDbCommand_ 
		(“SELECT * FROM XYZOrders” , myOleDbConnection) 
	Dim ordersData Reader As OleDbDataReader 
	myOleDbconnection.Open() 
	ordersDataReader = myOleDbCommand.ExecuteReader
C. 	Dim myConnection As New SqlConnection _ 
		(“Data Source=(local);Initial Catalog=XYZ;”_ 
		& “Integrated Security=true”) 
	Dim myCommand as new SqlCommand_ 
		(“SELECT * FROM XYZOrders” , myConnection) 
	Dim ordersData Reader As SqlDataReader 
	Myconnection.Open() 
	OrdersDataReader = mycommand.ExecuteReader
D. 	Dim myConnection As New SqlConnection _ 
		(“Data Source=(local); “Initial Catalog=XYZ;” _ 
		& “Integrated Security=true”) 
	Dim myCommand as new SqlCommand(“SELECT * FROM XYZOrders”) 
	Dim ordersData Reader As SqlDataReader 
	Myconnection.Open() 
	ordersDataReader = myCommand.ExecuteReader

Answer: C

Explanation: 
A SqlConnection gives better performance than an OleDBConnection when working with a SQL Server data source. Furthermore, the SqlCommand object should contain both a text query and a SqlConnection.
The critical command:
Dim myCommand as new SqlCommand (“SELECT * FROM XYZOrders ” , MyConnection)

Option A, B:
If we assume that the SQL Server is Version 7.0 or later, a SqlConnection would be more effective than an OleDBConnection.

Option D:
The SqlCommand should include the SqlConnection as well.

Reference: 
.NET Framework Class Library, SqlCommand Constructor [Visual Basic]

Question 5.
You are debugging a visual studio .Net application named XYZApp. The application produces an Xml documents object and then consumes the same object. This object moves data in the application. The object has no schema, but it contains a declaration line that you must inspect.
You decide to transform the XML code and its declaration into a string for easy inspection.
What should you do?

A. 	Assign the ToString method of the Xml Document object to a string variable.
B. 	Assign the OuterXml property of the Xml document object to a string variable
C. 	Assign the OuterXml property of the Xml document element property of the Xml document object to a string variable.
D. 	Use the WriteContentTo method of the XmlDocument object to write the document into a MemoryStream object. Use the GetXml method of the DataSet object to get a string version of the document.

Answer: B

Explanation: 
The XmlNode.OuterXml property gets the markup representing this node and all its children.

Option A:
The ToString method returns a String that represents only the current Object.

Option C:
There is no XmlDocument element property.

Option D:
This proposed solution is complicated. Furthermore the GetXml method of the DateSet object cannot be used on a stream.

Reference: 
.NET Framework Class Library, XmlNode.OuterXml Property [Visual Basic]

Question 6.
You are developing a order-processing application that retrieves data from a Microsoft SQL Server database contains a table named XYZCustomers and a table named Orders.
Customer has a primary key of customerID. Each row in orders has a CustomerID that indicates which customer placed the order.

Your application uses a DataSet object named ordersDataSet to capture customer and order information before it applied to the database. The ordersDataSet object has two Data Table objects named Customers and Orders.

You want to ensure that a row cannot exist in the Orders Data Table object without a matching row existing in the customers Data Table object.

Which two actions should you take? 
(Each correct Answer presents part of the solution. Choose two.)

A. 	Create a foreign key constraint named ConstraintOrders that has Orders.CustomersID as the parent column and Customers. CustomerID as the child column.
B. 	Create a foreign key constraint named ConstraintCustomers that has Customers.CustomerID as the parent column and Orders.CustomerID as the child column.
C. 	Create a unique constraint named UniqueCustomers by using the Customers.CustomerID
D. 	Add ConstraintOrders to the Orders Data Table.
E. 	Add ConstraintOrders to the Customer Data Table.
F. 	Add ConstraintCustomers to the Orders Data Table.
G. 	Add ConstraintCustomers to the Customers Data Table.
H. 	Add UniqueCustomers to the Customers Data Table.

Answer: B & F

Explanation:
The parent column is located in the table on the “one-side”, while the child column is located on the “many-side”.

Here the Customers table is the parent domain and Orders is the child domain: each Customer can have several orders, but for each specific order there must exists exactly one corresponding row in the Customers table. We should use the ConstraintsCustomers constraints.
The constraint must be added to the Orders table.

 

Option A:
This is incorrect. The parent column must be CustomerID in the Customers table.

Option B, D:
The ConstraintCustomers constraint must be used, not ConstraintOrders..

Option C, F:
A unique constraint only applies to one single table.

Option E:
The constraint must be added to the Orders table.

Question 7.
You have a .NET Remoting object named ITScheduler. The ITScheduler class is in an assembly file named TaskScheduler.dll. The ITScheduler class is hosted by an application named SchedulerServer.exe. This application is configured by using a file named SchedulerServer.exe config.

This file configures the ITScheduler class to be a client-activated object by using a TcpChannel and a BinaryFormatter.

You want to deploy the ITScheduler object to a computer named XYZ1 so that client applications can begin to use it.

You copy ITTaskScheduler.dll, SchedulerServer.exe, and SchedulerServer.exe.config to a directory on XYZ1.

What should you do next?

A. 	Install ITTaskScheduler.dll in the global assembly cache.
B. 	Use the Assembly Registration tool (Regasm.exe) on XYZ1 to register SchedulerServer.exe.
C. 	Use the Assembly Registration tool (Regasm.exe) on XYZ1 to register ITTaskScheduler.dll.
D. 	Configure XYZ1 to execute SchedulerServer.exe each time XYZ1 is restarted.
	Then manually execute SchedulerServer.exe on XYZ1.

Answer: D

Question 8.
You are creating an XML Web service named WeatherService that provides the current weather conditions for cities around the world. Your development cycle includes three stages: development, testing, and production. In each stage, WeatherService will be deployed on a different server.

For testing, you create an ASP.NET application named WeatherTest. To WeatherTest, you add a Web reference to WeatherService. You then build a user interface and add the necessary code to test the service.

The WeatherService interface will not change between testing and deployment. You want to ensure that you do not have to recompile WeatherTest every time WeatherService is moved from one server to another.

What should you do?

A. 	Each time WeatherService is moved, set the URL property of the generated proxy class to the new location.
B. 	Each time WeatherService is moved, set the Web Reference URL property of the generated proxy class to the new location.
C. 	Set the URLBehavior property of the generated proxy class to dynamic.
	Each time WeatherService is moved, update the appropriate key in the Web.config file to indicate the new location.
D. 	Take the location of WeatherService as input to WeatherTest, and set the Proxy property of all proxy class instances to that location.

Answer: C

Question 9.
You create an XML Web service named WeatherService. This service contains a Web method named RetrieveWeather. RetrieveWeather takes as input a city named and returns the current weather conditions for that city.

You need to provide callers of this service with the URL they need to issue an HTTP-GET against WeatherService.

Which URL should you use?

A. http://XYZSrv/AppPath/WeatherService.asmx/cityname=somecity 
B. http://XYZSrv/AppPath/WeatherService.asmx/RetrieveWeather?cityname=somecity 
C. http://XYZSrv/AppPath/WeatherService/RetreieveWeather.asmx?cityname=somecity 
D. http://XYZSrv/AppPath/WeatherService/RetrieveWeather?cityname=somecity 

Answer: B

Question 10.
You work as a Software developer at XYZ Inc. You are creating a Visual Studio .NET assembly, which will run as a shared assembly with other applications. The assembly will be installed in the global assembly cache. You will distribute the assembly to many customers outside XYZ.

You must ensure that each customer receives your assembly without alteration, in a way that reliably specifies the origin of the code.
What should you do?

A. 	Sign the assembly by using a string name.
	Do nothing further.
B. 	Sign the assembly by using File Signing tool (Signcode.exe).
	Do nothing further.
C. 	First sign the assembly by using a strong name.
	Then sign the assembly by using File Signing tool (Signcoe.exe).
D. 	First sigh the assembly by using File Signing tool (Signcode.exe).
	Then sign the assembly by using a strong name.

Answer: C

Question 11.
You are creating a data access component for an XML Web service. You need to populate and process a DataSet object with data from a table named Customers in a Microsoft SQL Server database named XYZA.

You write the following code segment:

Dim myConnection As New: 
SqlConnection(myConnectionString) 
Dim myDataAdapter As New SqlDataAdapter_
 (“SELECT * FROM Customers”, myConnection) 
Dim myDataSet As New DataSet()
Dim CustomerName as String

You want to capture all SQL Server errors and general exceptions that occur. You want to process SQL Server errors separate from general exceptions.

Which code segment should you use?.

A. 	Try myDataAdapter.Fill(myDataSet, “Customers”) customerName = 	myDataSet.Tables(0)._Rows(0).Item(“CustomerName”) 
	Catch mySqlException As SqlException 
	Throw New SqlException(“Sql exception occurred”) 
	Catch myException As Exception 
	‘ Code to process general exceptions goes here. 
	End Try
B. 	Try myDataAdapter.Fill(myDataSet, “Customers”) customerName 	=myDataSet.Tables(0)._Rows(0).Item(“CustomerName”) 
	Catch mySqlException As SqlException 
	For Each mySqlException In mySqlException.Errors 
	‘ Code to process SQL Server errors goes here. 
	Next Catch myException As Exception 
	‘ Code to process general exceptions goes here. 
	End Try
C. 	Try myDataAdapter.Fill(myDataSet, “Customers”) customerName = 	myDataSet.Tables(0)._Rows(0).Item(“CustomerName”) 
	Catch mySqlException As SqlException 
	Dim mySqlError As SqlError 
	For Each mySqlError In mySqlException.Errors 
	‘Code to process SQL Server errors goes here. 
	Next Catch myException As Exception 
	‘ Code to process general exceptions goes here. 
	End Try
D. 	Try myDataAdapter.Fill(myDataSet, “Customers”) customerName = 	myDataSet.Tables(0)._Rows(0).Item(“CustomerName”) 
	Catch myException As Exception
 	Throw New Exception(“General exception occurred”) 
	Catch mySqlException As SqlException 
	Dim mySqlError As SqlError 
	For Each mySqlError In mySqlExaption.Erros 
	‘Code to process SQL Server errors goes here. 
	Next 
	End Try

Answer: C.

Explanation: 
First we most catch the most specific errors, the SQL Errors. We then use a general catching of exceptions.

An SQLException is an exception that is thrown when SQL Server returns a warning or error.

Option A:
The scenario requires that each SQLServer error must be processed, not just that an SQLException occurred.

Option B:
The following statement is incorrect:
For Each mySqlException In mySqlException.Errors The mySQLException variable should be of SQLSerror type, not SQLException type. We are processing SQLErrors, not SQLExceptions.

Option D:
We must catch the SQL errors first.

Reference: 
.NET Framework Class Library, SqlException Class [Visual Basic]

Question 12.
You have a DataSet object named myDataSet. This object contains two DataTable objects named Customers and Orders. Customers has a column named CustomerID, which is unique to each customer.

Orders also has a column named CustomerID. You want to use the GetChildRows method of the DataRow object to get all orders for the current customers.

What should you do?

A. Add a foreign key constraint on CustomerID of Orders between Customers and Orders.
B. Add a data relation to myDataSet on OrderID between Customers and Orders.
C. Create a unique constraint on CustomerID of Customers..
D. Create a primary key on CustomerID of Customers.

Answer: B

Explanation:
The GetChildRows Method use a DataRelation to retrieve the child rows of this DataRow using 
the specified DataRelation. In this scenario we would be required to add a data relation between the two tables.

A Datarelation represents a parent/child relationship between two DataTable objects.

 
Option A:
A foreign key constraint works in conjunction with primary key or unique constraints to enforce referential integrity among specified tables. However, the GetChildRows method uses a DataRelation, not a foreign key constraint.

Option C:
A unique constraint on CustomerID of Customers would only make sure that the CustomerID column will have unique values.

Option D:
A primary key constraint would ensure that CustomerID column will have unique values.

Reference:
.NET Framework Class Library, DataRow.GetChildRows Method (DataRelation) [Visual Basic]
.NET Framework Class Library, DataRelation Class [Visual Basic]
Visual Database Tools, Foreign Key Constraints

Question 13.
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 ITQuery. 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 ITQuery.
	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 ITQuery.
	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 ITQuery.
	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 ITQuery.
	Use the ExecuteXmlReader method of the SqlCommand object to create a XmlReader object.
	Use the XmlReader object to read the data.

Answer: D

Explanation: 
You can execute SQL queries against existing relational databases to return results as XML documents rather than as standard rowsets. To retrieve results directly, use the FOR XML clause of the SELECT statement like in this scenario.

XmlReader provides non-cached, forward-only, read-only access.to an XML data source, such as the XML produces by the T-SQL statement of this scenario.

Option A:
We must take since the data is in XML format. Furthermore, a Dataset is not required.

Option B:
DataSet.ReadXml method reads XML data into the DataSet. However, it is not necessary to use a dataset.
Reading the data into a Dateset brings an unnecessary overhead.

Option C:
The SQLDateReader provides a means of reading a forward-only stream of rows from a SQL Server database. However, it operates on relational data not on XML data.

Reference:
SQL Server 2000 Books Online, Retrieving XML Documents Using FOR XML
.NET Framework Developer's Guide, Reading XML with the XmlReader

Question 14.
You have DataSet object named LoanCustomersDataSet that contains customers serviced by the loan department of XYZ. You receive a second DataSet that contains customers serviced by the asset management department of XYZ. Both objects have the same structure.

You want to merge assetCustomersDataSet into LoanCustomersDataSet and preserve the original values in loanCustomersDataSet.

Which code segment should you use?

A. loanCustomersDataSet.Merge (assetCustomersDataSet)
B. loanCustomersDataSet.Merge (assetCustomersDataSet, True)
C. assetCustomersDataSet.Merge (loanCustomersDataSet)
D. assetCustomersDataSet.Merge (loanCustomersDataSet, True)

Answer: B

Explanation: 
The DataSet.Merge method merges this DataSet with a specified DataSet. The data will be merged into the dataset on which the Merge method is applied. We want to merge into our Dateset, namely the loanCustomerDataSet. Furthermore, we want to preserve the original values in loanCustomerDataSet.

The Boolean parameter is the preserveChanges. PreserveChanges indicates a value indicating whether changes made to the current DataSet should be maintained. It should be true, if changes should be maintained, like in this scenario. .

Option A 
The PreserveChanges parameter must be set to true.

Option C, D:
We must merge into loanCustomerDataSet, not into the Dataset that we have received.

Reference: 
.NET Framework Class Library, DataSet.Merge Method (DataSet, Boolean) [Visual Basic]

Question 15.
You are creating an XML Web service that generates a SOAP message. Parameter information in the SOAP message must be encrypted.
You write the appropriate code to modify the SOAP message. You also write a method named Encrypt.

This method takes a string an argument, encrypts the string, and returns a new string that contains the encrypted string.
Before encryption , the Body element of the SOAP message will be written in the following format.

 
	 
		some date 
	
 

After encryption, the Body element must be written in the following format.

	
 	 
154 37 146 194 17 92 32 139 28 42 184 202 164 18 
	 


You write code to isolate the  XML node in an XmlNode object named theNode.
You now need to write code to encrypt the parameter information.
Which code segment should you use?

A. 	Dim encrypted as String = Encrypt(theNode.InnerText) 
	theNode.OuterXml = encrypted
B. 	Dim encrypted as String = Encrypt(theNode.InnerXml) 
	theNode.OuterXml = encrypted
C. 	Dim encrypted as String = Encrypt(theNode.InnerXml) 
	theNode.InnerXml = encrypted
D. 	Dim encrypted as String = Encrypt(theNode.OuterXml) 
	theNode.OuterXml = encrypted
E. 	Dim encrypted as String = Encrypt(theNode.InnerText) 
	theNode.InnerText = encrypted

Answer: C

Explanation: 
First we retrieve the markup representing the child of the node with the InnerXml property. Then we encrypt this string. Finally we set the InnerXml property to this encrypted string..

The XmlAttribute.InnerText property gets or sets the concatenated values of the node and all its children. For attribute nodes, this property has the same functionality as the Value property: it gets or sets the value of the node.

The XmlDocument.InnerXml property gets or sets the markup representing the children of the current node.

Setting this property replaces the children of the node with the parsed contents of the given string. 

The XmlNode.OuterXml property gets the markup representing this node and all its children.

Option A, B:
The XmlNode.OuterXml property is read only and cannot be used in the statement:
theNode.OuterXml = encrypted 

Option D:
theNode.OuterXml would produce the whole node, however we only want to encrypt the string “some date”.,

Option E:
Just encrypting the InnerText property would result in a body element where the  markup still would be present:


154 37 146 194 17 92 32 139 28 42 184 202 164 18



Reference:
.NET Framework Class Library, XmlDocument.InnerXml Property [Visual Basic]
.NET Framework Class Library, XmlAttribute.InnerText Property [Visual Basic]
.NET Framework Class Library, XmlNode.OuterXml Property [Visual Basic]

	Web www.certsbraindumps.com