A database consists of one fact table that is composed of multiple dimensions. Depending on the dimension, each one can be represented by a denormalized table or multiple normalized tables. This structure is an example of a:
B. A snowflake schema is a database schema design where the fact table is linked to multiple dimensions, and those dimension tables can be further normalized into multiple related tables. This results in a structure that resembles a snowflake, with dimensions branching out into sub-dimensions.
The answer is B. It's star schema because there are multiple dimension tables branch out of the fact table. It didn't mention whether or not there are other dimension tables that branch out of the dimension tables that are connected to the fact table, so we can assume that it's not snowflake schema.
upvoted 1 times
...
This section is not available anymore. Please use the main Exam Page.DA0-001 Exam Questions
Log in to ExamTopics
Sign in:
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.
JOH22
7 months, 1 week agoSwift_and_Quick
1 year, 2 months ago