Download Full Version SnowPro-Core Snowflake Exam

SnowPro Core Certification Exam Questions and Answers

Question 89

What is the purpose of the Snowflake SPLIT TO_TABLE function?

To count the number of characters in a string

To split a string into an array of sub-strings

To split a string and flatten the results into rows

To split a string and flatten the results into columns

Question 90

What function can be used with the recursive argument to return a list of distinct key names in all nested elements in an object?

FLATTEN

GET_PATH

CHECK_JSON

PARSE JSON

Question 91

What is the primary purpose of a directory table in Snowflake?

To store actual data from external stages

To automatically expire file URLs for security

To manage user privileges and access control

To store file-level metadata about data files in a stage

Question 92

What happens to the objects in a reader account when the DROP MANAGED ACCOUNT command is executed?

The objects are dropped.

The objects enter the Fail-safe period.

The objects enter the Time Travel period.

The objects are immediately moved to the provider account.