Free AWS-Certified-Database-Specialty Exam Dumps

Question 31

A company is moving its fraud detection application from on premises to the AWS Cloud and is using Amazon Neptune for data storage. The company has set up a 1 Gbps AWS Direct Connect connection to migrate 25 TB of fraud detection data from the on-premises data center to a Neptune DB instance. The company already has an Amazon S3 bucket and an S3 VPC endpoint, and 80% of the company’s network bandwidth is available.
How should the company perform this data load?

A. Use an AWS SDK with a multipart upload to transfer the data from on premises to the S3 bucke
B. Use the Copy command for Neptune to move the data in bulk from the S3 bucket to the Neptune DB instance.
C. Use AWS Database Migration Service (AWS DMS) to transfer the data from on premises to the S3 bucke
D. Use the Loader command for Neptune to move the data in bulk from the S3 bucket to the Neptune DB instance.
E. Use AWS DataSync to transfer the data from on premises to the S3 bucke
F. Use the Loader command for Neptune to move the data in bulk from the S3 bucket to the Neptune DB instance.
G. Use the AWS CLI to transfer the data from on premises to the S3 bucke
H. Use the Copy command for Neptune to move the data in bulk from the S3 bucket to the Neptune DB instance.

Correct Answer:C
"AWS DataSync is an online data transfer service that simplifies, automates, and accelerates moving data between on-premises storage systems and AWS storage services, and also between AWS storage services."
https://docs.aws.amazon.com/neptune/latest/userguide/bulk-load.html

Question 32

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?

A. Use reserved capacit
B. Set it to the capacity levels required for peak daytime throughput.
C. Use provisioned capacit
D. Set it to the capacity levels required for peak daytime throughput.
E. Use provisioned capacit
F. Create an AWS Application Auto Scaling policy to update capacity based on consumption.
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

Question 33

A software development company is using Amazon Aurora MySQL DB clusters for several use cases, including development and reporting. These use cases place unpredictable and varying demands on the Aurora DB clusters, and can cause momentary spikes in latency. System users run ad-hoc queries sporadically throughout the week. Cost is a primary concern for the company, and a solution that does not require significant rework is needed.
Which solution meets these requirements?

A. Create new Aurora Serverless DB clusters for development and reporting, then migrate to these new DB clusters.
B. Upgrade one of the DB clusters to a larger size, and consolidate development and reporting activities on this larger DB cluster.
C. Use existing DB clusters and stop/start the databases on a routine basis using scheduling tools.
D. Change the DB clusters to the burstable instance family.

Correct Answer:A
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Concepts.DBInstanceClass.html

Question 34

A business's production databases are housed on a 3 TB Amazon Aurora MySQL DB cluster. The database cluster is installed in the region us-east-1. For disaster recovery (DR) requirements, the company's database expert needs to fast deploy the DB cluster in another AWS Region to handle the production load with an RTO of less than two hours.
Which approach is the MOST OPERATIONALLY EFFECTIVE in meeting these requirements?

A. Implement an AWS Lambda function to take a snapshot of the production DB cluster every 2 hours, and copy that snapshot to an Amazon S3 bucket in the DR Regio
B. Restore the snapshot to an appropriately sized DB cluster in the DR Region.
C. Add a cross-Region read replica in the DR Region with the same instance type as the current primary instanc
D. If the read replica in the DR Region needs to be used for production, promote the read replica to become a standalone DB cluster.
E. Create a smaller DB cluster in the DR Regio
F. Configure an AWS Database Migration Service (AWS DMS) task with change data capture (CDC) enabled to replicate data from the current production DB cluster to the DB cluster in the DR Region.
G. Create an Aurora global database that spans two Region
H. Use AWS Database Migration Service (AWS DMS) to migrate the existing database to the new global database.

Correct Answer:B
RTO is 2 hours. With 3 TB database, cross-region replica is a better option

Question 35

A banking company recently launched an Amazon RDS for MySQL DB instance as part of a proof-of-concept project. A database specialist has configured automated database snapshots. As a part of routine testing, the database specialist noticed one day that the automated database snapshot was not created.
Which of the following are possible reasons why the snapshot was not created? (Choose two.)

A. A copy of the RDS automated snapshot for this DB instance is in progress within the same AWS Region.
B. A copy of the RDS automated snapshot for this DB instance is in progress in a different AWS Region.
C. The RDS maintenance window is not configured.
D. The RDS DB instance is in the STORAGE_FULL state.
E. RDS event notifications have not been enabled.

Correct Answer:AD
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithAutomatedBackups.html