Huawei Exam H13-922 Topic 1 Question 70 Discussion

Actual exam question for Huawei's H13-922 exam

Question #: 70
Topic #: 1

(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 Ashanti at Jul 01, 2024, 05:42 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Caprice

5 months ago

I heard the distribution column is chosen by throwing darts at a board. At least, that's how I passed the last exam.

upvoted 0 times

...

Karina

5 months ago

I'm just going to eeny-meeny-miny-moe this one. Distributions are like socks - they either fit or they don't.

upvoted 0 times

Jerrod

4 months ago

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

upvoted 0 times

...

Skye

4 months ago

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

upvoted 0 times

...

Alishia

4 months ago

A) Normally, the primary key of the table is selected as the distribution column.

upvoted 0 times

...

Jamie

4 months ago

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

upvoted 0 times

...

Kaycee

5 months ago

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

upvoted 0 times

...

Glory

5 months ago

A) Normally, the primary key of the table is selected as the distribution column.

upvoted 0 times

...

Arminda

5 months ago

I believe D is not a good choice, join conditions should not be used as distribution columns.

upvoted 0 times

...

Kate

5 months ago

A is the way to go. The primary key is the obvious choice for the distribution column.

upvoted 0 times

Emogene

4 months ago

I agree, it makes sense to use the primary key for distribution.

upvoted 0 times

...

Jesus

5 months ago

A) Normally, the primary key of the table is selected as the distribution column.

upvoted 0 times

...

Barney

5 months ago

I'm going with D. Join conditions are often used to distribute data, so that makes the most sense to me.

upvoted 0 times

...

Desmond

5 months ago

C seems like a logical choice since the query is filtering on the name column. That should be the distribution column.

upvoted 0 times

Nakisha

4 months ago

D) Join conditions in queries are more suitable as distribution columns.

upvoted 0 times

...

Dulce

4 months ago

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

upvoted 0 times

...

Skye

4 months ago

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

upvoted 0 times

...

Malcom

5 months ago

A) Normally, the primary key of the table is selected as the distribution column.

upvoted 0 times

...

Catalina

5 months ago

I'm not sure, but I think A could also be a valid option.

upvoted 0 times

...

Desmond

5 months ago

I agree with Lili, columns with fewer values are better for distribution.

upvoted 0 times

...

Shaun

6 months ago

I think B is the correct answer. Columns with fewer values will ensure a more even data distribution across the nodes.

upvoted 0 times

Lajuana

5 months ago

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

upvoted 0 times

...

Alesia

5 months ago

A) Normally, the primary key of the table is selected as the distribution column.

upvoted 0 times

...

Lili

6 months ago

I think the correct answer is B.

upvoted 0 times

...