exam questions

Exam AWS Certified Cloud Practitioner All Questions

View all questions & answers for the AWS Certified Cloud Practitioner exam

Exam AWS Certified Cloud Practitioner topic 1 question 470 discussion

Exam question from Amazon's AWS Certified Cloud Practitioner
Question #: 470
Topic #: 1
[All AWS Certified Cloud Practitioner Questions]

A company stores several terabytes of data in an Amazon S3 bucket. The company needs to query the data by using standard SQL and does not want to set up infrastructure.

Which AWS service should the company use to meet these requirements?

  • A. Amazon RDS
  • B. Amazon Redshift
  • C. Amazon Athena
  • D. Amazon EC2
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

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
NotMeAnyWay
Highly Voted 2 years, 7 months ago
Selected Answer: C
C. Amazon Athena Amazon Athena is a serverless, interactive query service that makes it easy to analyze data stored in Amazon S3 using standard SQL. It allows the company to query data stored in the S3 bucket without having to set up any infrastructure, making it a cost-effective option. Athena uses Presto, an open-source SQL query engine, to execute the queries, and it can handle large amounts of data, so it's suitable for the company's needs. Additionally, Athena is integrated with other AWS services such as Glue, QuickSight, and CloudTrail, which can help the company to analyze, visualize, and monitor their data.
upvoted 7 times
...
Aliciuzza
Highly Voted 2 years, 8 months ago
Selected Answer: C
I think C: Amazon Athena "Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to setup or manage, and you can start analyzing data immediately."
upvoted 6 times
...
Pranava_GCP
Most Recent 2 years ago
Selected Answer: C
C. Amazon Athena "Athena is an interactive analytics service that makes it simple to analyze data in Amazon Simple Storage Service (S3) using Python. Athena is serverless, so there is no infrastructure to set up or manage, and you can start analyzing data immediately. You don’t even need to load your data into Athena; it works directly with data stored in Amazon S3. " https://aws.amazon.com/athena/faqs/?nc=sn&loc=6
upvoted 1 times
...
Gulsah
2 years ago
Selected Answer: C
Answer is C. Amazon Athena features: Easy to query, just use standard SQL
upvoted 1 times
...
sri073
2 years, 1 month ago
Selected Answer: C
Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to setup or manage, and you can start analyzing data immediately.
upvoted 2 times
...
kk9550
2 years, 2 months ago
Selected Answer: C
Amazon Athena
upvoted 2 times
...
fhernandez
2 years, 2 months ago
C is correct -
upvoted 2 times
...
Amycert
2 years, 5 months ago
Selected Answer: C
athena according to chatgpt
upvoted 2 times
...
Saif93
2 years, 6 months ago
Selected Answer: C
C is the answer.
upvoted 2 times
...
dean192837
2 years, 7 months ago
Selected Answer: C
c. athena for sql s3
upvoted 2 times
...
dangji
2 years, 8 months ago
Selected Answer: C
C is correct. data stores in S3, and needs to query the data by using SQL.
upvoted 2 times
...
AF_1221
2 years, 8 months ago
Its C It says no setup infrastructure RDS its infrastructure need compute but Athena is for query
upvoted 2 times
...
saoirse98
2 years, 8 months ago
Selected Answer: C
C: Amazon Athena because it specifically mentions querying using standard SQL?
upvoted 2 times
...
Zonci
2 years, 8 months ago
Selected Answer: A
You can now create Amazon RDS for SQL Server database instances with up to 16TB of storage, up from 4TB. The new storage limit is available when using the Provisioned IOPS and General Purpose (SSD) storage types. In addition, the range for the IOPS to Storage (GB) Ratio has been increased from 10:1 to 50:1.
upvoted 2 times
...
RichC
2 years, 8 months ago
Redshift is correct?
upvoted 1 times
Zonci
2 years, 8 months ago
No. Amazon Redshift is a service by AWS that provides a fully managed and scaled for petabyte warehousing
upvoted 1 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
Loading ...