A company is using Amazon Aurora PostgreSQL for the backend of its application. The system users are complaining that the responses are slow. A database specialist has determined that the queries to Aurora take longer during peak times. With the Amazon RDS Performance Insights dashboard, the load in the chart for average active sessions is often above the line that denotes maximum CPU usage and the wait state shows that most wait events are IO:XactSync.

What should the company do to resolve these performance issues?

A. Add an Aurora Replica to scale the read traffic.

B. Scale up the DB instance class.

C. Modify applications to commit transactions in batches.

D. Modify applications to avoid conflicts by taking locks.

A corporation intends to migrate a 500-GB Oracle database to Amazon Aurora PostgreSQL utilizing the AWS Schema Conversion Tool (AWS SCT) and AWS Data Management Service (AWS DMS). The database does not have any stored procedures, but does contain several huge or partitioned tables. Because the program is vital to the company, it is preferable to migrate with little downtime.

Which measures should a database professional perform in combination to expedite the transfer process? (Select three.)

A. Use the AWS SCT data extraction agent to migrate the schema from Oracle to Aurora PostgreSQL.

B. For the large tables, change the setting for the maximum number of tables to load in parallel and perform a full load using AWS DMS.

C. For the large tables, create a table settings rule with a parallel load option in AWS DMS, then perform a full load using DMS.

D. Use AWS DMS to set up change data capture (CDC) for continuous replication until the cutover date.

E. Use AWS SCT to convert the schema from Oracle to Aurora PostgreSQL.

F. Use AWS DMS to convert the schema from Oracle to Aurora PostgreSQL and for continuous replication.

Recently, a gaming firm purchased a popular iOS game that is especially popular during the Christmas season. The business has opted to include a leaderboard into the game, which will be powered by Amazon DynamoDB. The application's load is likely to increase significantly throughout the Christmas season.

Which solution satisfies these criteria at the lowest possible cost?

A. DynamoDB Streams

B. DynamoDB with DynamoDB Accelerator

C. DynamoDB with on-demand capacity mode

D. DynamoDB with provisioned capacity mode with Auto Scaling

A media company is using Amazon RDS for PostgreSQL to store user data. 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. Move the DB instance to a private subnet using AWS DMS.

D. Enable VPC peering between the application host running on the corporate network and the VPC associated with the DB instance.

E. Disable the publicly accessible setting.

F. Connect to the DB instance using private IPs and a VPN.

A ride-hailing application stores bookings in a persistent Amazon RDS for MySQL DB instance. This program is very popular, and the corporation anticipates a tenfold rise in the application's user base over the next several months. The application receives a higher volume of traffic in the morning and evening.

This application is divided into two sections:

An internal booking component that takes online reservations in response to concurrent user queries.

A component of a third-party customer relationship management (CRM) system that customer service professionals utilize. Booking data is accessed using queries in the CRM.

To manage this workload effectively, a database professional must create a cost-effective database system.

Which solution satisfies these criteria?

A. Use Amazon ElastiCache for Redis to accept the bookings. Associate an AWS Lambda function to capture changes and push the booking data to the RDS for MySQL DB instance used by the CRM.

B. Use Amazon DynamoDB to accept the bookings. Enable DynamoDB Streams and associate an AWS Lambda function to capture changes and push the booking data to an Amazon SQS queue. 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.

C. Use Amazon ElastiCache for Redis to accept the bookings. Associate an AWS Lambda function to capture changes and push the booking data to an Amazon Redshift database used by the CRM.

D. Use Amazon DynamoDB to accept the bookings. 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.

A company uses an on-premises Microsoft SQL Server database to host relational and JSON data and to run daily ETL and advanced analytics. The company wants to migrate the database to the AWS Cloud. Database specialist must choose one or more AWS services to run the company's workloads.

Which solution will meet these requirements in the MOST operationally efficient manner?

A. Use Amazon Redshift for relational data. Use Amazon DynamoDB for JSON data

B. Use Amazon Redshift for relational data and JSON data.

C. Use Amazon RDS for relational data. Use Amazon Neptune for JSON data

D. Use Amazon Redshift for relational data. Use Amazon S3 for JSON data.

A company requires near-real-time notifications when changes are made to Amazon RDS DB security groups.

Which solution will meet this requirement with the LEAST operational overhead?

A. Configure an RDS event notification subscription for DB security group events.

B. Create an AWS Lambda function that monitors DB security group changes. Create an Amazon Simple Notification Service (Amazon SNS) topic for notification.

C. Turn on AWS CloudTrail. Configure notifications for the detection of changes to DB security groups.

D. Configure an Amazon CloudWatch alarm for RDS metrics about changes to DB security groups.

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?

A. Edit the my.cnf file for the DB cluster to increase max_connections

B. Increase the instance size of the DB cluster

C. Change the DB cluster to Multi-AZ

D. Increase the number of Aurora Replicas

A huge gaming firm is developing a centralized method for storing the status of various online games' user sessions. The workload requires low-latency key-value storage and will consist of an equal number of reads and writes. Across the games' geographically dispersed user base, data should be written to the AWS Region nearest to the user. The design should reduce the burden associated with managing data replication across Regions.

Which solution satisfies these criteria?

A. Amazon RDS for MySQL with multi-Region read replicas

B. Amazon Aurora global database

C. Amazon RDS for Oracle with GoldenGate

D. Amazon DynamoDB global tables

A database specialist needs to configure an Amazon RDS for MySQL DB instance to close non-interactive connections that are inactive after 900 seconds.

What should the database specialist do to accomplish this task?

A. Create a custom DB parameter group and set the wait_timeout parameter value to 900. Associate the DB instance with the custom parameter group.

B. Connect to the MySQL database and run the SET SESSION wait_timeout=900 command.

C. Edit the my.cnf file and set the wait_timeout parameter value to 900. Restart the DB instance.

D. Modify the default DB parameter group and set the wait_timeout parameter value to 900.