Which Snowflake objects can be restored using Time Travel? (Select VNO).

• A.Roles
• B.Users
• C.Databases
• D.Schemas
• E.Virtual warehouses

Comment: *

Name: *

Email: *

Verification: *

Which statement describes how Snowflake supports reader accounts?

• A.The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.
• B.The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.
• C.A reader account can consume data from the provider account that created it and combine it with its own data.
• D.A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.

Comment: *

Name: *

Email: *

Verification: *

Which statement accurately describes how a virtual warehouse functions?

• A.Increasing the size of a virtual warehouse will always improve data loading performance.
• B.Each virtual warehouse is an independent compute cluster that shares compute resources with other warehouses.
• C.Each virtual warehouse is a compute cluster composed of multiple compute nodes allocated by Snowflake from a cloud provider.
• D.All virtual warehouses share the same compute resources so performance degradation of one warehouse can significantly affect all the other warehouses.

Comment: *

Name: *

Email: *

Verification: *

Which of the following statements describe features of Snowflake data caching? (Choose two.)

• A.When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.
• B.A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.
• C.When the data cache is full, the least-recently used data will be cleared to make room.
• D.The RESULT_SCAN table function can access and filter the contents of the query result cache.
• E.A user can only access their own queries from the query result cache.

Comment: *

Name: *

Email: *

Verification: *

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

• A.Create information_schema in a database
• B.View usage information for all accounts in the organization.
• C.Enable database cloning for an account in the organization.
• D.Enable database replication for an account in the organization.
• E.View micro-partition information for all accounts in the organization.

Comment: *

Name: *

Email: *

Verification: *