To run a Multi-Cluster Warehouse in auto-scale mode, a user would:
Answer : D
Reference:
https://help.pentaho.com/Documentation/9.1/Products/Modify_Snowflake_warehouse
Which of the following terms best describes Snowflake's database architecture?
Answer : B
Reference:
https://docs.snowflake.com/en/user-guide/intro-key-concepts.html
Which of the following are options when creating a Virtual Warehouse? (Choose two.)
Answer : CD
Reference:
https://help.pentaho.com/Documentation/9.1/Products/Create_Snowflake_warehouse
A Virtual Warehouse's auto-suspend and auto-resume settings apply to:
Answer : B
Reference:
https://docs.snowflake.com/en/user-guide/warehouses-overview.html
Fail-safe is unavailable on which table types? (Choose two.)
Answer : AB
Reference:
https://docs.snowflake.com/en/user-guide/tables-temp-transient.html
Which of the following objects is not covered by Time Travel?
Answer : D
Reference:
https://docs.snowflake.com/en/user-guide/data-time-travel.html
True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.
Answer : A
Reference:
https://blog.ippon.tech/innovative-snowflake-features-caching/
Which of the following commands are not blocking operations? (Choose two.)
Answer : BD
Which of the following is true of Snowpipe via REST API? (Choose two.)
Answer : BD
Snowflake recommends, as a minimum, that all users with the following role(s) should be enrolled in Multi-Factor Authentication (MFA):
Answer : D
Reference:
https://docs.snowflake.com/en/user-guide/security-mfa.html
When can a Virtual Warehouse start running queries?
Answer : B
True or False: Users are able to see the result sets of queries executed by other users that share their same role.
Answer : B
Reference:
https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html
True or False: The user has to specify which cluster a query will run on in a multi-cluster Warehouse.
Answer : B
True or False: Pipes can be suspended and resumed.
Answer : B
Reference:
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html