Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25

- Free Preparation Discussions

IBM C1000-065 Exam - Topic 4 Question 102 Discussion

Actual exam question for IBM's C1000-065 exam

Question #: 102
Topic #: 4

[All C1000-065 Questions]

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 Irving at Jun 22, 2026, 05:56 PM

Limited Time Offer

25%

Off

Get Premium C1000-065 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Junita

2 days ago

A maximum auto-sort might actually slow things down, not sure about that one.

upvoted 0 times

...

Alita

7 days ago

I disagree, B could also help a lot with performance.

upvoted 0 times

...

Gilbert

12 days ago

C is definitely the way to go! Avoiding functions in filters speeds things up.

upvoted 0 times

...

Micah

17 days ago

I feel like setting the auto-sort property to maximum could help, but I also remember it might depend on the dataset size.

upvoted 0 times

...

Kiley

22 days ago

Adding more joins seems counterintuitive for performance, but I can't recall if that was explicitly covered in our sessions.

upvoted 0 times

...

Lili

28 days ago

I remember a practice question that mentioned the importance of minimizing complexity in queries, which makes me lean towards option C.

upvoted 0 times

...

Serita

1 month ago

I think avoiding functions in filters might be the best choice, but I'm not entirely sure how that impacts performance directly.

upvoted 0 times

...