SP Study Udemy

What is the purpose of the Snowflake SPLIT_TO_TABLE function?

• • 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

• • To count the number of characters in a string

How are privileges inherited in a role hierarchy in Snowflake?

• • Privileges are only inherited by the direct child role in the hierarchy.

• • Privileges are inherited by any roles above that role in the hierarchy.

• • Privileges are only inherited by the direct parent role in the hierarchy.

• • Privileges are inherited by any roles at the same level in the hierarchy.

Snowflake recommends, as a minimum, that all users with the following role(s) should be enrolled in Multi-Factor Authentication (MFA):

• • SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN

• • ACCOUNTADMIN

• • SECURITYADMIN, ACCOUNTADMIN

• • SECURITYADMIN, ACCOUNTADMIN, SYSADMIN

Which Snowflake feature allows a user to track sensitive data for compliance, discovery, protection, and resource usage?

• • Internal tokenization

• • Comments

• • Tags

• • Row access policies

Which loop type iterates until a condition is true?

• FOR

• REPEAT

• WHILE

• LOOP

What is the Snowflake recommended Parquet file size when querying from external tables to optimize the number of parallel scanning operations?

• • 1-16 MB

• • 256-512 MB

• • 16-128 MB

• • 100-250 MB

The VALIDATE table function has which parameter as an input argument for a Snowflake user?

• • CURRENT_STATEMENT

• • JOB_ID

• • LAST_QUERY_ID

• • UUID_STRING

Which Snowflake feature can be used to find sensitive data in a table or column?

• • External functions

• • Data classification

• • Row level policies

• • Masking policies

During periods of warehouse contention, which parameter controls the maximum length of time a warehouse will hold a query for processing?

• • QUERY_TIMEOUT_IN_SECONDS

• • MAX_CONCURRENCY_LEVEL

• • STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

• • STATEMENT_TIMEOUT_IN_SECONDS

Which Snowflake features can be enabled by calling the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function by a user with the ORGADMIN role? (Choose two.)

• • Account and database replication

• • Clustering

• • Search optimization service

• • Client redirect

• • Fail-safe