Practice Test 2 | Google Cloud Certified Professional Data Engineer | Dumps | Mock Test
An e-wallet company is designing a relational database solution for their e-payment transactions. Database will face high read/write transactions and accessed from different parts of Europe and may be expanded to other continents in the future. The database should be scalable and able to scale out to meet high demands.
What is the best approach for this scenario?
A. Use Cloud BigTable as a database. For scaling out, monitor CPU utilization and increase nodes when more than 75% of CPU is utilized in a 15-minute timespan.
B. Use Cloud SQL as a database. For scaling out, monitor disk utilization and increase nodes when more than 85% of storage is utilized in a 15-minute timespan.
C. Use Cloud BigTable as a database. For scaling out, monitor memory utilization and increase nodes when more than 80% of memory is utilized in a 15-minute timespan.
D. Use Cloud Spanner as a database. For scaling out, monitor CPU utilization and increase nodes when more than 75% of CPU is utilized in a 15-minute timespan.
Answer D.
Cloud Spanner is a horizontally scalable, strongly consistent, relational database service. it’s built to combine the benefits of relational database structure with non-relational horizontal scale. This delivers high-performance transactions and strong consistency across rows, regions and continents.
While Cloud Spanner does not automatically scale the number of nodes, You may set up notifications for Cloud Spanner using Stackdriver monitoring for CPU utilization alerts based on the threshold set. In this scenario, we need to scale out (increase nodes) when we are notified of high usage.
Answer A & C are incorrect: BigTable is not a relational database. It doesn’t meet the scenario’s requirements.
Answer B is incorrect: Cloud SQL cannot scale out on the fly and it does not support multi-regional/continental coverage.
Source(s):
Cloud Spanner:
https://cloud.google.com/spanner/
Cloud Spanner scale out: https://cloud.google.com/spanner/docs/instances
Stackdriver monitoring: https://cloud.google.com/spanner/docs/monitoring
Comments are closed, but trackbacks and pingbacks are open.