Zend Exam 200-710 Topic 6 Question 29 Discussion

Actual exam question for Zend's 200-710 exam

Question #: 29
Topic #: 6

[All 200-710 Questions]

An unbuffered database query will: (Choose 2)

AReturn the first data faster

BReturn all data faster

CFree connection faster for others scripts to use

DUse less memory

Show Suggested Answer

Suggested Answer: B

by Arminda at May 08, 2022, 03:47 AM

Limited Time Offer

25%

Off

Get Premium 200-710 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Virgilio

12 days ago

Wait, if it frees the connection faster, doesn't that mean it also returns all the data faster? I'm so confused now. Maybe I'll just guess and hope for the best.

upvoted 0 times

...

Luann

12 days ago

But wouldn't option D also be correct? Using less memory is important for efficiency.

upvoted 0 times

...

Alysa

13 days ago

I always thought unbuffered queries were faster overall, not just for the first bit. But I guess B is out then. Hmm, I'll go with A and C.

upvoted 0 times

...

Bong

14 days ago

I agree with Simona, option A makes sense because it doesn't wait to fetch all data before returning.

upvoted 0 times

...

A and D seem like the correct answers. An unbuffered query doesn't wait to load all the data before returning it, which means you get the first bit faster and use less memory. Perfect for when you just need the top result.

upvoted 0 times

...

Simona

21 days ago

I think an unbuffered database query will return the first data faster.

upvoted 0 times

...

Zend Exam 200-710 Topic 6 Question 29 Discussion

Contribute your Thoughts:

Virgilio

Luann

Alysa

Bong

Fausto

Simona