Amazon DBS-C01 Exam Dumps

AWS Certified Database - Specialty

968 Reviews

Exam Code	DBS-C01
Exam Name	AWS Certified Database - Specialty
Questions	270 Questions Answers With Explanation
Update Date	05, 13, 2026
Price	Was : $90 Today : $50 Was : $108 Today : $60 Was : $126 Today : $70

Add To Cart

Demo Questions

Question # 1

A company has an on-premises production Microsoft SQL Server with 250 GB of data in one database. A database specialist needs to migrate this on-premises SQL Server to Amazon RDS for SQL Server. The nightly native SQL Server backup file is approximately 120 GB in size. The application can be down for an extended period of time to complete the migration. Connectivity between the on-premises environment and AWS can be initiated from on-premises only. How can the database be migrated from on-premises to Amazon RDS with the LEAST amount of effort?

A. Back up the SQL Server database using a native SQL Server backup. Upload the backup files to Amazon S3. Download the backup files on an Amazon EC2 instance and restore them from the EC2 instance into the new production RDS instance. 
B. Back up the SQL Server database using a native SQL Server backup. Upload the backup files to Amazon S3. Restore the backup files from the S3 bucket into the new production RDS instance. 
C. Provision and configure AWS DMS. Set up replication between the on-premises SQL Server environment to replicate the database to the new production RDS instance. 
D. Back up the SQL Server database using AWS Backup. Once the backup is complete, restore the completed backup to an Amazon EC2 instance and move it to the new production RDS instance. 

Show Answer

Question # 2

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. 

Show Answer

Question # 3

A company requires near-real-time notifications when changes are made to Amazon RDS DB security groups. Which solution will meet this requirement with the LEAST operational overhead?

A. Configure an RDS event notification subscription for DB security group events.
B. Create an AWS Lambda function that monitors DB security group changes. Create an Amazon Simple Notification Service (Amazon SNS) topic for notification. 
C. Turn on AWS CloudTrail. Configure notifications for the detection of changes to DB security groups. 
D. Configure an Amazon CloudWatch alarm for RDS metrics about changes to DB security groups. 

Show Answer

Question # 4

A company uses Amazon Aurora MySQL as the primary database engine for many of its applications. A database specialist must create a dashboard to provide the company with information about user connections to databases. According to compliance requirements, the company must retain all connection logs for at least 7 years. Which solution will meet these requirements MOST cost-effectively?

A. Enable advanced auditing on the Aurora cluster to log CONNECT events. Export audit logs from Amazon CloudWatch to Amazon S3 by using an AWS Lambda function that is invoked by an Amazon EventBridge (Amazon CloudWatch Events) scheduled event. Build a dashboard by using Amazon QuickSight. 
B. Capture connection attempts to the Aurora cluster with AWS Cloud Trail by using the DescribeEvents API operation. Create a CloudTrail trail to export connection logs to Amazon S3. Build a dashboard by using Amazon QuickSight. 
C. Start a database activity stream for the Aurora cluster. Push the activity records to an Amazon Kinesis data stream. Build a dynamic dashboard by using AWS Lambda. 
D. Publish the DatabaseConnections metric for the Aurora DB instances to Amazon CloudWatch. Build a dashboard by using CloudWatch dashboards. 

Show Answer

Question # 5

A database professional is tasked with the task of migrating 25 GB of data files from an onpremises storage system to an Amazon Neptune database. Which method of data loading is the FASTEST?

A. Upload the data to Amazon S3 and use the Loader command to load the data from Amazon S3 into the Neptune database. 
B. Write a utility to read the data from the on-premises storage and run INSERT statements in a loop to load the data into the Neptune database. 
C. Use the AWS CLI to load the data directly from the on-premises storage into the Neptune database. 
D. Use AWS DataSync to load the data directly from the on-premises storage into the Neptune database. 

Show Answer

Question # 6

A company is running a business-critical application on premises by using Microsoft SQL Server. A database specialist is planning to migrate the instance with several databases to the AWS Cloud. The database specialist will use SQL Server Standard edition hosted on Amazon EC2 Windows instances. The solution must provide high availability and must avoid a single point of failure in the SQL Server deployment architecture. Which solution will meet these requirements?

A. Create Amazon RDS for SQL Server Multi-AZ DB instances. Use Amazon S3 as a shared storage option to host the databases. 
B. Set up Always On Failover Cluster Instances as a single SQL Server instance. Use Multi-AZ Amazon FSx for Windows File Server as a shared storage option to host the databases. 
C. Set up Always On availability groups to group one or more user databases that fail over together across multiple SQL Server instances. Use Multi-AZ Amazon FSx for Windows File Server as a shared storage option to host the databases.
 D. Create an Application Load Balancer to distribute database traffic across multiple EC2 instances in multiple Availability Zones. Use Amazon S3 as a shared storage option to host the databases. 

Show Answer

Question # 7

Amazon DynamoDB global tables are being used by a business to power an online gaming game. The game is played by gamers from all around the globe. As the game became popularity, the amount of queries to DynamoDB substantially rose. Recently, gamers have complained about the game's condition being inconsistent between nations. A database professional notices that the ReplicationLatency metric for many replica tables is set to an abnormally high value. Which strategy will resolve the issue? 

A. Configure all replica tables to use DynamoDB auto scaling. 
B. Configure a DynamoDB Accelerator (DAX) cluster on each of the replicas. 
C. Configure the primary table to use DynamoDB auto scaling and the replica tables to use manually provisioned capacity. 
D. Configure the table-level write throughput limit service quota to a higher value. 

Show Answer

Question # 8

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.)

A. Check that Amazon S3 has an IAM role granting read access to Neptune 
B. Check that an Amazon S3 VPC endpoint exists 
C. Check that a Neptune VPC endpoint exists 
D. Check that Amazon EC2 has an IAM role granting read access to Amazon S3 
E. Check that Neptune has an IAM role granting read access to Amazon S3 

Show Answer

Question # 9

A gaming company is evaluating Amazon ElastiCache as a solution to manage player leaderboards. Millions of players around the world will complete in annual tournaments. The company wants to implement an architecture that is highly available. The company also wants to ensure that maintenance activities have minimal impact on the availability of the gaming platform. Which combination of steps should the company take to meet these requirements? (Choose two.)

A. Deploy an ElastiCache for Redis cluster with read replicas and Multi-AZ enabled. 
B. Deploy an ElastiCache for Memcached global datastore. 
C. Deploy a single-node ElastiCache for Redis cluster with automatic backups enabled. In the event of a failure, create a new cluster and restore data from the most recent backup. 
D. Use the default maintenance window to apply any required system changes and mandatory updates as soon as they are available. 
E. Choose a preferred maintenance window at the time of lowest usage to apply any required changes and mandatory updates. 

Show Answer

Question # 10

A pharmaceutical company's drug search API is using an Amazon Neptune DB cluster. A bulk uploader process automatically updates the information in the database a few times each week. A few weeks ago during a bulk upload, a database specialist noticed that the database started to respond frequently with a ThrottlingException error. The problem also occurred with subsequent uploads. The database specialist must create a solution to prevent ThrottlingException errors for the database. The solution must minimize the downtime of the cluster. Which solution meets these requirements?

A. Create a read replica that uses a larger instance size than the primary DB instance. Fail over the primary DB instance to the read replica. 
B. Add a read replica to each Availability Zone. Use an instance for the read replica that is the same size as the primary DB instance. Keep the traffic between the API and the database within the Availability Zone. 
C. Create a read replica that uses a larger instance size than the primary DB instance. Offload the reads from the primary DB instance. 
D. Take the latest backup, and restore it in a DB cluster of a larger size. Point the application to the newly created DB cluster. 

Show Answer

Question # 11

A company is using Amazon Aurora MySQL as the database for its retail application on AWS. The company receives a notification of a pending database upgrade and wants to ensure upgrades do not occur before or during the most critical time of year. Company leadership is concerned that an Amazon RDS maintenance window will cause an outage during data ingestion. Which step can be taken to ensure that the application is not interrupted?

A. Disable weekly maintenance on the DB cluster. 
B. Clone the DB cluster and migrate it to a new copy of the database. 
C. Choose to defer the upgrade and then find an appropriate down time for patching. 
D. Set up an Aurora Replica and promote it to primary at the time of patching. 

Show Answer

Question # 12

A software company uses an Amazon RDS for MySQL Multi-AZ DB instance as a data store for its critical applications. During an application upgrade process, a database specialist runs a custom SQL script that accidentally removes some of the default permissions of the master user. What is the MOST operationally efficient way to restore the default permissions of the master user?

A. Modify the DB instance and set a new master user password. 
B. Use AWS Secrets Manager to modify the master user password and restart the DB instance. 
C. Create a new master user for the DB instance. 
D. Review the IAM user that owns the DB instance, and add missing permissions. 

Show Answer

Question # 13

A company conducted a security audit of its AWS infrastructure. The audit identified that data was not encrypted in transit between application servers and a MySQL database that is hosted in Amazon RDS. After the audit, the company updated the application to use an encrypted connection. To prevent this problem from occurring again, the company's database team needs to configure the database to require in-transit encryption for all connections. Which solution will meet this requirement?

A. Update the parameter group in use by the DB instance, and set the require_secure_transport parameter to ON. 
B. Connect to the database, and use ALTER USER to enable the REQUIRE SSL option on the database user. 
C. Update the security group in use by the DB instance, and remove port 80 to prevent unencrypted connections from being established. 
D. Update the DB instance, and enable the Require Transport Layer Security option. 

Show Answer

Question # 14

For the first time, a database professional is establishing a test graph database on Amazon Neptune. The database expert must input millions of rows of test observations from an Amazon S3.csv file. The database professional uploaded the data to the Neptune DB instance through a series of API calls. Which sequence of actions enables the database professional to upload the data most quickly? (Select three.) 

A. Ensure Amazon Cognito returns the proper AWS STS tokens to authenticate the Neptune DB instance to the S3 bucket hosting the CSV file. 
B. Ensure the vertices and edges are specified in different .csv files with proper header column formatting. 
C. Use AWS DMS to move data from Amazon S3 to the Neptune Loader. 
D. Curl the S3 URI while inside the Neptune DB instance and then run the addVertex or addEdge commands. 
E. Ensure an IAM role for the Neptune DB instance is configured with the appropriate permissions to allow access to the file in the S3 bucket. 
F. Create an S3 VPC endpoint and issue an HTTP POST to the database€™s loader endpoint.

Show Answer

Question # 15

A company is using an Amazon Aurora MySQL database with Performance Insights enabled. A database specialist is checking Performance Insights and observes an alert message that starts with the following phrase: `Performance Insights is unable to collect SQL Digest statistics on new queries`¦` Which action will resolve this alert message?

A. Truncate the events_statements_summary_by_digest table. 
B. Change the AWS Key Management Service (AWS KMS) key that is used to enable Performance Insights. 
C. Set the value for the performance_schema parameter in the parameter group to 1. 
D. Disable and reenable Performance Insights to be effective in the next maintenance window. 

Show Answer

Question # 16

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. 

Show Answer

Question # 17

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? 

A. Enable auto scaling and set the target usage rate to 90%. 
B. Switch the table to provisioned mode and enable auto scaling. 
C. Switch the table to provisioned mode and set the throughput to the peak value. 
D. Create a DynamoDB Accelerator cluster and use it to access the DynamoDB table. 

Show Answer

Question # 18

A bike rental company operates an application to track its bikes. The application receives location and condition data from bike sensors. The application also receives rental transaction data from the associated mobile app. The application uses Amazon DynamoDB as its database layer. The company has configured DynamoDB with provisioned capacity set to 20% above the expected peak load of the application. On an average day, DynamoDB used 22 billion read capacity units (RCUs) and 60 billion write capacity units (WCUs). The application is running well. Usage changes smoothly over the course of the day and is generally shaped like a bell curve. The timing and magnitude of peaks vary based on the weather and season, but the general shape is consistent. Which solution will provide the MOST cost optimization of the DynamoDB database layer

A. Change the DynamoDB tables to use on-demand capacity. 
B. Use AWS Auto Scaling and configure time-based scaling. 
C. Enable DynamoDB capacity-based auto scaling. 
D. Enable DynamoDB Accelerator (DAX). 

Show Answer

Question # 19

A startup company is building a new application to allow users to visualize their onpremises and cloud networking components. The company expects billions of components to be stored and requires responses in milliseconds. The application should be able to identify: The networks and routes affected if a particular component fails. The networks that have redundant routes between them. The networks that do not have redundant routes between them. The fastest path between two networks. Which database engine meets these requirements?

A. Amazon Aurora MySQL 
B. Amazon Neptune 
C. Amazon ElastiCache for Redis 
D. Amazon DynamoDB 

Show Answer

Question # 20

A business is operating an on-premises application that is divided into three tiers: web, application, and MySQL database. The database is predominantly accessed during business hours, with occasional bursts of activity throughout the day. As part of the company's shift to AWS, a database expert wants to increase the availability and minimize the cost of the MySQL database tier. Which MySQL database choice satisfies these criteria?

A. Amazon RDS for MySQL with Multi-AZ 
B. Amazon Aurora Serverless MySQL cluster 
C. Amazon Aurora MySQL cluster 
D. Amazon RDS for MySQL with read replica 

Show Answer

Question # 21

An ecommerce company is using Amazon DynamoDB as the backend for its orderprocessing application. The steady increase in the number of orders is resulting in increased DynamoDB costs. Order verification and reporting perform many repeated GetItem functions that pull similar datasets, and this read activity is contributing to the increased costs. The company wants to control these costs without significant development efforts. How should a Database Specialist address these requirements?

A. Use AWS DMS to migrate data from DynamoDB to Amazon DocumentDB 
B. Use Amazon DynamoDB Streams and Amazon Kinesis Data Firehose to push the data into Amazon Redshift 
C. Use an Amazon ElastiCache for Redis in front of DynamoDB to boost read performance 
D. Use DynamoDB Accelerator to offload the reads 

Show Answer

Question # 22

A company's application development team wants to share an automated snapshot of its Amazon RDS database with another team. The database is encrypted with a custom AWS Key Management Service (AWS KMS) key under the "WeShare" AWS account. The application development team needs to share the DB snapshot under the "WeReceive" AWS account. Which combination of actions must the application development team take to meet these requirements? (Choose two.) 

A. Add access from the "WeReceive" account to the custom AWS KMS key policy of the sharing team. 
B. Make a copy of the DB snapshot, and set the encryption option to disable. 
C. Share the DB snapshot by setting the DB snapshot visibility option to public. 
D. Make a copy of the DB snapshot, and set the encryption option to enable. 
E. Share the DB snapshot by using the default AWS KMS encryption key. 

Show Answer

Question # 23

A financial company is running an Amazon Redshift cluster for one of its data warehouse solutions. The company needs to generate connection logs, user logs, and user activity logs. The company also must make these logs available for future analysis. Which combination of steps should a database specialist take to meet these requirements? (Choose two.) 

A. Edit the database configuration of the cluster by enabling audit logging. Direct the logging to a specified log group in Amazon CloudWatch Logs. 
B. Edit the database configuration of the cluster by enabling audit logging. Direct the logging to a specified Amazon S3 bucket 
C. Modify the cluster by enabling continuous delivery of AWS CloudTrail logs to Amazon S3.
 D. Create a new parameter group with the enable_user_activity_logging parameter set to true. Configure the cluster to use the new parameter group. 
E. Modify the system table to enable logging for each user. 

Show Answer

Question # 24

A database specialist is designing an enterprise application for a large company. The application uses Amazon DynamoDB with DynamoDB Accelerator (DAX). The database specialist observes that most of the queries are not found in the DAX cache and that they still require DynamoDB table reads. What should the database specialist review first to improve the utility of DAX? 

A. The DynamoDB ConsumedReadCapacityUnits metric 
B. The trust relationship to perform the DynamoDB API calls 
C. The DAX cluster's TTL setting 
D. The validity of customer-specified AWS Key Management Service (AWS KMS) keys for DAX encryption at rest 

Show Answer

Question # 25

A global company is developing an application across multiple AWS Regions. The company needs a database solution with low latency in each Region and automatic disaster recovery. The database must be deployed in an active-active configuration with automatic data synchronization between Regions. Which solution will meet these requirements with the LOWEST latency?

A. Amazon RDS with cross-Region read replicas
 B. Amazon DynamoDB global tables 
C. Amazon Aurora global database 
D. Amazon Athena and Amazon S3 with S3 Cross Region Replication 

Show Answer