Which of the following tables contains the primary information in a data warehouse?
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: B. Fact table
Explanation
The fact table stores the measures (primary business data) and foreign keys to dimension tables in a star or snowflake schema.More Database Management Systems questions
- The INSERT command is used to A. add a single tuple to a relation B. add multiple tuples to a relation C. add values to specific attributes…
- Match List I with List IIList I List II A. Hadoop Distributed File System I. Trust B. Veracity II. Facebook C. Apache Pig III. Name-Node D.…
- The degree of a relation in a database is
- Match List I with List IIList I List II A. Project Join Normal Form I. Concurrency B. The lost update problem II. Fifth Normal Form C. Disc…
- In a schema R(A, B, C, D, E, F, G, H), each field of R contains only atomic values. F = {CH → G, A → BC, B → CFH, E → A, F → EG} is a set o…
- Consider a relation schema R = (U, V, W, X, Y, Z), on which the following functional dependencies hold: {U → V, VW → X, Y → W, X → U}. The…