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

Exam AWS Certified Data Analytics - Specialty All Questions

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

Exam AWS Certified Data Analytics - Specialty topic 1 question 36 discussion

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

A company's marketing team has asked for help in identifying a high performing long-term storage service for their data based on the following requirements:
✑ The data size is approximately 32 TB uncompressed.
✑ There is a low volume of single-row inserts each day.
✑ There is a high volume of aggregation queries each day.
✑ Multiple complex joins are performed.
✑ The queries typically involve a small subset of the columns in a table.
Which storage service will provide the MOST performant solution?

  • A. Amazon Aurora MySQL
  • B. Amazon Redshift
  • C. Amazon Neptune
  • D. Amazon Elasticsearch
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by Paitan at Sept. 8, 2020, 4:42 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
Paitan
Highly Voted 3 years, 9 months ago
Redhift for sure.
upvoted 28 times
...
jove
Highly Voted 3 years, 9 months ago
The simplest question in the exam.
upvoted 9 times
...
kondi2309
Most Recent 1 year, 4 months ago
Selected Answer: B
Amazon Redshift meets all the requirements.
upvoted 1 times
...
pk349
2 years, 2 months ago
B: I passed the test
upvoted 1 times
...
cloudlearnerhere
2 years, 8 months ago
Selected Answer: B
Correct answer is B as Redshift as it can be used for OLAP processing and meets all the requirements. Amazon Redshift uses SQL to analyze structured and semi-structured data across data warehouses, operational databases, and data lakes using AWS-designed hardware and machine learning to deliver the best price-performance at any scale. Option A is wrong as Amazon Aurora MySQL is ideal for OLTP solutions and not OLAP. Option C s wrong as Amazon Neptune is a fast, reliable, fully-managed graph database service that makes it easy to build and run applications. Option D is wrong as Amazon Elasticsearch would not allow complex queries.
upvoted 5 times
...
Arka_01
2 years, 9 months ago
Selected Answer: B
The scenario here is indicating for a columnar data storage. So the answer will be Amazon Redshift.
upvoted 1 times
...
rocky48
2 years, 11 months ago
Selected Answer: B
B is the right answer
upvoted 1 times
...
AWSRanger
3 years, 2 months ago
Selected Answer: B
B is correct
upvoted 1 times
...
sanpak
3 years, 6 months ago
why not D ? elastic search, search in subset of column works better in ES...
upvoted 1 times
...
Billhardy
3 years, 8 months ago
Ans B
upvoted 1 times
...
Shraddha
3 years, 8 months ago
Ans B A = wrong, Aurora for OLTP not OLAP. C = wrong, graph database not relevant. D = wrong, complex joins in ES are expensive.
upvoted 4 times
...
lostsoul07
3 years, 9 months ago
B is the right answer
upvoted 3 times
...
BillyC
3 years, 9 months ago
My answer is B
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