- (Topic 4)
A user wants to access files stored in a stage without authenticating into Snowflake. Which type of URL should be used?

1. A. File URL
2. B. Staged URL
3. C. Scoped URL
4. D. Pre-signed URL

Correct Answer: D
A Pre-signed URL should be used to access files stored in a Snowflake stage without requiring authentication into Snowflake. Pre-signed URLs are simple HTTPS URLs that provide temporary access to a file via a web browser, using a pre-signed access token. The expiration time for the access token is configurable, and this type of URL allows users or applications to directly access or download the files without needing to authenticate into Snowflake5.
References: [COF-C02] SnowPro Core Certification Exam Study Guide

- (Topic 3)
Which kind of Snowflake table stores file-level metadata for each file in a stage?

1. A. Directory
2. B. External
3. C. Temporary
4. D. Transient

Correct Answer: A
The kind of Snowflake table that stores file-level metadata for each file in a stage is a directory table. A directory table is an implicit object layered on a stage and stores file-level metadata about the data files in the stage3.

- (Topic 5)
What SnowFlake database object is derived from a query specification, stored for later use, and can speed up expensive aggregation on large data sets?

1. A. Temporary table
2. B. External table
3. C. Secure view
4. D. Materialized view

Correct Answer: D
A materialized view in Snowflake is a database object derived from a query specification, stored for later use, and can significantly speed up expensive aggregations on large data sets. Materialized views store the result of their underlying query, reducing the need to recompute the result each time the view is accessed. This makes them ideal for improving the performance of read-heavy, aggregate-intensive queries.
References:
✑ Snowflake Documentation: Using Materialized Views

- (Topic 2)
Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select THREE),

1. A. Snowflake data and services are deployed in a single availability zone within a cloud provider's region.
2. B. Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.
3. C. Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage
4. D. Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage
5. E. All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform
6. F. Snowflake data and services are deployed in at least three availability zones within a cloud provider's region

Correct Answer: DEF
Snowflake??s architecture is designed to operate entirely on cloud infrastructure. It uses the core compute and storage services of each cloud provider, which allows it to leverage the scalability and reliability of cloud resources. Snowflake??s services are deployed across multiple availability zones within a cloud provider??s region to ensure high availability and fault tolerance. References: [COF-C02] SnowPro Core Certification Exam Study Guide

- (Topic 2)
Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?

1. A. SHOW GRANTS OF ROLE MY_ROLE
2. B. SHOW GRANTS TO ROLE MY_ROLE
3. C. SHOW GRANTS FOR ROLE MY_ROLE
4. D. SHOW GRANTS ON ROLE MY_ROLE

Correct Answer: B
The SQL statement SHOW GRANTS TO ROLE MY_ROLE is used to determine which users and roles have access to a role called MY_ROLE. This statement lists all the privileges granted to the role, including which roles and users can assume MY_ROLE. References: [COF-C02] SnowPro Core Certification Exam Study Guide