A company is migrating its data analytics platform to AWS. The platform requires a data warehouse that can query petabytes of structured and semi-structured data. The company also wants to query data directly from Amazon S3 without loading it into the data warehouse. Which combination of services and features should be used? (Select TWO)

Answer options:

Use Amazon Redshift as the data warehouse.

Use Amazon RDS for PostgreSQL as the data warehouse.

Use Amazon Redshift Spectrum to query data directly in Amazon S3.

Use Amazon Kinesis Data Analytics to query the S3 data.

Use Amazon DynamoDB as the data warehouse.

Use AWS Glue to load all S3 data into Redshift before querying.

How to approach this question

Identify the data warehouse and its S3 querying feature.

Full Answer

Amazon Redshift is the AWS enterprise data warehouse. Redshift Spectrum is a feature of Redshift that allows you to query data directly from files on Amazon S3 without having to load the data into Redshift tables first.

Common mistakes

Thinking all data must be loaded into Redshift to be queried.

Question 74 All questions

Practice the full AWS Solutions Architect Professional SAP-C02 Practice Exam 7

75 questions · hints · full answers · grading

More questions from this exam

Q01A global enterprise is designing a multi-region network architecture connecting 50 AWS accounts a...Hard Q02A company is migrating its hybrid network to AWS. They have two 10 Gbps AWS Direct Connect connec...Hard Q03An enterprise has 100 AWS accounts in AWS Organizations. The security team mandates that all Amaz...Medium Q04A financial company requires that all EBS volumes, S3 buckets, and RDS databases be encrypted usi...Easy Q05An enterprise is designing a disaster recovery strategy for a critical application running on Ama...Hard

View all 75 questions →