Examsoon.com  The World Renowned  IT Certification Material Provider Exam : Microsoft 70-320 Title : DEV XML WEB SERV&amp;SER COMP W/MS C#.NET&amp;MS.NET FRAMEWORK Version : Demo Examsoon.com  The World Renowned  IT Certification Material Provider  Important Note, Please Read Carefully  Other examsoon products  All examsoon IT Exam Products  Our products of Offline Testing Engine  Use the offline Testing engine product to practice the questions in an exam environment.  Build a foundation of knowledge which will be useful also after passing the exam.  examsoon Testing Engine  Guarantee  Examsoon provides the most competitive quality of all exams for the customers, we guarantee your  success at the first attempt with only our Certification Question&Answers, if you do not pass the exam at  the first time, we will not only arrange FULL REFUND for you, but also provide you another exam of your  claim, ABSOLUTELY FREE!.  Features  1.  Comprehensive questions with complete details  2.  Instant Downloadable in PDF form.  3.  Verified Answers Researched by Industry Experts  4.  Questions accompanied by exhibits  5.  Drag and Drop questions as experienced in the Actual Exams.  6.  These questions and answers are backed by our GUARANTEE.  7.  Questions updated on regular basis.  8.  Like actual certification exams our product is in multiple­choice questions (MCQs). ExamSoon.com  The World Renowned  IT Certification Material Provider  Help you pass any IT Exams 1. You have a strongly typed DataSet object named myDataSet. This object contains three DataTable objects named Customers, Orders, and OrderDetails. Customers and Orders have a data column named CustomerID. Orders and OrderDetails have a data column named OrderID. Orders has a foreign key constraint between Customers and Orders on CustomerID. OrderDetails has a foreign key constraint between Orders and OrderDetails on OrderID. You want to populate Customers, Orders, and OrderDetails with data from a Microsoft SQL Server database. In which order should you fill the DataTable objects? A. Customers OrderDetails Orders B. OrderDetails Orders Customers C. Customers Orders OrderDetails D. Orders OrderDetails Customers Answer: C 2. You create an XML Web service that retrieves data from a Microsoft SQL Server database. You instantiate a SqlConnection object named myConnection and set the Max Pool Size property of the connectionString to 50. All 50 connections are now in use. However, a request for connection number 51 is received. What is the most likely result? A. An exception is immediately thrown. B. The current connection pool is expanded by 50 additional connections. C. A new connection pool is created that has the same maximum number of connections. D. The request is queued until a connection becomes available or until the timeout limit is reached. Answer: D 3. You are developing an order-processing application that retrieves data from a Microsoft SQL Server database. The database contains a table named Customers and a table named Orders. Customers has a primary key of CustomerID. Each row in Orders has a CustomerID that indicates which ExamSoon.com  The World Renowned  IT Certification Material Provider  Help you pass any IT Exams customer placed the order. Your application uses a DataSet object named ordersDataSet to capture customer and order information before it is applied to the database. The ordersDataSet object has two DataTable objects named Customers and Orders. You want to ensure that a row cannot exist in the Orders DataTable object without a matching row existing in the Customers DataTable 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.CustomerID 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 DataTable. E. Add ConstraintOrders to the Customers DataTable. F. Add ConstraintCustomers to the Orders DataTable. G. Add ConstraintCustomers to the Customers DataTable. H. Add UniqueCustomers to the Customers DataTable. Answer: BF 4. You have a DataSet object named ordersDataSet. This object contains two DataTable objects named Orders and OrderDetails. Both Orders and OrderDetails contain a column named OrderID. You create a DataRelation object named orderRelation between Orders and OrderDetails on OrderID. Orders is the parent table. OrderDetails is the child table. You add orderRelation to the ordersDataSet relation collection by using the following line of code: ordersDataSet.Relations.Add(orderRelation); You verify that prior to adding orderRelation, there were no constraints on either table. You then run the line of code. How many constraints does each table have now? A. one on Orders; none on OrderDetails B. none on Orders; one on OrderDetails C. none on Orders; none on OrderDetails D. one on Orders; one on OrderDetails Answer: D 5. Your Microsoft SQL Server database contains a table named Regions. Regions contains all the sales ExamSoon.com  The World Renowned  IT Certification Material Provider  Help you pass any IT Exams regions for a sales-tracking application. You create a DataSet object named regionsDataSet by using a SqlDataAdapter object named myDataAdapter. This object uses a single SQL SELECT statement to populate the regionsDataSet. You bind regionsDataSet to a DataGrid object named regionsDataGrid to display the contents of Regions. You now want to use the same regionsDataSet, myDataAdapter, and regionsDataGrid to insert, update, and delete data in Regions. You want to accomplish this task by writing the minimum amount of code. What should you do? A. Instantiate a SqlCommandBuilder object that has myDataAdapter as a constructor argument. Add an Update button to the form and add code to the Click event to update regionsDataSet by using myDataAdapter. B. Instantiate a SqlCommandBuilder object that has myDataAdapter as a constructor argument. Create one stored procedure for each of the insert, update, and delete functions and associate the stored procedures with the InsertCommand, UpdateCommand, and DeleteCommand properties of myDataAdapter. Add an Update button to the form and add code to the Click event to update regionsDataSet by using myDataAdapter. C. Create one stored procedure for each of the insert, update, and delete functions and associate the stored procedures with the InsertCommand, UpdateCommand, and DeleteCommand properties of myDataAdapter. Add an Update button to the form and add code to the Click event to update regionsDataSet by using myDataAdapter. D. Create one SQL string for each of the insert, update, and delete functions and associate the SQL strings with the InsertCommand, UpdateCommand, and DeleteCommand properties of myDataAdapter. Add an Update button to the form and add code to the Click event to update regionsDataSet by using myDataAdapter. Answer: A 6. 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 XmlSerializer.Deserialize to generate the code. D. Use the XML Schema Definition tool (Xsd.exe) to generate the code. ExamSoon.com  The World Renowned  IT Certification Material Provider  Help you pass any IT Exams Answer: D 7. You are developing an application that receives product information from external vendors in the form of XML documents. The information will be stored in a Microsoft SQL Server database. The application must validate all incoming XML data. It uses an XmlValidatingReader object to read each XML document. If any invalid sections of XML are encountered, the inconsistencies are listed in a single document. You must ensure that the validation process runs as quickly as possible. What should you do? A. Set the ValidationType property of the XmlValidatingReader object to Schema. B. Set the CanResolveEntity property of the XmlValidatingReader object to True. C. Create and register a ValidationEventHandler method. D. Use a try/catch block to catch validation exceptions. Answer: C 8. Your Microsoft SQL Server database has a stored procedure that sums the total number of orders received each day. The stored procedure returns a result that is a single data value of type integer. You need to write code that will execute the stored procedure and return the result as an integer value. You instantiate a SqlCommand object named myCommand and initialize all appropriate parameters. Which myCommand method should you use? A. ExecuteReader B. ExecuteNonQuery C. ExecuteScalar D. ExecuteXMLReader Answer: C 9. You are troubleshooting a Visual Studio .NET application that was developed by a former colleague. The application contains a NextToken function. This function reads product names from a file. You find the following code segment within a large assembly: ExamSoon.com  The World Renowned  IT Certification Material Provider  Help you pass any IT Exams You find that productNames.xml contains only two entries: prod0 and prod1. Which XML output is produced by this code segment? A. <?xml version="1.0"?> <data xmlns="www.contoso.com"> <item = "prod0" /> <item = "prod1" /> </data> B. <?xml version="1.0" encoding="utf-8" standalone="yes"?> <data> <item xmlns="www.contoso.com">prod0</item> <item xmlns="www.contoso.com">prod1</item> </data> C. <?xml version="1.0"?> <data> <item>prod0</item> <item>prod1</item> </data> D. <?xml version="1.0" encoding="utf-8" standalone="yes"?> <data xmlns="www.contoso.com"> <item>prod0</item> <item>prod1</item> </data> Answer: D 10. Your Microsoft SQL Server database has a stored procedure named GetCompanyName. GetCompanyName accepts one parameter named @CustomerID and returns the appropriate company name. You instantiate a SqlCommand object named myCommand. You need to initialize myCommand to return the company name for @CustomerID with a value of "ALFKI". Which code segment should you use? A. myCommand.CommandText = "GetCompanyName, ALFKI"; myCommand.Parameters.Add("@CustomerID"); B. myCommand.CommandText = "GetCompanyName"; myCommand.Parameters.Add("GetCompanyName", "ALFKI"); C. myCommand.CommandText = "@CustomerID"; myCommand.Parameters.Add("GetCompanyName", "ALFKI"); D. myCommand.CommandText = "GetCompanyName"; myCommand.Parameters.Add("@CustomerID", "ALFKI"); ExamSoon.com  The World Renowned  IT Certification Material Provider  Help you pass any IT Exams Answer: D 11. You are developing an application that queries a Microsoft SQL Server database. The application will package the results of the query as XML data. The XML data will be retrieved directly from the database and transmitted electronically to a business partner. The query must retrieve all rows and all columns from a database table named Customers. Which query should you use? A. SELECT * FROM Customers FOR XML AUTO B. SELECT * FOR XML FROM Customers C. SELECT * FROM Customers as XMLDATA D. SELECT * FROM OPENXML( '<Customers>', '/Root/Customer', 1) with (CustomerID varchar(10)) Answer: A 12. You are creating an XML Web service that processes credit card information. This service will be consumed by computers that run on Microsoft Windows operating systems, as well as computers that run on other operating systems. You must ensure that client credentials passed to the service are secure and cannot be compromised. You are not as concerned with the length of time that Web method calls take to maintain this level of security. You need to configure authentication for this service. Which type of authentication should you use? A. Basic B. Forms C. Client Certificate D. Integrated Windows Answer: C 13. You are creating a Windows-based application named MyWinApp. To the application, you add a Windows Form named MyForm and a reference to a SingleCall .NET Remoting object named TheirObject. You need to ensure that MyForm creates an instance of TheirObject to make the necessary remote object calls. Which code segment should you use? A. RemotingConfiguration.RegisterActivatedClientType( typeof(TheirObject), "http://TheirServer/TheirAppPath/TheirObject.rem"); TheirObject theirObject = new TheirObject(); B. RemotingConfiguration.RegisterWellKnownClientType( typeof(TheirObject), "http://TheirServer/TheirAppPath/TheirObject.rem"); TheirObject theirObject = new TheirObject(); C. RemotingConfiguration.RegisterActivatedServiceType( typeof(TheirObject)); ExamSoon.com  The World Renowned  IT Certification Material Provider  Help you pass any IT Exams TheirObject theirObject = new TheirObject(); D. RemotingConfiguration.RegisterWellKnownServiceType( typeof(TheirObject), "http://TheirServer/TheirAppPath/TheirObject.rem", WellKnownObjectMode.Singleton); TheirObject theirObject = new TheirObject(); Answer: B 14. You have an application named MyApp that contains a reference to version 1.0.0.0 of a strongly named serviced component named FabrikamComponent. This component is located in the bin directory of MyApp. You receive version 2.0.0.0 of FabrikamComponent, which you install in the global assembly cache. You reconfigure the application configuration file to redirect calls to version 2.0.0.0. You now receive version 3.0.0.0 of FabrikamComponent, which you install in the global assembly cache. You do not reconfigure the application configuration file. You then run MyApp. Which version of FabrikamComponent is loaded and from which location is it loaded? A. version 1.0.0.0 from the bin directory B. version 2.0.0.0 from the global assembly cache C. version 2.0.0.0 from the bin directory D. version 3.0.0.0 from the global assembly cache Answer: B 15. You create an XML Web service named myService. This service exposes a Web method named MyMethod. You need to register myService in UDDI. First, you add a new business name and a new tModel. You now need to list a valid access point to myService. Which URL should you use? A. http://YourServer/AppPath/myService B. http://YourServer/AppPath/myService?wsdl C. http://YourServer/AppPath/myService.asmx D. http://YourServer/AppPath/myService.asmx?MyMethod Answer: C Examsoon.com was founded in 2006. The safer,easier way to help you pass any IT Certification  exams . We provide high quality IT Certification exams practice questions and answers(Q&A).  Especially  Adobe,  Apple,  Citrix,  Comptia,  EMC,  HP,  Juniper,  LPI,  Nortel,  Oracle,  SUN,  Vmware  and so on. And help you pass any IT Certification exams at the first try.  we guarantee your success at the first attempt with only our Certification Question&Answers,  if you do not pass the exam at the first time, we will not only arrange FULL REFUND for you,  but also provide you another exam of your claim, ABSOLUTELY FREE!  You can reach us at any of the email addresses listed below.  E­MAIL:  examsoon(at)hotmail.Com  Examsoon.com  The World Renowned  IT Certification Material Provider