Data Engineer 면접 질문과 답변
Question: What is the difference between a star schema and a snowflake schema in data modeling?Answer: A star schema has a central fact table connected to dimension tables, while a snowflake schema extends the star schema by normalizing dimension tables.Example:
|
복습용 저장
이 항목을 북마크하거나, 어렵게 표시하거나, 복습 세트에 넣을 수 있습니다.
도움이 되었나요? 예 아니요
Most helpful rated by users:
- What is a schema in the context of databases?
- Explain the concept of ETL in the context of data engineering.