In Star Schema Dimension tables are:

  1. Short and Fat

  2. Long and Thin

  3. Long and Fat

  4. Short and thin


Correct Option: A

AI Explanation

To answer this question, we need to understand the concept of Star Schema in data warehousing.

In a Star Schema, one or more dimension tables are connected to a central fact table. The dimension tables contain descriptive attributes that provide context and details about the data in the fact table.

Now, let's go through each option to understand why it is correct or incorrect:

Option A) Short and Fat - This option is correct. In a Star Schema, the dimension tables are typically designed to be short and fat. This means that they have a wide structure with a larger number of columns, each representing a specific attribute or characteristic of the data.

Option B) Long and Thin - This option is incorrect. In a Star Schema, the dimension tables are not designed to be long and thin. This terminology suggests a narrow structure with fewer columns, which is not typically the case in a Star Schema design.

Option C) Long and Fat - This option is incorrect. Although the term "fat" is used correctly to describe the structure of dimension tables in a Star Schema, the term "long" is not accurate. Dimension tables are not typically designed to be long in terms of the number of rows or records they contain.

Option D) Short and Thin - This option is incorrect. The term "thin" suggests a narrow structure with fewer columns, which is not typically the case in a Star Schema design. Dimension tables are designed to be short and fat, as explained in Option A.

The correct answer is Option A) Short and Fat. This option is correct because it accurately describes the structure of dimension tables in a Star Schema.

Find more quizzes: