IBM Exam C1000-065 Topic 10 Question 79 Discussion

Actual exam question for IBM's C1000-065 exam

Question #: 79
Topic #: 10

Which technique is most likely to improve query performance?

ASet the auto-sort property to maximum.

BSet the detail aggregation to 'Calculated' for measures.

CAvoid functions in filters.

DAdd more joins between queries.

Show Suggested Answer

Suggested Answer: B

by Mitsue at Jan 09, 2025, 04:10 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

2 days ago

I agree with Jonelle, functions in filters can slow down the query.

upvoted 0 times

...

6 days ago

Adding more joins between queries? What is this, a game of SQL Tetris? D is not the way to go, my friend.

upvoted 0 times

...

6 days ago

I think avoiding functions in filters would improve query performance.

upvoted 0 times

...

9 days ago

Avoiding functions in filters? That's a no-brainer! I'm going with C on this one.

upvoted 0 times

...