What is Cloud SQL?
Cloud SQL is a fully managed relational database service that supports MySQL, PostgreSQL, and SQL Server databases.
What is Cloud Spanner?
Cloud Spanner is Google’s relational, horizontally scalable, global database. It is a relational database, so it supports fixed schemas and is ANSI SQL 2011 compliant. Cloud Spanner provides strong consistency, so all parallel processes see the same state of the database. This consistency is different from NoSQL databases, which are generally eventually consistent, allowing parallel processes to see different states of the database. Cloud Spanner is highly available and does not require failover instances in the way that Cloud SQL does. It also manages automatic replication.
What is Cloud Bigtable?
Cloud Bigtable is a wide-column NoSQL database used for high-volume databases that require low millisecond (ms) latency. Cloud Bigtable is used for IoT, time-series, finance, and similar applications.
What is Cloud Firestore?
Cloud Firestore is the managed document database that is replacing Cloud Datastore. Document databases are used when the structure of data can vary from one record to another.
What is BigQuery?
BigQuery are fully managed, petabyte-scale, low-cost analytics data warehouse databases.
As with other databases, some common tasks are as follows
How do the concpent of slots works in BigQuery?
BigQuery uses the concept of slots for allocating computing resources to execute queries. For most users, the default number of slots is sufficient, but very large queries, or a large number of concurrent queries, could see a performance benefit with additional slots. The default number of slots is shared across a project, and as long as you are not processing
more than 100 GB at once, you will probably be using less than the maximum number of slots, which is 2,000. The 2,000-slot limit only applies to on-demand pricing; Google also offers flat-rate pricing for enterprises with a need for more slots.
What is Cloud Memorystore?
Cloud Memorystore is a managed Redis service, which is commonly used for caching. Redis instances can be created using the Cloud Console or gcloud commands. There are only a small number of basic configuration parameters with Cloud Memorystore?
Redis is an open-source, in-memory data store that can be used as a database, cache, or message broker. The name “Redis” stands for REmote DIctionary Server. It is known for its incredibly fast performance, which comes from storing data directly in a computer’s main memory (RAM) rather than on a disk.
Redis functions as a key-value store.
What is Cloud SQL Proxy
Is a tool that provides secure access to Second Generation instances without you having to create allow lists or configure SSL.
What is recommended level of CPU utilization for a:
1. Regional cloud spanner instance
2. Multi-regional cloud spanner instance
65% for regional
45% for mutliregional
How many data can store one cloud spanner node?
2 TB per one node
