DBS-C01 practice question 34 of 35

Amazon Neptune is being used by a corporation as the graph database for one of its products. During an ETL procedure, the company's data science team…

Full set: 322 questions
Amazon Neptune is being used by a corporation as the graph database for one of its products. During an ETL procedure, the company's data science team produced enormous volumes of temporary data by unintentionally. The Neptune DB cluster extended its storage capacity automatically to handle the added data, but the data science team erased the superfluous data. What should a database professional do to prevent incurring extra expenditures for cluster volume space that is not being used?
Answer options
A: Take a snapshot of the cluster volume. Restore the snapshot in another cluster with a smaller volume size.
B: Use the AWS CLI to turn on automatic resizing of the cluster volume.
C: Export the cluster data into a new Neptune DB cluster. Correct answer
D: Add a Neptune read replica to the cluster. Promote this replica as a new primary DB instance. Reset the storage space of the cluster.
Correct Answer:
C. Export the cluster data into a new Neptune DB cluster.
Explanation

The only way to shrink the storage space used by your DB cluster when you have a large amount of unused allocated space is to export all the data in your graph and then reload it into a new DB cluster. Creating and restoring a snapshot does not reduce the amount of storage allocated for your DB cluster, because a snapshot retains the original image of the cluster's underlying storage.

Scroll to Top