Exam AWS Certified Cloud Practitioner topic 1 question 239 discussion

Exam question from Amazon's AWS Certified Cloud Practitioner

Question #: 239
Topic #: 1

[All AWS Certified Cloud Practitioner Questions]

A company needs to generate reports for business intelligence and operational analytics on petabytes of semistructured and structured data. These reports are produced from standard SQL queries on data that is in an Amazon S3 data lake.
Which AWS service provides the ability to analyze this data?

A. Amazon RDS
B. Amazon Neptune
C. Amazon DynamoDB
D. Amazon Redshift

Show Suggested Answer

Suggested Answer: D 🗳️

by zoeyaj at Oct. 3, 2022, 3 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

zoeyaj

Highly Voted 2 years, 8 months ago

Selected Answer: D

semi-structure > Redshift

upvoted 11 times

Kanyeeeah

2 years, 8 months ago

"Petabytes" scale of data > Redshift

upvoted 9 times

...

Pranava_GCP

Most Recent 1 year, 10 months ago

Selected Answer: D

D. Amazon Redshift "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." https://aws.amazon.com/redshift/

upvoted 1 times

...

man5484

1 year, 10 months ago

Selected Answer: D

Amazon Redshift is a fully-managed data warehousing service that allows you to run complex queries on large datasets. It is optimized for online analytic processing (OLAP) workloads and is well-suited for business intelligence and operational analytics use cases. Amazon Redshift can directly query data stored in Amazon S3, making it an excellent choice for analyzing large amounts of data in a data lake.

upvoted 1 times

...

Guru4Cloud

2 years, 1 month ago

Selected Answer: D

The AWS service that provides the ability to analyze data stored in an Amazon S3 data lake using standard SQL queries is Amazon Redshift. Amazon Redshift is a fast, scalable, and fully managed data warehouse service that makes it simple and cost-effective to analyze all your data using SQL and your existing business intelligence tools. It can easily handle petabytes of structured and semistructured data, and provides features such as columnar storage, parallel processing, and automatic compression to deliver fast query performance. Therefore, the correct answer is D. Amazon Redshift

upvoted 1 times

...