- (Topic 1)
Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)
Correct Answer:BDE
Snowflake supports several methods for authenticating users, including federated authentication, key-pair authentication, and OAuth. Federated authentication allows users to authenticate using their organization??s identity provider. Key-pair authentication uses a public-private key pair for secure login, and OAuth is an open standard for access delegation commonly used for token-based authentication. References: Authentication policies | SnowflakeDocumentation, Authenticating to the server | Snowflake Documentation, External API authentication and secrets | Snowflake Documentation.
- (Topic 4)
What is the primary purpose of a directory table in Snowflake?
Correct Answer:D
A directory table in Snowflake is used to store file-level metadata about the data files in a stage. It is conceptually similar to an external table and provides information such as file size, last modified timestamp, and file URL. References: [COF-C02] SnowPro Core Certification Exam Study Guide
- (Topic 6)
Which file function provides a URL with access to a file on a stage without the need for authentication and authorization?
Correct Answer:B
TheGET_PRESIGNED_URLfile function in Snowflake provides a URL with access to a file on a stage without requiring authentication and authorization. This is particularly useful for sharing data files stored in Snowflake stages with external parties securely and conveniently. The presigned URL generated by this function gives temporary access to the file, which expires after a specified duration.
Example usage ofGET_PRESIGNED_URL: SELECTGET_PRESIGNED_URL('
This function generates a URL that can be used to directly access a file in the stage, making it easier to share data without compromising security.
Reference: Snowflake Documentation on File and Table Functions, specifically the section
on GET_PRESIGNED_URL: https://docs.snowflake.com/en/sql- reference/functions/get_presigned_url.html
Top of Form
- (Topic 6)
What is the PRIMARY factor that determines the cost of using a virtual warehouse in Snowflake?
Correct Answer:D
The primary factor that determines the cost of using a virtual warehouse in Snowflake isD. The length of time the compute resources in each cluster run. Snowflake's pricing model for compute usage is based on the concept of Snowflake credits, which are consumed based on the time virtual warehouses are running and the size of the warehouses. The more compute resources are utilized and the longer they run, the more credits are consumed, which directly impacts the cost.
References:
✑ Snowflake Documentation on Virtual Warehouses: Understanding and Managing Warehouse Credit Usage
- (Topic 5)
Which data formats are supported by Snowflake when unloading semi-structured data? (Select TWO).
Correct Answer:BD
Snowflake supports a variety of file formats for unloading semi-structured data, among which Parquet and Newline Delimited JSON (NDJSON) are two widely used formats.
✑ B. Binary file in Parquet: Parquet is a columnar storage file format optimized for large-scale data processing and analysis. It is especially suited for complex nested data structures.
✑ D. Newline Delimited JSON (NDJSON): This format represents JSON records separated by newline characters, facilitating the storage and processing of multiple, separate JSON objects in a single file.
These formats are chosen for their efficiency and compatibility with data analytics tools and ecosystems, enabling seamless integration and processing of exported data.
References:
✑ Snowflake Documentation: Data Unloading