Data Foundations
This type of data has predefined schemas and fits neatly into tables
What is Structured Data?
A pipeline that processes data as it arrives instead of in batches
What is Streaming Processing?
A visualization best suited for comparing categories
What is a Bar Chart?
This cloud model offers infrastructure like VMs and networking
What is IaaS?
Role-based permissions limit this
What is Data Access?
A fact table typically contains this kind of data
What are Metrics or Measures?
In ELT, this step turns raw data into business-ready data
What is Transform?
This metric measures how fresh data is
What is Data Latency?
Storage optimized for large-scale unstructured data
What is Object Storage?
Masking PII while keeping data usable
What is Data Anonymization?
This concept ensures each data value is accurate and consistent over time
What is Data Quality?
This data architecture pattern organizes data into bronze, silver, and gold layers for ingestion, transformation, and serving
What is Medallion?
A dashboard used to show high-level KPIs across the organization to C-Suite and direct reports
What is an Executive Dashboard?
This concept ensures systems continue operating during failures
What is High Availability?
The regulation governing EU personal data protection
What is GDPR?
Slowly Changing Dimensions are used to track this
What is Historical Changes in Dimension Data?
A metric derived from other metrics, often leading to dependency chains
What is a Composite Metric?
This commonly random-generated primary key is used to distinguish individual records within a table
What is a UUID?
Automatically adjusting compute resources based on demand
What is Autoscaling?
Artifact that ensures data definitions mean the same thing across teams
What is a Data Dictionary?
The practice of tracing data from source to destination
What is Data Lineage?
The principle of designing systems to handle growth without rearchitecture
What is Scalability?
The analytical technique used to predict future outcomes
What is Predictive Analytics?
What is Fault-tolerant Architecture?
A RACI-style framework that defines who can create, modify, approve, or retire data assets
What is a Data Stewardship Model?