True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.
Answer(s): A
https://docs.snowflake.com/en/user-guide-data-unload.html
Select the different types of Internal Stages: (Choose three.)
Answer(s): A,B,C
https://dwgeek.com/type-of-snowflake-stages-how-to-create-and-use.html/#Snowflake-Internal-Named-Stage
Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)
Answer(s): B,D
"Snowflake credits are charged based on the number of virtual warehouses you use, how long they run, and their size."
https://docs.snowflake.com/en/user-guide/credits.html#virtual-warehouse-credit-usage
True or False: The COPY command must specify a File Format in order to execute.
Answer(s): B
Create Stage:https://docs.snowflake.com/en/sql-reference/sql/create-stage.htmlCreate Table (STAGE_FILE_FORMAT option): https://docs.snowflake.com/en/sql-reference/sql/create-table.htmlCopy Into:https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html
Post your Comments and Discuss Snowflake COF-R02 exam prep with other Community members:
We’re offering these study questions to support your success. The least you can do? Drop a useful comment about each question. Help others. Build the community.