Huawei Exam H13-922 Topic 1 Question 67 Discussion

Actual exam question for Huawei's H13-922 exam

Question #: 67
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 Tijuana at May 19, 2024, 09:51 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Glory

4 months ago

Option A seems like the obvious choice to me. Why reinvent the wheel when the primary key is a tried and true distribution column?

upvoted 0 times

...

Eleni

5 months ago

Option D sounds interesting, but I'm not sure it's the most efficient approach. Wouldn't the join conditions make the data distribution more complex?

upvoted 0 times

Lina

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

...

Helene

4 months ago

Option D sounds interesting, but I'm not sure it's the most efficient approach. Wouldn't the join conditions make the data distribution more complex?

upvoted 0 times

...

Lorriane

4 months ago

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

upvoted 0 times

...

Amira

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

...

Minna

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

...

Dottie

4 months ago

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

upvoted 0 times

...

Angella

4 months ago

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

upvoted 0 times

...

Ryann

5 months ago

Haha, option C is a joke, right? Using the filter condition as the distribution column? That's like putting the cart before the horse!

upvoted 0 times

Deandrea

4 months ago

User 2: Definitely not, the distribution column should be carefully chosen for better performance.

upvoted 0 times

...

Dusti

4 months ago

User 1: Yeah, option C doesn't make any sense.

upvoted 0 times

...

Paul

5 months ago

I think option B is the best choice here. Columns with fewer values will help distribute the data more evenly across the nodes.

upvoted 0 times

Fannie

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

...

Joaquin

4 months ago

I agree, option B makes sense for better data distribution.

upvoted 0 times

...

Margo

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

...

Maricela

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

...

Virgie

4 months ago

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

upvoted 0 times

...

Doretha

5 months ago

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

upvoted 0 times

...