- (Topic 5)
How does a Snowflake user extract the URL of a directory table on an external stage for further transformation?

1. A. Use the SHOW STAGES command.
2. B. Use the DESCRIBE STAGE command.
3. C. Use the GET_ABSOLUTE_PATH function.
4. D. Use the GET_STAGE_LOCATION function.

Correct Answer: C
To extract the URL of a directory table on an external stage for further transformation in Snowflake, the GET_ABSOLUTE_PATH function can be used. This function returns the full path of a file or directory within a specified stage, enabling users to dynamically construct URLs for accessing or processing data stored in external stages. References:
✑ Snowflake Documentation: Working with Stages

- (Topic 6)
How should a Snowflake use' configure a virtual warehouse to be in Maximized mode''

1. A. Set the WAREHOUSES_SIZE to 6XL.
2. B. Set the STATEMENT_TIMEOUT_1M_SECOMES to 0.
3. C. Set the MAX_CONCURRENCY_LEVEL to a value of 12 or large.
4. D. Set the same value for both MIN_CLUSTER_COUNT and MAX_CLUSTER_COUNT.

Correct Answer: D
In Snowflake, configuring a virtual warehouse to be in a "Maximized" mode implies maximizing the resources allocated to the warehouse for its duration. This is done to ensure that the warehouse has a consistent amount of compute resources available, enhancing performance for workloads that require a high level of parallel processing or for handling high query volumes.
To configure a virtual warehouse in maximized mode, you should set the same value for bothMIN_CLUSTER_COUNTandMAX_CLUSTER_COUNT. This configuration ensures that the warehouse operates with a fixed number of clusters, thereby providing a stable and maximized level of compute resources.
Reference to Snowflake documentation on warehouse sizing and scaling:
✑ Warehouse Sizing and Scaling
✑ Understanding Warehouses

- (Topic 3)
The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?

1. A. USERADMIN
2. B. PUBLIC
3. C. ORGADMIN
4. D. SYSADMIN

Correct Answer: A
The first user assigned to a new Snowflake account, typically with the ACCOUNTADMIN role, should create at least one additional user with the USERADMIN administrative privilege. This role is responsible for creating and managing users and roles within the Snowflake account. References: Access control considerations | Snowflake Documentation

- (Topic 1)
Which stage type can be altered and dropped?

1. A. Database stage
2. B. External stage
3. C. Table stage
4. D. User stage

Correct Answer: B
External stages can be altered and dropped in Snowflake. An external stage points to an external location, such as an S3 bucket, where data files are stored. Users can modify the stage??s definition or drop it entirely if it??s no longer needed. This is in contrast to table stages, which are tied to specific tables and cannot be altered or dropped independently.
References:
✑ [COF-C02] SnowPro Core Certification Exam Study Guide
✑ Snowflake Documentation on Stages1

- (Topic 6)
Which Snowflake function and command combination should be used to convert rows in a relational table to a single VARIANT column, and unload the rows Into a file in JSON format? (Select TWO).

1. A. PUT
2. B. GET
3. C. COPY
4. D. EXPORT
5. E. OBJECT CONSTRUCT

Correct Answer: CE
To convert rows in a relational table to a single VARIANT column and unload the rows into a file in JSON format, you can use the COPY command in combination with the OBJECT_CONSTRUCT function. The OBJECT_CONSTRUCT function converts the row into a JSON object stored in a VARIANT column, and the COPY command can then be used to unload this data into a JSON file.
References:
✑ Snowflake Documentation: OBJECT_CONSTRUCT
✑ Snowflake Documentation: COPY INTO <location> Top of Form
Bottom of Form