Amazon DBS-C01 Online Practice
Questions and Exam Preparation
DBS-C01 Exam Details
Exam Code
:DBS-C01
Exam Name
:AWS Certified Database - Specialty (DBS-C01)
Certification
:Amazon Certifications
Vendor
:Amazon
Total Questions
:321 Q&As
Last Updated
:Jul 12, 2026
Amazon DBS-C01 Online Questions &
Answers
Question 51:
A company is using Amazon RDS for PostgreSQL. The Security team wants all database connection requests to be logged and retained for 180 days. The RDS for PostgreSQL DB instance is currently using the default parameter group. A Database Specialist has identified that setting the log_connections parameter to 1 will enable connections logging.
Which combination of steps should the Database Specialist take to meet the logging and retention requirements? (Choose two.)
A. Update the log_connections parameter in the default parameter group B. Create a custom parameter group, update the log_connections parameter, and associate the parameter with the DB instance C. Enable publishing of database engine logs to Amazon CloudWatch Logs and set the event expiration to 180 days D. Enable publishing of database engine logs to an Amazon S3 bucket and set the lifecycle policy to 180 days E. Connect to the RDS PostgreSQL host and update the log_connections parameter in the postgresql.conf file
A. Update the log_connections parameter in the default parameter group E. Connect to the RDS PostgreSQL host and update the log_connections parameter in the postgresql.conf file
A large gaming company is creating a centralized solution to store player session state for multiple online games. The workload required key-value storage with low latency and will be an equal mix of reads and writes. Data should be written into the AWS Region closest to the user across the games' geographically distributed user base. The architecture should minimize the amount of overhead required to manage the replication of data between Regions.
Which solution meets these requirements?
A. Amazon RDS for MySQL with multi-Region read replicas B. Amazon Aurora global database C. Amazon RDS for Oracle with GoldenGate D. Amazon DynamoDB global tables
A. Amazon RDS for MySQL with multi-Region read replicas
Question 53:
A security team is conducting an audit for a financial company. The security team discovers that the database credentials of an Amazon RDS for MySQL DB instance are hardcoded in the source code. The source code is stored in a shared
location for automatic deployment and is exposed to all users who can access the location.
A database specialist must use encryption to ensure that the credentials are not visible in the source code.
Which solution will meet these requirements?
A. Use an AWS Key Management Service (AWS KMS) key to encrypt the most recent database backup. Restore the backup as a new database to activate encryption. B. Store the source code to access the credentials in an AWS Systems Manager Parameter Store secure string parameter that is encrypted by AWS Key Management Service (AWS KMS). Access the code with calls to Systems Manager. C. Store the credentials in an AWS Systems Manager Parameter Store secure string parameter that is encrypted by AWS Key Management Service (AWS KMS). Access the credentials with calls to Systems Manager. D. Use an AWS Key Management Service (AWS KMS) key to encrypt the DB instance at rest. Activate RDS encryption in transit by using SSL certificates.
C. Store the credentials in an AWS Systems Manager Parameter Store secure string parameter that is encrypted by AWS Key Management Service (AWS KMS). Access the credentials with calls to Systems Manager.
Explanation/Reference:
only creds in system manager secure parameter.
Question 54:
An information management services company is storing JSON documents on premises. The company is using a MongoDB 3.6 database but wants to migrate to
AWS. The solution must be compatible, scalable, and fully managed. The solution also must result in as little downtime as possible during the migration.
Which solution meets these requirements?
A. Create an AWS Database Migration Service (AWS DMS) replication instance, a source endpoint for MongoDB, and a target endpoint of Amazon DocumentDB (with MongoDB compatibility). B. Create an AWS Database Migration Service (AWS DMS) replication instance, a source endpoint for MongoDB, and a target endpoint of a MongoDB image that is hosted on Amazon EC2 C. Use the mongodump and mongorestore tools to migrate the data from the source MongoDB deployment to Amazon DocumentDB (with MongoDB compatibility). D. Use the mongodump and mongorestore tools to migrate the data from the source MongoDB deployment to a MongoDB image that is hosted on Amazon EC2.
A. Create an AWS Database Migration Service (AWS DMS) replication instance, a source endpoint for MongoDB, and a target endpoint of Amazon DocumentDB (with MongoDB compatibility).
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?
A. The request will fail because this storage capacity is too large. B. The request will succeed only if the primary instance is in active status. C. The request will succeed only if CPU utilization is less than 10%. D. The request will fail as the most recent modification was too soon.
D. The request will fail as the most recent modification was too soon.
A Database Specialist must create a read replica to isolate read-only queries for an Amazon RDS for MySQL DB instance. Immediately after creating the read replica, users that query it report slow response times. What could be causing these slow response times?
A. New volumes created from snapshots load lazily in the background B. Long-running statements on the master C. Insufficient resources on the master D. Overload of a single replication thread by excessive writes on the master
A. New volumes created from snapshots load lazily in the background
Explanation/Reference:
snapshot is lazy loaded If the volume is accessed where the data is not loaded, the application accessing the volume encounters a higher latency than normal while the data gets loaded https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-ebs-fast-snapshot- restore-eliminates-need-for-prewarming-data-into-volumes-created-snapshots/
Question 57:
A company has an Amazon Redshift cluster with database audit logging enabled. A security audit shows that raw SQL statements that run against the Redshift cluster are being logged to an Amazon S3 bucket. The security team requires that authentication logs are generated for use in an intrusion detection system (IDS), but the security team does not require SQL queries.
What should a database specialist do to remediate this issue?
A. Set the parameter to true in the database parameter group. B. Turn off the query monitoring rule in the Redshift cluster's workload management (WLM). C. Set the enable_user_activity_logging parameter to false in the database parameter group. D. Disable audit logging on the Redshift cluster.
C. Set the enable_user_activity_logging parameter to false in the database parameter group.
Question 58:
A database professional maintains a fleet of Amazon RDS database instances that are configured to utilize the default database parameter group. A database expert must connect a custom parameter group with certain database instances. When will the instances be allocated to this new parameter group once the database specialist performs this change?
A. Instantaneously after the change is made to the parameter group B. In the next scheduled maintenance window of the DB instances C. After the DB instances are manually rebooted D. Within 24 hours after the change is made to the parameter group
C. After the DB instances are manually rebooted
Explanation/Reference:
When you associate a new DB parameter group with a DB instance, the modified static and dynamic parameters are applied only after the DB instance is rebooted.
Question 59:
Developers have requested a new Amazon Redshift cluster so they can load new third- party marketing data. The new cluster is ready and the user credentials are given to the developers. The developers indicate that their copy jobs fail with
The developers need to load this data soon, so a database specialist must act quickly to solve this issue.
What is the MOST secure solution?
A. Create a new IAM role with the same user name as the Amazon Redshift developer user ID. Provide the IAM role with read-only access to Amazon S3 with the assume role action. B. Create a new IAM role with read-only access to the Amazon S3 bucket and include the assume role action. Modify the Amazon Redshift cluster to add the IAM role. C. Create a new IAM role with read-only access to the Amazon S3 bucket with the assume role action. Add this role to the developer IAM user ID used for the copy job that ended with an error message. D. Create a new IAM user with access keys and a new role with read-only access to the Amazon S3 bucket. Add this role to the Amazon Redshift cluster. Change the copy job to use the access keys created.
B. Create a new IAM role with read-only access to the Amazon S3 bucket and include the assume role action. Modify the Amazon Redshift cluster to add the IAM role.
Explanation/Reference:
https://docs.aws.amazon.com/redshift/latest/gsg/rs-gsg-create-an-iam-role.html "Now that you have created the new role, your next step is to attach it to your cluster. You can attach the role when you launch a new cluster or you can attach it to an existing cluster. In the next step, you attach the role to a new cluster."
A company runs hundreds of Microsoft SQL Server databases on Windows servers in its on-premises data center. A database specialist needs to migrate these databases to Linux on AWS. Which combination of steps should the database specialist take to meet this requirement? (Choose three.)
A. Install AWS Systems Manager Agent on the on-premises servers. Use Systems Manager Run Command to install the Windows to Linux replatforming assistant for Microsoft SQL Server Databases. B. Use AWS Systems Manager Run Command to install and configure the AWS Schema Conversion Tool on the on-premises servers. C. On the Amazon EC2 console, launch EC2 instances and select a Linux AMI that includes SQL Server. Install and configure AWS Systems Manager Agent on the EC2 instances. D. On the AWS Management Console, set up Amazon RDS for SQL Server DB instances with Linux as the operating system. Install AWS Systems Manager Agent on the DB instances by using an options group. E. Open the Windows to Linux replatforming assistant tool. Enter configuration details of the source and destination databases. Start migration. F. On the AWS Management Console, set up AWS Database Migration Service (AWS DMS) by entering details of the source SQL Server database and the destination SQL Server database on AWS. Start migration.
A. Install AWS Systems Manager Agent on the on-premises servers. Use Systems Manager Run Command to install the Windows to Linux replatforming assistant for Microsoft SQL Server Databases. C. On the Amazon EC2 console, launch EC2 instances and select a Linux AMI that includes SQL Server. Install and configure AWS Systems Manager Agent on the EC2 instances. E. Open the Windows to Linux replatforming assistant tool. Enter configuration details of the source and destination databases. Start migration.
Nowadays, the certification exams become more and more important and required by more and more
enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare
for the exam in a short time with less efforts? How to get a ideal result and how to find the
most reliable resources? Here on Vcedump.com, you will find all the answers.
Vcedump.com provide not only Amazon exam questions,
answers and explanations but also complete assistance on your exam preparation and certification
application. If you are confused on your DBS-C01 exam preparations
and Amazon certification application, do not hesitate to visit our
Vcedump.com to find your solutions here.