Domain 4.3: Database Cost Optimization

A startup is launching a new mobile app backed by Amazon DynamoDB. The marketing team expects the app to go viral, but they have no idea how much database traffic to expect. They want to ensure the database does not throttle requests, but they also want to avoid paying for unused capacity. Which DynamoDB capacity mode should they choose?

A company has an internal reporting application that uses an Amazon RDS for MySQL database. The application is only used by employees during business hours (Monday to Friday, 9 AM to 5 PM). The database is currently running 24/7. What is the MOST cost-effective way to optimize the database costs?

A company is migrating a legacy application to AWS. The application requires a relational database. The database will be used sporadically, with long periods of inactivity followed by short bursts of high CPU utilization. The company wants to minimize costs. Which database service should be used?

A new startup is launching a mobile app backed by Amazon DynamoDB. They have no historical data to predict traffic patterns and expect sudden, unpredictable spikes in usage. Which DynamoDB capacity mode is the MOST cost-effective?

A company has a multi-tier web application. The database tier runs on Amazon RDS for PostgreSQL. The database is only used during business hours (8 AM to 6 PM, Monday to Friday). How can the company optimize the RDS costs with the LEAST operational overhead?

A company has an Amazon RDS database in the us-east-1 region. They want to create a Read Replica in the eu-west-1 region for disaster recovery. What cost implications should the solutions architect consider?

A development team uses an Amazon Aurora database for testing. The database is only used during business hours and sits idle on weekends and nights. What is the MOST cost-effective way to run this database?

A startup is launching a new mobile app backed by Amazon DynamoDB. They have no historical data to predict traffic patterns and expect sudden, unpredictable spikes in usage. Which DynamoDB capacity mode is the MOST cost-effective for this launch?

A company runs a production PostgreSQL database on Amazon RDS. The database size is 2 TB and it runs 24/7. The company expects to use this database for the next 3 years. What is the MOST cost-effective purchasing option?

A startup is building a new application using Amazon DynamoDB. They expect traffic to be highly unpredictable for the first few months, with sudden spikes and long periods of zero activity. <br/><br/>Which DynamoDB capacity mode is the MOST cost-effective for this scenario?

A company has a development environment running on Amazon Aurora MySQL. The developers only use the database during business hours (9 AM to 5 PM, Monday to Friday). The company wants to minimize costs without losing data. <br/><br/>What should the solutions architect recommend?

A company has an application that reads data from an Amazon DynamoDB table. The data is updated infrequently but read thousands of times per second. The read operations are consuming a large amount of provisioned read capacity units (RCUs), leading to high costs. <br/><br/>How can the solutions architect reduce the DynamoDB costs while maintaining performance?

A startup is building a new application with an unpredictable workload. The database will experience periods of high activity followed by days of zero activity. They need a relational database that minimizes costs during idle periods. Which service should they choose?

A new mobile game uses Amazon DynamoDB. The game is expected to go viral, but the exact traffic patterns and peak loads are completely unknown. To avoid throttling and minimize costs, which DynamoDB capacity mode should be used?

A development team uses a relational database for a testing environment. The database is used heavily during business hours but is completely idle at night and on weekends. The team wants to minimize costs without having to manually start and stop the database.<br/><br/>Which database solution is MOST cost-effective?

A company is launching a new mobile app backed by Amazon DynamoDB. The marketing team expects a massive spike in traffic on launch day, but traffic will be highly unpredictable for the first few months. After 6 months, traffic is expected to stabilize into a predictable daily pattern.<br/><br/>Which TWO pricing models should the company use for DynamoDB? (Select TWO.)

A company has been running a production Amazon RDS for MySQL database for two years. The database runs 24/7 and the compute requirements have not changed. The company plans to keep this architecture for at least another two years.<br/><br/>What is the MOST cost-effective way to pay for this database?

A startup is building a new application using Amazon DynamoDB. The application will have unpredictable traffic for the first 6 months, with occasional large spikes. After 6 months, the traffic is expected to stabilize. What is the MOST cost-effective DynamoDB capacity mode for the first 6 months?

A company has a development database running on Amazon Aurora MySQL. The database is only used by developers during business hours (9 AM to 5 PM, Monday to Friday). Outside of these hours, the database sits completely idle. What is the MOST cost-effective architectural choice for this database?

A company is migrating a legacy application to AWS. The application requires a relational database. The database will be heavily used during the day but completely idle at night. The company wants to minimize licensing and compute costs. Which solution is MOST cost-effective?