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

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

IBM C1000-085 Exam - Topic 5 Question 97 Discussion

When choosing a distribution key for a large fact table, what is a valid choice?
A) any column used in table constraints
B) any column with low cardinality
C) a technical or surrogate key
D) any date column commonly used in queries

IBM C1000-085 Exam - Topic 5 Question 97 Discussion

Actual exam question for IBM's C1000-085 exam
Question #: 97
Topic #: 5
[All C1000-085 Questions]

When choosing a distribution key for a large fact table, what is a valid choice?

Show Suggested Answer Hide Answer
Suggested Answer: A

by Elden at May 16, 2026, 07:39 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Wei
30 days ago
I think option C, a technical or surrogate key, makes sense because it helps with joins and indexing.
upvoted 0 times
...

Save Cancel