exam questions

Exam 98-361 All Questions

View all questions & answers for the 98-361 exam

Exam 98-361 topic 1 question 87 discussion

Actual exam question from Microsoft's 98-361
Question #: 87
Topic #: 1
[All 98-361 Questions]

Which three phrases are advantages of connection pooling? (Choose three.)

  • A. reduces time to create a connection
  • B. requires no configuration
  • C. reduces load on the server
  • D. improved scalability
  • E. improved performance
Show Suggested Answer Hide Answer
Suggested Answer: ADE 🗳️
E: In connection pooling, after a connection is created, it is placed in the pool and it is used over again so that a new connection does not have to be established.
D: Connection pooling often improves application performance, concurrency and scalability.
A: Connection pooling also cuts down on the amount of time a user must wait to establish a connection to the database.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Heicke
1 year, 8 months ago
D. improved scalability is right. It's used to close old connections and open new ones as needed, so more users can use the same limit of connections just by handling who is needed at the time.
upvoted 1 times
...
itexamsmicrosoft
2 years, 2 months ago
A, C, E
upvoted 3 times
...
TroyAnabolic
2 years, 5 months ago
I thought ACE too, I think we are right, from google "Establishing a connection to database is a costly process and has impact to the performance of application. To reduce this connection time to database a pool is maintained so that it can be re-used. " .. If it's expensive, it means that it's expensive on the server, and therefore connection pools is used to reduce server load.
upvoted 4 times
AltFsleep
8 months ago
It's expensive in terms of time and resources.With conection pooling you can have the same server load, but with reduced times, better scalability and better performance, so ADE.
upvoted 1 times
...
...
therealstgo
2 years, 8 months ago
I think the correct answers are A, C, and E
upvoted 3 times
...
ccoutinho
3 years, 1 month ago
By using connection pooling, won't the load on the server be reduced?
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago