Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?
Options:
A.
CREATE STAGE
B.
COPY INTO
C.
COPY INTO
D.
CREATE PIPE
Answer:
C
Explanation:
Explanation:
The COPY INTO command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage1.
Question 117
What does a masking policy consist of in Snowflake?
Options:
A.
A single data type, with one or more conditions, and one or more masking functions
B.
A single data type, with only one condition, and only one masking function
C.
Multiple data types, with only one condition, and one or more masking functions
D.
Multiple data types, with one or more conditions, and one or more masking functions
Answer:
A
Explanation:
Explanation:
A masking policy in Snowflake consists of a single data type, with one or more conditions, and one or more masking functions. These components define how the data is masked based on the specified conditions3.
Question 118
When enabling access to unstructured data, which URL permits temporary access to a staged file without the need to grant privileges to the stage or to issue access tokens?
Options:
A.
File URL
B.
Scoped URL
C.
Relative URL
D.
Pre-Signed URL
Answer:
B
Explanation:
Explanation:
A Scoped URL permits temporary access to a staged file without the need to grant privileges to the stage or to issue access tokens. It provides a secure way to share access to files stored in Snowflake
Question 119
Which function unloads data from a relational table to JSON?
Options:
A.
TO_OBJECT
B.
TO_JSON
C.
TO_VARIANT
D.
OBJECT CONSTRUCT
Answer:
B
Explanation:
Explanation:
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
