You are creating an ASP.NET application for XYZ. The company data is stored in a Microsoft SQL Server 6.5 database. Your application generates accounting summary reports based on transaction tables that contain million of rows._x005F_x000D_ You want your application to return each summary report as quickly as possible. You need to configure your application to connect to the database and retrieve the data in a away that achieves this goal._x005F_x000D_ What should you do?

Configure SQL Server to support HTTP access, and create an XML template to run a stored procedure that returns the data in XML format.

Use a SqlConnection object to connect to the database, and use a SqlCommand object to run a stored procedure that returns the data.

Use an OleDbConnection object to connect to the database, and use an OleDbCommand object to run a stored procedure that returns the data.

Use COM interop to create an ADODB.Connection object, and use an ADODB.Command object to run a SQL statement that returns the data.

You are creating an ASP.NET application for XYZ. The company data is s

1.	You are creating an ASP.NET application for XYZ. The company data is stored in a Microsoft SQL Server 6.5 database. Your application generates accounting summary reports based on transaction tables that contain million of rows._x005F_x000D_ You want your application to return each summary report as quickly as possible. You need to configure your application to connect to the database and retrieve the data in a away that achieves this goal._x005F_x000D_ What should you do?
A.	Use a SqlConnection object to connect to the database, and use a SqlCommand object to run a stored procedure that returns the data.
B.	Use an OleDbConnection object to connect to the database, and use an OleDbCommand object to run a stored procedure that returns the data.
C.	Configure SQL Server to support HTTP access, and create an XML template to run a stored procedure that returns the data in XML format.
D.	Use COM interop to create an ADODB.Connection object, and use an ADODB.Command object to run a SQL statement that returns the data.
Answer» C. Configure SQL Server to support HTTP access, and create an XML template to run a stored procedure that returns the data in XML format.

Discussion

No Comment Found

Related MCQs

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create anÂ application. You use the ADO.NET Entity Data Model (EDM) to define a Customer entity. YouÂ need to add a new Customer to the data store without setting all the customer's properties. What should you do?
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create anÂ application. The application uses the ADO.NET Entity Framework to manage customer andÂ related order records. You add a new order for an existing customer. You need to associate the Order entity with the Customer entity. What should you do?
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create anÂ application. The application uses the ADO.NET Entity Framework to model entities. TheÂ application allows users to make changes to entities while disconnected from the central data store._x005F_x000D_ Â _x005F_x000D_ You need to ensure that when the user connects to the central data store and retrieves new data, the application meets the following requirements:_x005F_x000D_ _x005F_x000D_ Changes made to the local data store in disconnected mode are preserved._x005F_x000D_ Entities that have already been loaded into the local data store, but have not been modified by the user, are updated with the latest data._x005F_x000D_ _x005F_x000D_ What should you do?
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create a WindowsÂ Communication Foundation (WCF) Data Services service. You discover that when anÂ application submits a PUT or DELETE request to the Data Services service, it receives an error. You need to ensure that the application can access the service. Which header and request type should you use in the application?
You use Microsoft Visual Studio 2010 and Microsoft ADO.NET Framework 4 to create anÂ application. The application connects to a Microsoft SQL Server 2008 database. You use the ADO.NET LINQ to SQL model to retrieve data from the database. You use stored procedures to return multiple result sets. You need to ensure that the result sets are returned as strongly typed values. What should you do?
You create English, French, and German versions of a test engine ASP.NET application you are developing for XYZ Inc. You have separate resource files for each language version.You need to deploy the appropriate resource file based on the language settings of the server. What should you do?
You plan to deploy your ASP.NET application over XYZâ€™s intranet. The application uses data retrieved from a Microsoft SQL Server database. You want to use SQL Server connection pooling to optimize performance. You also need to protect confidential data stored on the server while minimizing administrative costs._x005F_x000D_ Â _x005F_x000D_ You need to configure security for your application. What should you do?
You create an ASP.NET page that uses images to identify areas where a user can click to initiate actions. The users of the application use Internet Explorer._x005F_x000D_ You want to provide a pop-up window when the user moves the mouse pointer over an image. You want the pop-up window to display text that identifies the action that will be taken if the user clicks the image._x005F_x000D_ What should you do?
You create an ASP.NET application to provide corporate news and information to XYZâ€™sÂ employees. The application is used by employees in New Zealand._x005F_x000D_ Default.aspx has a Web Form label control named currentDateLabel. The Page.Load event handler for Default.aspx included the following line of code:currentDateLabel.Text = DateTime.Now.ToString(â€œDâ€)_x005F_x000D_ You need to ensure that the data is displayed correctly for employees in New Zealand. What should you do?
You ASP.NET application manages order entry data by using a DataSet object named EXorderEntry. The EXorderEntry object includes two DataTable objects named orderNames and OrderDetails. A ForeignKeyConstraint object named orderDetailsKey is defined between the two DataTable objects._x005F_x000D_ You attempt to delete a row in orderNames while there are related rows in OrderDetails, and an exception is generated.What is the most likely cause of the problem?

Discussion

No Comment Found

Related MCQs

Reply to Comment