Snowflake
SOL-C01 · Question #190
You are designing a Snowflake UDF to parse log files. The UDF needs to accept the log file content as a string argument and a configuration parameter that specifies the log format. Which of the follow
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #190. The question stem and answer options stay visible for context.
Snowflake Account and Security
Question
You are designing a Snowflake UDF to parse log files. The UDF needs to accept the log file content as a string argument and a configuration parameter that specifies the log format. Which of the following approaches is MOST efficient and allows for easy updates to the log format without redeploying the UDF?
Options
- APass the log format as a string argument directly to the UDF. Parse the string within the UDF to
- BStore the log format in a separate table and use a Snowflake lookup within the UDF to retrieve the
- CUse a stage to store the log format definition as a JSON file. Read the file content from the stage
- DStore the log format in a named stage and create a function to retrieve the format from the stage
- EStore the log format in a Snowflake secret and retrieve it using the SYSTEM$GET SECRET
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.
Topics
#UDFs#Snowflake Secrets#Configuration management#Performance