ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam
Go to Exam

Exam AWS Certified Database - Specialty topic 1 question 178 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 178
Topic #: 1
[All AWS Certified Database - Specialty Questions]

A company is using Amazon Neptune as the graph database for one of its products. The company's data science team accidentally created large amounts of temporary information during an ETL process. The Neptune DB cluster automatically increased the storage space to accommodate the new data, but the data science team deleted the unused information.
What should a database specialist do to avoid unnecessary charges for the unused cluster volume space?

  • 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.
  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by leunamE at Nov. 11, 2021, 11:43 p.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
leunamE
Highly Voted 3 years, 6 months ago
Option C. 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.
upvoted 11 times
johnconnor
3 years, 6 months ago
you are actually right, taking from AWS documentation "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. See Neptune's data export service and utility for an easy way to export data from a DB cluster, and Neptune's bulk loader for an easy way to import data back into Neptune."
upvoted 3 times
...
user0001
3 years, 3 months ago
Neptune storage allocation Even though a Neptune cluster volume can grow to 64 TiB, you are only charged for the space actually allocated. The total space allocated is determined by the storage high water mark, which is the maximum amount allocated to the cluster volume at any time during its existence. This means that even if user data is removed from a cluster volume, such as by a drop query like g.V().drop(), the total allocated space remains the same. Neptune does automatically optimize the unused allocated space for reuse in the future.
upvoted 1 times
...
...
novice_expert
Most Recent 3 years, 1 month ago
Selected Answer: C
https://docs.aws.amazon.com/neptune/latest/userguide/feature-overview-storage.html#feature-overview-storage-best-practices 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.
upvoted 2 times
...
Dantas
3 years, 2 months ago
Selected Answer: C
C "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." https://docs.aws.amazon.com/neptune/latest/userguide/feature-overview-storage.html
upvoted 3 times
...
RotterDam
3 years, 3 months ago
Selected Answer: C
Answer is C. Its very easy to get tricked into "Restoring from a snapshot" but remember - restoring from a snapshot WONT change the storage capacity (in console RDS Snapshot > Restore > under Allocate Capacity its greyed out).
upvoted 3 times
...
jove
3 years, 5 months ago
Selected Answer: C
Option C
upvoted 4 times
...
mnzsql365
3 years, 5 months ago
Ans is C 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.
upvoted 2 times
...
GMartinelli
3 years, 6 months ago
Selected Answer: C
Option C. As for every provisioned storage in AWS, you cant reduce the capacity choosen, you need to create a new one and transfer the data.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel