Teradata Data Warehousing Flashcards
6 cards from real Teradata practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 Teradata Data Warehousing flashcards as text
What is a star schema in the context of Teradata data warehousing?
Answer: A design with a central fact table surrounded by denormalized dimension tables
A star schema has a central fact table containing measurable business events and surrounds it with denormalized dimension tables describing the context of those events.
What is the difference between a fact table and a dimension table in Teradata?
Answer: Fact tables store measurable quantitative data (metrics); dimension tables store descriptive attributes
Fact tables contain numerical measures (sales amount, quantity) and foreign keys to dimensions, while dimension tables contain descriptive attributes (product name, customer city) used for filtering and grouping.
What is a Slowly Changing Dimension (SCD) Type 2 in data warehousing?
Answer: Adds a new row for each change, preserving full history with effective date columns
SCD Type 2 inserts a new row for each attribute change, keeping all historical versions with start/end date or a current-flag indicator.
In Teradata data warehousing, what is the purpose of an ODS (Operational Data Store)?
Answer: Provides near-real-time integrated data from multiple operational systems for tactical decisions
An ODS integrates current-state data from multiple source systems at a low latency, supporting operational reporting and short-term tactical decision-making.
What is the ETL process in data warehousing?
Answer: Extract, Transform, Load — the process of moving and preparing data from source systems into a warehouse
ETL extracts data from operational sources, transforms it (cleansing, aggregation, enrichment), and loads it into the target data warehouse for analysis.
What is a surrogate key in a Teradata dimensional model?
Answer: A system-generated integer key used as the Primary Index of a dimension table, replacing the natural key
A surrogate key is a meaningless integer assigned by the ETL or warehouse system to uniquely identify dimension rows, independent of the source system's natural key.
How this page was made: written with AI tools and published by Nathan Beja, founder of Practice Test Geeks, who is responsible for its content. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- teradata.com — Test delivery, eligibility, passing score, renewal, retake policy, score validity, exam information · verified Oct 2026