DBS-C01 Practice Test

A company is developing a multi-tier web application hosted on AWS using Amazon Aurora as the database.
The application needs to be deployed to production and other non-production environments. A Database
Specialist needs to specify different MasterUsername and MasterUserPassword properties in the AWS
CloudFormation templates used for automated deployment. The CloudFormation templates are version
controlled in the company’s code repository. The company also needs to meet compliance requirement by
routinely rotating its database master password for production.
What is most secure solution to store the master password?

A.

Store the master password in a parameter file in each environment. Reference the environment-specific
parameter file in the CloudFormation template

B.

Encrypt the master password using an AWS KMS key. Store the encrypted master password in
theCloudFormation template

C.

Use the secretsmanager dynamic reference to retrieve the master password stored in AWS
SecretsManager and enable automatic rotation.

D.

Use the ssm dynamic reference to retrieve the master password stored in the AWS Systems
ManagerParameter Store and enable automatic rotation.

A company has migrated a single MySQL database to Amazon Aurora. The production data is hosted in a DB
cluster in VPC_PROD, and 12 testing environments are hosted in VPC_TEST using the same AWS account.
Testing results in minimal changes to the test data. The Development team wants each environment refreshed
nightly so each test database contains fresh production data every day.
Which migration approach will be the fastest and most cost-effective to implement?

A.

Run the master in Amazon Aurora MySQL. Create 12 clones in VPC_TEST, and script the clones to
bedeleted and re-created nightly.

B.

Run the master in Amazon Aurora MySQL. Take a nightly snapshot, and restore it into 12 databases
inVPC_TEST using Aurora Serverless.

C.

Run the master in Amazon Aurora MySQL. Create 12 Aurora Replicas in VPC_TEST, and script
thereplicas to be deleted and re-created nightly.

D.

Run the master in Amazon Aurora MySQL using Aurora Serverless. Create 12 clones in VPC_TEST,
andscript the clones to be deleted and re-created nightly.

A company is running its line of business application on AWS, which uses Amazon RDS for MySQL at the
persistent data store. The company wants to minimize downtime when it migrates the database to Amazon
Aurora.
Which migration method should a Database Specialist use?

A.

Take a snapshot of the RDS for MySQL DB instance and create a new Aurora DB cluster with the option to migrate snapshots.

B.

Make a backup of the RDS for MySQL DB instance using the mysqldump utility, create a new Aurora
DB cluster, and restore the backup

C.

Create an Aurora Replica from the RDS for MySQL DB instance and promote the Aurora DB cluster.

D.

Create a clone of the RDS for MySQL DB instance and promote the Aurora DB cluster.

A company has an Amazon RDS Multi-AZ DB instances that is 200 GB in size with an RPO of 6 hours. To
meet the company’s disaster recovery policies, the database backup needs to be copied into another Region.
The company requires the solution to be cost-effective and operationally efficient.
What should a Database Specialist do to copy the database backup into a different Region?

A.

Use Amazon RDS automated snapshots and use AWS Lambda to copy the snapshot into another Region

B.

Use Amazon RDS automated snapshots every 6 hours and use Amazon S3 cross-Region replication tocopy the snapshot into another Region

C.

Create an AWS Lambda function to take an Amazon RDS snapshot every 6 hours and use a secondLambda function to copy the snapshot into another Region

D.

Create a cross-Region read replica for Amazon RDS in another Region and take an automated snapshot
ofthe read replica

A company is using Amazon with Aurora Replicas for read-only workload scaling. A Database Specialistneeds to split up two read-only applications so each application always connects to a dedicated replica. The
Database Specialist wants to implement load balancing and high availability for the read-only applications.
Which solution meets these requirements?

A.

Use a specific instance endpoint for each replica and add the instance endpoint to each read-onlyapplication connection string

B.

Use reader endpoints for both the read-only workload applications.

C.

Use a reader endpoint for one read-only application and use an instance endpoint for the other read-onlyapplication.

D.

Use custom endpoints for the two read-only applications