IBM Exam C1000-085 Topic 7 Question 75 Discussion

Actual exam question for IBM's C1000-085 exam

Question #: 75
Topic #: 7

[All C1000-085 Questions]

What are two important factors to consider when selecting a distribution key?

Anot Nullable constraint

Bcolumns used for filters

Cdistinct values

Dcolumns used for joins

Etable constraints

Show Suggested Answer

Suggested Answer: A

by Alease at Dec 08, 2024, 11:51 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Vashti

2 days ago

I also consider columns used for joins when selecting a distribution key.

upvoted 0 times

...

Evan

3 days ago

I agree with Anthony. Those factors can help optimize query performance.

upvoted 0 times

...

Eun

4 days ago

I think B) columns used for filters and D) columns used for joins are the correct answers. The distribution key should be based on the columns commonly used in queries.

upvoted 0 times

...

Anthony

12 days ago

I think columns used for filters and distinct values are important factors.

upvoted 0 times

...