Assume there is a table consisting of five micro-partitions with values ranging from A to Z.
Which diagram indicates a well-clustered table?

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

Comment: *

Name: *

Email: *

Verification: *

Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

• A.Internal stages
• B.Incremental backups
• C.Time Travel
• D.Zero-copy clones
• E.Fail-safe

Comment: *

Name: *

Email: *

Verification: *

What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

• A.ACCESS_HISTORY
• B.VIEWS_HISTORY
• C.OBJECT_HISTORY
• D.LOGIN_HISTORY

Comment: *

Name: *

Email: *

Verification: *

What are the default Time Travel and Fail-safe retention periods for transient tables?

• A.Time Travel - 1 day. Fail-safe - 1 day
• B.Time Travel - 0 days. Fail-safe - 1 day
• C.Time Travel - 1 day. Fail-safe - 0 days
• D.Transient tables are retained in neither Fail-safe nor Time Travel

Comment: *

Name: *

Email: *

Verification: *

What is a best practice after creating a custom role?

• A.Assign the custom role to the PUBLIC role
• B.Create the custom role using the SYSADMIN role.
• C.Add_CUSTOM to all custom role names
• D.Assign the custom role to the SYSADMIN role

Comment: *

Name: *

Email: *

Verification: *