AWS Certified Data Analytics – Specialty — Question 87

A marketing company has data in Salesforce, MySQL, and Amazon S3. The company wants to use data from these three locations and create mobile dashboards for its users. The company is unsure how it should create the dashboards and needs a solution with the least possible customization and coding.
Which solution meets these requirements?

Answer options

• A. Use Amazon Athena federated queries to join the data sources. Use Amazon QuickSight to generate the mobile dashboards.
• B. Use AWS Lake Formation to migrate the data sources into Amazon S3. Use Amazon QuickSight to generate the mobile dashboards.
• C. Use Amazon Redshift federated queries to join the data sources. Use Amazon QuickSight to generate the mobile dashboards.
• D. Use Amazon QuickSight to connect to the data sources and generate the mobile dashboards.

Correct answer: D

Explanation

The correct answer is D because Amazon QuickSight can directly connect to multiple data sources, allowing for quick and straightforward dashboard creation without significant customization. Options A, B, and C involve additional steps such as federated queries or data migration, which adds complexity and coding requirements, going against the need for minimal customization.