You are developing an application that connects to a Microsoft SQL Server database using the SqlConnection object. Your connection objects are being pooled. As the pool fills up, connection requests are queued. Some connection requests are rejected. You need to ensure that the application releases connections back to the pool as soon as possible. Also, you need to decrease the likelihood that connection requests will be rejected. Which three actions should you perform?（）A、Ensure that the Close method is called on each connection object after it has finishedexecuting.B、Ensure that each connection object is left open after it has finished executing.C、Increase the Max Pool Size value inside the connection string.D、Increase the Min Pool Size value inside the connection string.E、Increase the Connection Lifetime value inside the connection string.F、Increase the value of the ConnectionTimeout property of the SqlConnection object.
You are developing an application that connects to a Microsoft SQL Server database using the SqlConnection object. Your connection objects are being pooled. As the pool fills up, connection requests are queued. Some connection requests are rejected. You need to ensure that the application releases connections back to the pool as soon as possible. Also, you need to decrease the likelihood that connection requests will be rejected. Which three actions should you perform?（）
- A、Ensure that the Close method is called on each connection object after it has finished executing.
- B、Ensure that each connection object is left open after it has finished executing.
- C、Increase the Max Pool Size value inside the connection string.
- D、Increase the Min Pool Size value inside the connection string.
- E、Increase the Connection Lifetime value inside the connection string.
- F、Increase the value of the ConnectionTimeout property of the SqlConnection object.
相关考题：
You are developing an application that connects to a Microsoft SQL Server database using the SqlConnection object. Your connection objects are being pooled. As the pool fills up, connection requests are queued. Some connection requests are rejected. You need to ensure that the application releases connections back to the pool as soon as possible. Also, you need to decrease the likelihood that connection requests will be rejected.Which three actions should you perform?（）A. Ensure that the Close method is called on each connection object after it has finished executing.B. Ensure that each connection object is left open after it has finished executing.C. Increase the Max Pool Size value inside the connection string.D. Increase the Min Pool Size value inside the connection string.E. Increase the Connection Lifetime value inside the connection string.F. Increase the value of the ConnectionTimeout property of the SqlConnection object.
Exhibit: You are developing a Web application. The Web application uses a GridView control to display data. You build your Web Forms for the Web application by dragging and dropping tables from the Data Connections tree in Server Explorer. You need to add a connection to your data by using the Add Connection dialog box as shown in the exhibit. During the process, you need to configure the .NET Data Provider that you use to create the data source objects. What should you do?（）A. Right-click the connection, and click Properties. Modify the Provider property of the data connection.B. Click the Change button, and change the data provider for the selected data source.C. Click the Advanced button, and change the Data Source property to the target provider.D. Click the Advanced button, and change the Application Name property to the target provider.
You are the network administrator for Company.You install Windows 2000 Professional on your computer at home. Your computer contains threemodems， each connected to a separate phone line. You create a new dial-up connection to connect toCompany’s remote access server. You configure the connection to dial up all three devices. You start thedial-up connection and connect to the remote access server. You notice that only one of the modems isconnected to the remote access server.You want to use as many modems as possible to make a single connection to the remote access server.What should you do？ （）A、Configure the dial-up connection to sue a SLIP connection.B、Configure all three modems to use the same phone line.C、Configure the remote access server to enable multi-link.D、Configure the dial-up connection to only dial two of the three modems.E、Configure the dial-up connection to Enable LCP extensions.
You create a new dial-up connection to connect to the Internet. You configure the Internet connection to enable Internet Connection Sharing. However， you cannot see or connect to any shared resource on your network. What should you do？（）A、Configure the dial-up connection to disable shared access.B、Configure the dial-up connection to disable on-demand dialing.C、Disable data encryption in the new dial-up connection.D、Use the ipconfig command to release and renew your network TCP/P address.
A customer needs to ensure that the number of threads servicing an application does not exceed the number of database connections available to the application. What step must you take to address this situation?（）A、Configure a Max Threads Constraint and add your application to the list of applications for the Constraint.B、Configure a Work Manager with a Maximum Threads Constraint tied to the Connection Pool and configuration your application to use the Work Manager.C、Configure a Work Manager with a Minimum Threads Constraint tied to the Connection Pool and configure your application to use the Work Manager.D、Configure a global MaxThreads constraint and target it to the server or clusters where your application is deployed.E、Configure the startup parameter "-Dwls-maxThreads" to be the same as the number of database connections configured.
You work as a database administrator for Supportcenter.cn. Client connection requests are failing because the listener is not responding. You want to forward client connect requests to another listener if one listener is not responding. How do you achieve this？（）A、Enable instance failoverB、Configure shared serverC、Enable database failoverD、Enable connect-time failoverE、Enable Transparent Application Failover （TAF）
A Windows Azure application connects to a SQL Azure database. Connections to the database are being dropped due to throttling. You need to recommend an approach for identifying the root cause of the problem. Which two actions should you recommend？（）A、 Use Dynamic Management Views to analyze performance issues.B、 Decrease the connection timeout in the database connection string.C、 Make sure the application is closing database connections that are not needed.D、 Use SQL Profiler to analyze performance issues by configuring it to connect to SQL Azure.
You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database， except when querying this data. You need to provide a way to query data from the application database. What should you？（）A、Configure a Linked Server connection to the application database.B、Write a query that uses an OPENDATASOURCE command.C、Write a query that uses an OPENQUERY command.D、Configure a Remote Server connection to the application database.
An application connects to a SQL Azure database. The application occasionally loses the connection to the SQL Azure database. You need to recommend an approach for reliably completing data access operations. What should you recommend？（） A、 Use Microsoft ADO.NET connection pooling.B、 Pass exceptions to the user interface layer.C、 Implement a retry policy in the data access layer.D、 Begin a transaction before each data access operation.
You are creating a dial-up connection for Internet access. The wizard cannot access the default Internet Service Providers （ISP） with either of the numbers provided. What is your alternate method for setting up the connection？（）A、Configure the dial-up connection to negotiate with the server using Challenge-Handshake Authentication Protocol (CHAP).B、You can choose the option to set up the Internet connection manually if you know the ISP's phone number and your account and password already.C、You need to provide a known IP address before attempting to connect to the ISP server.D、Your ISP is requiring Data Encryption. Configure the dial- up connection to use it.
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）；
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；"
You are creating a shared Internet connection on your Windows 2000 Professional computer. You want to enable other computers on the LAN to be able to access only HTTP and FTP sites on the Internet. What should you do?（）A、Configure your shared Internet connection to disable LCP extensions.B、Configure you shared Internet connection to disable on-demand dialing.C、Create an Internet Connection Sharing application type for HTTP to use remote server port 25.D、Create an Internet Connection Sharing application type for HTTP to use remote server port 80.E、Create an Internet Connection Sharing application type for FTP to use remote server port 21.F、Create an Internet Connection Sharing application type for FTP to use remote server port 72.
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；
You install Windows 2000 Professional on your computer at home. You create a new dial-up connection to connect to your company’s remote access server. You configure the connection to use both of your external modems and to use multilink to bind the modems together. You start the dial-up connection and connect to the remote access server. You notice that only one of the modems is connected to the remote access server. What should you do？（）A、Configure the dial-up connection to use a SLIP connection.B、Configure the company’s remote access server to accept multilink connections.C、Replace your modems with new modems that support multilink.D、Grant your user account multilink permission on the company’s remote access.
You want to configure your Windows 2000 Professional portable computer to use offline files. The files that you want to access offline include a large project file and some smaller personal files. Your portable computer is configured to connect to the network by using the dial up connection at scheduled times during day to automatically download your e-mail messages. You do not want to synchronize the project file when you connect to the network using the dial-up connection. What you should do?（）A、Configure the Synchronization Settings to perform a quick synchronization. B、Configure the Synchronization Settings to ask you before synchronizing items. C、Configure the Synchronization Settings to synchronize the project file only when using the LAN connection. Set synchronization for the personal files for both the LAN connection and your dial-up connection. D、Set the synchronization settings to synchronize the project file only when you log off the network. Set synchronization for the personnel files for both the LAN and dialup connection for logging on and logging off.
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.
You create a Web Form. The Web Form allows users to log on to a Web site. You implement the login logic using a Login control named Login1. The membership data for the application is stored in a SQL Express database in the App_Data directory. You need to configure your application so that the membership data is stored in a local Microsoft SQL Server database. You add the following code segment to the Web.config file. Which two additional actions should you perform?（）A、Use Aspnet_regsql.exe to create the Microsoft SQL Server database.B、Set Login1's MembershipProvider property to MySqlProviderConnection.C、Add the following code segment to the Web.config file.connectionStrings add name="MySqlProviderConnection" connectionString="valid connection string" //connectionStringsD、Add the following code segment to the Web.config file.appSettingsadd key="MySqlProviderConnection" value="valid connection string" //appSettingsE、In the ASP.NET configuration settings within IIS, ensure that Role Management Enabled is selected.F、Use the Web Site Administration Tool to select AspNetSqlMembershipProvider as the membership provider for your application.
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、 Create an exception handler for the connection-busy exception that is thrown on using a single SqlConnection object.C、 Run the two SqlDataReader objects by using a single SqlCommand object.D、 Enable Multiple Active Result Sets （MARS） in the connection string of the application.
You install Windows 2000 Professional on your portable computer. You create a new dial up connection to connect to your company’s remote access server. You connect to the remote access server by using the dial up connection. You can connect to the servers on the same segment as the remote access server. You cannot access the shared resources that are on the remote segments from the remote access server. What should you do？ （）A、Configure the company remote access server to accept multilink connections.B、Configure the TCP/IP program for the dial up connection to disable IP header compression.C、Configure the TCP/IP properties for the dial up connection to use the default gateway on theremote network.D、Grant your user account dial in permission on the company remote access server.
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A vendor company’s application is utilized， and the application is based on a proprietary database. Data is queried from the application database and the data is imported into a SQL Server 2005 database. A new OLE DB driver is offered by the application vendor， and the new OLE DB driver will be utilized when the application database is queried. According the company requirements， the connections between the SQL Server database and the application database is prohibited， except when this data is queried. You should think out a method to have data queried from the application database. Which action should be performed to achieve the goal？（）A、To achieve the goal， a Linked Server connection should be configured to the application database.B、To achieve the goal， a query should be written， and an OPENQUERY command is utilized by the query.C、To achieve the goal， a Remote Server connection to the application database should be configured.D、To achieve the goal， a query should be written， and an OPENDATASOURCE command is utilized by the query.
多选题You are creating a shared Internet connection on your Windows 2000 Professional computer. You want to enable other computers on the LAN to be able to access only HTTP and FTP sites on the Internet. What should you do?（）AConfigure your shared Internet connection to disable LCP extensions.BConfigure you shared Internet connection to disable on-demand dialing.CCreate an Internet Connection Sharing application type for HTTP to use remote server port 25.DCreate an Internet Connection Sharing application type for HTTP to use remote server port 80.ECreate an Internet Connection Sharing application type for FTP to use remote server port 21.FCreate an Internet Connection Sharing application type for FTP to use remote server port 72.
单选题You are creating a dial-up connection for Internet access. The wizard cannot access the default Internet Service Providers （ISP） with either of the numbers provided. What is your alternate method for setting up the connection？（）AConfigure the dial-up connection to negotiate with the server using Challenge-Handshake Authentication Protocol (CHAP).BYou can choose the option to set up the Internet connection manually if you know the ISP's phone number and your account and password already.CYou need to provide a known IP address before attempting to connect to the ISP server.DYour ISP is requiring Data Encryption. Configure the dial- up connection to use it.
单选题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 Create an exception handler for the connection-busy exception that is thrown on using a single SqlConnection object.C Run the two SqlDataReader objects by using a single SqlCommand object.D Enable Multiple Active Result Sets （MARS） in the connection string of the application.
单选题You work as a database administrator for Supportcenter.cn. Client connection requests are failing because the listener is not responding. You want to forward client connect requests to another listener if one listener is not responding. How do you achieve this？（）AEnable instance failoverBConfigure shared serverCEnable database failoverDEnable connect-time failoverEEnable Transparent Application Failover （TAF）
单选题You create a shared Internet connection on a Windows 2000 Professional computer. Your network has 10 users on the LAN. All of the users can connect to HTTP sites， FTP sites， and streaming audio content on the Internet. One of the computers on your LAN is running an FTP host application. Users on the Internet cannot connect to the FTP host on your network. What should you do？（）AConfigure the FTP host to accept incoming requests on service port 80.BConfigure an Internet Connection Sharing application type for FTP to use remote server port 23.CConfigure an Internet Connection Sharing service type for FTP use service port 21 on the FTP host computer.DConfigure an Internet Connection Sharing service type for FTP use service port 23 on the FTP host computer.
单选题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.