Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.

Amazon AWS Certified Database - Specialty Exam Practice Questions

The questions for AWS Certified Database - Specialty were last updated at June 27, 2022.
  • Viewing page 1 out of 47 pages.
  • Viewing questions 1-4 out of 193 questions
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.
Question #1 Topic 1

A business utilizes Amazon DynamoDB to power a web-based survey program. A Database Specialist encounters the ProvisionedThroughputExceededException problem during peak use, while survey answers are being gathered.

What is the Database Specialist's role in resolving this issue? (Select two.)

  • A. Change the table to use Amazon DynamoDB Streams
  • B. Purchase DynamoDB reserved capacity in the affected Region
  • C. Increase the write capacity units for the specific table
  • D. Change the table capacity mode to on-demand
  • E. Change the table type to throughput optimized
Reveal Solution Hide Solution   Discussion   15

Correct Answer: CE 🗳️
Reference:
https://forums.aws.amazon.com/thread.jspa?threadID=174315

Question #2 Topic 1

A business's customer relationship management (CRM) system is hosted on an Amazon RDS for PostgreSQL DB instance. According to new compliance rules, the database must be encrypted at rest.

Which course of action will satisfy these criteria?

  • A. Create an encrypted copy of manual snapshot of the DB instance. Restore a new DB instance from the encrypted snapshot.
  • B. Modify the DB instance and enable encryption.
  • C. Restore a DB instance from the most recent automated snapshot and enable encryption.
  • D. Create an encrypted read replica of the DB instance. Promote the read replica to a standalone instance.
Reveal Solution Hide Solution   Discussion   16

Correct Answer: C 🗳️
Reference:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.Encryption.html

Question #3 Topic 1

On an Amazon RDS for PostgreSQL Multi-AZ DB instance, a business conducts online transaction processing (OLTP) workloads. After-hours tests were done on the database, generating extra database logs. Due to these extra logs, the RDS DB instance's free storage space is limited.

What should the business do to handle this problem of space constraint?

  • A. Log in to the host and run the rm $PGDATA/pg_logs/* command
  • B. Modify the rds.log_retention_period parameter to 1440 and wait up to 24 hours for database logs to be deleted
  • C. Create a ticket with AWS Support to have the logs deleted
  • D. Run the SELECT rds_rotate_error_log() stored procedure to rotate the logs
Reveal Solution Hide Solution   Discussion   10

Correct Answer: B 🗳️

Question #4 Topic 1

Amazon Aurora MySQL is being used by an ecommerce business to migrate its main application database. The firm is now doing OLTP stress testing using concurrent database connections. A database professional detected sluggish performance for several particular write operations during the first round of testing.
Examining the Amazon CloudWatch stats for the Aurora DB cluster revealed a CPU usage of 90%.

Which actions should the database professional take to determine the main cause of excessive CPU use and sluggish performance most effectively? (Select two.)

  • A. Enable Enhanced Monitoring at less than 30 seconds of granularity to review the operating system metrics before the next round of tests.
  • B. Review the VolumeBytesUsed metric in CloudWatch to see if there is a spike in write I/O.
  • C. Review Amazon RDS Performance Insights to identify the top SQL statements and wait events.
  • D. Review Amazon RDS API calls in AWS CloudTrail to identify long-running queries.
  • E. Enable Advance Auditing to log QUERY events in Amazon CloudWatch before the next round of tests.
Reveal Solution Hide Solution   Discussion   8

Correct Answer: BC 🗳️
Reference:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.API.html

Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...