Most Recent Amazon DBS-C01 Exam Dumps

Prepare for the Amazon AWS Certified Database - Specialty exam with our extensive collection of questions and answers. These practice Q&A are updated according to the latest syllabus, providing you with the tools needed to review and test your knowledge.

QA4Exam focus on the latest syllabus and exam objectives, our practice Q&A are designed to help you identify key topics and solidify your understanding. By focusing on the core curriculum, These Questions & Answers helps you cover all the essential topics, ensuring you're well-prepared for every section of the exam. Each question comes with a detailed explanation, offering valuable insights and helping you to learn from your mistakes. Whether you're looking to assess your progress or dive deeper into complex topics, our updated Q&A will provide the support you need to confidently approach the Amazon DBS-C01 exam and achieve success.

The questions for DBS-C01 were last updated on Jul 20, 2026.

Viewing page 1 out of 64 pages.
Viewing questions 1-5 out of 322 questions

Get All 322 Questions & Answers

Question No. 1

A finance company migrated its 3 ' on-premises PostgreSQL database to an Amazon Aurora PostgreSQL DB cluster. During a review after the migration, a database specialist discovers that the database is not encrypted at rest. The database must be encrypted at rest as soon as possible to meet security requirements. The database specialist must enable encryption for the DB cluster with minimal downtime.

Which solution will meet these requirements?

AModify the unencrypted DB cluster using the AWS Management Console. Enable encryption and choose to apply the change immediately.

BTake a snapshot of the unencrypted DB cluster and restore it to a new DB cluster with encryption enabled. Update any database connection strings to reference the new DB cluster endpoint, and then delete the unencrypted DB cluster.

CCreate an encrypted Aurora Replica of the unencrypted DB cluster. Promote the Aurora Replica as the new master.

DCreate a new DB cluster with encryption enabled and use the pg_dump and pg_restore utilities to load data to the new DB cluster. Update any database connection strings to reference the new DB cluster endpoint, and then delete the unencrypted DB cluster.

Show Answer

Correct Answer: B

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

Question No. 2

A database specialist needs to review and optimize an Amazon DynamoDB table that is experiencing performance issues. A thorough investigation by the database specialist reveals that the partition key is causing hot partitions, so a new partition key is created. The database specialist must effectively apply this new partition key to all existing and new data.

How can this solution be implemented?

AUse Amazon EMR to export the data from the current DynamoDB table to Amazon S3. Then use Amazon EMR again to import the data from Amazon S3 into a new DynamoDB table with the new partition key.

BUse AWS DMS to copy the data from the current DynamoDB table to Amazon S3. Then import the DynamoDB table to create a new DynamoDB table with the new partition key.

CUse the AWS CLI to update the DynamoDB table and modify the partition key.

DUse the AWS CLI to back up the DynamoDB table. Then use the restore-table-from-backup command and modify the partition key.

Show Answer

Correct Answer: A

https://aws.amazon.com/premiumsupport/knowledge-center/back-up-dynamodb-s3/

Question No. 3

A business maintains a SQL Server database on-premises. Active Directory authentication is used to provide users access to the database. The organization transferred their database successfully to Amazon RDS for SQL Server. The organization, however, has reservations regarding user authentication in the AWS Cloud environment.

Which authentication solution should a database professional provide?

ADeploy Active Directory Federation Services (AD FS) on premises and configure it with an on-premises Active Directory. Set up delegation between the on- premises AD FS and AWS Security Token Service (AWS STS) to map user identities to a role using theAmazonRDSDirectoryServiceAccess managed IAM policy.

BEstablish a forest trust between the on-premises Active Directory and AWS Directory Service for Microsoft Active Directory. Use AWS SSO to configure an Active Directory user delegated to access the databases in RDS for SQL Server.

CUse Active Directory Connector to redirect directory requests to the companys on-premises Active Directory without caching any information in the cloud. Use the RDS master user credentials to connect to the DB instance and configure SQL Server logins and users from the Active Directory users and groups.

DEstablish a forest trust between the on-premises Active Directory and AWS Directory Service for Microsoft Active Directory. Ensure RDS for SQL Server is using mixed mode authentication. Use the RDS master user credentials to connect to the DB instance and configure SQL Server logins and users from the Active Directory users and groups.

Show Answer

Correct Answer: D

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

Question No. 4

A company is going to use an Amazon Aurora PostgreSQL DB cluster for an application backend. The DB cluster contains some tables with sensitive dat

a. A Database Specialist needs to control the access privileges at the table level.

How can the Database Specialist meet these requirements?

AUse AWS IAM database authentication and restrict access to the tables using an IAM policy.

BConfigure the rules in a NACL to restrict outbound traffic from the Aurora DB cluster.

CExecute GRANT and REVOKE commands that restrict access to the tables containing sensitive data.

DDefine access privileges to the tables containing sensitive data in the pg_hba.conf file.

Show Answer

Correct Answer: C

Question No. 5

A company has a web-based survey application that uses Amazon DynamoDB. During peak usage, when

survey responses are being collected, a Database Specialist sees the ProvisionedThroughputExceededException error.

What can the Database Specialist do to resolve this error? (Choose two.)

AChange the table to use Amazon DynamoDB Streams

BPurchase DynamoDB reserved capacity in the affected Region

CIncrease the write capacity units for the specific table

DChange the table capacity mode to on-demand

EChange the table type to throughput optimized

Show Answer

Correct Answer: C, D

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

Unlock All Questions for Amazon DBS-C01 Exam

Full Exam Access, Actual Exam Questions, Validated Answers, Anytime Anywhere, No Download Limits, No Practice Limits

Get All 322 Questions & Answers