COF-C02 Free Practice Test

- (Topic 1)
User-level network policies can be created by which of the following roles? (Select TWO).

1. A. ROLEADMIN
2. B. ACCOUNTADMIN
3. C. SYSADMIN
4. D. SECURITYADMIN
5. E. USERADMIN

Correct Answer: BD
User-level network policies in Snowflake can be created by roles with the necessary privileges to manage security and account settings. The ACCOUNTADMIN role has the highest level of privileges across the account, including the ability to manage network policies. The SECURITYADMIN role is specifically responsible for managing security objects within Snowflake, which includes the creation and management of network policies.
References:
✑ [COF-C02] SnowPro Core Certification Exam Study Guide
✑ Snowflake Documentation on Network Policies1
✑ Section 1.3 - SnowPro Core Certification Study Guide

- (Topic 6)
What activities can a user with the ORGADMIN role perform? (Select TWO).

1. A. Create information_schema in a database
2. B. View usage information for all accounts in the organization.
3. C. Enable database cloning for an account in the organization.
4. D. Enable database replication for an account in the organization.
5. E. View micro-partition information for all accounts in the organization.

Correct Answer: BD
The ORGADMIN role in Snowflake is designed to manage organization-level activities. This role can perform several tasks that span across multiple accounts within the organization.
✑ View Usage Information:The ORGADMIN role can view usage statistics and billing
information for all accounts within the organization.
-- Example: Viewing usage information SELECT *
FROM organization_usage_history;
✑ Enable Database Replication:The ORGADMIN role has the authority to enable and manage database replication for accounts within the organization.
-- Example: Enabling database replication
ALTER DATABASE my_database ENABLE REPLICATION TO ACCOUNT other_account;
References:
✑ Snowflake Documentation: Organization Administration
✑ Snowflake Documentation: Replication

- (Topic 6)
How many credits does a size 3X-Large virtual warehouse consume if it runs continuously for 2 hours?

1. A. 32
2. B. 64
3. C. 128
4. D. 256

Correct Answer: C
In Snowflake, the consumption of credits by a virtual warehouse is determined by its size and the duration for which it runs. A size 3X-Large virtual warehouse consumes 128 credits if it runs continuously for 2 hours. This consumption rate is based on the principle that larger warehouses, capable of providing greater computational resources and throughput, consume more credits per hour of operation. The specific rate of consumption is defined by Snowflake??s pricing model and the scale of the virtual warehouse.References:Snowflake Pricing Documentation

- (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.

   QUESTION 200

   - (Topic 6)
   What command is used to export or unload data from Snowflake?

   1. A. PUT @mystage
   2. B. GET @mystage
   3. C. COPY INTO @mystage
   4. D. INSERT @mystage

   Reveal Solution Next Question

   Correct Answer: A
   The command used to export or unload data from Snowflake to a stage (such as a file in an S3 bucket, Azure Blob Storage, or Google Cloud Storage) is thePUTcommand. ThePUT command is designed to upload data files from a local file system (in the case of SnowSQL or other client) or a virtual warehouse to a specified stage. This functionality is critical for scenarios where data needs to be extracted from Snowflake for use in external systems, backups, or further processing.
   The syntax for thePUTcommand follows the structure:PUT file://
   @, wherespecifies the path to the file(s) on the local file system that you wish to upload, andspecifies the destination stage in Snowflake.
   It's important to distinguish that thePUTcommand is used for exporting data out of Snowflake, whereas theCOPY INTO

   command is used for importing data intoSnowflake from a stage. TheGETcommand, on the other hand, is used to download files from a stage to the local file system, essentially the inverse operation of thePUT command.
   References:
   ✑ Snowflake Documentation on Loading and Unloading Data: [Loading and Unloading Data](https://docs.snowflake.com/en/user-guide/data-load
   • 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