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?()
第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? ()
第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?()
第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.
第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?()
第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?()
第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?()
第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?()
第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.
第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?()
第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?()