Archival Solution for Data Warehouse: Cost-Efficient Storage Options

Selecting a Cost-Efficient Storage Option for Archiving Data

Question

You are building an archival solution for your data warehouse and have selected Cloud Storage to archive your data.

Your users need to be able to access this archived data once a quarter for some regulatory requirements.

You want to select a cost-efficient option.

Which storage option should you use?

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D.

A.

Nearline, Coldline, and Archive offer ultra low-cost, highly-durable, highly available archival storage.

For data accessed less than once a year, Archive is a cost- effective storage option for long-term preservation of data.

Coldline is also ideal for cold storage"data your business expects to touch less than once a quarter.

For warmer storage, choose Nearline: data you expect to access less than once a month, but possibly multiple times throughout the year.

All storage classes are available across all GCP regions and provide unparalleled sub-second access speeds with a consistent API.

https://cloud.google.com/storage/archival

For archival solutions, Google Cloud Platform (GCP) provides several storage options that offer cost-effectiveness based on access frequency and retrieval time. As the requirement is to access the data once a quarter, a suitable storage option that satisfies both cost-effectiveness and accessibility needs to be selected.

A. Cold Storage: Cold Storage is a GCP storage option designed for storing infrequently accessed data that can tolerate several hours of retrieval latency. Cold Storage is the most cost-effective storage option available in GCP but has the longest retrieval times compared to other storage options. As users need to access the archived data every quarter, this storage option may not be suitable due to its high retrieval latency.

B. Nearline Storage: Nearline Storage is a GCP storage option that offers a balance between cost and retrieval latency. Nearline Storage is designed for data that is accessed less than once a month but requires faster retrieval times than Cold Storage. Nearline Storage offers slightly higher storage costs than Cold Storage but provides lower retrieval latency. As users need to access the archived data once a quarter, Nearline Storage can be an appropriate storage option that meets both cost-effectiveness and accessibility requirements.

C. Regional Storage: Regional Storage is a GCP storage option designed for frequently accessed data that requires low latency and high durability within a single region. Regional Storage is not suitable for archival solutions as it does not offer cost-effectiveness for infrequently accessed data.

D. Multi-Regional Storage: Multi-Regional Storage is a GCP storage option that offers high durability and low latency for frequently accessed data worldwide. Multi-Regional Storage is not suitable for archival solutions as it does not offer cost-effectiveness for infrequently accessed data.

Therefore, the best storage option to archive data in GCP, that provides cost-effectiveness and accessibility for data access once a quarter, is Nearline Storage.