What affects whether the query results cache can be used?

• A.If the virtual warehouse has been suspended
• B.If the referenced data in the table has changed
• C.If the query contains a deterministic function
• D.If multiple users are using the same virtual warehouse

Comment: *

Name: *

Email: *

Verification: *

A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

• A.SYSADMIN
• B.The user that deleted the role
• C.The tables are now orphaned
• D.The assumed role that dropped the role

Comment: *

Name: *

Email: *

Verification: *

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

• A.Micro-partitions are immutable objects that support the use of Time Travel.
• 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.Rows are automatically stored in sorted order within micro-partitions

Comment: *

Name: *

Email: *

Verification: *

How does a Snowflake user extract the URL of a directory table on an external stage for further transformation?

• A.Use the GET_STAGE_LOCATION function.
• B.Use the GET_ABSOLUTE_PATH function.
• C.Use the DESCRIBE STAGE command.
• D.Use the SHOW STAGES command.

Comment: *

Name: *

Email: *

Verification: *

Which Snowflake technique can be used to improve the performance of a query?

• A.Clustering
• B.Indexing
• C.Fragmenting
• D.Using INDEX__HINTS

Comment: *

Name: *

Email: *

Verification: *