GCP Storage General Flashcards
What storage would I use for unstructured data, requiring no analytics?
Google Cloud Storage
What is Cloud SQL?
It is a managed service for Postgres and MySQL
Is Cloud SQL structured or unstructured data?
Structured data
What is Cloud BigTable?
It is a manged noSQL database for structured data
Is GCP Cloud BigTable, structured database?
Yes
I have structured data what is my options in GCP for storing such data?
- Cloud SQL
- Datastore (noSQL)
- Bigtable (noSQL)
- Spanner (newSQL)
What options do I have in GCP for unstructured data?
- Google Cloud Storage
- Firebase Cloud Storage
How do I choose between relational and non-relational database?
SQL - Consistent - ACID -More table noSQL - Scalable - Fewer tables
I am building a global scale application dealing with millions of user per min and I require a database, what are my options, SQL or noSQL?
noSQL
I require a noSQL database, what are my GCP options?
Bigtable, Satastore
I require a newSQL database, what GCP options do I have?
Spanner
I require a database for data that will be changing often, I intend to use GCP BigQuery, is this a valid option?
No BigQuery is aa data wherehouse and is intended for data storage and analytics, data is intended to be written once and not changed often.
I require a SQL database that has lo management, what GCP options do I have?
GCP CloudSQL, CloudSQL supports both MySQL and Postgres.
For an application, I use MySQL in my data centre and I am migrating to GCP, I also intend to make my application global scale dealing with millions of users per min, can I have GCP ClooudSQL?
No google CloudSQL has scale limits as it is a managed version of MySQL and Postgres. An option is to modify the application to use a noSQL option like GCP BigTable or DatStore.
Today I operate a MySQL database and intend to move the database to GCP, I need to scale out my the ability to provide my customers with reading operations, I do not need scaleout to write operations, what GCP options do I have when I migrate?
Because you what to make little changes to the database, the fastest and easy option are to use a readd replicate. Option to use a noSQL is the wrong option.
I require noSQL and ACID tranations, I am lookikng at using GCP Datastore, is this an option?
Yes noSQL and ACID as supported by GCP Datastore
Is GCP CloudNSQ a noOPS database?
It is not a noOPS database, its requires some settig up and configuration at the start.
What is the data size sutable for GCP Datastore?
0 to TB’s
I require a database for petabytes of data with no acid required, database can be nosql, what options do I have?
BigTable is a nosql data base with the ability to deal withPB’s of data.
I require high volume writes for a nosql database, what options do I have?
BigTable supports high volume writes.
Is DataStore lower cost and BigTable?
Yes, BigTable costs more then DataStore. The reason BigTable cost more is it is designed for PB scale and uses nodes and you have to have a minium of 3 mode running at all times and you are chanrged for the 3 nodes.
I have less then a TB of data and require a noSQL database, my options, Bigtable, Datastore. What is my best cost option?
DataStore, as it is lower cost then BigTable and still sutable for TB amounts of data?
I have PB of data and require a noSQL database, my options, Bigtable, Datastore. What is my best option?
BigTable as it can deal with PB of data?
What is GCP Spanner?
It is a SQL like database, but with better scalability, it horozontaly scales.
