To run a multi-cluster warehouse in maximized mode, a user should set the minimum and maximum number of clusters to the same value. This ensures that all clusters are available when the warehouse is started, providing maximum resources for query execution. Reference: Snowflake Documentation2.

A Query Profile provides detailed execution information for a query, which can be used to analyze the performance and behavior of queries. This information can help users optimize and right-size their virtual warehouses for better efficiency. Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

The correct answers are A. SHOW USERS and B. DESCRIBE USER .
Snowflake user metadata includes information related to MFA enrollment and configuration. To inspect user- level properties, administrators can use SHOW USERS or DESCRIBE USER.
Why A is correct:
SHOW USERS returns information about users in the account. Its output can include user properties that indicate MFA status or related authentication details.
Why B is correct:
DESCRIBE USER returns detailed properties for a specific user. This can be used to inspect whether MFA has been enabled for that user.
Example:
DESCRIBE USER my_user;
Why the other options are incorrect:
C). SHOW PARAMETERS displays parameters, not user MFA enrollment status.
D). SHOW USER FUNCTIONS lists user-defined functions, not Snowflake users.
E). SHOW CONNECTIONS displays connection objects and does not indicate MFA status for a specific user.
Official Snowflake documentation reference:
Snowflake documentation describes SHOW USERS and DESCRIBE USER as commands for viewing user metadata and user properties.
Reference: Snowflake Documentation - SHOW USERS; DESCRIBE USER; Multi-Factor Authentication; SnowPro Core Study Guide - Security and Access Control.

The COPY INTO SQL command with the option SINGLE=FALSE is used to unload data into multiple files. This option allows the data to be split into multiple files during the unload process. Reference: SnowPro Core Certification COPY INTO SQL command unload multiple files