A database professional is tasked with the task of migrating 25 GB of data files from an on-premises storage system to an Amazon Neptune database.
Which method of data loading is the FASTEST?

• A.Upload the data to Amazon S3 and use the Loader command to load the data from Amazon S3 into the Neptune database.
• B.Write a utility to read the data from the on-premises storage and run INSERT statements in a loop to load the data into the Neptune database.
• C.Use the AWS CLI to load the data directly from the on-premises storage into the Neptune database.
• D.Use AWS DataSync to load the data directly from the on-premises storage into the Neptune database.

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: *

A database specialist is responsible for an Amazon RDS for MySQL DB instance with one read replica. The DB instance and the read replica are assigned to the default parameter group. The database team currently runs test queries against a read replica. The database team wants to create additional tables in the read replica that will only be accessible from the read replica to benefit the tests.
Which should the database specialist do to allow the database team to create the test tables?

• A.Contact AWS Support to disable read-only mode on the read replica. Reboot the read replica. Connect to the read replica and create the tables.
• B.Change the read_only parameter to false (read_only=0) in the default parameter group of the read replica. Perform a reboot without failover. Connect to the read replica and create the tables using the local_only MySQL option.
• C.Change the read_only parameter to false (read_only=0) in the default parameter group. Reboot the read replica. Connect to the read replica and create the tables.
• D.Create a new DB parameter group. Change the read_only parameter to false (read_only=0). Associate the read replica with the new group. Reboot the read replica. Connect to the read replica and create the tables.

Comment: *

Name: *

Email: *

Verification: *

A company has an Amazon RDS Multi-AZ DB instances that is 200 GB in size with an RPO of 6 hours. To meet the company's disaster recovery policies, the database backup needs to be copied into another Region.
The company requires the solution to be cost-effective and operationally efficient.
What should a Database Specialist do to copy the database backup into a different Region?

• A.Use Amazon RDS automated snapshots and use AWS Lambda to copy the snapshot into another Region
• B.Use Amazon RDS automated snapshots every 6 hours and use Amazon S3 cross-Region replication to copy the snapshot into another Region
• C.Create an AWS Lambda function to take an Amazon RDS snapshot every 6 hours and use a second Lambda function to copy the snapshot into another Region
• D.Create a cross-Region read replica for Amazon RDS in another Region and take an automated snapshot of the read replica

Comment: *

Name: *

Email: *

Verification: *

An online advertising website uses an Amazon DynamoDB table with on-demand capacity mode as its data store. The website also has a DynamoDB Accelerator (DAX) cluster in the same VPC as its web application server. The application needs to perform infrequent writes and many strongly consistent reads from the data store by querying the DAX cluster.
During a performance audit, a systems administrator notices that the application can look up items by using the DAX cluster. However, the QueryCacheHits metric for the DAX cluster consistently shows 0 while the QueryCacheMisses metric continuously keeps growing in Amazon CloudWatch.
What is the MOST likely reason for this occurrence?

• A.A VPC endpoint was not added to access DynamoDB.
• B.Strongly consistent reads are always passed through DAX to DynamoDB.
• C.DynamoDB is scaling due to a burst in traffic, resulting in degraded performance.
• D.A VPC endpoint was not added to access CloudWatch.

Comment: *

Name: *

Email: *

Verification: *