Free COF-C02 Exam Dumps

Question 116

- (Topic 1)
In which use cases does Snowflake apply egress charges?

A. Data sharing within a specific region
B. Query result retrieval
C. Database replication
D. Loading data into Snowflake

Correct Answer:C
Snowflake applies egress charges in the case of database replication when data is transferred out of a Snowflake region to another region or cloud provider. This is because the data transfer incurs costs associated with moving data across different networks. Egress charges are not applied for data sharing within the same region, query result retrieval, or loading data into Snowflake, as these actions do not involve data transfer across regions.
References:
✑ [COF-C02] SnowPro Core Certification Exam Study Guide
✑ Snowflake Documentation on Data Replication and Egress Charges1

Question 117

- (Topic 2)
How are serverless features billed?

A. Per second multiplied by an automatic sizing for the job
B. Per minute multiplied by an automatic sizing for the job, with a minimum of one minute
C. Per second multiplied by the size, as determined by the SERVERLESS_FEATURES_SIZE account parameter
D. Serverless features are not billed, unless the total cost for the month exceeds 10% of the warehouse credits, on the account

Correct Answer:B
Serverless features in Snowflake are billed based on the time they are used, measured in minutes. The cost is calculated by multiplying the duration of the job by an automatic sizing determined by Snowflake, with a minimum billing increment of one minute. This means that even if a serverless feature is used for less than a minute, it will still be billed for the full minute.

Question 118

- (Topic 5)
Which file function generates a SnowFlake-hosted URL that must be authenticated when used?

A. GET_STATE_LOCATION
B. GET_PRESENT_URL
C. BUILD_SCOPED_FILE_URL
D. BUILD_STAGE_FILE_URL

Correct Answer:D
✑ Purpose:TheBUILD_STAGE_FILE_URLfunction generates a temporary, pre- signed URL that allows you to access a file within a Snowflake stage (internal or external). This URL requires authentication to use.
✑ Key Points:
✑ Snowflake Documentation
(BUILD_STAGE_FILE_URL): https://docs.snowflake.com/en/sql-reference/functions/build_stage_file_url.html

Question 119

- (Topic 3)
Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)

A. SHOW STORAGE BY TABLE;
B. SHOW TABLES;
C. Information Schema -> TABLE_HISTORY
D. Information Schema -> TABLE_FUNCTION
E. Information Schema -> TABLE_STORAGE_METRICS

Correct Answer:AE
To monitor data storage for individual tables, the commands and objects that can be used are ??SHOW STORAGE BY TABLE;?? and the Information Schema view ??TABLE_STORAGE_METRICS??. These tools provide detailed information about the storage utilization for tables. References: Snowflake Documentation

Question 120

- (Topic 3)
What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?

A. The shared objects are transferred.
B. The shared objects are copied.
C. The shared objects become accessible.
D. The shared objects can be re-shared.

Correct Answer:C
Once a database has been created in a consumer account from a share, the shared objects become accessible to users in that account. The shared objects are not transferred or copied; they remain in the provider??s account and are accessible to the consumer account