Question

In the dimensional data model, what does a Fact Table contain?

a.

Business entities

b.

Business metrics or facts

c.

Relationships between entities

d.

Historical data records

Posted under Data Warehousing and OLAP

Answer: (b).Business metrics or facts Explanation:In the dimensional data model, a Fact Table is the middle table that contains the facts or metrics of the business as attributes, such as sales units, sales dollars, costs, and profit margin.

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. In the dimensional data model, what does a Fact Table contain?

Add Comment

Suggested Topics

Are you eager to expand your knowledge beyond Data Warehousing and OLAP? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

Digital Communication

Master the basics of electronic communication with our Digital Communication MCQs....

Cryptography and Network Security

Secure your knowledge of information security with our Cryptography and Network...

C# programming

Hone your skills in the C# language with our MCQs. Understand data types, operators,...

Software Architecture and Design

Get a strong hold on the blueprint of software systems with our Software Architecture...

CompTIA PenTest+ Certification Exam PT0 002

Prepare for the CompTIA PenTest+ PT0-002 exam with our targeted MCQs. Covering...

SQL Server

Master Microsoft's database server with our SQL Server MCQs. Topics cover database...

Visual Basic

Enhance your knowledge of Microsoft's event-driven programming language with our...

Compiler Design

Unravel the process of translating source code into executable programs with our...

DBMS

Get a firm grasp on database systems with our DBMS MCQs. Explore relational...