Free AWS-Certified-Database-Specialty Exam Braindumps

A company is developing a new web application. An AWS CloudFormation template was created as a part of the build process.
Recently, a change was made to an AWS::RDS::DBInstance resource in the template. The CharacterSetName property was changed to allow the application to process international text. A change set was generated using the new template, which indicated that the existing DB instance should be replaced during an upgrade.
What should a database specialist do to prevent data loss during the stack upgrade?

1. A. Create a snapshot of the DB instanc
2. B. Modify the template to add the DBSnapshotIdentifier property with the ID of the DB snapsho
3. C. Update the stack.
4. D. Modify the stack policy using the aws cloudformation update-stack command and the set-stack-policy command, then make the DB resource protected.
5. E. Create a snapshot of the DB instanc
6. F. Update the stac
7. G. Restore the database to a new instance.
8. H. Deactivate any applications that are using the DB instanc
9. I. Create a snapshot of the DB instance.Modify the template to add the DBSnapshotIdentifier property with the ID of the DB snapsho
10. J. Update the stack and reactivate the applications.

Correct Answer: D
To preserve your data, perform the following procedure:
* 1.Deactivate any applications that are using the DB instance so that there's no activity on the DB instance. * 2.Create a snapshot of the DB instance. For more information about creating DB snapshots
* 3. If you want to restore your instance using a DB snapshot, modify the updated template with your DB instance changes and add the DBSnapshotIdentifier property with the ID of the DB snapshot that you want to use
* 4. Update the stack.

A company just migrated to Amazon Aurora PostgreSQL from an on-premises Oracle database. After the migration, the company discovered there is a period of time every day around 3:00 PM where the response time of the application is noticeably slower. The company has narrowed down the cause of this issue to the database and not the application.
Which set of steps should the Database Specialist take to most efficiently find the problematic PostgreSQL query?

1. A. Create an Amazon CloudWatch dashboard to show the number of connections, CPU usage, and disk space consumptio
2. B. Watch these dashboards during the next slow period.
3. C. Launch an Amazon EC2 instance, and install and configure an open-source PostgreSQL monitoring tool that will run reports based on the output error logs.
4. D. Modify the logging database parameter to log all the queries related to locking in the database and then check the logs after the next slow period for this information.
5. E. Enable Amazon RDS Performance Insights on the PostgreSQL databas
6. F. Use the metrics to identify any queries that are related to spikes in the graph during the next slow period.

Correct Answer: D

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 business that specializes in internet advertising is developing an application that will show adverts to its customers. The program stores data in an Amazon DynamoDB database. Additionally, the application caches its reads using a DynamoDB Accelerator (DAX) cluster. The majority of reads come via the GetItem and BatchGetItem queries. The application does not need consistency of readings.
The application cache does not behave as intended after deployment. Specific extremely consistent queries to the DAX cluster are responding in several milliseconds rather than microseconds.
How can the business optimize cache behavior in order to boost application performance?

1. A. Increase the size of the DAX cluster.
2. B. Configure DAX to be an item cache with no query cache
3. C. Use eventually consistent reads instead of strongly consistent reads.
4. D. Create a new DAX cluster with a higher TTL for the item cache.

Correct Answer: C

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