A company has a heterogeneous six-node production Amazon Aurora DB cluster that handles online transaction processing (OLTP) for the core business and OLAP reports for the human resources department. To match compute resources to the use case, the company has decided to have the reporting workload for the human resources department be directed to two small nodes in the Aurora DB cluster, while every other workload goes to four large nodes in the same DB cluster.
Which option would ensure that the correct nodes are always available for the appropriate workload while meeting these requirements?

• A.Use the writer endpoint for OLTP and the reader endpoint for the OLAP reporting workload.
• B.Use automatic scaling for the Aurora Replica to have the appropriate number of replicas for the desired workload.
• C.Create additional readers to cater to the different scenarios.
• D.Use custom endpoints to satisfy the different workloads.

Comment: *

Name: *

Email: *

Verification: *

The Amazon CloudWatch metric for FreeLocalStorage on an Amazon Aurora MySQL DB instance shows that the amount of local storage is below 10 MB. A database engineer must increase the local storage available in the Aurora DB instance.
How should the database engineer meet this requirement?

• A.Modify the DB instance and configure the required storage volume in the configuration section.
• B.Modify the DB instance to use an instance class that provides more local SSD storage.
• C.Increase the local storage by upgrading the database engine version.
• D.Modify the Aurora DB cluster to enable automatic volume resizing.

Comment: *

Name: *

Email: *

Verification: *

A company is using an Amazon Aurora MySQL database with Performance Insights enabled. A database specialist is checking Performance Insights and observes an alert message that starts with the following phrase:
`Performance Insights is unable to collect SQL Digest statistics on new queries`
Which action will resolve this alert message?

• A.Truncate the events_statements_summary_by_digest table.
• B.Change the AWS Key Management Service (AWS KMS) key that is used to enable Performance Insights.
• C.Set the value for the performance_schema parameter in the parameter group to 1.
• D.Disable and reenable Performance Insights to be effective in the next maintenance window.

Comment: *

Name: *

Email: *

Verification: *

A database administrator needs to save a particular automated database snapshot from an Amazon RDS for Microsoft SQL Server DB instance for longer than the maximum number of days.
Which solution will meet these requirements in the MOST operationally efficient way?

• A.Create a manual copy of the snapshot.
• B.Export the contents of the snapshot to an Amazon S3 bucket.
• C.Change the retention period of the snapshot to 45 days.
• D.Create a native SQL Server backup. Save the backup to an Amazon S3 bucket.

Comment: *

Name: *

Email: *

Verification: *

A company conducted a security audit of its AWS infrastructure. The audit identified that data was not encrypted in transit between application servers and a MySQL database that is hosted in Amazon RDS.
After the audit, the company updated the application to use an encrypted connection. To prevent this problem from occurring again, the company's database team needs to configure the database to require in-transit encryption for all connections.
Which solution will meet this requirement?

• A.Update the parameter group in use by the DB instance, and set the require_secure_transport parameter to ON.
• B.Connect to the database, and use ALTER USER to enable the REQUIRE SSL option on the database user.
• C.Update the security group in use by the DB instance, and remove port 80 to prevent unencrypted connections from being established.
• D.Update the DB instance, and enable the Require Transport Layer Security option.

Comment: *

Name: *

Email: *

Verification: *