In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?

• A.When the system has enough load for 2 minutes
• B.When the system has enough load for 8 minutes
• C.When the system has enough load for 6 minutes
• D.When the system has enough load for 10 minutes

Comment: *

Name: *

Email: *

Verification: *

What activities can a user with the ORGADMIN role perform? (Select TWO).

• A.Create an account for an organization.
• B.Edit the account data for an organization.
• C.Delete the account data for an organization.
• D.View usage information for all accounts in an organization.
• E.Select all the data in tables for all accounts in an organization.

Comment: *

Name: *

Email: *

Verification: *

What happens when an external or an internal stage is dropped? (Select TWO).

• A.When dropping an internal stage, the files are deleted with the stage and the files are not recoverable
• B.When dropping an internal stage, only selected files are deleted with the stage and are not recoverable
• C.When dropping an external stage, both the stage and the files within the stage are removed
• D.When dropping an external stage, the files are not removed and only the stage is dropped
• E.When dropping an internal stage, the files are deleted with the stage and the files are recoverable

Comment: *

Name: *

Email: *

Verification: *

Which table function is used to perform additional processing on the results of a previously-run query?

• A.QUERY_HISTORY
• B.RESULT_SCAN
• C.DESCRIBE_RESULTS
• D.QUERY HISTORY BY SESSION

Comment: *

Name: *

Email: *

Verification: *

Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

• A.Pipe
• B.External stage
• C.Task
• D.Stream

Comment: *

Name: *

Email: *

Verification: *