Snowflake Snowflake Certifications COF-R02 Questions & Answers

• Question 311:

  The PUT command: (Choose two.)

  A. Automatically creates a File Format object

  B. Automatically uses the last Stage created

  C. Automatically compresses files using Gzip

  D. Automatically encrypts files

  Correct Answer: CD

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

• Question 312:

  True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

  A. True

  B. False

  Correct Answer: B

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

• Question 313:

  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 314:

  True or False: Snowflake charges a premium for storing semi-structured data.

  A. True

  B. False

  Correct Answer: B

  Reference: https://snowflakecommunity.force.com/s/question/0D50Z00008ckwNuSAI/does-snowflakecharges-premium-for-storing-semi-structured-data

• Question 315:

  Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

  A. Customers can change the size of the Warehouse after creation

  B. A Warehouse can be resized while running

  C. A Warehouse can be configured to suspend after a period of inactivity

  D. A Warehouse can be configured to auto-resume when new queries are submitted

  Correct Answer: ABCD

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

• Question 316:

  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 317:

  Which of the following statements are true of Snowflake releases: (Choose two.)

  A. They happen approximately weekly

  B. They roll up and release approximately monthly, but customers can request early release application

  C. During a release, new customer requests/queries/connections transparently move over to the newer version

  D. A customer is assigned a 30 minute window (that can be moved anytime within a week) during which the system will be unavailable and customer is upgraded

  Correct Answer: AC

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

• Question 318:

  True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.

  A. True

  B. False

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/user-guide/security-access-control-overview.html

• Question 319:

  Select the different types of Internal Stages: (Choose three.)

  A. Named Stage

  B. User Stage

  C. Table Stage

  D. Schema Stage

  Correct Answer: ABC

  Reference: https://dwgeek.com/type-of-snowflake-stages-how-to-create-and-use.html/#Snowflake-Internal-Named-Stage

• Question 320:

  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