SnowPro Core Certification Exam Questions and Answers
Question 109
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:
The COPY INTO command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage1.
Question 110
Which ACCOUNT_USAGE schema database role provides visibility into policy-related information?
Options:
A.
USAGE_VIEWER
B.
GOVERNANCE_VIEWER
C.
OBJECT_VIEWER
D.
SECURITY_VIEWER
Answer:
B
Explanation:
The GOVERNANCE_VIEWER role in the ACCOUNT_USAGE schema provides visibility into policy-related information within Snowflake. This role is specifically designed to access views that display object metadata and usage metrics related to governance12.
Question 111
How is unstructured data retrieved from data storage?
Options:
A.
SQL functions like the GET command can be used to copy the unstructured data to a location on the client.
B.
SQL functions can be used to create different types of URLs pointing to the unstructured data. These URLs can be used to download the data to a client.
C.
SQL functions can be used to retrieve the data from the query results cache. When the query results are output to a client, the unstructured data will be output to the client as files.
D.
SQL functions can call on different web extensions designed to display different types of files as a web page. The web extensions will allow the files to be downloaded to the client.
Answer:
B
Explanation:
Unstructured data stored in Snowflake can be retrieved by using SQL functions to generate URLs that point to the data. These URLs can then be used to download the data directly to a client
Question 112
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:
A.
Data:employee.name
B.
DATA:employee.name
C.
data:Employee.name
D.
data:employee.name
Answer:
D
Explanation:
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.
