SnowPro Advanced Architect Exam

Exam SnowPro Advanced Architect All QuestionsBrowse all questions from this exam

Question 28

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

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

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

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

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

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

Correct Answer: B, C

To support the diverse requirements, it is necessary to use different Snowflake data modeling approaches. Creating a raw database for landing and persisting raw data ensures that the Data Science team has access to unprocessed data necessary for ML model development. Additionally, creating a set of profile-specific databases that aligns data with usage patterns will allow different teams, like Finance and Sales, to access the data in forms that suit their specific needs, enabling reporting, visualization, and data monetization.

Discussion

hillcat111

Answer is C,E and is validated

SrideviJOptions: BC

I think options are BC

67422cbOptions: BC

A Data Vault is very expansive. Selecting solely from the Data Vault can include a whole bunch of differently structured tables.

ayushi7rawatOptions: BC

I think options are BC