COF-C02 Free Practice Test

- (Topic 1)
Which of the following can be executed/called with Snowpipe?

1. A. A User Defined Function (UDF)
2. B. A stored procedure
3. C. A single copy_into statement
4. D. A single insert into statement

Correct Answer: C
Snowpipe is used for continuous, automated data loading into Snowflake. It uses a COPY INTO <table> statement within a pipe object to load data from files as soon as they are available in a stage. Snowpipe does not execute UDFs, stored procedures, or insert statements. References: Snowpipe | Snowflake Documentation

- (Topic 3)
Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)

1. A. If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace.
2. B. A Data Exchange allows groups of accounts to share data privately among the accounts.
3. C. A Data Exchange allows accounts to share data with third, non-Snowflake parties.
4. D. Data Exchange functionality is available by default in accounts using the Enterprise edition or higher.
5. E. The sharing of data in a Data Exchange is bidirectiona
6. F. An account can be a provider for some datasets and a consumer for others.

Correct Answer: BE
A Snowflake Data Exchange allows groups of accounts to share data privately among the accounts (B), and it supports bidirectional sharing, meaning an account can be both a provider and a consumer of data (E). This facilitates secure and governed data collaboration within a selected group3.

- (Topic 6)
Which Snowflake table supports unstructured data?

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

Correct Answer: D
While Snowflake primarily deals with structured and semi-structured data, it also has the capability to handle unstructured data. Unstructured data can be stored in Snowflake using variants of SQL data types in tables, which can be permanent tables. These permanent tables, while traditionally used for structured or semi-structured data (like JSON, Avro, or Parquet), can also accommodate unstructured data in the form of binary formats or strings, offering flexibility in data storage and analysis. However, the management and querying of unstructured data in Snowflake may require additional considerations compared to structured data.References:Snowflake Documentation on Data Types

- (Topic 4)
When working with a managed access schema, who has the OWNERSHIP privilege of any tables added to the schema?

1. A. The database owner
2. B. The object owner
3. C. The schema owner
4. D. The Snowflake user's role

Correct Answer: C
In a managed access schema, the schema owner retains the OWNERSHIP privilege of any tables added to the schema. This means that while object owners have certain privileges over the objects they create, only the schema owner can manage privilege grants on these objects1.

- (Topic 4)
Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?

1. A. CREATE STAGE
2. B. COPY INTO
   C. COPY INTO
   D. CREATE PIPE
   Reveal SolutionNext Question

   Correct Answer: C
   The COPY INTO <location> command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage1.

   • 1
   • 2
   • 3
   • 4
   • 5
   • 6
   • 7
   • 8
   • 9
   • 10
   • 11
   • 12
   • 13
   • 14
   • 15
   • 16
   • 17
   • 18
   • 19
   • 20
   • 21
   • 22
   • 23
   • 24
   • 25
   • 26
   • 27
   • 28
   • 29
   • 30
   • 31
   • 32
   • 33
   • 34
   • 35
   • 36
   • 37
   • 38
   • 39
   • 40
   • 41
   • 42
   • 43
   • 44
   • 45
   • 46
   • 47
   • 48
   • 49
   • 50
   • 51
   • 52
   • 53

   Want to Unlock All Questions for this Exam?
   98.4% Pass Rate

   Full Exam Access

   Practice Test

   Use this for 1year and renew if you’re satisfied.

   $19.95

   Practice, PDF

   Go to Shop