Download AWS Certified Database - Specialty.DBS-C01.ExamTopics.2026-05-15.281q.vcex

Vendor: Amazon
Exam Code: DBS-C01
Exam Name: AWS Certified Database - Specialty
Date: May 15, 2026
File Size: 2 MB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAMFILESCOM

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator
ProfExam Discount

Demo Questions

Question 1
An advertising company is developing a backend for a bidding platform. The company needs a cost-effective datastore solution that will accommodate a sudden increase in the volume of write transactions. The database also needs to make data changes available in a near real-time data stream.
Which solution will meet these requirements?
  1. Amazon Aurora MySQL Multi-AZ DB cluster
  2. Amazon Keyspaces (for Apache Cassandra)
  3. Amazon DynamoDB table with DynamoDB auto scaling
  4. Amazon DocumentDB (with MongoDB compatibility) cluster with a replica instance in a second Availability Zone
Correct answer: C
Question 2
A legal research company wants to build a recommendation engine on AWS that connects datasets to help lawyers create legal arguments. The recommendation engine will collect millions of unstructured text documents from third-party sources to identify connections between documents without users needing to manually compare the documents.
Which solution will meet these requirements with the LEAST operational overhead?
  1. Build a graph-based recommendation engine by using Amazon Neptune. Search the documents for vertices with relationships among the different sources to connect.
  2. Create an AWS Lambda application in which the documents are uploaded into Amazon S3. Populate Amazon DynamoDB tables with the metadata of the documents for users to search.
  3. Develop a serverless document scanner by using Amazon Textract to analyze the text from the various sources. Store the detected text in an Amazon Aurora database for analysis.
  4. Define the data sources in an Amazon S3 data lake. Analyze the documents by using AWS Glue. Query the documents for relationships by using Amazon Athena.
Correct answer: A
Question 3
A company recently created a snapshot of an Amazon RDS for PostgreSQL DB instance that hosts a production database. The company created a new DB instance from the snapshot to test a new application feature while providing isolation from the production database.
During testing of the new application feature, the company noticed that read latency on the new database was higher than normal. A database specialist needs to resolve the latency issue.
Which solution will meet these requirements with the MOST operational efficiency?
  1. Log in to the database by using the PostgreSQL administration tool. Issue a SELECT * command against each table in the database.
  2. Create a new parameter group and set the max_connections parameter to 100. Assign the parameter group to the new database. Apply the changes immediately.
  3. Edit the default parameter group for the matching PostgreSQL engine. Set the max_connections parameter to 100. Reboot the new database to pick up the changes to the parameter group.
  4. Login to the database by using the PostgreSQL administration tool. Issue the VACUUM (ANALYZE, DISABLE_PAGE_SKIPPING) command.
Correct answer: D
Question 4
A database administrator is reviewing the deployment of an application that uses Amazon DynamoDB. A fleet of Amazon EC2 application instances accesses the database.
The database administrator notices that EC2 instances are using public IP addresses to access the database and that the database is available to the internet. Company policy requires that all corporate data must be accessed privately and that external access from the internet is not allowed.
Which combination of steps will ensure that the DynamoDB database meets these requirements? (Choose two.)
  1. Configure the DynamoDB security group and network ACLs to block external access.
  2. Create an AWS PrivateLink VPC endpoint for DynamoDUpdate the VPC route table.
  3. Create a gateway VPC endpoint for DynamoDB. Update the VPC route table.
  4. Provision a NAT gateway to access DynamoDB. Update the VPC route table.
  5. Use the aws:sourceVpce condition for all the IAM roles that provision access to the table.
Correct answer: C, E
Question 5
A company has a 250 GB Amazon RDS Multi-AZ DB instance. The company’s disaster recovery policy requires an RPO of 6 hours in a second AWS Region.
Which solution will meet these requirements MOST cost-effectively?
  1. Use RDS automated snapshots. Create an AWS Lambda function to copy the snapshot to a second Region.
  2. Use RDS automated snapshots every 6 hours. Use Amazon S3 Cross-Region Replication to copy the snapshot to a second Region.
  3. Use AWS Backup to take an RDS snapshot every 6 hours and to copy the snapshot to a second Region.
  4. Create an RDS cross-Region read replica in a second Region. Use AWS Backup to take an automated snapshot of the read replica every 6 hours.
Correct answer: C
Question 6
A company is using an Amazon RDS for MySQL DB instance for a production application. During the company’s upcoming scheduled maintenance window, a database specialist will perform a major version upgrade to the DB instance. The application is critical, so the company wants to minimize the maintenance time and allow for a rollback if a problem occurs.
Which solution will meet these requirements?
  1. Enable the automatic upgrade option by using the AWS Management Console. Amazon RDS will apply the upgrade, which will occur during the scheduled maintenance window with no downtime.
  2. Create a new DB instance that has the desired version. Configure AWS Database Migration Service (AWS DMS) to migrate the existing data to the new DB instance. Change the DNS records to point to the new DB instance.
  3. Create read replica of the DB instance. Upgrade the version on the read replica. Promote the read replica to be the primary DB instance. Direct the application to use the read replica endpoint.
  4. Create a read replica of the DB instance. Configure a policy to fall over to the read replica if failure occurs during the upgrade. Upgrade the version on the primary DB instance.
Correct answer: C
Question 7
A database specialist is designing a disaster recovery (DR) strategy for a highly available application that is in development. The application uses an Amazon DynamoDB table as its data store. The application requires an RTO of 1 minute and an RPO of 2 minutes.
Which DR strategy for the DynamoDB table will meet these requirements with the MOST operational efficiency?
  1. Create a DynamoDB stream and an AWS Lambda function. Configure the Lambda function to process the stream and copy the data to a table in another AWS Region.
  2. Use a DynamoDB global table replica in another AWS Region. Activate point-in-time recovery for both tables.
  3. Use a DynamoDB Accelerator (DAX) table in another AWS Region. Activate point-in-time recovery for the table.
  4. Create an AWS Backup plan. Assign the DynamoDB table as a resource.
Correct answer: B
Question 8
A database specialist needs to enable IAM authentication on an existing Amazon Aurora PostgreSQL DB cluster. The database specialist already has modified the DB cluster settings, has created IAM and database credentials, and has distributed the credentials to the appropriate users.
What should the database specialist do next to establish the credentials for the users to use to log in to the DB cluster?
  1. Add the users' IAM credentials to the Aurora cluster parameter group.
  2. Run the generate-db-auth-token command with the user names to generate a temporary password for the users.
  3. Add the users' IAM credentials to the default credential profile, Use the AWS Management Console to access the DB cluster.
  4. Use an AWS Security Token Service (AWS STS) token by sending the IAM access key and secret key as headers to the DB cluster API endpoint.
Correct answer: B
Question 9
A company has an existing system that uses a single-instance Amazon DocumentDB (with MongoDB compatibility) cluster. Read requests account for 75% of the system queries. Write requests are expected to increase by 50% after an upcoming global release. A database specialist needs to design a solution that improves the overall database performance without creating additional application overhead.
Which solution will meet these requirements?
  1. Recreate the cluster with a shared cluster volume. Add two instances to serve both read requests and write requests.
  2. Add one read replica instance. Activate a shared cluster volume. Route all read queries to the read replica instance.
  3. Add one read replica instance. Set the read preference to secondary preferred.
  4. Add one read replica instance. Update the application to route all read queries to the read replica instance.
Correct answer: C
Question 10
A company hosts an online gaming application on AWS. A single Amazon DynamoDB table contains one item for each registered user. The partition key for each item is the user's ID.
A daily report generator computes the sum totals of two well-known attributes for all items in the table that contain a dimension attribute. As the number of users grows, the report generator takes more time to generate the report.
Which combination of steps will minimize the time it takes to generate the report? (Choose two.)
  1. Create a global secondary index (GSI) that uses the user ID as the partition key and the dimension attribute as the sort key. Use the GSI to project the two attributes that the report generator uses to compute the sum totals.
  2. Create a local secondary index (LSI) that uses the user ID as the partition key and the dimension attribute as the sort key. Use the LSI to project the two attributes that the report generator uses to compute the sum totals.
  3. Modify the report generator to query the index instead of the table.
  4. Modify the report generator to scan the index instead of the table.
  5. Modify the report generator to call the BatchGetItem operation.
Correct answer: A, C
Question 11
A company uses multiple AWS accounts in AWS Organizations to separate development teams that work on different applications. Each AWS account contains multiple applications that run in the default VPC with interface endpoints. The applications need access to the same underlying data in an Amazon Aurora PostgreSQL DB cluster in one of the AWS accounts.
Which solution will meet these requirements in the MOST operationally efficient way?
  1. Use AWS Resource Access Manager (AWS RAM) to share the subnet that contains the database. Create an Amazon RDS Proxy endpoint for the other applications to access.
  2. Use VPC peering to connect the VPCs of the other AWS accounts to the subnet that contains the database.
  3. Create an Amazon S3 bucket that stores database backups. Configure replication to S3 buckets in the other accounts. Restore the backups in the other AWS accounts.
  4. Create an interface VPC endpoint for the Amazon RDS API. Attach an endpoint policy that grants the other AWS accounts access to the database.
Correct answer: A
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!