Question 1

A company is migrating its on-premises Oracle data warehouse to AWS. The new solution must be a fully managed, petabyte-scale data warehouse service that supports standard SQL and allows querying data directly in Amazon S3 without loading it. Which TWO AWS services/features should be used? (Select TWO.)

Accepted Answer

Identify 'petabyte-scale data warehouse' (Redshift) and 'querying data directly in S3' (Redshift Spectrum).

Question 2

What mistakes do candidates make on this AWS SAA-C03 question?

Accepted Answer

Choosing Athena. While Athena queries S3, the prompt specifically asks for a data warehouse service.

How to approach this question

Full Answer

Common mistakes

Practice the full AWS SAA-C03 Practice Exam 7

More questions from this exam