Snowflake Snowpro Core Certification Exam Questions and Answers.docx

Snowflake Snowpro Core Certification Exam
Questions and Answers
Which queries would not require the use of a Virtual Warehouse
and instead would make use of the metadata cache? Select all that
apply.
DESCRIBE TABLE EMPLOYEE;
SELECT COUNT(*) FROM EMPLOYEE;
SELECT * FROM TABLE(FLATTEN(INPUT => PARSE_JSON('[1, ,77]')))
F;
SELECT EMP_ID, NAME, ADDRESS FROM EMPLOYEE; -
correct answer ✅DESCRIBE TABLE EMPLOYEE;
SELECT COUNT(*) FROM EMPLOYEE; -
The number of rows along with a description of tables is
maintained in the metadata cache and so doesn't need a Virtual
Warehouse to compute the result.
This was discussed in Lecture 52: Caching


Which system function is called to retrieve clustering metadata for
a column or columns? Choose one correct value.
system$clustering_metadata
system$clustering_information
system$allowlist

, Snowflake Snowpro Core Certification Exam
Questions and Answers
system$natural_clustering_information -
correct answer ✅system$clustering_information


Which symbols are used when referencing a table stage via SQL?
Choose one correct value.
@~
@
@%
@* -
correct answer ✅@%


What is the recommended maximum number of columns (or
expressions) defined per clustering key? Choose one correct value.
2 or 3
3 or 4
2
1-
correct answer ✅3 or 4


Time Travel is not possible on transient tables. True or false?