Snowflake COF-C02 SnowPro Core Certification Exam Practice Test
Page: 1 / 14 Total 844 questions
Want more questions? Get Premium Access. ()
Question 1
A Snowflake user needs to share unstructured data from an internal stage to a reporting tool that does not have Snowflake access.
Which file function should be used?
Answer : C
The GET_PRESIGNED_URL function in Snowflake generates a presigned URL for a file stored in an internal stage, allowing direct access to the file without requiring Snowflake access. This feature is particularly useful for sharing unstructured data with external applications or tools that do not have direct access to Snowflake. The presigned URL provides temporary access to the file, making it an ideal solution for securely sharing unstructured data from an internal stage with a reporting tool or any other external application.
From what stage can a Snowflake user omit the FROM clause while loading data into a table?
Answer : B
In Snowflake, when loading data into a table using the COPY INTO command, the FROM clause can be omitted if loading from the table's stage, also known as the table stage. The table stage is a default location associated with each table where files can be temporarily stored for loading operations. This simplifies the data loading process by allowing direct loading from files that have been uploaded to the table's stage without specifying the stage explicitly in the COPY INTO command.
Snowflake Documentation: Loading Data into Tables
Question 3
Which statement accurately describes how a virtual warehouse functions?
Answer : C
A virtual warehouse in Snowflake is an independent compute cluster that performs data processing tasks such as executing SQL queries. Each virtual warehouse is dynamically allocated by Snowflake from the cloud provider's resources and does not share compute resources with other warehouses. This architecture ensures that the performance of one warehouse does not impact the performance of another. Adjusting the size of a virtual warehouse affects its computational power by increasing or decreasing the number of compute nodes, which can improve the performance of data processing tasks depending on the workload.
Which SQL statement will require a virtual warehouse to run?
Answer : C
A virtual warehouse in Snowflake is used to perform data processing tasks that require computational resources, such as queries that modify data or perform significant computation. Of the options provided:
C . INSERT INTO TBL_EMPLOYEE(EMP_ID, EMP_NAME, EMP_SALARY, DEPT) VALUES(1,'Adam',20000,'Finance'); This SQL statement performs a data modification operation (DML) by inserting a new record into the TBL_EMPLOYEE table, which requires computational resources provided by a virtual warehouse to execute.
A user wants to upload a file to an internal Snowflake stage using a put command.
Which tools and or connectors could be used to execute this command? (Select TWO).
Answer : B, E
To upload a file to an internal Snowflake stage using a PUT command, you can use:
B . SnowSQL: SnowSQL, the command-line client for Snowflake, supports the PUT command, allowing users to upload files directly to Snowflake stages from their local file systems.
E . Snowsight worksheets: Snowsight, the web interface for Snowflake, provides a user-friendly environment for executing SQL commands, including the PUT command, through its interactive worksheets.
Snowflake Documentation: Loading Data into Snowflake using SnowSQL
Snowflake Documentation: Using Snowsight
Topic 5, Exam pool E
Question 6
In Snowflake, the use of federated authentication enables which Single Sign-On (SSO) workflow activities? (Select TWO).
Answer : B, C
Federated authentication in Snowflake allows users to use their organizational credentials to log in to Snowflake, leveraging Single Sign-On (SSO). The key activities enabled by this setup include:
B . Initiating user sessions: Federated authentication streamlines the process of starting a user session in Snowflake by using the existing authentication mechanisms of an organization.
C . Logging into Snowflake: It simplifies the login process, allowing users to authenticate with their organization's identity provider instead of managing separate credentials for Snowflake.
Which DDL/DML operation is allowed on an inbound data share?
Answer : D
In Snowflake, an inbound data share refers to the data shared with an account by another account. The only DDL/DML operation allowed on an inbound data share is SELECT. This restriction ensures that the shared data remains read-only for the consuming account, maintaining the integrity and ownership of the data by the sharing account.
All Official Question Types