What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?

• A.Enterprise
• B.Business Critical
• C.Standard
• D.Virtual Private Snowflake

Comment: *

Name: *

Email: *

Verification: *

A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days.
Which of the following statements will return the required information?
A)

B)

C)

D)

• A.Option D
• B.Option C
• C.Option B
• D.Option A

Comment: *

Name: *

Email: *

Verification: *

A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes.
The warehouse is currently suspended and the user performs the following actions:
1. Runs a query that takes 3 minutes to complete
2. Leaves for 15 minutes
3. Returns and runs a query that takes 10 seconds to complete
4. Manually suspends the warehouse as soon as the last query was completed When the user returns, how much billable compute time will have been consumed?

• A.4 minutes
• B.10 minutes
• C.14 minutes
• D.24 minutes

Comment: *

Name: *

Email: *

Verification: *

Which statement best describes '' clustering''?

• A.Clustering represents the way data is grouped together and stored within snowflake's micro-partitions
• B.Clustering can be disabled within a Snowflake account.
• C.The clustering key must be included on the COPV command when loading data into Snowflake.
• D.The database administrator must define the clustering methodology for each Snowflake table.

Comment: *

Name: *

Email: *

Verification: *

Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.
Which SQL command should be used to delete the files?

• A.REMOVE
• B.PURGE
• C.MODIFY
• D.DELETE

Comment: *

Name: *

Email: *

Verification: *