Free DBS-C01 Exam Braindumps

A ride-hailing application uses an Amazon RDS for MySQL DB instance as persistent storage for bookings. This application is very popular and the company expects a tenfold increase in the user base in next few months. The application experiences more traffic during the morning and evening hours.
This application has two parts:
An in-house booking component that accepts online bookings that directly correspond to simultaneous requests from users.
A third-party customer relationship management (CRM) component used by customer care representatives. The CRM uses queries to access booking data.
A database specialist needs to design a cost-effective database solution to handle this workload. Which solution meets these requirements?

1. A. Use Amazon ElastiCache for Redis to accept the booking
2. B. Associate an AWS Lambda function to capture changes and push the booking data to the RDS for MySQL DB instance used by the CRM.
3. C. Use Amazon DynamoDB to accept the booking
4. D. Enable DynamoDB Streams and associate an AWS Lambda function to capture changes and push the booking data to an Amazon SQS queu
5. E. This triggers another Lambda function that pulls data from Amazon SQS and writes it to the RDS for MySQL DB instance used by the CRM.
6. F. Use Amazon ElastiCache for Redis to accept the booking
7. G. Associate an AWS Lambda function to capture changes and push the booking data to an Amazon Redshift database used by the CRM.
8. H. Use Amazon DynamoDB to accept the booking
9. I. Enable DynamoDB Streams and associate an AWS Lambda function to capture changes and push the booking data to Amazon Athena, which is used by the CRM.

Correct Answer: D

A company is about to launch a new product, and test databases must be re-created from production data. The company runs its production databases on an Amazon Aurora MySQL DB cluster. A Database Specialist needs to deploy a solution to create these test databases as quickly as possible with the least amount of administrative effort.
What should the Database Specialist do to meet these requirements?

1. A. Restore a snapshot from the production cluster into test clusters
2. B. Create logical dumps of the production cluster and restore them into new test clusters
3. C. Use database cloning to create clones of the production cluster
4. D. Add an additional read replica to the production cluster and use that node for testing

Correct Answer: C
https://aws.amazon.com/getting-started/hands-on/aurora-cloning-backtracking/
"Cloning an Aurora cluster is extremely useful if you want to assess the impact of changes to your database, or if you need to perform workload-intensive operations—such as exporting data or running analytical queries, or simply if you want to use a copy of your production database in a development or testing environment. You can make multiple clones of your Aurora DB cluster. You can even create additional clones from other clones, with the constraint that the clone databases must be created in the same region as the source databases.

A team of Database Specialists is currently investigating performance issues on an Amazon RDS for MySQL DB instance and is reviewing related metrics. The team wants to narrow the possibilities down to specific database wait events to better understand the situation.
How can the Database Specialists accomplish this?

1. A. Enable the option to push all database logs to Amazon CloudWatch for advanced analysis
2. B. Create appropriate Amazon CloudWatch dashboards to contain specific periods of time
3. C. Enable Amazon RDS Performance Insights and review the appropriate dashboard
4. D. Enable Enhanced Monitoring will the appropriate settings

Correct Answer: C
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.Enabling.html https://aws.amazon.com/rds/performance-insights/
https://aws.amazon.com/blogs/database/tuning-amazon-rds-for-mysql-with-performance-insights/

A Database Specialist must create a read replica to isolate read-only queries for an Amazon RDS for MySQL DB instance. Immediately after creating the read replica, users that query it report slow response times.
What could be causing these slow response times?

1. A. New volumes created from snapshots load lazily in the background
2. B. Long-running statements on the master
3. C. Insufficient resources on the master
4. D. Overload of a single replication thread by excessive writes on the master

Correct Answer: A
snapshot is lazy loaded If the volume is accessed where the data is not loaded, the application accessing the volume encounters a higher latency than normal while the data gets loaded
https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-ebs-fast-snapshot-restore-eliminates-need-for-p

Amazon DynamoDB global tables are being used by a business to power an online gaming game. The game is played by gamers from all around the globe. As the game became popularity, the amount of queries to DynamoDB substantially rose. Recently, gamers have complained about the game's condition being inconsistent between nations. A database professional notices that the ReplicationLatency metric for many replica tables is set to an abnormally high value.
Which strategy will resolve the issue?

1. A. Configure all replica tables to use DynamoDB auto scaling.
2. B. Configure a DynamoDB Accelerator (DAX) cluster on each of the replicas.
3. C. Configure the primary table to use DynamoDB auto scaling and the replica tables to use manually provisioned capacity.
4. D. Configure the table-level write throughput limit service quota to a higher value.

Correct Answer: A
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/V2globaltables_reqs_bestpractices.html