What are the data lifecycle four stages?
- Ingest (acquiring data and bringing data into the GCP)
- Store (persisting data to a storage system)
- Process and analyze (transforming data into a usable format for analysis applications)
- Explore and visualize
What are the three ingestion modes?
- Application data
- Streaming data
- Batch data
What is nearline storage and coldline storage?
Nearline storage is used for data that is accessed less than once per
30 days. Coldline storage is used to store data accesses less than once
per year.
What are 3 types of data structure how do they differ?
- Structured (Structured data has a fixed set of attributes that can be modeled in a table of rows and columns.)
- Semi-structured (Semi-structured data has attributes like structured data, but the set of attributes can vary from one instance to another.)
- Unstructured (Unstructured data does not fit into a tabular structure. Images and audio files are good examples of unstructured data.)
What are types of structured data structure?
- Transactional (one row at time)
- Analytical (table aggregation)
What are types of Semi-Structured data structure?
- Fully Indexed (index per each field)
- Row Key Access (just an id)
Which storage technology (for structured data) for:
1. Transactional - Regional
2. Transactional - Global
3. Analytical
- Cloud SQL
- Cloud Spanner
- BigQuery
Which storage technology (for semi structured data) for:
1. Fully indexed
2. Row Key
- Cloud datastore
- Bigtable
Which storage technology for unstructured data
Cloud storage
Expand the acronym: OLTP
Online transaction processing
Expand the acronym: OLTP
Online analytical processing
What are NoSQL databases designs?
- Key-value
- Document
- Wide column
- Graph
How key-value database design works?
Which storage tool works with this paradigm?
Key-value data stores are databases that use associative arrays or dictionaries as the basic datatype. Keys are data used to look up values.
Tool in gcp is: Cloud Memorystore
How document database design works?
Which storage tool works with this paradigm?
Document stores allow complex data structures, called documents, to be used as values and accessed in more ways than simple key lookup.
Tool in gcp is: Cloud Datastore.
What is the tool for storing loging data?
Stackdriver Logging is a menaged service designed for storing logging data
What is the best storage service for a IoT data
Bigtable
What is the best tool designed for transaction processing at a regional level
Cloud SQL
