SnowPro Advanced: Architect — Question 117

An Architect is designing a data pipeline that processes JSON data from an untrusted source into Snowflake. The pipeline needs to handle instances where the incoming JSON is malformed or contains invalid records.

Which components should an Architect use to meet these requirements? (Choose three.)

Answer options

• A. Stream
• B. Task
• C. Stored procedure with exception block
• D. User-Defined Function (UDF)
• E. Event table
• F. Directory table

Correct answer: A, B, C

Explanation

The correct answer includes Stream, Task, and Stored procedure with exception block, as these components are essential for monitoring data streams, scheduling processing tasks, and managing errors in data handling. Options D, E, and F do not facilitate error handling and management of malformed JSON, making them unsuitable for this scenario.