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!

Software Architecture and Design

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

Digital Image Processing (DIP)

Delve into the techniques of enhancing digital images with our Digital Image...

MS Office

Master the suite of productivity tools with our MS Office MCQs. From Word and Excel...

Compiler Design

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

Microprocessor

Understand the heart of your computer with our Microprocessor MCQs. Topics include...

Java Programming

Level up your coding skills with our Java Programming MCQs. From object-oriented...

Internet of Things (IoT)

Discover how devices communicate with each other in the smart world with our IoT...

Cloud Computing

Stay on top of the biggest trend in IT with our Cloud Computing MCQs. These questions...

C Programming

Master one of the most widely used programming languages with our C Programming MCQs....