A Data Analyst Is Designing a Solution to Interactively Query

question 111

Multiple Choice

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.

---

Definitions:

Duty of Care

A legal obligation requiring individuals to exercise a reasonable standard of care while performing acts that could foreseeably harm others.

Intentional Conduct

Describes actions undertaken with the aware intent to cause a particular result or outcome.

Legal Imperialism

American insistence that all disputes be resolved under American law.

Corporate Governance

The system of rules, practices, and processes through which a company is directed and controlled, focusing on balancing the interests of its various stakeholders.