Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously? Choose 3 answers

• A.UPDATE
• B.COPY
• C.SUM(<< column value >>)
• D.MIN(< < column value>>)

Comment: *

Name: *

Email: *

Verification: *

Which of the following statements is true of zero-copy cloning?

• A.Zero-copy coning is licensed as an additional Snowflake feature
• B.All zero-copy clone objects inherit the privileges of their original objects
• C.At the instance/instance a clone is created, all micro-partitions in the original table and the clone are fully shared.
• D.Zero-copy clones objects inherit

Comment: *

Name: *

Email: *

Verification: *

How long is the Fail-safe period for temporary and transient tables?

• A.31 days
• B.There is no Fail-safe period for these tables.
• C.90 days
• D.7 days
• E.1 day

Comment: *

Name: *

Email: *

Verification: *

What actions will prevent leveraging of the ResultSet cache? (Choose two.)

• A.Stopping the virtual warehouse that the query is running against
• B.Executing the RESULTS_SCAN() table function
• C.Removing a column from the query SELECT list
• D.Changing a column that is not in the cached query
• E.Clustering of the data used by the query

Comment: *

Name: *

Email: *

Verification: *

Which of the following statements describes a schema in Snowflake?

• A.A named Snowflake object that includes all the information required to share a database
• B.A logical grouping of objects that belongs to a single database
• C.A logical grouping of objects that belongs to multiple databases
• D.A uniquely identified Snowflake account within a business entity

Comment: *

Name: *

Email: *

Verification: *