SOL-C01 · Question #299
You're building a Snowflake Notebook to automate data quality checks on a daily basis. You have a series of SQL queries, each representing a different quality rule (e.g., checking for null values, dup
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #299. The question stem and answer options stay visible for context.
Question
You're building a Snowflake Notebook to automate data quality checks on a daily basis. You have a series of SQL queries, each representing a different quality rule (e.g., checking for null values, duplicate records, invalid date formats). You want to implement error handling so that if one quality check fails, the notebook continues to execute the remaining checks and logs the errors. Which is the most robust approach to achieve this within the Snowflake Notebook environment, minimizing code complexity and maximizing fault tolerance?
Options
- AWrap each SQL query execution in a Python `try...except' block and log any exceptions to a
- BUse Snowflake's 'SYSTEM$LAST_CHANGE COMMIT _ TIME function to check if the SQL query
- CCreate a stored procedure in Snowflake that encapsulates each quality check and handles its own
- DWithin each SQL query, use Snowflake's ` TRY_CAST or similar error-handling functions to handle
- EEnable the 'AUTO_RETRY parameter at the account level, so failed queries are automatically
Unlock SOL-C01 to see the answer
You've previewed enough free SOL-C01 questions. Unlock SOL-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.