Practice DBS-C01 Exam Online

Question 1

A company migrated one of its business-critical database workloads to an Amazon Aurora Multi-AZ DB cluster. The company requires a very low RTO and needs to improve the application recovery time after database failovers. Which approach meets these requirements?

A : Set the max_connections parameter to 16,000 in the instance-level parameter group.

B : Modify the client connection timeout to 300 seconds.

C : Create an Amazon RDS Proxy database proxy and update client connections to point to the proxy endpoint.

D : Enable the query cache at the instance level

Answer: C

Question 2

An e-commerce platform is utilizing Amazon Keyspaces (for Apache Cassandra) to manage the inventory and customer data. The database administrator needs to ensure the database remains highly available and data is consistently backed up.

Which action should the database administrator take?

A : Configure Amazon Keyspaces to replicate data across multiple AWS regions.

B : Implement custom application logic to create periodic snapshots of table data.

C : Enable point-in-time recovery (PITR) on the Amazon Keyspaces tables.

D : Schedule regular exports of table data to Amazon S3 using AWS Data Pipeline.

Answer: C

Question 3

A company’s development team needs to have production data restored in a staging AWS account. The

production database is running on an Amazon RDS for PostgreSQL Multi-AZ DB instance, which has AWS

KMS encryption enabled using the default KMS key. A database specialist planned to share the most recent

automated snapshot with the staging account, but discovered that the option to share snapshots is disabled in

the AWS Management Console.

What should the database specialist do to resolve this?

A : Disable automated backups in the DB instance. Share both the automated snapshot and the default KMS key with the staging account. Restore the snapshot in the staging account and enable automated backups.

B : Copy the automated snapshot specifying a custom KMS encryption key. Share both the copied snapshot and the custom KMS encryption key with the staging account. Restore the snapshot to the staging account within the same Region.

C : Modify the DB instance to use a custom KMS encryption key. Share both the automated snapshot and the custom KMS encryption key with the staging account. Restore the snapshot in the staging account

D : Copy the automated snapshot while keeping the default KMS key. Share both the snapshot and the default KMS key with the staging account. Restore the snapshot in the staging account.

Answer: B

Question 4

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.

Answer: A,C

Question 5

A company is going through a security audit. The audit team has identified cleartext master user password in the AWS CloudFormation templates for Amazon RDS for MySQL DB instances. The audit team has flagged this as a security risk to the database team. What should a database specialist do to mitigate this risk?

A : Change all the databases to use AWS IAM for authentication and remove all the cleartext passwords in CloudFormation templates.

B : Use an AWS Secrets Manager resource to generate a random password and reference the secret in the CloudFormation template.

C : Remove the passwords from the CloudFormation templates so Amazon RDS prompts for the password when the database is being created.

D : Remove the passwords from the CloudFormation template and store them in a separate file. Replace the passwords by running CloudFormation using a sed command.

Answer: B

Name:	AWS Certified Database - Specialty
Exam Code:	DBS-C01
Certification:	AWS Certified Database
Vendor:	Amazon
Total Questions:	459
Last Updated:	Apr 24, 2024

Amazon DBS-C01