A media company is using Amazon RDS for PostgreSQL to store user dat
a. The RDS DB instance currently has a publicly accessible setting enabled and is hosted in a public subnet. Following a recent AWS Well- Architected Framework review, a Database Specialist was given new security requirements.
Only certain on-premises corporate network IPs should connect to the DB instance. Connectivity is allowed from the corporate network only.
Which combination of steps does the Database Specialist need to take to meet these new requirements? (Choose three.)

• A.Modify the pg_hba.conf file. Add the required corporate network IPs and remove the unwanted IPs.
• B.Modify the associated security group. Add the required corporate network IPs and remove the unwanted IPs.
• C.Disable the publicly accessible setting.
• D.Enable VPC peering between the application host running on the corporate network and the VPC associated with the DB instance.
• E.Move the DB instance to a private subnet using AWS DMS.
• F.Connect to the DB instance using private IPs and a VPN.

Comment: *

Name: *

Email: *

Verification: *

A company runs online transaction processing (OLTP) workloads on an Amazon RDS for PostgreSQL Multi-AZ DB instance. Tests were run on the database after work hours, which generated additional database logs. The free storage of the RDS DB instance is low due to these additional logs.
What should the company do to address this space constraint issue?

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

Comment: *

Name: *

Email: *

Verification: *

A company runs online transaction processing (OLTP) workloads on an Amazon RDS for PostgreSQL Multi- AZ DB instance. Tests were run on the database after work hours, which generated additional database logs.
The free storage of the RDS DB instance is low due to these additional logs.
What should the company do to address this space constraint issue?

• 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

Comment: *

Name: *

Email: *

Verification: *

An Amazon RDS EBS-optimized instance with Provisioned IOPS (PIOPS) storage is using less than half of its allocated IOPS over the course of several hours under constant load. The RDS instance exhibits multi-second read and write latency, and uses all of its maximum bandwidth for read throughput, yet the instance uses less than half of its CPU and RAM resources.
What should a Database Specialist do in this situation to increase performance and return latency to sub- second levels?

• A.Disable EBS optimization on the DB instance
• B.Change the underlying EBS storage type to General Purpose SSD (gp2)
• C.Change the DB instance to an instance class with a higher maximum bandwidth
• D.Increase the size of the DB instance storage

Comment: *

Name: *

Email: *

Verification: *

An ecommerce company has tasked a Database Specialist with creating a reporting dashboard that visualizes critical business metrics that will be pulled from the core production database running on Amazon Auror a. Data that is read by the dashboard should be available within 100 milliseconds of an update.
The Database Specialist needs to review the current configuration of the Aurora DB cluster and develop a cost-effective solution. The solution needs to accommodate the unpredictable read workload from the reporting dashboard without any impact on the write availability and performance of the DB cluster.
Which solution meets these requirements?

• A.Add an automatic scaling policy to the DB cluster to add Aurora Replicas to the cluster based on CPU consumption.
• B.Provision a clone of the existing DB cluster for the new Application team.
• C.Turn on the serverless option in the DB cluster so it can automatically scale based on demand.
• D.Create a separate DB cluster for the new workload, refresh from the source DB cluster, and set up ongoing replication using AWS DMS change data capture (CDC).

Comment: *

Name: *

Email: *

Verification: *