单选题You work as an application developer at Contoso.com. You use Microsoft .NET Framework 3.5 and Microsoft ADO.NET to develop an application that will connect to the Microsoft SQL Server 2005 database. You want to use Windows Authentication along with the

第1题：

You work as an application developer at Contoso.com. You use Microsoft .NET Framework 3.5 and Microsoft ADO.NET to develop an application. You want to make sure that the application is operative to any type of database.   What should you do？（）

• A、 Set the database driver name in the connection string of the application， and then the connection object as follows： DbConnection connection = new OdbcConnection（connectionString）；
• B、 Create the connection object as follows： DbProviderFactory factoryDbProviderFactories.GetFactory（databaseProviderName）； DbConnection connection =factory.CreateConnection（）；
• C、 Create the connection object as follows： DbProviderFactory factory = DbProviderFactories.GetFactory（"System.Data.Odbc"）； DbConnection connection = factory.CreateConnection（）；
• D、 Set the database driver name in the connection string of the application， and then the connection object as follows：DbConnection connection = new OleDbConnection（connectionString）；

第2题：

You work as an application developer at Contoso.com. You use Microsoft .NET Framework 3.5 and Microsoft ADO.NET to develop an application. The Contoso.com network contains a Microsoft SQL Server 2005 server named DB01. Your application retrieve records from a  database named Trades that resides on DB01. The application connects to Trades by using an instance of the SqlConnection class with the following connection string.   "Data Source=DB01；UID=’mhamm’；PWD=’password’；"   When the application calls the Open method of the SqlConnection object， it displays the following： "Cannot open user default database. Login failed. Login failed for user ’mhamm’".  You need to make sure that you can connect to Trades when the user account for the connection is mhamm.   What should you do？ （）

• A、 Change the connection string as follows：Data Source=DB01；Initial Catalog=Trades；UID=mhamm； PWD=password；"
• B、 Create a login for Mia Hamm on DB01.
• C、 Create a database user object in Trades and map the object to the SQL Server 2005 Login of Mia Hamm.
• D、 Change the connection string as follows："Server=DB01；Database=Trades；UID=mhamm；PWD=password；"

第3题：

You work as an application developer at Contoso.com. You use Microsoft .NET Framework 3.5 and Microsoft ADO.NET to develop an application. The database on the Microsoft SQL Server 2005 database has two tables that are displayed by using two SqlConnection objects in two different GridView controls. You want the tables to be displayed at the same time with the use a single SqlConnection object.   What should you do？（）

• A、 Create a bound connection by using the sp_getbindtoken and the sp_bindsession stored procedures.
• B、 Enable Multiple Active Result Sets （MARS） in the connection string of the application. 
• C、 Create an exception handler for the connection-busy exception that is thrown on using a single SqlConnection object.
• D、 Run the two SqlDataReader objects by using a single SqlCommand object.

第4题：

You use Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. You use the ClickOnce deployment methodology to distribute the application. You need to store application-specific data along with read/write permissions without requiring elevated permissions for the application. Where should you store the application data?（）

• A、 In isolated storage.
• B、 On the database server.
• C、 In the ClickOnce data directory.
• D、 In the App.config file of the application.

第5题：

You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. You create a Web page to display photos and captions. The caption of each photo in the database can be modified by using the application. You write the following code fragment：         ’ runat="server"/>             ’ runat="server" />             When you access the Web page， the application throws an error.  You need to ensure that the application successfully updates each caption and stores it in the database.  What should you do？（）

• A、Add the ID attribute to the Label control. 
• B、Add the ID attribute to the TextBox control. 
• C、Use the Bind function for the Label control instead of the Eval function. 
• D、Use the Eval function for the TextBox control instead of the Bind function.

第6题：

You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. The application contains a DataSourceControl named CategoriesDataSource that is bound to a Microsoft SQL Server 2005 table. The CategoryName column is the primary key of the table. You write the following code fragment in a FormView control：   01    02   Category：   03      09      10     You need to ensure that the changes made to the CategoryID field can be written to the database.  Which code fragment should you insert at line 04？（）

• A、SelectedValue='<%# Eval("CategoryID") %>' 
• B、SelectedValue='<%# Bind("CategoryID") %>' 
• C、SelectedValue='<%# Eval("CategoryName") %>' 
• D、SelectedValue='<%# Bind("CategoryName") %>'

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. The application uses Session objects. You are modifying the application to run on a Web farm. You need to ensure that the application can access the Session objects from all the servers in the Web farm. You also need to ensure that when any server in the Web farm restarts or stops responding， the Session objects are not lost.  What should you do？（）

• A、Use the InProc Session Management mode to store session data in the ASP.NET worker process. 
• B、Use the SQLServer Session Management mode to store session data in a common Microsoft SQL Server 2005 database. 
• C、Use the SQLServer Session Management mode to store session data in an individual database for each Web server in the Web farm. 
• D、Use the StateServer Session Management mode to store session data in a common State Server process on a Web server in the Web farm. 

第14题：

You work as an application developer at Contoso.com. You use Microsoft .NET Framework 3.5 and Microsoft ADO.NET to develop an application that will connect to the Microsoft SQL Server 2005 database. You want to use Windows Authentication along with the Microsoft OLE DB provider. You now need to make sure that the OLE DB connection is as secure as possible.   What should you do？（）

• A、 Add the following parameter to the connection string： Integrated Security=true； PersistSecurityInfo=true；
• B、 Add the following parameter to the connection string： Integrated Security=SSPI；
• C、 Add the following parameter to the connection string： Integrated Security=SSPI； PersistSecurityInfo=yes；
• D、 Add the following parameter to the connection string： Integrated Security=true；

第15题：

You are planning the migration of an existing application to Windows Azure and SQL Azure.  The original application includes a Microsoft SQL Server 2008 database.   You need to recommend an approach for ensuring that the database migrates successfully toSQL Azure.  Which two actions should you recommend？（）

• A、 Remove all clustered indexes from the database.
• B、 Remove all dependencies on the Microsoft Distributed Transaction Coordinator （MSDTC） from the application.
• C、 Use SSL and SQL authentication to connect to the database.
• D、 Use SSL and Windows authentication to connect to the database.

第16题：

You create Windows Forms applications by using the .NET Framework 3.5. You plan to use a setup project to deploy a new Windows Forms application.The application uses a component that requires the Microsoft NET Framework 1.1.You need to create a launch condition so that the application can be deployed on client computers.   What should you do？（）

• A、Use the Depth property.
• B、Use the Version property.
• C、Use the MinVersion property.
• D、Use the ComponentID property.

第17题：

You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. The application resides on a server named ContosoTest that runs Microsoft IIS 5.0.  You use a computer named ContosoDev to log on to the Contoso.com domain with an account named ContosoUser.  The ContosoTest and ContosoDev servers are members of the Contoso.com domain. You need to set up the appropriate permission for remote debugging.  What should you do？（）

• A、Set the Remote Debugging Monitor to use Windows Authentication. 
• B、Add the ContosoUser account to the domain Administrators group.
• C、Add the ContosoUser account to the local Administrators group on the ContosoTest server. 
• D、Change the ASP.NET worker process on the ContosoTest server to run as the local Administrator account.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：