ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Big Data - Specialty All Questions

View all questions & answers for the AWS Certified Big Data - Specialty exam
Go to Exam

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

Exam question from Amazon's AWS Certified Big Data - Specialty
Question #: 6
Topic #: 1
[All AWS Certified Big Data - Specialty Questions]

An administrator needs to design a strategy for the schema in a Redshift cluster. The administrator needs to determine the optimal distribution style for the tables in the Redshift schema.
In which two circumstances would choosing EVEN distribution be most appropriate? (Choose two.)

  • A. When the tables are highly denormalized and do NOT participate in frequent joins.
  • B. When data must be grouped based on a specific key on a defined slice.
  • C. When data transfer between nodes must be eliminated.
  • D. When a new table has been loaded and it is unclear how it will be joined to dimension.
Show Suggested Answer Hide Answer
Suggested Answer: BD 🗳️
by mattyb123 at Aug. 6, 2019, 9:53 a.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

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
mattyb123
Highly Voted 3 years, 8 months ago
I think it should be A & D. B is describing Key style
upvoted 17 times
...
Debi_mishra
Most Recent 3 years, 7 months ago
A &D . Not sure how B is correct
upvoted 1 times
...
san2020
3 years, 7 months ago
my selection A,D
upvoted 2 times
...
kalpanareddy
3 years, 7 months ago
A,D is correct reference: https://docs.aws.amazon.com/redshift/latest/dg/c_choosing_dist_sort.html
upvoted 1 times
...
kalpanareddy
3 years, 7 months ago
A & D--EVEN distribution is appropriate when a table does not participate in joins or when there is not a clear choice between KEY distribution and ALL distribution.
upvoted 1 times
...
jay1ram2
3 years, 7 months ago
A&D. This site contains lot of bad default answers. Thanks for these discussions. They provide much-needed corrections.
upvoted 1 times
...
michelleY
3 years, 7 months ago
A,D for sure.
upvoted 1 times
...
WWODIN
3 years, 8 months ago
AD seems right
upvoted 1 times
...
viduvivek
3 years, 8 months ago
A & D are correct. Amazon Redshift EVEN distribution : The leader node distributes the rows across the slices in a round-robin fashion, regardless of the values in any particular column. EVEN distribution is appropriate when a table does not participate in joins or when there is not a clear choice between KEY distribution and ALL distribution. Refer : https://docs.aws.amazon.com/redshift/latest/dg/c_choosing_dist_sort.html
upvoted 2 times
...
M2
3 years, 8 months ago
A & D is correct as the rest 2 doesnt apply to Even distribution
upvoted 1 times
...
bigdatalearner
3 years, 8 months ago
A and D are the right answers for this question . because when you are not sure about data you can choose even and when no more joins are required
upvoted 1 times
...
gonda
3 years, 8 months ago
A & D plase!
upvoted 1 times
exams
3 years, 8 months ago
I also think AD
upvoted 1 times
...
...
Jialu
3 years, 8 months ago
a,d is the correct answer
upvoted 1 times
...
jlpl
3 years, 8 months ago
a d are right
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel