Free DBS-C01 Exam Braindumps

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 unencrypted snapsho
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
"However, because you can encrypt a copy of an unencrypted DB snapshot, you can effectively add encryption to an unencrypted DB instance. That is, you can create a snapshot of your DB instance, and then create an encrypted copy of that snapshot. You can then restore a DB instance from the encrypted snapshot, and thus you have an encrypted copy of your original DB instance. For more information, see Copying a Snapshot." https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.Encryption.html

A company uses Amazon DynamoDB as the data store for its ecommerce website. The website receives little to no traffic at night, and the majority of the traffic occurs during the day. The traffic growth during peak hours is gradual and predictable on a daily basis, but it can be orders of magnitude higher than during off-peak hours.
The company initially provisioned capacity based on its average volume during the day without accounting for the variability in traffic patterns. However, the website is experiencing a significant amount of throttling during peak hours. The company wants to reduce the amount of throttling while minimizing costs.
What should a database specialist do to meet these requirements?

1. A. Use reserved capacit
2. B. Set it to the capacity levels required for peak daytime throughput.
3. C. Use provisioned capacit
4. D. Set it to the capacity levels required for peak daytime throughput.
5. E. Use provisioned capacit
6. F. Create an AWS Application Auto Scaling policy to update capacity based on consumption.
7. G. Use on-demand capacity.

Correct Answer: C
On-demand mode is a good option if any of the following are true: You create new tables with unknown
workloads. You have unpredictable application traffic. You prefer the ease of paying for only what you use. https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/HowItWorks.ReadWriteCapacityMode.h
Amazon DynamoDB auto scaling uses the AWS Application Auto Scaling service to dynamically adjust provisioned throughput capacity on your behalf https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/AutoScaling.html

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?

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

Correct Answer: C

A database specialist is constructing an AWS CloudFormation stack using AWS CloudFormation. The database expert wishes to avoid the stack's Amazon RDS ProductionDatabase resource being accidentally deleted.
Which solution will satisfy this criterion?

1. A. Create a stack policy to prevent update
2. B. Include €Effect€ : €ProductionDatabase€ and €Resource€€Deny€ in the policy.
3. C. Create an AWS CloudFormation stack in XML forma
4. D. Set xAttribute as false.
5. E. Create an RDS DB instance without the DeletionPolicy attribut
6. F. Disable termination protection.
7. G. Create a stack policy to prevent update
8. H. Include Effect, Deny, and Resource :ProductionDatabase in the policy.

Correct Answer: D
https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/protect-stack-resources.html "When you set a stack policy, all resources are protected by default. To allow updates on all resources, we add an Allow statement that allows all actions on all resources. Although the Allow statement specifies all resources, the explicit Deny statement overrides it for the resource with the ProductionDatabase logical ID. This Deny statement prevents all update actions, such as replacement or deletion, on the ProductionDatabase resource."

A user has a non-relational key-value database. The user is looking for a fully managed AWS service that will offload the administrative burdens of operating and scaling distributed databases. The solution must be cost- effective and able to handle unpredictable application traffic.
What should a Database Specialist recommend for this user?

1. A. Create an Amazon DynamoDB table with provisioned capacity mode
2. B. Create an Amazon DocumentDB cluster
3. C. Create an Amazon DynamoDB table with on-demand capacity mode
4. D. Create an Amazon Aurora Serverless DB cluster

Correct Answer: C