A company has a VARCHAR column `price_string` that contains values like '$1,234.56'. An analyst needs to convert this to a NUMBER for calculations. Which expression correctly handles the currency symbol and comma?

TO_NUMBER(SUBSTR(price_string, 2)) AS price

TO_NUMBER(REPLACE(REPLACE(price_string, '$', ''), ',', '')) AS price

CAST(price_string AS NUMBER) AS price

TO_NUMBER(price_string) AS price

SnowPro® Core Certification

Domain 2Objective 4

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

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 16–20

16foundation · easy
Which window function allows you to access the value of a column from the previous row in the result set?
Select an answer first
17application · medium
A company has a VARCHAR column `price_string` that contains values like '$1,234.56'. An analyst needs to convert this to a NUMBER for calculations. Which expression correctly handles the currency symbol and comma?
Select an answer first
18foundation · easy
Which function returns an array of the keys from an OBJECT?
Select an answer first
19foundation · easy
Which conditional expression in Snowflake returns one of two values based on a boolean condition, and is often used for simple if-else logic?
Select an answer first
20foundation · easy
Which set operation returns only the rows that appear in both result sets of two queries?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack 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 4)

Questions 16–20

Which window function allows you to access the value of a column from the previous row in the result set?

A company has a VARCHAR column `price_string` that contains values like '$1,234.56'. An analyst needs to convert this to a NUMBER for calculations. Which expression correctly handles the currency symbol and comma?

Which function returns an array of the keys from an OBJECT?

Which conditional expression in Snowflake returns one of two values based on a boolean condition, and is often used for simple if-else logic?

Which set operation returns only the rows that appear in both result sets of two queries?

Keep studying — Performance Optimization, Querying, and Transformation