What should be used when creating a CSV file format where the columns are wrapped by single quotes or double quotes?

• A.BINARY_FORMAT
• B.ESCAPE_UNENCLOSED_FIELD
• C.FIELD_OPTIONALLY_ENCLOSED_BY
• D.SKIP BYTE ORDER MARK

Comment: *

Name: *

Email: *

Verification: *

Which of the following are benefits of micro-partitioning? (Select TWO)

• A.Rows are automatically stored in sorted order within micro-partitions
• B.Micro-partitions cannot overlap in their range of values
• C.Micro-partitions can be defined on a schema-by-schema basis
• D.Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses
• E.Micro-partitions are immutable objects that support the use of Time Travel.

Comment: *

Name: *

Email: *

Verification: *

How do Snowflake data providers share data that resides in different databases?

• A.External tables
• B.User-Defined Functions (UDFs)
• C.Materialized views
• D.Secure views

Comment: *

Name: *

Email: *

Verification: *

What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

• A.Data is hashed by the cluster key to facilitate fast searches for common data values
• B.Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned
• C.Smaller micro-partitions are created for common data values to allow for more parallelism
• D.Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

Comment: *

Name: *

Email: *

Verification: *

Based on Snowflake recommendations, when creating a hierarchy of custom roles, the top-most custom role should be assigned to which role?

• A.ACCOUNTADMIN
• B.SECURITYADMIN
• C.SYSADMIN
• D.USERADMIN

Comment: *

Name: *

Email: *

Verification: *