Your Microsoft SQL Server database contains a table named Orders. Orders is used to store new purchase orders as they are entered into an orderentry application. To keep up with customer demand, the order fulfillment department wants to know at 15-minute intervals when new orders are entered.You need to develop an application that reads Orders every 15 minutes and sends all new orders to the order fulfillment department. The application will run on computer that is used by several users who continuously log on and log off from the network to perform miscellaneous tasks.Which type of .NET application should you use?

试卷相关题目

• 1Your Microsoft SQL Server 6.5 database contains a table named PurchaseOrders that consists of more than 1 million rows.You are developing an application to populate a DataReader object with data from PurchaseOrders. You want to ensure that the application processes the data as quickly as possible.You create a SQL SELECT statement in a local variable named YourSQLSelect You need to instantiate a SqlConnection object and a SqlCommand object that you will use to populate the DataReader object.Which code segment should you use?

  A.Dim myConnection As New OleDbConnection —(rayOleDbConnectionString)Dim YourCommand As New OleDbCommand (YourSQLSelect)

  B.Dim myConnection As New OleDbConnection (myOleDbConnectionString)Dim YourCommand As New OleDbCommand (YourSQLSelect, myConnection)

  C.Dim myConnection As New SqlConnection _(mySqlConnectionString)Dim YourCommand As New SqlCommand (YourSQLSelect)

  D.Dim myConnection As New SqlConnection (mySqlConnectionString)Dim YourCommand As New SqlCommand (YourSQLSelect, myConnection)

  开始考试点击查看答案
• 2You are creating an XML Web service named ListBoxService. This service provides content, such as states, countries, and geographical regions, for use in dropdown 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 dat

  A.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 Web Method attribute to false

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

  开始考试点击查看答案
• 3Your company provides a credit card processing application for its customers. The current application supports only computers that run on a Microsoft Windows operating system.You are asked to rewrite the current application as a . NET application. This .NET application does not need to be backward compatible with the current application.You must ensure that this new application meets the following requirements: ••Must support asynchronous processing•Must be able to pass data through firewalls•Must pass only SOAP-Compliant formatted data validated by using an XSD schema•Must not be limited to client computers running on a Microsoft operating systemYou want to accomplish this task by using the minimum amount of development effort.Which type of .NET application should you use?

  A.Windows service

  B.XML Web service

  C.Serviced component

  D..NET Remoting object

  开始考试点击查看答案
• 4You are creating an XML Web service that provides a daily quotation from literary works to its customers. This quotation is requested in many different languages, thousands of times every day, and by thousands of Web sites operating many different platform.A Web method named GetQuotes takes a languagelD as input. GetQuotes uses this languagelD to retrieve a translated version of the daily quotation from a Microsoft SQL Server database and to return that quotation to the customer.You want to minimize the time it takes to return the translated version.What should you do?

  A.Store each translated quotation by using the Cache object

  B.Store each translated quotation by using the Session object

  C.Set the Buf ferResponse property of the WebMethod attribute to false

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

  开始考试点击查看答案
• 5You 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

  开始考试点击查看答案
• 6You are creating a .NET Remoting object named BankOps. BankOps exposes methods for creating, finding, and modifying objects in a class named BankCustomer. BankCustomer has a large number of read/write properties.You expect a large number of remote client applications to frequently connect to BankOps. You expect these remote client applications to use many of the BankCustomer properties. You want to ensure that network traffic is minimized.What should you do?

  A.Add the Serializable attribute to the BankCustomer class

  B.Implement the IDisposable interface in the BankCustomer class

  C.Derive the BankCustomer class from ContextBoundObject

  D.Derive the BankCustomer class from MarshalByRefObject. Override the inherited InitializeLifetimeService method to return null

  开始考试点击查看答案
• 7You create two serviced components named OrderPipeline and Or- derAdmin. Each component is registered in a separate COM+ server application. Both components use pricing dat

  A.OrderPipeline reads the pricing data for placing user orders. OrderAdmin modifies the pricing data.You want to ensure that OrderPipeline accesses the pricing data as quickly as possible, while still being able to immediately retrieve any pricing changes made by OrderAdmin.What should you do?A.Store the pricing data in the Shared Property Manager

  B.Store the pricing data in Microsoft SQL Server database

  C.Store the pricing data in a Hashtable object within OrderAdmin. Expose the Hashtable object through a property on OrderAdmin

  D.Store the pricing data in an XmlDocument object within OrderAdmin. Expose the XmlDocument object through a property on OrderAdmin

  开始考试点击查看答案
• 8You create an XML web service that retrieves data from Microsoft SQL Server database. You instantiate a SqlConnection object named YourConnection and set the Max Pool Size property of the conne- ctionString 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

  开始考试点击查看答案
• 9You are planning to create a DataSet object named YourDataSet to be used in a bond-trading application. Several developers will need to write code to manipulate YourDataSet, and you want to ensure that YourDataSet is easy for them to use . You decide to create YourDataSet as a strongly typed data set.Which two actions should you take? (Each correct answer presents part of the solution. Choose two)

  A.Create an XSD schema that defines YourDataSet

  B.Create an XDR schema that defines YourDataSet

  C.Create a class for YourDataSet that is based on the schema and that inherits from the DataSet class

  D.Create a class for YourDataSet that is based on the schema and that inherits from the XmlSchema class

  E.Create a key pair for YourDataSet by using the Strong Name tool(Sn.exe)

  开始考试点击查看答案
• 10You are developing an application that retrieves a list of geographical regions from a table in a Microsoft SQL Server database. The list of regions is displayed in a dropdown list box on a Windows Form. .You want to populate the list box with data from a DataSet object. You want to fill the DataSet object by using a SqlDataAdapter object.You create a SqlConnection object named YourConnection and a SQL query string named regionSQL. You need to write the code to create the SqlDataAdapter object.Which code segment should you use?

  A.Dim myDataAdapter As New SqlDataAdapter()myDataAdapter.SelectCommand.Connection = MyConnection myDataAdapter.SelectCommand.CommandTexc = regionSQL

  B.Dim myDataAdapter As New SqlDataAdapter(regionSQL, MyConnection)C . Dim SqlCmd As New SqlCommand(regionSQL)Dim myDataAdapter As New SqlDataAdapter() myDataAdapter.SelectCommand.Connection = MyConnection myDataAdapter.SelectCommand = SqlCmdD. Dim SqlCmd As New SqlComrnand ()Dim myDataAdapter As New SqlDataAdapter()SqlCmd.CommandText = regionSQLmyDataAdapter.SelectCommand.Connection = MyConnection myDataAdapter.SelectCommand = SqlCmd

  开始考试点击查看答案