ExpertMedium1 markMultiple Choice
AWS SAA-C03 · Question 47 · Domain 3.3: Database Performance
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.)
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.)
Answer options:
A.
Amazon RDS for Oracle
B.
Amazon Redshift
C.
Amazon Athena
D.
Amazon Redshift Spectrum
E.
Amazon EMR
How to approach this question
Identify 'petabyte-scale data warehouse' (Redshift) and 'querying data directly in S3' (Redshift Spectrum).
Full Answer
Amazon Redshift is a fast, fully managed data warehouse. Redshift Spectrum is a feature of Redshift that enables you to run queries against data in Amazon S3 without having to load it into Redshift tables.
Common mistakes
Choosing Athena. While Athena queries S3, the prompt specifically asks for a data warehouse service.
Practice the full AWS SAA-C03 Practice Exam 7
65 questions · hints · full answers · grading
More questions from this exam
Q01A company has multiple AWS accounts in an AWS Organizations organization. The security team needs...MediumQ02An application runs on Amazon EC2 instances and needs to access an Amazon S3 bucket. What is the ...EasyQ03A company wants to implement federated access to the AWS Management Console for its employees usi...MediumQ04A company is building a mobile application that requires users to sign in using their social medi...EasyQ05A security team wants to enforce MFA for all IAM users before they can terminate EC2 instances. H...Medium