
SnowPro® Core Certification
Domain 2Objective 4
Transform Data with SQL and Semi-Structured Functions COF-C03 Practice Questions (Page 1)
Part of the Performance Optimization, Querying, and Transformation domain, which accounts for 21% of the COF-C03 exam.
20questions here
4free pages
10concepts
21%of the exam
Questions 1–5
- 1
Which Snowflake function converts a JSON string into a VARIANT value that can be queried using semi-structured navigation?
Select an answer first - 2
Which function returns the first non-NULL value from a list of arguments?
Select an answer first - 3
What is the primary purpose of the FLATTEN function in Snowflake?
Select an answer first - 4
Which window function assigns a unique sequential number to each row within a partition, starting at 1?
Select an answer first - 5
Which function is used to convert a string containing a numeric value, such as '123.45', into a NUMBER data type?
Select an answer first
Finished these 5 questions?
Review the revealed explanations, or continue through the curriculum.
Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Snowflake. “COF-C03” is a trademark of its owner, used for identification only.