Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam SnowPro Advanced Architect All Questions

View all questions & answers for the SnowPro Advanced Architect exam

Exam SnowPro Advanced Architect topic 1 question 88 discussion

Actual exam question from Snowflake's SnowPro Advanced Architect
Question #: 88
Topic #: 1
[All SnowPro Advanced Architect Questions]

Which data models can be used when modeling tables in a Snowflake environment? (Choose three.)

  • A. Graph model
  • B. Dimensional/Kimball
  • C. Data lake
  • D. Inmon/3NF
  • E. Bayesian hierarchical model
  • F. Data vault
Show Suggested Answer Hide Answer
Suggested Answer: BDF 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
MSIDDIQUI18
4 months, 2 weeks ago
B: Dimensional Modeling (Kimball): This approach organizes data into fact and dimension tables. It's widely used in data warehousing to optimize for query performance and ease of understanding for end-users. Snowflake supports this model well due to its columnar storage and performance optimization features. D: Inmon/3NF: This model, proposed by Bill Inmon, focuses on a normalized structure (Third Normal Form) which is more flexible and reduces redundancy. Snowflake’s capabilities support the normalized model, ensuring data integrity and reducing storage costs. F: Data Vault: This modeling approach is designed to provide long-term historical storage of data from multiple operational systems. It supports agile and scalable data integration and changes. Snowflake’s support for semi-structured data and its efficient storage makes it a good fit for the Data Vault methodology.
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
Loading ...