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 Apr 22, 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 financial services organization employs an Amazon Aurora PostgreSQL DB cluster to host an application on AWS. No log files detailing database administrator activity were discovered during a recent examination. A database professional must suggest a solution that enables access to the database and maintains activity logs. The solution should be simple to implement and have a negligible effect on performance.

Which database specialist solution should be recommended?

AEnable Aurora Database Activity Streams on the database in synchronous mode. Connect the Amazon Kinesis data stream to Kinesis Data Firehose. Set the Kinesis Data Firehose destination to an Amazon S3 bucket.

BCreate an AWS CloudTrail trail in the Region where the database runs. Associate the database activity logs with the trail.

CEnable Aurora Database Activity Streams on the database in asynchronous mode. Connect the Amazon Kinesis data stream to Kinesis Data Firehose. Set the Firehose destination to an Amazon S3 bucket.

DAllow connections to the DB cluster through a bastion host only. Restrict database access to the bastion host and application servers. Push the bastion host logs to Amazon CloudWatch Logs using the CloudWatch Logs agent.

Show Answer

Correct Answer: C

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

Question No. 2

A Database Specialist is constructing a new Amazon Neptune DB cluster and tries to load data from Amazon S3 using the Neptune bulk loader API. The Database Specialist is confronted with the following error message:

Unable to establish a connection to the s3 endpoint. The source URL is s3:/mybucket/graphdata/ and the region code is us-east-1. Kindly confirm your Configuration S3.

Which of the following activities should the Database Specialist take to resolve the issue? (Select two.)

ACheck that Amazon S3 has an IAM role granting read access to Neptune

BCheck that an Amazon S3 VPC endpoint exists

CCheck that a Neptune VPC endpoint exists

DCheck that Amazon EC2 has an IAM role granting read access to Amazon S3

ECheck that Neptune has an IAM role granting read access to Amazon S3

Show Answer

Correct Answer: B, E

https://docs.aws.amazon.com/neptune/latest/userguide/bulk-load-tutorial-IAM.html

https://docs.aws.amazon.com/neptune/latest/userguide/bulk-load-data.html

''An IAM role for the Neptune DB instance to assume that has an IAM policy that allows access to the data files in the S3 bucket. The policy must grant Read and List permissions.'' ''An Amazon S3 VPC endpoint. For more information, see the Creating an Amazon S3 VPC Endpoint section.''

Question No. 3

An online gaming company is using an Amazon DynamoDB table in on-demand mode to store game scores. After an intensive advertisement campaign in South

America, the average number of concurrent users rapidly increases from 100,000 to 500,000 in less than 10 minutes every day around 5 PM.

The on-call software reliability engineer has observed that the application logs contain a high number of DynamoDB throttling exceptions caused by game score insertions around 5 PM. Customer service has also reported that several users are complaining about their scores not being registered.

How should the database administrator remediate this issue at the lowest cost?

AEnable auto scaling and set the target usage rate to 90%.

BSwitch the table to provisioned mode and enable auto scaling.

CSwitch the table to provisioned mode and set the throughput to the peak value.

DCreate a DynamoDB Accelerator cluster and use it to access the DynamoDB table.

Show Answer

Correct Answer: B

Question No. 4

An internet advertising firm stores its data in an Amazon DynamoDb table. Amazon DynamoDB Streams are enabled on the table, and one of the keys has a global secondary index. The table is encrypted using a customer-managed AWS Key Management Service (AWS KMS) key.

The firm has chosen to grow worldwide and want to duplicate the database using DynamoDB global tables in a new AWS Region.

An administrator observes the following upon review:

No role with the dynamodb: CreateGlobalTable permission exists in the account.

An empty table with the same name exists in the new Region where replication is desired.

A global secondary index with the same partition key but a different sort key exists in the new Region where replication is desired.

Which settings will prevent you from creating a global table or replica in the new Region? (Select two.)

AA global secondary index with the same partition key but a different sort key exists in the new Region where replication is desired.

BAn empty table with the same name exists in the Region where replication is desired.

CNo role with the dynamodb:CreateGlobalTable permission exists in the account.

DDynamoDB Streams is enabled for the table.

EThe table is encrypted using a KMS customer managed key.

Show Answer

Correct Answer: A, B

Question No. 5

A company is using Amazon Redshift as its data warehouse solution. The Redshift cluster handles the following types of workloads:

*Real-time inserts through Amazon Kinesis Data Firehose

*Bulk inserts through COPY commands from Amazon S3

*Analytics through SQL queries

Recently, the cluster has started to experience performance issues.

Which combination of actions should a database specialist take to improve the cluster's performance? (Choose three.)

AModify the Kinesis Data Firehose delivery stream to stream the data to Amazon S3 with a high buffer size and to load the data into Amazon Redshift by using the COPY command.

BStream real-time data into Redshift temporary tables before loading the data into permanent tables.

CFor bulk inserts, split input files on Amazon S3 into multiple files to match the number of slices on Amazon Redshift. Then use the COPY command to load data into Amazon Redshift.

DFor bulk inserts, use the parallel parameter in the COPY command to enable multi-threading.

EOptimize analytics SQL queries to use sort keys.

FAvoid using temporary tables in analytics SQL queries.

Show Answer

Correct Answer: B, C, E

https://aws.amazon.com/blogs/big-data/top-10-performance-tuning-techniques-for-amazon-redshift/

Tip #6: Improving the efficiency of temporary tables

Tip #9: Maintaining efficient data loads

Amazon Redshift best practices suggest using the COPY command to perform data loads of file-based data.

Tip #3: Sort key recommendation

Sorting a table on an appropriate sort key can accelerate query performance, especially queries with range-restricted predicates, by requiring fewer table blocks to be read from disk.

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