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 28 discussion

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

The Data Engineering team at a large manufacturing company needs to engineer data coming from many sources to support a wide variety of use cases and data consumer requirements which include:
1. Finance and Vendor Management team members who require reporting and visualization
2. Data Science team members who require access to raw data for ML model development
3. Sales team members who require engineered and protected data for data monetization
What Snowflake data modeling approaches will meet these requirements? (Choose two.)

  • A. Consolidate data in the company’s data lake and use EXTERNAL TABLES.
  • B. Create a raw database for landing and persisting raw data entering the data pipelines.
  • C. Create a set of profile-specific databases that aligns data with usage patterns.
  • D. Create a single star schema in a single database to support all consumers’ requirements.
  • E. Create a Data Vault as the sole data pipeline endpoint and have all consumers directly access the Vault.
Show Suggested Answer Hide Answer
Suggested Answer: DE 🗳️

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
hillcat111
Highly Voted 11 months, 3 weeks ago
Answer is C,E and is validated
upvoted 5 times
...
67422cb
Most Recent 1 month, 1 week ago
A Data Vault is very expansive. Selecting solely from the Data Vault can include a whole bunch of differently structured tables.
upvoted 1 times
...
ayushi7rawat
6 months, 1 week ago
Selected Answer: BC
I think options are BC
upvoted 1 times
...
SrideviJ
1 year ago
I think options are BC
upvoted 2 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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago