A data analyst is designing a solution to interactively query datasets with SQL using a JDBC connection. Users will join data stored in Amazon S3 in Apache ORC format with data stored in Amazon Elasticsearch Service (Amazon ES) and Amazon Aurora MySQL. Which solution will provide the MOST up-to-date results?
A) Use AWS Glue jobs to ETL data from Amazon ES and Aurora MySQL to Amazon S3. Query the data with Amazon Athena.
B) Use Amazon DMS to stream data from Amazon ES and Aurora MySQL to Amazon Redshift. Query the data with Amazon Redshift.
C) Query all the datasets in place with Apache Spark SQL running on an AWS Glue developer endpoint.
D) Query all the datasets in place with Apache Presto running on Amazon EMR.
Correct Answer:
Verified
Q1: A mortgage company has a microservice for
Q2: An ecommerce company stores customer purchase data
Q4: A global company has different sub-organizations, and
Q5: An airline has .csv-formatted data stored in
Q6: A banking company is currently using an
Q7: A company analyzes its data in an
Q8: A large company receives files from external
Q9: An Amazon Redshift database contains sensitive user
Q10: A company developed a new elections reporting
Q11: A data analyst is using Amazon QuickSight
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents