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

Exam AWS Certified Solutions Architect - Associate SAA-C02 All Questions

View all questions & answers for the AWS Certified Solutions Architect - Associate SAA-C02 exam
Go to Exam

Exam AWS Certified Solutions Architect - Associate SAA-C02 topic 1 question 448 discussion

Exam question from Amazon's AWS Certified Solutions Architect - Associate SAA-C02
Question #: 448
Topic #: 1
[All AWS Certified Solutions Architect - Associate SAA-C02 Questions]

A company is using Amazon Redshift for analytics and to generate customer reports. The company recently acquired 50 TB of additional customer demographic data. The data is stored in .csv files in Amazon S3. The company needs a solution that joins the data and visualizes the results with the least possible cost and effort.
What should a solutions architect recommend to meet these requirements?

  • A. Use Amazon Redshift Spectrum to query the data in Amazon S3 directly and join that data with the existing data in Amazon Redshift. Use Amazon QuickSight to build the visualizations.
  • B. Use Amazon Athena to query the data in Amazon S3. Use Amazon QuickSight to join the data from Athena with the existing data in Amazon Redshift and to build the visualizations.
  • C. Increase the size of the Amazon Redshift cluster, and load the data from Amazon S3. Use Amazon EMR Notebooks to query the data and build the visualizations in Amazon Redshift.
  • D. Export the data from the Amazon Redshift cluster into Apache Parquet files in Amazon S3. Use Amazon Elasticsearch Service (Amazon ES) to query the data. Use Kibana to visualize the results.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by henry_x at May 31, 2021, 11:38 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
reliquary
Highly Voted 3 years, 7 months ago
this appeared in my exam today (3 Jun 2021) i picked A
upvoted 43 times
madatt
3 years, 7 months ago
recommendations on which questions to start from? 200 and up?
upvoted 9 times
miles3719
2 years, 9 months ago
or from 1 through to 577?
upvoted 1 times
...
...
...
sic6sic
Highly Voted 3 years, 7 months ago
Yep, I think it's A. AWS Redshift Spectrum is a feature that comes automatically with Redshift. It can execute SQL queries on CSV files that are stored in S3 using AWS Redshift Spectrum and the EXTERNAL command. And then add Amazon QuickSight for visualization.
upvoted 16 times
...
BECAUSE
Most Recent 1 year, 11 months ago
Selected Answer: A
A is the answer
upvoted 1 times
...
jw1806
2 years, 7 months ago
Selected Answer: A
answer is A, I do it in my job.
upvoted 1 times
...
queen101
2 years, 9 months ago
AAAAAAAAAAA
upvoted 1 times
...
marklovesaws143
2 years, 9 months ago
Selected Answer: A
AAAAAAAAAAAA
upvoted 2 times
...
saifeddine92
3 years, 2 months ago
Selected Answer: A
A for sure
upvoted 1 times
...
Eswarshiv
3 years, 5 months ago
do I need to cover all 514 questions?
upvoted 11 times
azi_2021
3 years ago
577 by now
upvoted 3 times
miles3719
2 years, 9 months ago
I would suspect so. I have gone through the stephane udemy course, now realising that wading through the 577 questions here and looking at every discussion may take just as long if not longer. The exam is deprecated in 2 weeks. Better get reading hey? :)
upvoted 1 times
...
...
...
FF11
3 years, 5 months ago
Use Amazon Redshift Spectrum to query data in Amazon S3 files without having to load the data into Amazon Redshift tables. Amazon Redshift provides SQL capability designed for fast online analytical processing (OLAP) of very large datasets that are stored in both Amazon Redshift clusters and Amazon S3 data lakes. https://docs.aws.amazon.com/redshift/latest/gsg/concepts-diagrams.html
upvoted 4 times
...
Xfo
3 years, 6 months ago
I think is B. The cuestion says.."with least possible cost and effort". Athena is serverless, so there is no infrastructure to manage, and you pay only for the queries that you run. RedShift Spectrum is not serverless as it requires a RedShift cluster which is based on EC2 instances. So Athena is cheaper..
upvoted 1 times
gargaditya
3 years, 5 months ago
Quicksight cannot be used for joining/it is used to build visualizations.
upvoted 2 times
...
rlnd2000
3 years, 6 months ago
You are right but the Redshift cluster is part of the infrastructure, read the question "...A company is using Amazon Redshift for analytics..." in that case I think spectrum is the solution I think.
upvoted 3 times
farciarz212
3 years, 5 months ago
I don't think Athena can handle this amount of work. I always think about Redshift as "Athena on steroids" similar to elasticache and DynamoDB
upvoted 5 times
...
...
...
Gats
3 years, 7 months ago
A. https://docs.aws.amazon.com/redshift/latest/dg/c-using-spectrum.html https://searchaws.techtarget.com/definition/Amazon-Redshift-Spectrum
upvoted 4 times
Gats
3 years, 7 months ago
Redshift Spectrum vs. Athena Amazon Athena is similar to Redshift Spectrum, though the two services typically address different needs. An analyst that already works with Redshift will benefit most from Redshift Spectrum because it can quickly access data in the cluster and extend out to infrequently accessed, external tables in S3. It's also better suited for fast, complex queries on multiple data sets. Alternatively, Athena is a simpler way to run interactive, ad hoc queries on data stored in S3. It doesn't require any cluster management, and an analyst only needs to define a table to make a standard SQL query.
upvoted 12 times
...
...
AnuhyaTech
3 years, 7 months ago
answer is A
upvoted 6 times
...
henry_x
3 years, 7 months ago
A is correct. Amazon Redshift Spectrum is external table in Redshift.
upvoted 5 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago