Independence Day Deal! Unlock 25% OFF Today – Limited-Time Offer - Ends In 00:00:00 Coupon code: SAVE25

- Free Preparation Discussions

Huawei Exam H13-922 Topic 1 Question 65 Discussion

Actual exam question for Huawei's H13-922 exam

Question #: 65
Topic #: 1

[All H13-922 Questions]

(Multiple choices). The following description about the selection of the distribution column is correct?

ANormally, the primary key of the table is selected as the distribution column.

BColumns with fewer values are suitable as distribution columns, which can ensure that the data distribution is relatively concentrated.

CThe filter condition of the query is name = 'wang five', so the name column should be used as the distribution column.

DJoin conditions in queries are more suitable as distribution columns.

Show Suggested Answer

Suggested Answer: A, D

by Isreal at May 01, 2024, 01:56 PM

Limited Time Offer

25%

Off

Get Premium H13-922 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Lezlie

1 years ago

Agree, B doesn't ensure balanced distribution. I'll probably choose A or D.

upvoted 0 times

...

Valentin

1 years ago

Option B seems incorrect. Fewer values could cause data skew.

upvoted 0 times

...

Allene

1 years ago

I'm not sure about C. Using 'name' as a distribution column might not be typical.

upvoted 0 times

...

Yolande

1 years ago

But what about option D? Join conditions seem relevant for performance.

upvoted 0 times

...

Vallie

1 years ago

Me too. I think option A is usually correct, primary keys are stable.

upvoted 0 times

...

Lezlie

1 years ago

I found this question about distribution columns tricky.

upvoted 0 times

...

az-700 pass4success az-104 200-301 200-201 cissp 350-401 350-201 350-501 350-601 350-801 350-901 az-720 az-305 pl-300

Warning: Cannot modify header information - headers already sent by (output started at /pass.php:70) in /pass.php on line 77