A finance company migrated its on-premises PostgreSQL database to an Amazon Aurora PostgreSQL DB cluster. During a review after the migration, a database specialist discovers that the database is not encrypted at rest. The database must be encrypted at rest as soon as possible to meet security requirements. The database specialist must enable encryption for the DB cluster with minimal downtime.
Which solution will meet these requirements?

• A.Modify the unencrypted DB cluster using the AWS Management Console. Enable encryption and choose to apply the change immediately.
• B.Take a snapshot of the unencrypted DB cluster and restore it to a new DB cluster with encryption enabled. Update any database connection strings to reference the new DB cluster endpoint, and then delete the unencrypted DB cluster.
• C.Create an encrypted Aurora Replica of the unencrypted DB cluster. Promote the Aurora Replica as the new master.
• D.Create a new DB cluster with encryption enabled and use the pg_dump and pg_restore utilities to load data to the new DB cluster. Update any database connection strings to reference the new DB cluster endpoint, and then delete the unencrypted DB cluster.

Comment: *

Name: *

Email: *

Verification: *

A company stores session history for its users in an Amazon DynamoDB table. The company has a large user base and generates large amounts of session data.
Teams analyze the session data for 1 week, and then the data is no longer needed. A database specialist needs to design an automated solution to purge session data that is more than 1 week old.
Which strategy meets these requirements with the MOST operational efficiency?

• A.Create an AWS Step Functions state machine with a DynamoDB DeleteItem operation that uses the ConditionExpression parameter to delete items older than a week. Create an Amazon EventBridge (Amazon CloudWatch Events) scheduled rule that runs the Step Functions state machine on a weekly basis.
• B.Create an AWS Lambda function to delete items older than a week from the DynamoDB table. Create an Amazon EventBridge (Amazon CloudWatch Events) scheduled rule that triggers the Lambda function on a weekly basis.
• C.Enable Amazon DynamoDB Streams on the table. Use a stream to invoke an AWS Lambda function to delete items older than a week from the DynamoDB table
• D.Enable TTL on the DynamoDB table and set a Number data type as the TTL attribute. DynamoDB will automatically delete items that have a TTL that is less than the current time.

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 running a two-tier ecommerce application in one AWS account. The web server is deployed using an Amazon RDS for MySQL Multi-AZ DB instance. A Developer mistakenly deleted the database in the production environment. The database has been restored, but this resulted in hours of downtime and lost revenue.
Which combination of changes in existing IAM policies should a Database Specialist make to prevent an error like this from happening in the future? (Choose three.)

• A.Grant least privilege to groups, users, and roles
• B.Allow all users to restore a database from a backup that will reduce the overall downtime to restore the database
• C.Enable multi-factor authentication for sensitive operations to access sensitive resources and API operations
• D.Use policy conditions to restrict access to selective IP addresses
• E.Use AccessList Controls policy type to restrict users for database instance deletion
• F.Enable AWS CloudTrail logging and Enhanced Monitoring

Comment: *

Name: *

Email: *

Verification: *

A company wants to migrate its existing on-premises Oracle database to Amazon Aurora PostgreSQL. The migration must be completed with minimal downtime using AWS DMS. A Database Specialist must validate that the data was migrated accurately from the source to the target before the cutover. The migration must have minimal impact on the performance of the source database.
Which approach will MOST effectively meet these requirements?

• A.Use the AWS Schema Conversion Tool (AWS SCT) to convert source Oracle database schemas to the target Aurora DB cluster. Verify the datatype of the columns.
• B.Use the table metrics of the AWS DMS task created for migrating the data to verify the statistics for the tables being migrated and to verify that the data definition language (DDL) statements are completed.
• C.Enable the AWS Schema Conversion Tool (AWS SCT) premigration validation and review the premigration checklist to make sure there are no issues with the conversion.
• D.Enable AWS DMS data validation on the task so the AWS DMS task compares the source and target records, and reports any mismatches.

Comment: *

Name: *

Email: *

Verification: *