ExamTopics Logo
Mail Us[email protected]
Menu
Comptia Discussions
exam questions

Exam DA0-001 All Questions

View all questions & answers for the DA0-001 exam
Go to Exam

Exam DA0-001 topic 1 question 194 discussion

Actual exam question from CompTIA's DA0-001
Question #: 194
Topic #: 1
[All DA0-001 Questions]

A database consists of one fact table that is composed of multiple dimensions. Each dimension is represented by a denormalized table. This structure is an example of a:

  • A. non-relational schema.
  • B. galaxy schema.
  • C. snowflake schema.
  • D. star schema.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by Swift_and_Quick at April 17, 2024, 11:50 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Adonisy
8 months ago
Selected Answer: D
D is the answer
upvoted 1 times
...
Swift_and_Quick
1 year, 2 months ago
D. Star schema. In a star schema, the fact table sits at the center and is connected to multiple dimension tables, typically in a denormalized form. This design simplifies querying and improves performance, making it a commonly used schema for data warehousing and analytics.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel