AWS Certified Solutions Architect – Associate (SAA-C03) — Question 506

A company runs a microservice-based serverless web application. The application must be able to retrieve data from multiple Amazon DynamoDB tables A solutions architect needs to give the application the ability to retrieve the data with no impact on the baseline performance of the application.

Which solution will meet these requirements in the MOST operationally efficient way?

Answer options

• A. AWS AppSync pipeline resolvers
• B. Amazon CloudFront with Lambda@Edge functions
• C. Edge-optimized Amazon API Gateway with AWS Lambda functions
• D. Amazon Athena Federated Query with a DynamoDB connector

Correct answer: A

Explanation

AWS AppSync pipeline resolvers allow a serverless application to orchestrate queries across multiple Amazon DynamoDB tables within a single GraphQL API request, maximizing operational efficiency and performance. Using Amazon Athena Federated Query is intended for analytical queries and introduces too much latency for a transactional web application. Lambda-based options like Lambda@Edge or API Gateway with Lambda require custom integration code and introduce cold-start latencies, reducing operational efficiency.