Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 1191:

  In which layer of its architecture does Snowflake store its metadata statistics? Select one.

  A. Storage Layer

  B. Compute Layer

  C. Database Layer

  D. Cloud Service Layer

  Correct Answer: D

  Reference: https://hevodata.com/blog/snowflake-architecture-cloud-data-warehouse/

• Question 1192:

  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);

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/user-guide/data-unload-considerations.html

• Question 1193:

  True or False: A Snowflake account is charged for data stored in both Internal and External Stages.

  A. True

  B. False

  Correct Answer: B

• Question 1194:

  When can a Virtual Warehouse start running queries?

  A. 12am-5am

  B. Only during administrator defined time slots

  C. When its provisioning is complete

  D. After replication

  Correct Answer: C

  https://docs.snowflake.com/en/user-guide/warehouses-overview.html

• Question 1195:

  What privileges are required to execute a task?

  A. To execute a task, you need the EXECUTE TASK.

  B. A task is an account-level object and can only be executed by the Account Admin role.

  C. Tasks run automatically and do run under any rote.

  D. Tasks are stored in a special database called the utility database and require EXECUTE TASK privilege in the utility database.

  Correct Answer: A

• Question 1196:

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

  A. True

  B. False

  Correct Answer: A

• Question 1197:

  Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA): Select one:

  A. SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN

  B. SECURITYADMIN ACCOUNTADMIN, SYSADMIN

  C. SECURITYADMIN, ACCOUNTADMIN

  D. ACCOUNTADMIN

  Correct Answer: D

  Reference: https://docs.snowflake.com/en/user-guide/security-mfa.html

• Question 1198:

  Which of the following commands sets the Virtual Warehouse for a session?

  A. COPT WAREHOUSE FROM < ;

  B. SET warehouse = <>;

  C. USE WAREHOUSE <>;

  D. USE VIRTUAL_WAREHOUSE <>;

  Correct Answer: C

  Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html

• Question 1199:

  True or False: When active, a pipe requires a dedicated Virtual Warehouse to execute.

  A. True

  B. False

  Correct Answer: B

• Question 1200:

  Which statement best describes Snowflake tables?

  A. Snowflake tables are logical representations of underlying physical data

  B. Snowflake tables ate the physical instantiation of data loaded Into Snowflake

  C. Snowflake tables require that clustering keys be defined to perform optimally

  D. Snowflake tables are owned by a user

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/user-guide/tables-micro-partitions.html