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.

Comment: *

Name: *

Email: *

Verification: *

A retail company is about to migrate its online and mobile store to AWS. The company's CEO has strategic plans to grow the brand globally. A Database Specialist has been challenged to provide predictable read and write database performance with minimal operational overhead.
What should the Database Specialist do to meet these requirements?

• A.Use Amazon DynamoDB global tables to synchronize transactions
• B.Use Amazon EMR to copy the orders table data across Regions
• C.Use Amazon Aurora Global Database to synchronize all transactions
• D.Use Amazon DynamoDB Streams to replicate all DynamoDB transactions and sync them

Comment: *

Name: *

Email: *

Verification: *

A company migrated one of its business-critical database workloads to an Amazon Aurora Multi-AZ DB cluster. The company requires a very low RTO and needs to improve the application recovery time after database failovers.
Which approach meets these requirements?

• A.Set the max_connections parameter to 16,000 in the instance-level parameter group.
• B.Modify the client connection timeout to 300 seconds.
• C.Create an Amazon RDS Proxy database proxy and update client connections to point to the proxy endpoint.
• D.Enable the query cache at the instance level.

Comment: *

Name: *

Email: *

Verification: *

A company is using an Amazon Aurora PostgreSQL DB cluster with an xlarge primary instance master and two large Aurora Replicas for high availability and read-only workload scaling. A failover event occurs and application performance is poor for several minutes. During this time, application servers in all Availability Zones are healthy and responding normally.
What should the company do to eliminate this application performance issue?

• A.Configure both of the Aurora Replicas to the same instance class as the primary DB instance. Enable cache coherence on the DB cluster, set the primary DB instance failover priority to tier-0, and assign a failover priority of tier-1 to the replicas.
• B.Deploy an AWS Lambda function that calls the DescribeDBInstances action to establish which instance has failed, and then use the PromoteReadReplica operation to promote one Aurora Replica to be the primary DB instance. Configure an Amazon RDS event subscription to send a notification to an Amazon SNS topic to which the Lambda function is subscribed.
• C.Configure one Aurora Replica to have the same instance class as the primary DB instance. Implement Aurora PostgreSQL DB cluster cache management. Set the failover priority to tier-0 for the primary DB instance and one replica with the same instance class. Set the failover priority to tier-1 for the other replicas.
• D.Configure both Aurora Replicas to have the same instance class as the primary DB instance. Implement Aurora PostgreSQL DB cluster cache management. Set the failover priority to tier-0 for the primary DB instance and to tier-1 for the replicas.

Comment: *

Name: *

Email: *

Verification: *

A retail company with its main office in New York and another office in Tokyo plans to build a database solution on AWS. The company's main workload consists of a mission-critical application that updates its application data in a data store. The team at the Tokyo office is building dashboards with complex analytical queries using the application data. The dashboards will be used to make buying decisions, so they need to have access to the application data in less than 1 second.
Which solution meets these requirements?

• A.Use an Amazon RDS DB instance deployed in the us-east-1 Region with a read replica instance in the ap- northeast-1 Region. Create an Amazon ElastiCache cluster in the ap-northeast-1 Region to cache application data from the replica to generate the dashboards.
• B.Use an Amazon DynamoDB global table in the us-east-1 Region with replication into the ap-northeast-1 Region. Use Amazon QuickSight for displaying dashboard results.
• C.Use an Amazon RDS for MySQL DB instance deployed in the us-east-1 Region with a read replica instance in the ap-northeast-1 Region. Have the dashboard application read from the read replica.
• D.Use an Amazon Aurora global database. Deploy the writer instance in the us-east-1 Region and the replica in the ap-northeast-1 Region. Have the dashboard application read from the replica ap-northeast-1 Region.

Comment: *

Name: *

Email: *

Verification: *