A large gaming company is creating a centralized solution to store player session state for multiple online games. The workload required key-value storage with low latency and will be an equal mix of reads and writes. Data should be written into the AWS Region closest to the user across the games' geographically distributed user base. The architecture should minimize the amount of overhead required to manage the replication of data between Regions.
Which solution meets these requirements?

• A.Amazon DynamoDB global tables
• B.Amazon Aurora global database
• C.Amazon RDS for Oracle with GoldenGate
• D.Amazon RDS for MySQL with multi-Region read replicas

Comment: *

Name: *

Email: *

Verification: *

A company runs a customer relationship management (CRM) system that is hosted on-premises with a MySQL database as the backend. A custom stored procedure is used to send email notifications to another system when data is inserted into a table. The company has noticed that the performance of the CRM system has decreased due to database reporting applications used by various teams. The company requires an AWS solution that would reduce maintenance, improve performance, and accommodate the email notification feature.
Which AWS solution meets these requirements?

• A.Use MySQL running on an Amazon EC2 instance with Auto Scaling to accommodate the reporting applications. Configure a stored procedure and an AWS Lambda function that uses Amazon SES to send email notifications to the other system.
• B.Use Amazon Aurora MySQL in a multi-master cluster to accommodate the reporting applications.
  Configure Amazon RDS event subscriptions to publish a message to an Amazon SNS topic and subscribe the other system's email address to the topic.
• C.Use MySQL running on an Amazon EC2 instance with a read replica to accommodate the reporting applications. Configure Amazon SES integration to send email notifications to the other system.
• D.Use Amazon Aurora MySQL with a read replica for the reporting applications. Configure a stored procedure and an AWS Lambda function to publish a message to an Amazon SNS topic. Subscribe the other system's email address to the topic.

Comment: *

Name: *

Email: *

Verification: *

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?

• A.Enable Amazon RDS Performance Insights on the PostgreSQL database. Use the metrics to identify anyqueries that are related to spikes in the graph during the next slow period.
• B.Launch an Amazon EC2 instance, and install and configure an open-source PostgreSQL monitoring toolthat will run reports based on the output error logs.
• C.Create an Amazon CloudWatch dashboard to show the number of connections, CPU usage, and diskspace consumption. Watch these dashboards during the next slow period.
• D.Modify the logging database parameter to log all the queries related to locking in the database and thencheck the logs after the next slow period for this information.

Comment: *

Name: *

Email: *

Verification: *

A financial company wants to store sensitive user data in an Amazon Aurora PostgreSQL DB cluster. The database will be accessed by multiple applications across the company. The company has mandated that all communications to the database be encrypted and the server identity must be validated. Any non-SSL-based connections should be disallowed access to the database.
Which solution addresses these requirements?

• A.Set the rds.force_ssl=0 parameter in DB parameter groups. Download and use the Amazon RDS certificate bundle and configure the PostgreSQL connection string with sslmode=allow.
• B.Set the rds.force_ssl=1 parameter in DB parameter groups. Download and use the Amazon RDS certificate bundle and configure the PostgreSQL connection string with sslmode=disable.
• C.Set the rds.force_ssl=0 parameter in DB parameter groups. Download and use the Amazon RDS certificate bundle and configure the PostgreSQL connection string with sslmode=verify-ca.
• D.Set the rds.force_ssl=1 parameter in DB parameter groups. Download and use the Amazon RDS certificate bundle and configure the PostgreSQL connection string with sslmode=verify-full.

Comment: *

Name: *

Email: *

Verification: *

A large company is using an Amazon RDS for Oracle Multi-AZ DB instance with a Java application. As a part of its disaster recovery annual testing, the company would like to simulate an Availability Zone failure and record how the application reacts during the DB instance failover activity. The company does not want to make any code changes for this activity.
What should the company do to achieve this in the shortest amount of time?

• A.Use a blue-green deployment with a complete application-level failover test
• B.Use the RDS console to reboot the DB instance by choosing the option to reboot with failover
• C.Use RDS fault injection queries to simulate the primary node failure
• D.Add a rule to the NACL to deny all traffic on the subnets associated with a single Availability Zone

Comment: *

Name: *

Email: *

Verification: *