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 n

题目

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.
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

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.

正确答案:C

第2题:

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.

正确答案:B

第3题:

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.


参考答案:A, C, F

第4题:

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.

正确答案:C

第5题:

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.

正确答案:A,C

第6题:

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.

正确答案:D

第7题:

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 failover
  • B、Configure shared server
  • C、Enable database failover
  • D、Enable connect-time failover
  • E、Enable Transparent Application Failover (TAF)

正确答案:D

第8题:

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.


参考答案:B

第9题:

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.

正确答案:B

第10题:

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. 

正确答案:B

更多相关问题