Free DBS-C01 Exam Braindumps
AWS Certified Database - Specialty Questions 111–115 (page: 24)

Updated On: 10-Feb-2026

A gaming company is developing a new mobile game and decides to store the data for each user in Amazon DynamoDB. To make the registration process as easy as possible, users can log in with their existing Facebook or Amazon accounts. The company expects more than 10,000 users.

How should a database specialist implement access control with the LEAST operational effort?

  1. Use web identity federation on the mobile app and AWS STS with an attached IAM role to get temporary credentials to access DynamoDB.
  2. Use web identity federation on the mobile app and create individual IAM users with credentials to access DynamoD
  3. Use a self-developed user management system on the mobile app that lets users access the data from DynamoDB through an API.
  4. Use a single IAM user on the mobile app to access DynamoDB.

Answer(s): A


Reference:

https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/WIF.html



A large retail company recently migrated its three-tier ecommerce applications to AWS. The company’s backend database is hosted on Amazon Aurora PostgreSQL. During peak times, users complain about longer page load times. A database specialist reviewed Amazon RDS Performance Insights and found a spike in IO:XactSync wait events. The SQL attached to the wait events are all single INSERT statements.

How should this issue be resolved?

  1. Modify the application to commit transactions in batches
  2. Add a new Aurora Replica to the Aurora DB cluster.
  3. Add an Amazon ElastiCache for Redis cluster and change the application to write through.
  4. Change the Aurora DB cluster storage to Provisioned IOPS (PIOPS).

Answer(s): A



A company uses Amazon DynamoDB as the data store for its ecommerce website. The website receives little to no traffic at night, and the majority of the traffic occurs during the day. The traffic growth during peak hours is gradual and predictable on a daily basis, but it can be orders of magnitude higher than during off-peak hours.

The company initially provisioned capacity based on its average volume during the day without accounting for the variability in traffic patterns. However, the website is experiencing a significant amount of throttling during peak hours. The company wants to reduce the amount of throttling while minimizing costs.

What should a database specialist do to meet these requirements?

  1. Use reserved capacity. Set it to the capacity levels required for peak daytime throughput.
  2. Use provisioned capacity. Set it to the capacity levels required for peak daytime throughput.
  3. Use provisioned capacity. Create an AWS Application Auto Scaling policy to update capacity based on consumption.
  4. Use on-demand capacity.

Answer(s): C


Reference:

https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/HowItWorks.ReadWriteCapacityMode.html



A company uses an Amazon RDS for PostgreSQL DB instance for its customer relationship management (CRM) system. New compliance requirements specify that the database must be encrypted at rest.

Which action will meet these requirements?

  1. Create an encrypted copy of manual snapshot of the DB instance. Restore a new DB instance from the encrypted snapshot.
  2. Modify the DB instance and enable encryption.
  3. Restore a DB instance from the most recent automated snapshot and enable encryption.
  4. Create an encrypted read replica of the DB instance. Promote the read replica to a standalone instance.

Answer(s): A


Reference:

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.Encryption.html



A database specialist was alerted that a production Amazon RDS MariaDB instance with 100 GB of storage was out of space. In response, the database specialist modified the DB instance and added 50 GB of storage capacity. Three hours later, a new alert is generated due to a lack of free space on the same DB instance. The database specialist decides to modify the instance immediately to increase its storage capacity by 20 GB.

What will happen when the modification is submitted?

  1. The request will fail because this storage capacity is too large.
  2. The request will succeed only if the primary instance is in active status.
  3. The request will succeed only if CPU utilization is less than 10%.
  4. The request will fail as the most recent modification was too soon.

Answer(s): D



Viewing page 24 of 67
Viewing questions 116 - 120 out of 359 questions


Post your Comments and Discuss Amazon DBS-C01 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!