Distribution Flashcards by Bethany Marshall

Q

Distributes rows by using a deterministic hash function

A

Hash

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Best for querying (Large table)

Distribution

A

Hash

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Distributes rows evenly

A

Round robin

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Speeds up loading data

A

Round robin

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Does not use distribution column

A

Round robin

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Full copy of the table across each node

A

Replicated

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Best for small tables

A

Replicated

How well did you know this?

1

Not at all

2

3

4

5

Perfectly