COF-R02 exam

True or False: Pipes can be suspended and resumed.A . True B. FalseView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html#pausing-or-resuming-pipes Pausing or Resuming Pipes In addition to the pipe owner, a role that has the following minimum permissions can pause or resume the pipe:

True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.A . True B. FalseView AnswerAnswer: B

True or False: An active warehouse is required to run a COPY INTO statement.A . True B. FalseView AnswerAnswer: A

When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:A . Concurrency B. PerformanceView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

Which of the following statements would be used to export/unload data from Snowflake?A . COPY INTO @stage B. EXPORT TO @stage C. INSERT INTO @stage D. EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);View AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-unload-considerations.html

True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.A . True B. FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

Why would a customer size a Virtual Warehouse from an X-Small to a Medium?A . To accommodate more queries B. To accommodate more users C. To accommodate fluctuations in workload D. To accommodate a more complex workloadView AnswerAnswer: D Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-considerations.html

True or False: Data Providers can share data with only the Data Consumer.A . True B. FalseView AnswerAnswer: B

True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.A . True B. FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/security-access-control-overview.html

True or False: The COPY command must specify a File Format in order to execute.A . True B. FalseView AnswerAnswer: B Explanation: Create Stage: https://docs.snowflake.com/en/sql-reference/sql/create-stage.html Create 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