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.)

Question

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.)

Andrew Staton · Accepted Answer

Create a raw database for landing and persisting raw data entering the data pipelines.

Andrew Staton · Accepted Answer

Create a set of profile-specific databases that aligns data with usage patterns.

Andrew Staton · Answer

Consolidate data in the company's data lake and use EXTERNAL TABLES.

Andrew Staton · Answer

Create a single star schema in a single database to support all consumers' requirements.

Andrew Staton · Answer

Create a Data Vault as the sole data pipeline endpoint and have all consumers directly access the Vault.

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 6 - ARA-C01 discussion

Suggested answer: B, C

0 comments