A company is deploying their application on Google Cloud Platform. Company policy requires long-term data to be stored using a solution that can automatically replicate data over at least two geographic places.
Which Storage solution are they allowed to use?
The correct answer is Cloud Bigtable. Cloud Bigtable provides replication across multiple regions or multiple zones within the same region, which aligns with the requirement of automatically replicating data over at least two geographic places for long-term storage. The other options do not fully meet the criteria: Cloud BigQuery primarily handles data analytics and, while it offers durability, it does not explicitly provide cross-region replication in the same manner. Compute Engine SSD and Persistent Disks are not designed for long-term storage solutions and their replication capabilities are limited to within single regions or zones, not across multiple geographic locations.
https://cloud.google.com/bigquery#:~:text=BigQuery%20transparently%20and%20automatically%20provides,charge%20and%20no%20additional%20setup.&text=BigQuery%20also%20provides%20ODBC%20and,interact%20with%20its%20powerful%20engine. Answer is B. BigQuery transparently and automatically provides highly durable, replicated storage in multiple locations and high availability with no extra charge and no additional setup. @xhova: https://cloud.google.com/bigquery-transfer/docs/locations What it mentions here is once you create a replication. YOu cannot change a location. Here the question is about high availability. synchronous replication.
Correct answer is A. B is not correct because: "BigQuery does not automatically provide a backup or replica of your data in another geographic region." https://cloud.google.com/bigquery/docs/availability
"In either case, BigQuery automatically stores copies of your data in two different Google Cloud zones within the selected location." your link
Correct answer is B. BQ: https://cloud.google.com/bigquery-transfer/docs/locations#multi-regional-locations and https://cloud.google.com/bigquery-transfer/docs/locations#colocation_required Bigtable: https://cloud.google.com/bigtable/docs/locations PS: To people that are only commenting an answer, please provide a valid source to back your answers. This is a community driven forum and just spamming with wrong answers affects all of us.
The answer is definitely A. Here's why: https://cloud.google.com/bigtable/docs/replication-overview#how-it-works Replication for Cloud Bigtable lets you increase the availability and durability of your data by copying it across multiple regions or multiple zones within the same region. You can also isolate workloads by routing different types of requests to different clusters. BQ does not do cross-region replication. The blue highlighted note in the two links below clearly says the following: "Selecting a multi-region location does NOT provide cross-region replication NOR regional redundancy. Data will be stored in a single region within the geographic location." https://cloud.google.com/bigquery/docs/reliability-disaster#availability_and_durability https://cloud.google.com/bigquery/docs/locations#multi-regions
I was about to select D, BUT: - the question says "long term data" -> which makes me think about BQ - the replication of persistent disk is between different ZONES, but the question says "different geo location" -> which means different regions (if you look at the zone distribution, different zones in same region are located in the same datacenter) but I still have doubt since the application data are not supposed to be stored in BQ , unless it is for analytics and so on. GCS would have been the best choice, but in absence of this, probably B is the 1st choice.
Thank God we have you giovy_82, very good explanation.
Answer is A. the below statement is from the google cloud documentation. https://cloud.google.com/bigquery/docs/reliability-disaster BigQuery does not automatically provide a backup or replica of your data in another geographic region
The answer is D. Do not forget the context, we are talking here about an Application and its storage, we are not talking about high throughput low latency database (Bigtable) or Analytics Database (BigQuery). On the other way SSDs are physically attached to the VM.
https://cloud.google.com/bigquery/docs/availability#availability_and_durability As per the link above BigQuery does not automatically provide a backup or replica of your data in another geographic region. It only stores copies of data in two different Google Cloud zones within the selected location. Reading through the link https://cloud.google.com/bigtable/docs/replication-overview It states that the Bigtable replicates any changes to your data automatically within a region or multi-region.
Multiregion
B. Cloud BigQuery
I think answer is B First of reason is long-term data solution, it's suitable for Cloud Storage and BigQuery Second is that BigQuery dataset is placed to multi-region that means that two or more regions.
Point not to be confused , Even with BQ multi region , data s stores in different ones in 1 region not different geographic regions. The question asks " different geographic places " which means essentially seperate zone storage will work. hence answer is B ( Big query ) either single region or multi region . Both suffice
--- Typo correction --- Point not to be confused , Even with BQ multi region , data is stored in different zones in 1 region & not different geographic regions. The question asks " different geographic places " which means essentially separate zone storage will work. hence answer is B ( Big query ) either single region or multi region . Both suffice
I am drifting towards D Regional persistent disk are safe from zonal failures. The question mentions different geo places ( not regions ) . So if zone seperation is done in 1 google region and we use regional persistent disk , the data will be safe from failure. Also why would someone move their DR to BQ ? persistent disk make more sense to me
Correct one is A, as BigQuery does not provide replication but multi location storage which is different
Answer is A - Cloud Bigtable. Cloud Bigtable - Replication: This page provides a detailed overview of how Cloud Bigtable uses replication to increase the availability and durability of your data. Cloud BigQuery: From the BigQuery product description, you can see that it is mainly focused on analyzing data and does not mention geographic replication of data as a feature. Compute Engine Disks: The documentation for Compute Engine Disks explains that they are zonal resources, meaning they are replicated within a single zone, but not across multiple zones or regions.
this is geographic, not region, then the correct ans is D
In my opinion the key word is "automatic" because BigQuery and BigeTable are by default store on one zone for a piece of data (no replication) Withe BigTable replication is automatic : https://cloud.google.com/bigtable/docs/replication-overview and copy dataset on Bigquery is not automatic https://cloud.google.com/bigquery/docs/managing-datasets#copy-datasets I go to A
BigQuery automatically stores copies of your data in two different Google Cloud zones within a single region in the selected location. https://cloud.google.com/bigquery/docs/locations
Answer is D, becasue: A. Cloud Bigtable: This is a NoSQL database service, not designed for long-term data storage with automatic geographic replication. B. Cloud BigQuery: This is a data warehouse service, excellent for analyzing data, but it doesn't inherently replicate data for disaster recovery. C. Compute Engine SSD Disk: These are local disks attached to virtual machines, not designed for long-term storage or automatic replication.