A marketing team stores campaign data in a VARIANT column `campaign_data` that contains an OBJECT with keys representing different channels (e.g., 'email', 'social', 'search'). An analyst needs to list all the channel names for a given campaign. Which function should they use?

FLATTEN(input => campaign_data) AS channels

ARRAY_SIZE(campaign_data) AS channels

OBJECT_KEYS(campaign_data) AS channels

VALUE(campaign_data) AS channels

SnowPro® Core Certification

Domain 2Objective 4

Transform Data with SQL and Semi-Structured Functions COF-C03 Practice Questions (Page 3)

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 11–15

11foundation · easy
Which set operation returns all rows from the first query plus all rows from the second query, removing duplicates?
Select an answer first
12foundation · easy
Which Snowflake data type is used to store a sequence of elements, such as a list of product IDs, where each element can be accessed by its position?
Select an answer first
13application · easy
A marketing team stores campaign data in a VARIANT column `campaign_data` that contains an OBJECT with keys representing different channels (e.g., 'email', 'social', 'search'). An analyst needs to list all the channel names for a given campaign. Which function should they use?
Select an answer first
14foundation · easy
Which string function extracts a portion of a string starting at a specified position and with a specified length?
Select an answer first
15foundation · easy
Which Snowflake semi-structured data type is best suited for storing a collection of key-value pairs where the keys are strings and the values can be of any data type, including other semi-structured types?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to COF-C03

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.

Transform Data with SQL and Semi-Structured Functions COF-C03 Practice Questions (Page 3)

Questions 11–15

Which set operation returns all rows from the first query plus all rows from the second query, removing duplicates?

Which Snowflake data type is used to store a sequence of elements, such as a list of product IDs, where each element can be accessed by its position?

A marketing team stores campaign data in a VARIANT column `campaign_data` that contains an OBJECT with keys representing different channels (e.g., 'email', 'social', 'search'). An analyst needs to list all the channel names for a given campaign. Which function should they use?

Which string function extracts a portion of a string starting at a specified position and with a specified length?

Which Snowflake semi-structured data type is best suited for storing a collection of key-value pairs where the keys are strings and the values can be of any data type, including other semi-structured types?

Keep studying — Performance Optimization, Querying, and Transformation