Free DBS-C01 Exam Braindumps (page: 18)

Page 18 of 82

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. Create an Amazon CloudWatch dashboard to show the number of connections, CPU usage, and disk space consumption. Watch these dashboards during the next slow period.
  2. 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.
  3. 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.
  4. Enable Amazon RDS Performance Insights on the PostgreSQL database. Use the metrics to identify any queries that are related to spikes in the graph during the next slow period.

Answer(s): D



A company has a web-based survey application that uses Amazon DynamoDB. During peak usage, when survey responses are being collected, a Database Specialist sees the Provisioned Through put Exceeded Exception error.
What can the Database Specialist do to resolve this error? (Choose two.)

  1. Change the table to use Amazon DynamoDB Streams
  2. Purchase DynamoDB reserved capacity in the affected Region
  3. Increase the write capacity units for the specific table
  4. Change the table capacity mode to on-demand
  5. Change the table type to throughput optimized

Answer(s): C,D


Reference:

https://forums.aws.amazon.com/thread.jspa?threadID=174315



A company is running a two-tier ecommerce application in one AWS account. The web server is deployed using an Amazon RDS for MySQL Multi-AZ DB instance. A Developer mistakenly deleted the database in the production environment. The database has been restored, but this resulted in hours of downtime and lost revenue.
Which combination of changes in existing IAM policies should a Database Specialist make to prevent an error like this from happening in the future? (Choose three.)

  1. Grant least privilege to groups, users, and roles
  2. Allow all users to restore a database from a backup that will reduce the overall downtime to restore the database
  3. Enable multi-factor authentication for sensitive operations to access sensitive resources and API operations
  4. Use policy conditions to restrict access to selective IP addresses
  5. Use AccessList Controls policy type to restrict users for database instance deletion
  6. Enable AWS CloudTrail logging and Enhanced Monitoring

Answer(s): A,C,D



A company is building a new web platform where user requests trigger an AWS Lambda function that performs an insert into an Amazon Aurora MySQL DB cluster. Initial tests with less than 10 users on the new platform yielded successful execution and fast response times. However, upon more extensive tests with the actual target of 3,000 concurrent users, Lambda functions are unable to connect to the DB cluster and receive too many connections errors.
Which of the following will resolve this issue?

  1. Edit the my.cnf file for the DB cluster to increase max_connections
  2. Increase the instance size of the DB cluster
  3. Change the DB cluster to Multi-AZ
  4. Increase the number of Aurora Replicas

Answer(s): B



Page 18 of 82



Post your Comments and Discuss Amazon DBS-C01 exam with other Community members:

Pedro commented on April 27, 2024
Thanks for the dumps. It was an easy pass.
UNITED STATES
upvote

Keran commented on April 26, 2024
All of these questions are in the real exam. I just wrote my test yesterday. This is a valid exam dumps.
Anonymous
upvote

Mungara commented on March 14, 2023
thanks to this exam dumps, i felt confident and passed my exam with ease.
UNITED STATES
upvote

Mungara commented on March 14, 2023
Thanks to this exam dumps, I felt confident and passed my exam with ease.
UNITED STATES
upvote

otaku commented on August 11, 2022
just passed my dbs-c01 exam this site is really helped a lot.
Anonymous
upvote

Erik commented on March 02, 2022
These braindumps questions make passing very easy.
UNITED KINGDOM
upvote

Sanjev commented on January 12, 2022
This is the easiest way to get a 90%. Perfect exam dumps.
UNITED STATES
upvote

Abigail commented on September 20, 2021
I know using prep course are not ethical but I had to do this as this exam is way too hard to pass on your own. Thid prep course got me out of trouble.
UNITED STATES
upvote