Exam AWS Certified Database - Specialty topic 1 question 171 discussion

BEF https://docs.aws.amazon.com/neptune/latest/userguide/bulk-load-data.html

https://docs.aws.amazon.com/neptune/latest/userguide/dms-neptune.html AWS Database Migration Service (AWS DMS) can load data into Neptune from supported source databases quickly and securely.

B. specification in separate csv E. access from Neptune to S3 F. S3 vpc endpoint to run Loader command

Amazon Neptune provides a Loader command for loading data from external files directly into a Neptune DB instance. You can use this command instead of executing a large number of INSERT statements, addV and addE steps, or other API calls. https://docs.aws.amazon.com/neptune/latest/userguide/bulk-load.html

The question is saying the professional has already uploaded the data. What was needed to complete the upload? Que: "The database professional uploaded the data to the Neptune DB instance through a series of API calls. Which sequence of actions enables the database professional to upload the data most quickly?" Ans: Setup S3 VPC endpoint. Setup the IAM roles with GET and LIST permissions to S3. Make sure the contents of CSV are accurate. These are (B) (E) (F)!!

Correct order of steps

Correct order of steps

B,E,F: Correct

BEF, Disagree with C: curl is issued from CLI to load the data from S3 to Neptune, not "log in" to to the database and run those commands: curl -X POST https://your-neptune-endpoint:port/loader \ -H 'Content-Type: application/json' \ -d ' { "source" : "s3://bucket-name/object-key-name", "format" : "opencypher", "userProvidedEdgeIds": "TRUE", "iamRoleArn" : "arn:aws:iam::account-id:role/role-name", "region" : "region", "failOnError" : "FALSE", "parallelism" : "MEDIUM", }'

I think BEF https://docs.aws.amazon.com/neptune/latest/userguide/bulk-load-optimize.html

DEF for me https://docs.aws.amazon.com/neptune/latest/userguide/bulk-load.html

BEF is the correct answer. Look out for the "got you" Amazon Neptune provides a Loader command for loading data from external files directly into a Neptune DB instance. You can use this command instead of executing a large number of INSERT statements, addV and addE steps, or other API calls. This makes D incorrect

CEF is the correct one!

Bcd Loader does not need separate a addvertex addedge

DEF From https://docs.aws.amazon.com/neptune/latest/userguide/bulk-load.html 1. Copy the data files to an Amazon Simple Storage Service (Amazon S3) bucket. 2. Create an IAM role with Read and List access to the bucket. 3. Create an Amazon S3 VPC endpoint. 4. Start the Neptune loader by sending a request via HTTP to the Neptune DB instance. 5. The Neptune DB instance assumes the IAM role to load the data from the bucket.