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.