What are characteristics of transient tables in Snowflake? (Select TWO).

• A.Transient tables persist until they are explicitly dropped.
• B.Transient tables have Time Travel retention periods of 0 or 1 day.
• C.Transient tables can be altered to make them permanent tables.
• D.Transient tables have a Fail-safe period of 7 days.
• E.Transient tables can be cloned to permanent tables.

Comment: *

Name: *

Email: *

Verification: *

Which table function should be used to view details on a Directed Acyclic Graphic (DAG) run that is presently scheduled or is executing?

• A.COMPLETE_TASK_GRAPHS
• B.TASK_HISTORY
• C.TASK_DEPENDENTS
• D.CURRENT_TASK_GRAPHS

Comment: *

Name: *

Email: *

Verification: *

True or False: When active, a pipe requires a dedicated Virtual Warehouse to execute.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

What happens when a virtual warehouse is resized?

• A.When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.
• B.When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected
• C.The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.
• D.Users who are trying to use the warehouse will receive an error message until the resizing is complete

Comment: *

Name: *

Email: *

Verification: *

Which of the following objects can be shared through secure data sharing?

• A.Masking policy
• B.Stored procedure
• C.Task
• D.External table

Comment: *

Name: *

Email: *

Verification: *