Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 1121:

  True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.

  A. True

  B. False

  Correct Answer: B

  Reference: https://interworks.com/blog/bdu/2020/02/05/zero-to-snowflake-secure-data-sharing/

• Question 1122:

  Which object allows you to limit the number of credits consumed within a Snowflake account? Select one.

  A. Account usage Tracking

  B. Resource Monitor

  C. Warehouse Limit Parameter

  D. Credit Consumption Tracker

  Correct Answer: B

  The time travel data retention can be overwritten at the table level "When creating a table, schema, or database, the account default can be overridden using the DATA_RETENTION_TIME_IN_DAYS parameter in the command."

• Question 1123:

  True or False: Snowpipe via RFST API can only reference External Stages as source.

  A. True

  B. False

  Correct Answer: B

  Reference: https://community.snowflake.com/s/article/Making-Transient-table-by-Default

• Question 1124:

  If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

  A. 4

  B. 16

  C. 32

  D. 128

  Correct Answer: A

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

• Question 1125:

  What happens when a Data Provider revokes privileges to a Share on an object in their source database?

  A. The object immediately becomes unavailable for all Data Consumers

  B. Any additional data arriving after this point in time will not be visible to Data Consumers

  C. The Data Consumers stop seeing data updates and become responsible for storage charges for the object

  D. A static copy of the object at the time the privilege was revoked is created In the Data Consumers' accounts

  Correct Answer: A

• Question 1126:

  True or False: Multi_Factor Authentication (MFA) in Snowflake is only supported in conjunction with single Sign-on (sso).

  A. True

  B. False

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/user-guide/admin-security-fed-auth-use.html

• Question 1127:

  True or False: A single database can exist in more than one Snowflake account.

  A. True

  B. False

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/sql-reference/ddl-database.html

• Question 1128:

  Increasing the size of a Virtual Warehouse from an X-Small to an X-Large is an example of:

  A. Scaling rhythmically

  B. Scaling max

  C. Scaling out

  D. Scaling up

  Correct Answer: D

• Question 1129:

  True or False: Snowflake supports federated authentication in all editions.

  A. True

  B. False

  Correct Answer: A

  Reference: https://community.snowflake.com/s/news/federated-authentication-sso-now-available-in-all-snowflake-editions- MC6N3I63LJGNGMHCTKGKFDH4NH2Q

• Question 1130:

  What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?

  A. Standard

  B. Premier

  C. Enterprise

  D. Business Critical Edition

  Correct Answer: D

  Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html