AWS Certified Cloud Practitioner · Free Practice Question Easy

Question 65

Which of these AWS services allow you to run queries against Amazon S3 without loading the data from Amazon S3 into data warehousing solution?
  • A Amazon DynamoDB
  • B Amazon Redshift
  • C Amazon EMR
  • D Amazon Redshift Spectrum
Reveal correct answer

Correct answer: D

Explanation

- Amazon Redshift - Run complex queries (SQL) against data warehouse - housing structured and unstructured data pulled in from a variety of sources

- Amazon EMR - Managed Hadoop.  Large scale data processing with high customization (machine learning, graph analytics)

- Amazon Redshift Spectrum - Run queries directly against S3 without worrying about loading entire data from S3 into a data warehouse. Needs a compute cluster. Scale compute and storage independently.

- Amazon Athena - Quick ad-hoc queries without worrying about provisioning a compute cluster (serverless)   Amazon Redshift Spectrum is recommended if you are executing queries frequently against structured data.


Discussion

Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.

You must be logged in to post a comment.

Preparing For

Your Certification?

255+ certifications
Detailed explanations
Free PDF samples

Has All The Questions You Need