Free AWS-Certified-Database-Specialty Exam Dumps

Question 6

A bank intends to utilize Amazon RDS to host a MySQL database instance. The database should be able to handle high-volume read requests with extremely few repeated queries.
Which solution satisfies these criteria?

A. Create an Amazon ElastiCache cluste
B. Use a write-through strategy to populate the cache.
C. Create an Amazon ElastiCache cluste
D. Use a lazy loading strategy to populate the cache.
E. Change the DB instance to Multi-AZ with a standby instance in another AWS Region.
F. Create a read replica of the DB instanc
G. Use the read replica to distribute the read traffic.

Correct Answer:D

Question 7

A company is using a Single-AZ Amazon RDS for MySQL DB instance for development. The DB instance is experiencing slow performance when queries are executed. Amazon CloudWatch metrics indicate that the instance requires more I/O capacity.
Which actions can a database specialist perform to resolve this issue? (Choose two.)

A. Restart the application tool used to execute queries.
B. Change to a database instance class with higher throughput.
C. Convert from Single-AZ to Multi-AZ.
D. Increase the I/O parameter in Amazon RDS Enhanced Monitoring.
E. Convert from General Purpose to Provisioned IOPS (PIOPS).

Correct Answer:BE
https://aws.amazon.com/blogs/database/best-storage-practices-for-running-production-workloads-on-hosted-data "If you find the pattern of IOPS usage consistently going beyond more than 16,000, you should modify the DB instance and change the storage type from gp2 to io1.

Question 8

A large company has a variety of Amazon DB clusters. Each of these clusters has various configurations that adhere to various requirements. Depending on the team and use case, these configurations can be organized into broader categories.
A database administrator wants to make the process of storing and modifying these parameters more systematic. The database administrator also wants to ensure that changes to individual categories of configurations are automatically applied to all instances when required.
Which AWS service or feature will help automate and achieve this objective?

A. AWS Systems Manager Parameter Store
B. DB parameter group
C. AWS Config
D. AWS Secrets Manager

Correct Answer:B

Question 9

A database professional is developing an application that will respond to single-instance requests. The program will query large amounts of client data and offer end users with results.
These reports may include a variety of fields. The database specialist want to enable users to query the database using any of the fields offered.
During peak periods, the database's traffic volume will be significant yet changeable. However, the database will see little activity over the rest of the day.
Which approach will be the most cost-effective in meeting these requirements?

A. Amazon DynamoDB with provisioned capacity mode and auto scaling
B. Amazon DynamoDB with on-demand capacity mode
C. Amazon Aurora with auto scaling enabled
D. Amazon Aurora in a serverless mode

Correct Answer:D
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/Limits.html#limits-items

Question 10

A database specialist must create nightly backups of an Amazon DynamoDB table in a mission-critical workload as part of a disaster recovery strategy.
Which backup methodology should the database specialist use to MINIMIZE management overhead?

A. Install the AWS CLI on an Amazon EC2 instanc
B. Write a CLI command that creates a backup of the DynamoDB tabl
C. Create a scheduled job or task that executes the command on a nightly basis.
D. Create an AWS Lambda function that creates a backup of the DynamoDB tabl
E. Create an Amazon CloudWatch Events rule that executes the Lambda function on a nightly basis.
F. Create a backup plan using AWS Backup, specify a backup frequency of every 24 hours, and give the plan a nightly backup window.
G. Configure DynamoDB backup and restore for an on-demand backup frequency of every 24 hours.

Correct Answer:C
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/CreateBackup.html#:~:text=If you%2 https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/backuprestore_HowItWorks.html