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

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

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

Exam question from Amazon's AWS Certified Solutions Architect - Associate SAA-C02

Question #: 355
Topic #: 1

[All AWS Certified Solutions Architect - Associate SAA-C02 Questions]

A company stores 200 GB of data each month in Amazon S3. The company needs to perform analytics on this data at the end of each month to determine the number of items sold in each sales region for the previous month.
Which analytics strategy is MOST cost-effective for the company to use?

A. Create an Amazon Elasticsearch Service (Amazon ES) cluster. Query the data in Amazon ES. Visualize the data by using Kibana.
B. Create a table in the AWS Glue Data Catalog. Query the data in Amazon S3 by using Amazon Athena. Visualize the data in Amazon QuickSight.
C. Create an Amazon EMR cluster. Query the data by using Amazon EMR, and store the results in Amazon S3. Visualize the data in Amazon QuickSight.
D. Create an Amazon Redshift cluster. Query the data in Amazon Redshift, and upload the results to Amazon S3. Visualize the data in Amazon QuickSight.

Show Suggested Answer

Suggested Answer: B 🗳️

by dmscountera at March 11, 2021, 5:29 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

syu31svc

Highly Voted 3 years, 10 months ago

I would go for B A is definitely out as ES is for data visualization not querying of data C and D are more costly than B; EMR and Redshfit operate at a higher compute level than Athena

upvoted 47 times

massyg

3 years, 9 months ago

ES have SQL support. I don't know if it is A or B https://docs.aws.amazon.com/it_it/elasticsearch-service/latest/developerguide/sql-support.html

upvoted 3 times

...

nickname_03042021

3 years, 9 months ago

Amazon Elasticsearch Service supports more than 40 SQL functions, data types, and commands, including direct export to CSV and query translation from SQL to the Elasticsearch DSL. You can run SQL queries against your domains with the built-in REST API and the Kibana Dev Console https://aws.amazon.com/about-aws/whats-new/2019/05/amazon-elasticsearch-service-sql-support/#:~:text=Amazon%20Elasticsearch%20Service%20supports%20more,and%20the%20Kibana%20Dev%20Console.

upvoted 2 times

...

done7

3 years, 8 months ago

S3> Glue>Athena>QuickSight Read the raw data from S3, massage the data (ETL), query the data using SQL and show the results in QuickSight

upvoted 11 times

...

dmscountera

Highly Voted 3 years, 10 months ago

B. Create a table in the AWS Glue Data Catalog. Query the data in Amazon S3 by using Amazon Athena. Visualize the data in Amazon QuickSight.

upvoted 15 times

noahsark

3 years, 9 months ago

agree with B... https://aws.amazon.com/blogs/big-data/harmonize-query-and-visualize-data-from-various-providers-using-aws-glue-amazon-athena-and-amazon-quicksight/

upvoted 6 times

naveenagurjara

3 years, 1 month ago

WHy not A?

upvoted 2 times

ProtonUser

3 years ago

Do you really believe AWS would consider proposing open source applications when they have similar offerings? They would not suggest using Kibana when AWS offers Quicksight.

upvoted 4 times

miles3719

2 years, 11 months ago

^^ Exactly right

upvoted 1 times

...

qax2022

Most Recent 2 years, 10 months ago

Selected Answer: B

exact the same method in my previous job.

upvoted 1 times

...

queen101

2 years, 12 months ago

We need Amazon Glue, Athenna and Quicksight. BBBBBB

upvoted 1 times

...

3 years, 4 months ago

I will go with B AWS Glue - Extract, transform, and load service that is Useful for preparing and transforming data for analytics Amazon Athena is a Serverless query service to perform analytics against S3 objects QuickSight - is a cloud-scale business intelligence service that you can use to deliver easy-to-understand insights to the people who you work with, wherever they are

upvoted 3 times

...

timcheuk

3 years, 4 months ago

Selected Answer: A

A is working and the cheapest. because ES and kibana is opensource. But you need to convert the data in S3 to ES index using logstash or other method.

upvoted 2 times

...

3 years, 7 months ago

also for me is B S3> Glue>Athena>QuickSight Read the raw data from S3, massage the data (ETL), query the data using SQL and show the results in QuickSight

upvoted 1 times

...

done7

3 years, 8 months ago

• Point Glue at this data and build a catalog, a structure for that data. • Athena takes that data that Glue has structured and run queries on it without having to load it into that database. • visualize this data with Quick Sight

upvoted 1 times

...

manan728

3 years, 8 months ago

This question was on my test that I passed on Nov 20 2021. I picked B. Roughly about half of the questions are from this 500 examtopics dump. But other half were unheard of new and lengthy ones in my test. Some of those questions had similarities but had twisted options. Good luck ya'll.

upvoted 7 times

anil101

3 years, 8 months ago

Hi, is there any dump/any website where we can get re-meaning half of question. practicing hard as planning to write exam next month

upvoted 1 times

...

Konglao

3 years, 8 months ago

if you passed it, then its B, am writing on Dec 3rd, and practicing hard, i'd love the best prep links, thanks

upvoted 4 times

...

Load full discussion...