<< Prev Question Next Question >>

Question 57/70

Your company has decided to build a backup replica of their on-premises user authentication PostgreSQL database on Google Cloud Platform. The database is 4 TB, and large updates are frequent. Replication requires private address space communication.
Which networking approach should you use?

Recent Comments (The most recent comments are at the top.)

rubje - Jun 06, 2019

https://cloud.google.com/solutions/images/transfer-speed.png

A single vpn can be up to 1.5 Gbps?. Then it would take around 10 hours to transfer 4TB. For 1 time that is maybe acceptable. But what are large updates? 1TB? that would cost 2-3 hours(to much i think)

Then I would prefer Dedicated interconnect.

But large updates from 10GB would take less then 2 minutes and that is okay.

For me this question is not clear enough and still not sure if it is VPN or Dedicated Interconnect

Pavan - Nov 07, 2018

VPN is in public space and interconnect provides private address space

Ruben - Oct 10, 2018

It can&#39;t be &#39;A&#39; because it&#39;s not Cloud VPN (https://cloud.google.com/vpn/docs/concepts/overview but a VPN server installed on a GCP instance which not have enough troughput to handle the transfert

Eikistein - Sep 03, 2018

Agree with RK, VPN suits well but I would choose D
https://cloud.google.com/vpn/docs/concepts/overview

RK - Aug 12, 2018

VPN throughput is @GBits/sec in average: (1.5–3 Gbps for each tunnel https://cloud.google.com/solutions/best-practices-for-iam-and-billing-in-higher-education#networking_options)

So to transfer 1GB = 8Gb requires 4 seconds.
1TB -&gt; 4 * 1024 / 3600 = 1.14h
4TB -&gt; around 5 hours to copy the whole DB

Both VPN and interconnect provide private address space.
I suppose that 1GB per 4 sec are totally enough for large frequent updates of user authentication data into backup replica.

Interconnect requires close location to Google supported colocation facility, either directly or through a carrier and it cost a lot. So there is no reason to make dedicated interconnect just for backup replica.

bob - Aug 12, 2018

It is not said that it should be cost effective though. In this case dedictated interconnect is best option.

tlan - Aug 05, 2018

Something is wrong with your math Alex:
1GByte=8Gbits
transferring of 8gbits via 10 gbits channel will take much less than 18 minutes.
https://cloud.google.com/interconnect/
Assuming that VPN could have up to 3GBs transferring of 4TB would take ~5-12 hours.
So I&#39;d go with VPN if on-premise DC has such hardware.

Alex - Jun 18, 2018

1 GB om 10 GB network which is min requirement for cloud VPN takes 18 minutes.
1TB -12 days.
4TB -48 days.
Answer C unfortunately is most suitable here.

Roger - Jun 12, 2018

I agree with Stonewealth, answer is - C
Both VPN and Dedicated Interconnect provide private address space communication. Yet, due to "The database is 4 TB, and large updates are frequent", the Dedicated Interconnect would be able to deliver a more suitable connection bandwidth.

stonewealth - Jun 10, 2018

I think answer should be C.

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (70q)
2 commentQuestion 1: For this question, refer to the JencoMart case study. JencoM...
6 commentQuestion 2: You want to enable your running Google Container Engine clus...
10 commentQuestion 3: Your application needs to process credit card transactions. ...
4 commentQuestion 4: For this question refer to the TerramEarth case study Operat...
2 commentQuestion 5: For this question, refer to the TerramEarth case study Your ...
3 commentQuestion 6: You want to make a copy of a production Linux virtual machin...
10 commentQuestion 7: For this question, refer to the Dress4Win case study. As par...
6 commentQuestion 8: Your company just finished a rapid lift and shift to Google ...
7 commentQuestion 9: Your solution is producing performance bugs in production th...
6 commentQuestion 10: Your organization requires that metrics from all application...
4 commentQuestion 11: You are creating a solution to remove backup files older tha...
2 commentQuestion 12: Your organization has a 3-tier web application deployed in t...
7 commentQuestion 13: Your company's test suite is a custom C++ application that r...
1 commentQuestion 14: For this question, refer to the TerramEarth case study. Terr...
5 commentQuestion 15: A news teed web service has the following code running on Go...
10 commentQuestion 16: For this question, refer to the JencoMart case study. JencoM...
8 commentQuestion 17: For this question, refer to the Mountkirk Games case study. ...
4 commentQuestion 18: A lead engineer wrote a custom tool that deploys virtual mac...
Question 19: You want to optimize the performance of an accurate, real-ti...
5 commentQuestion 20: For this question, refer to the TerramEarth case study. To s...
8 commentQuestion 21: You are designing a large distributed application with 30 mi...
3 commentQuestion 22: For this question, refer to the JencoMart case study. JencoM...
Question 23: For this question, refer to the Dress4Win case study. You wa...
3 commentQuestion 24: One of your primary business objectives is being able to tru...
3 commentQuestion 25: Your company places a high value on being responsive and mee...
4 commentQuestion 26: For this question, refer to the Mountkirk Games case study. ...
2 commentQuestion 27: Your development team has installed a new Linux kernel modul...
2 commentQuestion 28: You have created several preemptible Linux virtual machine i...
2 commentQuestion 29: For this question, refer to the Dress4Win case study. Dress4...
4 commentQuestion 30: The application reliability team at your company has added a...
1 commentQuestion 31: For this question, refer to the Mountkirk Games case study. ...
5 commentQuestion 32: For this question, refer to the TerramEarth case study. Terr...
6 commentQuestion 33: For this question, refer to the TerramEarth case study. Terr...
5 commentQuestion 34: For this question, refer to the Dress4Win case study. Dress4...
2 commentQuestion 35: Your company's user-feedback portal comprises a standard LAM...
Question 36: You need to reduce the number of unplanned rollbacks of erro...
1 commentQuestion 37: Your company wants to try out the cloud with low risk. They ...
3 commentQuestion 38: For this question, refer to the Dress4Win case study. The Dr...
1 commentQuestion 39: Your company plans to migrate a multi-petabyte data set to t...
8 commentQuestion 40: For this question, refer to the JencoMart case study A few d...
6 commentQuestion 41: A development manager is building a new application He asks ...
1 commentQuestion 42: You set up an autoscaling instance group to serve web traffi...
13 commentQuestion 43: For this question, refer to the TerramEarth case study. Terr...
4 commentQuestion 44: To reduce costs, the Director of Engineering has required al...
2 commentQuestion 45: During a high traffic portion of the day, one of your relati...
5 commentQuestion 46: Your company runs several databases on a single MySQL instan...
Question 47: You deploy your custom Java application to Google App Engine...
4 commentQuestion 48: The database administration team has asked you to help them ...
3 commentQuestion 49: For this question, refer to the JencoMart case study. The Je...
6 commentQuestion 50: You write a Python script to connect to Google BigQuery from...
7 commentQuestion 51: For this question, refer to the Mountkirk Games case study M...
Question 52: Your company has successfully migrated to the cloud and want...
2 commentQuestion 53: A lead software engineer tells you that his new application ...
1 commentQuestion 54: For this question, refer to the Dress4Win case study. As par...
2 commentQuestion 55: For this question, refer to the JencoMart case study. JencoM...
4 commentQuestion 56: Your customer is receiving reports that their recently updat...
10 commentQuestion 57: Your company has decided to build a backup replica of their ...
Question 58: Your marketing department wants to send out a promotional em...
Question 59: Your company is forecasting a sharp increase in the number a...
8 commentQuestion 60: You have been asked to select the storage system for the cli...
Question 61: Your company wants to track whether someone is present in a ...
3 commentQuestion 62: A small number of API requests to your microservices-based a...
Question 63: Your company's test suite is a custom C++ application that r...
7 commentQuestion 64: You are helping the QA team to roll out a new load-testing t...
7 commentQuestion 65: An application development team believes their current loggi...
4 commentQuestion 66: For this question, refer to the Mountkirk Games case study. ...
5 commentQuestion 67: For this question, refer to the Dress4Win case study. Dress4...
5 commentQuestion 68: For this question, refer to the JencoMart case study. The mi...
7 commentQuestion 69: One of the developers on your team deployed their applicatio...
7 commentQuestion 70: Your customer is moving an existing corporate application to...