The dimensional schema is often referred to as the:
A)Fact table
B)Dimension table
C)Star schema
D)Transaction schema

Question

Quizplus · Accepted Answer

The dimensional schema is also known as a star schema, because the structure resembles a star with the fact table at the center and the dimension tables branching out like spokes. This schema is commonly used in data warehousing to organize and analyze large amounts of data. A fact table contains the values or measures that are being analyzed, while the dimension tables provide context or descriptive information about the measures. The transaction schema, on the other hand, is a different type of database schema that is used for online transaction processing (OLTP), where the focus is on recording and processing individual transactions in real time.

The Dimensional Schema Is Often Referred to as The