| Exam Name: | SnowPro Core Certification Exam | ||
| Exam Code: | COF-C02 Dumps | ||
| Vendor: | Snowflake | Certification: | SnowPro Core Certification |
| Questions: | 948 Q&A's | Shared By: | zoey |
Which function unloads data from a relational table to JSON?
Options:
TO_OBJECT
TO_JSON
TO_VARIANT
OBJECT CONSTRUCT
Answer:
BExplanation:
The TO_JSON function is used to convert a VARIANT value into a string containing the JSON representation of the value. This function is suitable for unloading data from a relational table to JSON format. References: [COF-C02] SnowPro Core Certification Exam Study Guide
A column named "Data" contains VARIANT data and stores values as follows:
How will Snowflake extract the employee's name from the column data?
Options:
Data:employee.name
DATA:employee.name
data:Employee.name
data:employee.name
Answer:
DExplanation:
In Snowflake, to extract a specific value from a VARIANT column, you use the column name followed by a colon and then the key. The keys are case-sensitive. Therefore, to extract the employee’s name from the “Data” column, the correct syntax is data:employee.name.
Which commands can only be executed using SnowSQL? (Select TWO).
Options:
COPY INTO
GET
LIST
PUT
REMOVE
Answer:
C, DExplanation:
The LIST and PUT commands are specific to SnowSQL and cannot be executed in the web interface or other SQL clients. LIST is used to display the contents of a stage, and PUT is used to upload files to a stage. References: [COF-C02] SnowPro Core Certification Exam Study Guide
Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?
Options:
CREATE STAGE
COPY INTO