Exam AWS Certified Big Data - Specialty topic 1 question 27 discussion

Exam question from Amazon's AWS Certified Big Data - Specialty

Question #: 27
Topic #: 1

[All AWS Certified Big Data - Specialty Questions]

A customer needs to determine the optimal distribution strategy for the ORDERS fact table in its Redshift schema. The ORDERS table has foreign key relationships with multiple dimension tables in this schema.
How should the company determine the most appropriate distribution key for the ORDERS table?

A. Identify the largest and most frequently joined dimension table and ensure that it and the ORDERS table both have EVEN distribution.
B. Identify the largest dimension table and designate the key of this dimension table as the distribution key of the ORDERS table.
C. Identify the smallest dimension table and designate the key of this dimension table as the distribution key of the ORDERS table.
D. Identify the largest and the most frequently joined dimension table and designate the key of this dimension table as the distribution key of the ORDERS table.

Show Suggested Answer

Suggested Answer: D 🗳️
Reference:
https://aws.amazon.com/blogs/big-data/optimizing-for-star-schemas-and-interleaved-sorting-on- amazon-redshift/

by Hitu at Sept. 8, 2019, 5:17 p.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

san2020

Highly Voted 3 years, 8 months ago

my selection D

upvoted 5 times

...

practicioner

Most Recent 3 years, 8 months ago

I'm sure D is a right choice

upvoted 1 times

...

VB

3 years, 9 months ago

it is D

upvoted 2 times

...

Hitu

3 years, 9 months ago

A or D? In a typical star schema, the fact table has foreign key relationships with multiple dimension tables, so you need to choose one of the dimensions. You would choose the foreign key for the largest frequently joined dimension as a distribution key in the fact table and the primary key in the dimension table. Make sure that the distribution keys chosen result in relatively even distribution for both tables, and if the distribution is skewed, use a different dimension. Then analyze the remaining dimensions to determine if a distribution style of ALL, KEY, or EVEN is appropriate.

upvoted 3 times

exams

3 years, 9 months ago

I think D

upvoted 1 times

...

Hitu

3 years, 9 months ago

https://aws.amazon.com/blogs/big-data/optimizing-for-star-schemas-and-interleaved-sorting-on-amazon-redshift/

upvoted 2 times

...