Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. Amazon
  5. DBS-C01

Amazon DBS-C01 Exam Questions
AWS Certified Database - Specialty (Page 12 )

Updated On: 10-Mar-2026
Page 12 of 67
PDF with 359 Questions

A company runs online transaction processing (OLTP) workloads on an Amazon RDS for PostgreSQL Multi- AZ DB instance. Tests were run on the database after work hours, which generated additional database logs. The free storage of the RDS DB instance is low due to these additional logs.
What should the company do to address this space constraint issue?

  1. Log in to the host and run the rm $PGDATA/pg_logs/* command
  2. Modify the rds.log_retention_period parameter to 1440 and wait up to 24 hours for database logs to be deleted
  3. Create a ticket with AWS Support to have the logs deleted
  4. Run the SELECT rds_rotate_error_log() stored procedure to rotate the logs

Answer(s): B



A user has a non-relational key-value database. The user is looking for a fully managed AWS service that will offload the administrative burdens of operating and scaling distributed databases. The solution must be cost- effective and able to handle unpredictable application traffic.

What should a Database Specialist recommend for this user?

  1. Create an Amazon DynamoDB table with provisioned capacity mode
  2. Create an Amazon DocumentDB cluster
  3. Create an Amazon DynamoDB table with on-demand capacity mode
  4. Create an Amazon Aurora Serverless DB cluster

Answer(s): C

Explanation:


Reference:

https://aws.amazon.com/dynamodb/



A gaming company is designing a mobile gaming app that will be accessed by many users across the globe. The company wants to have replication and full support for multi-master writes. The company also wants to ensure low latency and consistent performance for app users.
Which solution meets these requirements?

  1. Use Amazon DynamoDB global tables for storage and enable DynamoDB automatic scaling
  2. Use Amazon Aurora for storage and enable cross-Region Aurora Replicas
  3. Use Amazon Aurora for storage and cache the user content with Amazon ElastiCache
  4. Use Amazon Neptune for storage

Answer(s): A

Explanation:


Reference:

https://aws.amazon.com/blogs/database/how-to-use-amazon-dynamodb-global-tables-to-power-multiregion-architectures/



A Database Specialist needs to speed up any failover that might occur on an Amazon Aurora PostgreSQL DB cluster. The Aurora DB cluster currently includes the primary instance and three Aurora Replicas.
How can the Database Specialist ensure that failovers occur with the least amount of downtime for the application?

  1. Set the TCP keepalive parameters low
  2. Call the AWS CLI failover-db-cluster command
  3. Enable Enhanced Monitoring on the DB cluster
  4. Start a database activity stream on the DB cluster

Answer(s): A



A Database Specialist needs to define a database migration strategy to migrate an on-premises Oracle database to an Amazon Aurora MySQL DB cluster. The company requires near-zero downtime for the data migration. The solution must also be cost-effective.
Which approach should the Database Specialist take?

  1. Dump all the tables from the Oracle database into an Amazon S3 bucket using data pump (expdp). Run data transformations in AWS Glue. Load the data from the S3 bucket to the Aurora DB cluster.
  2. Order an AWS Snowball appliance and copy the Oracle backup to the Snowball appliance. Once the Snowball data is delivered to Amazon S3, create a new Aurora DB cluster. Enable the S3 integration to migrate the data directly from Amazon S3 to Amazon RDS.
  3. Use the AWS Schema Conversion Tool (AWS SCT) to help rewrite database objects to MySQL during the schema migration. Use AWS DMS to perform the full load and change data capture (CDC) tasks.
  4. Use AWS Server Migration Service (AWS SMS) to import the Oracle virtual machine image as an Amazon EC2 instance. Use the Oracle Logical Dump utility to migrate the Oracle data from Amazon EC2 to an Aurora DB cluster.

Answer(s): C



Viewing page 12 of 67
Viewing questions 56 - 60 out of 359 questions



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

DBS-C01 Exam Discussions & Posts

AI Tutor