ExpertMedium1 markMultiple Choice
AWS SAP-C02 · Question 70 · Domain 2.5: Performance Objectives
A company is building a data analytics platform. They have petabytes of data in Amazon S3. They want to allow their data scientists to run complex SQL queries against this data without provisioning any infrastructure. The queries often take several minutes to run. The results of these queries need to be visualized in dashboards. Which combination of services should they use? (Select TWO)
A company is building a data analytics platform. They have petabytes of data in Amazon S3. They want to allow their data scientists to run complex SQL queries against this data without provisioning any infrastructure. The queries often take several minutes to run. The results of these queries need to be visualized in dashboards. Which combination of services should they use? (Select TWO)
Answer options:
A.
Amazon Redshift
B.
Amazon Athena
C.
Amazon QuickSight
D.
Amazon EMR
E.
AWS Glue DataBrew
F.
Amazon OpenSearch Service
How to approach this question
Identify the serverless SQL engine for S3 (Athena) and the visualization tool (QuickSight).
Full Answer
Amazon Athena. Amazon QuickSight.
Amazon Athena is a serverless query service that analyzes data directly in Amazon S3 using standard SQL. Amazon QuickSight is a scalable, serverless, embeddable, machine learning-powered business intelligence (BI) service built for the cloud, which integrates perfectly with Athena.
Common mistakes
Choosing Redshift or EMR, which require infrastructure provisioning.
Practice the full AWS Solutions Architect Professional SAP-C02 Practice Exam 4
75 questions · hints · full answers · grading
More questions from this exam
Q01A global enterprise is redesigning its network architecture across 50 AWS accounts. They require ...HardQ02A financial services company uses AWS Organizations to manage 100+ accounts. The security team ma...MediumQ03An e-commerce company requires a multi-region active-active architecture for its critical order p...MediumQ04A company is setting up a new AWS environment using AWS Control Tower. They need to ensure that a...HardQ05An enterprise has 50 AWS accounts under AWS Organizations. They want to implement a chargeback mo...Medium