DBS-C01 Free Practice Test

A company is planning to close for several days. A Database Specialist needs to stop all applications alongwith the DB instances to ensure employees do not have access to the systems during this time. All databasesare running on Amazon RDS for MySQL.
The Database Specialist wrote and executed a script to stop all the DB instances. When reviewing the logs,the Database Specialist found that Amazon RDS DB instances with read replicas did not stop.
How should the Database Specialist edit the script to fix this issue?

1. A. Stop the source instances before stopping their read replicas
2. B. Delete each read replica before stopping its corresponding source instance
3. C. Stop the read replicas before stopping their source instances
4. D. Use the AWS CLI to stop each read replica and source instance at the same

Correct Answer: D

The Security team for a finance company was notified of an internal security breach that happened 3 weeks ago. A Database Specialist must start producing audit logs out of the production Amazon Aurora PostgreSQL cluster for the Security team to use for monitoring and alerting. The Security team is required to perform real-time alerting and monitoring outside the Aurora DB cluster and wants to have the cluster push encrypted files to the chosen solution.
Which approach will meet these requirements?

1. A. Use pg_audit to generate audit logs and send the logs to the Security team.
2. B. Use AWS CloudTrail to audit the DB cluster and the Security team will get data from Amazon S3.
3. C. Set up database activity streams and connect the data stream from Amazon Kinesis to consumer applications.
4. D. Turn on verbose logging and set up a schedule for the logs to be dumped out for the Security team.

Correct Answer: B

A company is running Amazon RDS for MySQL for its workloads. There is downtime when AWS operating system patches are applied during the Amazon RDS-specified maintenance window.
What is the MOST cost-effective action that should be taken to avoid downtime?

1. A. Migrate the workloads from Amazon RDS for MySQL to Amazon DynamoDB
2. B. Enable cross-Region read replicas and direct read traffic to then when Amazon RDS is down
3. C. Enable a read replicas and direct read traffic to it when Amazon RDS is down
4. D. Enable an Amazon RDS for MySQL Multi-AZ configuration

Correct Answer: C

A Database Specialist migrated an existing production MySQL database from on-premises to an Amazon RDS for MySQL DB instance. However, after the migration, the database needed to be encrypted at rest using AWS KMS. Due to the size of the database, reloading, the data into an encrypted database would be too time-consuming, so it is not an option.
How should the Database Specialist satisfy this new requirement?

1. A. Create a snapshot of the unencrypted RDS DB instanc
2. B. Create an encrypted copy of the unencryptedsnapsho
3. C. Restore the encrypted snapshot copy.
4. D. Modify the RDS DB instanc
5. E. Enable the AWS KMS encryption option that leverages the AWS CLI.
6. F. Restore an unencrypted snapshot into a MySQL RDS DB instance that is encrypted.
7. G. Create an encrypted read replica of the RDS DB instanc
8. H. Promote it the master.

Correct Answer: A

A gaming company is designing a mobile gaming app that will be accessed by many users across the globe. The company wants to have replication and full support for multi-master writes. The company also wants to ensure low latency and consistent performance for app users.
Which solution meets these requirements?

1. A. Use Amazon DynamoDB global tables for storage and enable DynamoDB automatic scaling
2. B. Use Amazon Aurora for storage and enable cross-Region Aurora Replicas
3. C. Use Amazon Aurora for storage and cache the user content with Amazon ElastiCache
4. D. Use Amazon Neptune for storage

Correct Answer: A