Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
Comptia Discussions

Exam DA0-001 topic 1 question 68 discussion

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

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:

  • A. transactional schema.
  • B. star schema.
  • C. non-relational schema.
  • D. snowflake schema.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by Swift_and_Quick at April 16, 2024, 2:07 a.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
Swift_and_Quick
1 month ago
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
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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