Domain 3.3: Database Performance

A company uses Amazon DynamoDB to store user activity logs. The partition key is the `UserID`, and the sort key is the `Timestamp`. A small number of highly active users are causing ProvisionedThroughputExceededException errors, even though the overall table capacity seems sufficient. What is the MOST likely cause of this issue?

A data analytics team needs to run complex SQL queries against petabytes of structured and semi-structured data stored in Amazon S3. They want a serverless solution where they only pay for the queries they run, without managing any infrastructure. Which service should they use?

A company is developing a new SaaS application. The database workload is highly unpredictable, with periods of zero activity followed by sudden, massive spikes in traffic. The company wants a relational database that scales compute capacity instantly to meet demand and scales down to save costs. Which TWO database options meet these requirements? (Select TWO.)

A company is migrating a read-heavy application to AWS. They want to implement an in-memory caching layer to reduce the load on their Amazon RDS database. The caching solution must support complex data structures (like sorted sets) and Multi-AZ high availability. Which TWO actions should they take? (Select TWO.)

An application uses Amazon DynamoDB to store product catalog data. During flash sales, the application experiences massive read spikes, causing ReadCapacityUnit (RCU) throttling and increased latency. The application requires microsecond read latency. What is the BEST solution?

A startup is building an application with unpredictable, intermittent traffic. They need a relational database that can automatically scale compute capacity up and down based on application demand, and pause during periods of inactivity. Which service should they use?

A company has petabytes of historical data stored in Amazon S3. They want to query this data using standard SQL without loading it into a database. They also want to join this S3 data with frequently accessed data stored in their Amazon Redshift cluster. What is the MOST efficient solution?

A data analyst needs to run ad-hoc SQL queries on CSV files stored in Amazon S3. They want a serverless solution that requires zero infrastructure setup. Which service should they use?

A relational database is struggling to handle a high volume of read queries for a leaderboard application. The data structure is simple (key-value pairs) and requires sub-millisecond response times. Which service should be added to the architecture to offload the database?

An application uses Amazon DynamoDB. During peak hours, the application experiences read throttling, even though the read capacity units (RCUs) are set high. The access pattern shows that a small number of items are being read thousands of times per second. How can this be resolved MOST efficiently?

A reporting application runs complex analytical queries against an Amazon Aurora MySQL database. These queries are slowing down the primary database used by the transactional web application. How can a solutions architect improve performance for both applications?

A company has petabytes of structured data stored in Amazon S3. They want to run complex SQL queries across this data and their existing data warehouse. Which service is designed for petabyte-scale data warehousing and can query S3 directly?

A company is building a serverless application using Amazon API Gateway and AWS Lambda. The application needs to store user session state data that requires sub-millisecond read latency. <br/><br/>Which database solution should the solutions architect recommend?

A global application uses an Amazon Aurora database. Users in Europe are experiencing high latency when reading data because the primary database is located in the us-east-1 Region. The application is read-heavy. <br/><br/>How can a solutions architect improve read performance for European users?

A data analytics team needs to run complex SQL queries against petabytes of structured and semi-structured data stored in Amazon S3. They want a serverless solution where they only pay for the queries they run, without managing any infrastructure. <br/><br/>Which AWS service should they use?

A company has a multi-tier application. The database tier runs on Amazon RDS for MySQL. The application experiences heavy read traffic, causing the primary database instance to become a bottleneck. <br/><br/>How can the solutions architect improve performance MOST cost-effectively?

A company is designing an application that will write thousands of records per second to an Amazon DynamoDB table. The partition key is based on the date (e.g., '2023-10-25'). During load testing, the application experiences heavy throttling, even though the total provisioned write capacity is higher than the write rate. <br/><br/>What is the MOST likely cause of this issue?

A company is building an application that requires a highly available, relational database. The database must automatically scale storage capacity as data grows, up to 128 TB, without manual intervention. <br/><br/>Which TWO database options meet these requirements? (Select TWO.)

A gaming leaderboard application requires an in-memory data store to handle millions of requests per second with sub-millisecond latency. The data store must support complex data structures like sorted sets. Which AWS service should be used?

An application uses Amazon DynamoDB as its backend database. The application is experiencing high read traffic for a small set of popular items, leading to increased latency and higher costs due to consumed read capacity units. How can a solutions architect improve read performance and reduce database load with the LEAST application code changes?

A reporting application runs heavy analytical queries against an Amazon RDS for PostgreSQL database. These queries are causing performance degradation for the main transactional web application. Which TWO actions should the solutions architect take to improve performance? (Select TWO.)

A company has petabytes of structured data stored in Amazon S3. They want to run complex SQL queries across this data and their existing data warehouse. They need a solution that is optimized for online analytical processing (OLAP). Which AWS service should they use?

A popular news website uses an Amazon RDS for PostgreSQL database. During major news events, the database CPU utilization hits 100% due to a massive spike in read queries from users viewing articles. Write operations (publishing new articles) remain low.<br/><br/>Which TWO actions should a solutions architect take to improve database performance? (Select TWO.)

A gaming company uses Amazon DynamoDB to store player profiles. The game requires microsecond latency for read operations to ensure a smooth user experience. The data is frequently accessed but rarely updated.<br/><br/>Which AWS service or feature should be added to the architecture?

A company is building a real-time leaderboard for a mobile game. The leaderboard requires sorting complex datasets, high availability, and the ability to persist data to disk in case of a node failure.<br/><br/>Which TWO statements about the appropriate caching solution are correct? (Select TWO.)

A data analytics team uses Amazon Redshift for complex queries. They have a large fact table and several small dimension tables. Queries joining these tables are running slowly because data is being broadcast across the network between compute nodes.<br/><br/>Which Redshift distribution style should a solutions architect apply to the small dimension tables to improve query performance?

A gaming company uses Amazon DynamoDB to store player leaderboards. The application experiences heavy read traffic, and the company wants to reduce read latency from milliseconds to microseconds while reducing the load on the DynamoDB table. Which solution should be implemented?

A reporting application runs complex SQL queries against an Amazon RDS for MySQL database. During the end-of-month reporting period, the heavy read traffic causes the database to become unresponsive for the main transactional web application. How can a solutions architect improve performance for both workloads?

A company is migrating its on-premises Oracle data warehouse to AWS. The new solution must be a fully managed, petabyte-scale data warehouse service that supports standard SQL and allows querying data directly in Amazon S3 without loading it. Which TWO AWS services/features should be used? (Select TWO.)

A company is building a highly available web application. They need a database that provides single-digit millisecond latency at any scale, supports key-value data models, and automatically replicates data across multiple AWS Regions for active-active usage. Which database should they choose?