For users assigned the ACCOUNTADMIN role, Snowflake recommends enforcing Multi-Factor Authentication (MFA) to enhance security. The ACCOUNTADMIN role has extensive permissions, making it crucial to secure accounts held by such users against unauthorized access. MFA adds an additional layer of security by requiring a second form of verification beyond just the username and password, significantly reducing the risk of account compromise.References: Snowflake Security Best Practices
Question 2
What happens when a virtual warehouse is resized?
Options:
A.
When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected
B.
When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.
C.
The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.
D.
Users who are trying to use the warehouse will receive an error message until the resizing is complete
Answer:
A
Explanation:
Explanation:
When a virtual warehouse in Snowflake is resized, specifically when it is increased in size, the additional compute resources become immediately available to all running and queued queries. This means that the performance of these queries can improve due to the increased resources. Conversely, when the size of a warehouse is reduced, the compute resources are not removed until they are no longer being used by any current operations1.
References:
[COF-C02] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Virtual Warehouses2
Question 3
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.
Options:
A.
True
B.
False
Answer:
A
Explanation:
Explanation:
Provisioning time can vary based on the size of the warehouse. A 4X-Large Warehouse typically has more resources and may take longer to provision compared to a X-Small Warehouse, which has fewer resources and can generally be provisioned more quickly.References: Understanding and viewing Fail-safe | Snowflake Documentation