A company is building a software as a service application. As part of the new user sign-on workflow, a Python script invokes the CreateTable operation using the Amazon DynamoDB API. After the call returns, the script attempts to call PutItem.
Occasionally, the PutItem request fails with a ResourceNotFoundException error, which causes the workflow to fail. The development team has confirmed that the same table name is used in the two API calls.
How should a database specialist fix this issue?

• A.Add an allow statement for the dynamodb:PutItem action in a policy attached to the role used by the application creating the table.
• B.Set the StreamEnabled property of the StreamSpecification parameter to true, then call PutItem.
• C.Change the application to call DescribeTable periodically until the TableStatus is ACTIVE, then call PutItem.
• D.Add a ConditionExpression parameter in the PutItem request.

Comment: *

Name: *

Email: *

Verification: *

A Database Specialist has migrated an on-premises Oracle database to Amazon Aurora PostgreSQL. The schema and the data have been migrated successfully. The on-premises database server was also being used to run database maintenance cron jobs written in Python to perform tasks including data purging and generating data exports. The logs for these jobs show that, most of the time, the jobs completed within 5 minutes, but a few jobs took up to 10 minutes to complete. These maintenance jobs need to be set up for Aurora PostgreSQL.
How can the Database Specialist schedule these jobs so the setup requires minimal maintenance and provides high availability?

• A.Create cron jobs on an Amazon EC2 instance to run the maintenance jobs following the required schedule.
• B.Connect to the Aurora host and create cron jobs to run the maintenance jobs following the required schedule.
• C.Create AWS Lambda functions to run the maintenance jobs and schedule them with Amazon CloudWatch Events.
• D.Create the maintenance job using the Amazon CloudWatch job scheduling plugin.

Comment: *

Name: *

Email: *

Verification: *

A Database Specialist is migrating a 2 TB Amazon RDS for Oracle DB instance to an RDS for PostgreSQL DB instance using AWS DMS. The source RDS Oracle DB instance is in a VPC in the us-east-1 Region. The target RDS for PostgreSQL DB instance is in a VPC in the use-west-2 Region.
Where should the AWS DMS replication instance be placed for the MOST optimal performance?

• A.In the same Region and VPC of the source DB instance
• B.In the same Region and VPC as the target DB instance
• C.In the same VPC and Availability Zone as the target DB instance
• D.In the same VPC and Availability Zone as the source DB instance

Comment: *

Name: *

Email: *

Verification: *

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

Comment: *

Name: *

Email: *

Verification: *

A company has migrated a single MySQL database to Amazon Aurora. The production data is hosted in a DB cluster in VPC_PROD, and 12 testing environments are hosted in VPC_TEST using the same AWS account.
Testing results in minimal changes to the test data. The Development team wants each environment refreshed nightly so each test database contains fresh production data every day.
Which migration approach will be the fastest and most cost-effective to implement?

• A.Run the master in Amazon Aurora MySQL using Aurora Serverless. Create 12 clones in VPC_TEST, andscript the clones to be deleted and re-created nightly.
• B.Run the master in Amazon Aurora MySQL. Create 12 Aurora Replicas in VPC_TEST, and script thereplicas to be deleted and re-created nightly.
• C.Run the master in Amazon Aurora MySQL. Create 12 clones in VPC_TEST, and script the clones to bedeleted and re-created nightly.
• D.Run the master in Amazon Aurora MySQL. Take a nightly snapshot, and restore it into 12 databases inVPC_TEST using Aurora Serverless.

Comment: *

Name: *

Email: *

Verification: *