SnowPro Advanced: Architect — Question 123

A company’s management has requested insights concerning their Snowflake usage. An Architect needs to quickly build a reporting framework for a web application which stores its data in JSON format.

How can this requirement be met with the LEAST operational overhead?

Answer options

• A. Define a schema for the data before it is loaded from the application, so that it is loaded in a structured way and easy to build reports on top.
• B. Load the semi-structured data into Snowflake and after minimal transformations, query it for the reports.
• C. For the data that only has top-level key-value pairs and no nesting, load it in semi-structured format. For more complex data, define a schema and then load it in a structured table.
• D. Share the data in the third normal form (3NF). Load the data in semi-structured format and apply transformations to normalize the data for reporting.

Correct answer: B

Explanation

Option B is correct because it allows for the direct loading of semi-structured data into Snowflake, which is designed to handle such formats efficiently, thus minimizing overhead. Option A requires upfront schema definition, which adds complexity, while option C complicates the process by suggesting different strategies for varying data complexity. Option D involves unnecessary normalization steps, increasing operational overhead.