|
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 1. Which DHCP server gives secondary codecs in Cisco TelePresence CTS-3000 and CTS-3200 systems their IP addresses? A. DHCP server on the voice VLAN B. DHCP server on the primary codec C. DHCP server on the Cisco Unified Communications Manager D. DHCP server on the CiscoTelePresence Manager Answer: B Question 2. How do you calibrate the light meter from the Cisco recommended RRA tool kit? A. Press the Auto Adjust button on the meter. B. Turn the meter on and off. C. Cover the sensor with the cap and press the Zero button. D. Cover the sensor with the cap and press the Light Source button. Answer: C Question 3. What two options does an administrator have using WebUI for CTMS in Monitoring/Room Testing for any active meeting? (Choose two.) A. add a CTS System to a meeting B. view network statistics C. view meeting statistics D. start loopback E. force switch Answer: A, B Question 4. The Cisco Telepresence room Fluffy does not have an email account listed in the Unified CM. This is preventing the Cisco Telepresence Manager from synchronizing with the email address for the Cisco Telepresence Room in the Calendar server. Refer to the exhibit. You are using Cisco Telepresence Manager and have just added a new room in the Cisco Unified Communications Manager and have made test calls successfully. You run the Discover Rooms option under Discovery Service successfully. You then go into the Rooms section and see the status. Which is the cause of the problem? A. The Cisco Telepresence room Fluffy does not have an email account listed in the Unified CM. This is preventing the Cisco Telepresence Manager from synchronizing with the email address for the Cisco Telepresence Room in the Calendar server. B. The Cisco Telepresence room Fluffy has an email address listed in the Unified CM. The Calendar server does not have an account for the email address provided by the Unified CM. C. The Cisco Telepresence room Fluffy has an email address listed in the Unified CM. The Calendar server has an account for the email address provided by the Unified CM. The Cisco Telepresence Manager does not have proper privileges to view this account. D. The Cisco Telepresence room Fluffy has an email address listed in the Unified CM. The Calendar server has an account for the email address provided by the Unified CM. The Cisco Telepresence Manager cannot authenticate to the LDAP server and cannot log into the Calendar server to synchronize with the account. Answer: C Question 5. During the RRA, how should you hold the light sensor when taking the majority of light measurements? A. Horizontally, so it gets the direct lighting from ceiling light fixtures. B. Vertically, toward the displays to measure the light they put off. C. Horizontally, toward any untreated windows to measure light coming in. D. Vertically, so it is reading light as if it were hitting the participant's face. Answer: D Question 6. At a minimum, what must an administrator configure in the CUCM for the Cisco Telepresence Multipoint Switch? A. SIP trunk and route pattern B. H.323 gateway and route pattern C. H.323 gateway, route pattern, route list and route group D. SIP trunk, route pattern, route list and route group E. H.323 gateway, route pattern and route group F. route pattern, route list and route group Answer: A Question 7. Which QoS mapping is specific to Cisco Telepresence? A. CoS 5 to map to a DSCP value of 40 B. CoS 4 to map to a DSCP value of 46 C. CoS 3 to map to a DSCP value of 48 D. CoS 5 to map to a DSCP value of 16 E. CoS 4 to map to a DSCP value of 32 Answer: E Question 8. How is VIP mode enabled for a scheduled multipoint Cisco Telepresence meeting? A. through the Cisco IP phone interface B. through theWebUI on the CTMS C. through the CiscoTelepresence Manager D. through calendar scheduling interface Answer: B Question 9. Which three statements about the cabling of a Cisco Telepresence 3000 are true? (Choose three.) A. All speakers connect to the primary codec. B. All video cameras connect to the primary codec. C. All 65 inch plasma displays connect to the primary codec. D. Microphones connect to the corresponding codec. E. Speakers connect to the corresponding codec. F. Video cameras connect to the corresponding codec. G. Plasma displays connect to the corresponding codec. Answer: A, F, G Question 10. DRAG DROP Answer:
Copyright © 2004 CertsBraindumps.com Inc. All rights reserved.