← Back to exam page

DBS-C01 – AWS Certified Database - Specialty

Loading demo links...

Showing 10–12 of 15 questions

Question 10

A database specialist is working on an Amazon RDS for PostgreSQL DB instance that is experiencing application performance issues due to the addition of new workloads. The database has 5 ׀¢׀’ of storage space with Provisioned IOPS. Amazon CloudWatch metrics show that the average disk queue depth is greater than

200 and that the disk I/O response time is significantly higher than usual.

What should the database specialist do to improve the performance of the application immediately?

Select an option, then click Submit answer.

  • ○

    Increase the Provisioned IOPS rate on the storage.
  • ○

    Increase the available storage space.
  • ○

    Use General Purpose SSD (gp2) storage with burst credits.
  • ○

    Create a read replica to offload Read IOPS from the DB instance.
Question 11

A Database Specialist is migrating a 2 TB Amazon RDS for Oracle DB instance to an RDS for PostgreSQL DB instance using AWS DMS. The source RDS Oracle DB instance is in a VPC in the us-east-1 Region. The target RDS for PostgreSQL DB instance is in a VPC in the use-west-2 Region.

Where should the AWS DMS replication instance be placed for the MOST optimal performance?

Select an option, then click Submit answer.

  • ○

    In the same Region and VPC of the source DB instance
  • ○

    In the same Region and VPC as the target DB instance
  • ○

    In the same VPC and Availability Zone as the target DB instance
  • ○

    In the same VPC and Availability Zone as the source DB instance
Question 12

A company uses Amazon Aurora MySQL as the primary database engine for many of its applications. A database specialist must create a dashboard to provide the company with information about user connections to databases. According to compliance requirements, the company must retain all connection logs for at least 7 years.

Which solution will meet these requirements MOST cost-effectively?

Select an option, then click Submit answer.

  • ○

    Enable advanced auditing on the Aurora cluster to log CONNECT events. Export audit logs from Amazon CloudWatch to Amazon S3 by using an AWS Lambda function that is invoked by an Amazon EventBridge (Amazon CloudWatch Events) scheduled event. Build a dashboard by using Amazon QuickSight.
  • ○

    Capture connection attempts to the Aurora cluster with AWS Cloud Trail by using the DescribeEvents API operation. Create a CloudTrail trail to export connection logs to Amazon S3. Build a dashboard by using Amazon QuickSight.
  • ○

    Start a database activity stream for the Aurora cluster. Push the activity records to an Amazon Kinesis data stream. Build a dynamic dashboard by using AWS Lambda.
  • ○

    Publish the DatabaseConnections metric for the Aurora DB instances to Amazon CloudWatch. Build a dashboard by using CloudWatch dashboards.