A Database Specialist migrated an existing production MySQL database from on-premises to an Amazon RDS for MySQL DB instance. However, after the migration, the database needed to be encrypted at rest using AWS KMS. Due to the size of the database, reloading, the data into an encrypted database would be too time- consuming, so it is not an option.

How should the Database Specialist satisfy this new requirement?

A. Create a snapshot of the unencrypted RDS DB instance. Create an encrypted copy of the unencrypted snapshot. Restore the encrypted snapshot copy.

B. Modify the RDS DB instance. Enable the AWS KMS encryption option that leverages the AWS CLI.

C. Restore an unencrypted snapshot into a MySQL RDS DB instance that is encrypted.

D. Create an encrypted read replica of the RDS DB instance. Promote it the master.

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

A coffee machine manufacturer is equipping all of its coffee machines with 10T sensors. The 10T core application is writing measurements for each record to Amazon Timestream. The records have multiple dimensions and measures. The measures include multiple measure names and values.

An analysis application is running queries against the Timestream database and is focusing on data from the current week. A database specialist needs to optimize the query costs of the analysis application.

Which solution will meet these requirements?

A. Ensure that queries contain whole records over the relevant time range.

B. Use time range, measure name, and dimensions in the WHERE clause of the query.

C. Avoid canceling any query after the query starts running.

D. Implement exponential backoff in the application.

A database specialist is launching a test graph database using Amazon Neptune for the first time. The database specialist needs to insert millions of rows of test observations from a .csv file that is stored in Amazon S3. The database specialist has been using a series of API calls to upload the data to the Neptune DB instance.

Which combination of steps would allow the database specialist to upload the data faster? (Choose three.)

A. Ensure Amazon Cognito returns the proper AWS STS tokens to authenticate the Neptune DB instance to the S3 bucket hosting the CSV file.

B. Ensure the vertices and edges are specified in different .csv files with proper header column formatting.

C. Use AWS DMS to move data from Amazon S3 to the Neptune Loader.

D. Curl the S3 URI while inside the Neptune DB instance and then run the addVertex or addEdge commands.

E. Ensure an IAM role for the Neptune DB instance is configured with the appropriate permissions to allow access to the file in the S3 bucket.

F. Create an S3 VPC endpoint and issue an HTTP POST to the database's loader endpoint.

A company runs an ecommerce application on premises on Microsoft SQL Server. The company is planning to migrate the application to the AWS Cloud. The application code contains complex T-SQL queries and stored procedures.

The company wants to minimize database server maintenance and operating costs after the migration is completed. The company also wants to minimize the need to rewrite code as part of the migration effort.

Which solution will meet these requirements?

A. Migrate the database to Amazon Aurora PostgreSQL. Turn on Babelfish.

B. Migrate the database to Amazon S3. Use Amazon Redshift Spectrum for query processing.

C. Migrate the database to Amazon RDS for SQL Server. Turn on Kerberos authentication.

D. Migrate the database to an Amazon EMR cluster that includes multiple primary nodes.