Databases

Question 1

Relational Database

Answer 1

Structured data that strongly represents tabular data (tables, rows and columns)

Row-oriented or Columnar-oriented

Question 2

Non-relational Database

Answer 2

Semi-structured that may or may not distantly resemble tabular data.

Question 3

What is a database?

Answer 3

A database is a data-store that stores semi-structured and structured data.

A database is more complex data stores because it requires using formal design and modeling techniques

Question 4

Databases Functionality

Answer 4

specialized language to query (retrieve data)
• specialized modeling strategies to optimize retrieval
for different use cases
• more fine tune control over the transformation of
the data into useful data structures or reports
Normally a databases infers someone is using a relational row-oriented data store

Question 5

Cloud Bigtable

Answer 5

Petabyte Scale, low-latency, non-relational

Question 6

Cloud Firestore

Answer 6

NoSQL, serverless, document DB

Question 7

Cloud Memorystore

Answer 7

Managed Redi’s and Memcached

Question 8

Cloud Spanner

Answer 8

Horizontally scalable relational database

Question 9

Cloud SQL

Answer 9

Managed mySQL, Postgre SQL, SQL Server

Question 10

Database Migration Service

Answer 10

Migrate to Cloud SQL

Question 11

DB Insights

Answer 11

SQL Inspector