This question falls under the Data Concepts and Environments domain, focusing on understanding table types in data warehousing. The task is to identify a table that holds relational keys and numeric values, typically used in a star schema.
Fact (Option A): Fact tables in a star schema store quantitative data (numeric values, e.g., sales amounts) and foreign keys (relational keys) linking to dimension tables, making this the correct choice.
Graph (Option B): Graph tables are used in graph databases for relationships (e.g., nodes, edges), not typically for relational keys and numeric values in a traditional sense.
Dimensional (Option C): Dimension tables store descriptive attributes (e.g., product names) and primary keys, not typically numeric measures.
Transactional (Option D): Transactional tables are used in OLTP systems and may contain numeric values, but they’re not specifically designed for relational keys in a data warehousing context.
The DA0-002 Data Concepts and Environments domain includes understanding "data schemas and dimensions," and fact tables are designed to hold relational keys and numeric values in a data warehouse.
[Reference: CompTIA Data+ DA0-002 Draft Exam Objectives, Domain 1.0 Data Concepts and Environments., ==============]
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit