COF-C02 Free Practice Test

- (Topic 6)
Which command is used to upload data files from a local directory or folder on a client machine to an internal stage, for a specified table?

1. A. GET
2. B. PUT
3. C. CREATE STREAM
4. D. COPY INTO

Correct Answer: B
To upload data files from a local directory or folder on a client machine to an internal stage in Snowflake, thePUTcommand is used. ThePUTcommand takes files from the local file system and uploads them to an internal Snowflake stage (or a specified stage) for the purpose of preparing the data to be loaded into Snowflake tables.
Syntax Example:
PUT file:// @;
This command is crucial for data ingestion workflows in Snowflake, especially when preparing to load data using theCOPY INTOcommand.
Reference: Snowflake Documentation on Using the PUT Command:
https://docs.snowflake.com/en/sql-reference/sql/put.html

- (Topic 3)
For the ALLOWED VALUES tag property, what is the MAXIMUM number of possible string values for a single tag?

1. A. 10
2. B. 50
3. C. 64
4. D. 256

Correct Answer: D
For the ALLOWED VALUES tag property, the maximum number of possible string values for a single tag is 256. This allows for a wide range of values to be assigned to a tag when it is set on an object

- (Topic 2)
Which Snowflake architectural layer is responsible for a query execution plan?

1. A. Compute
2. B. Data storage
3. C. Cloud services
4. D. Cloud provider

Correct Answer: C
In Snowflake??s architecture, the Cloud Services layer is responsible for generating the query execution plan. This layer handles all the coordination, optimization, and management tasks, including query parsing, optimization, and compilation into an execution plan that can be processed by the Compute layer.

- (Topic 3)
Which query contains a Snowflake hosted file URL in a directory table for a stage named bronzestage?

1. A. list @bronzestage;
2. B. select * from directory(@bronzestage);
3. C. select metadata$filename from @bronzestage;
4. D. select * from table(information_schema.stage_directory_file_registration_history( stage name=>'bronzestage1));

Correct Answer: B
The query that contains a Snowflake hosted file URL in a directory table for a stage named bronzestage is select * from directory(@bronzestage). This query retrieves a list of all files on the stage along with metadata, including the Snowflake file URL for each file3.

- (Topic 4)
What is the minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data?

1. A. Standard Edition
2. B. Enterprise Edition
3. C. Business Critical Edition
4. D. Virtual Private Snowflake Edition

Correct Answer: C
The minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data is the Business Critical Edition. This edition offers enhanced security features necessary for compliance with regulations such as HIPAA and HITRUST CSF4.