Snowflake Snowflake Certifications COF-R02 Questions & Answers

• Question 261:

  A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?

  A. Yes, because a table owner has full control and can unset masking policies.

  B. Yes, because masking policies only apply to cloned tables.

  C. No, because masking policies must always reference specific access roles.

  D. No, because ownership of a table does not include the ability to change masking policies

  Correct Answer: A

• Question 262:

  Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)

  A. SCIM

  B. Federated authentication

  C. TLS 1.2

  D. Key-pair authentication

  E. OAuth

  F. OCSP authentication

  Correct Answer: BDE

• Question 263:

  What are the three things customers want most from their enterprise data warehouse solution? Choose 3 answers

  A. On-premise availability

  B. Simplicity

  C. Open source based

  D. Concurrency

  E. Performance

  Correct Answer: BDE

• Question 264:

  When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

  A. A single join node uses more than 50% of the query time

  B. Partitions scanned is equal to partitions total

  C. An AggregateOperacor node is present

  D. The query is spilling to remote storage

  Correct Answer: D

• Question 265:

  True or False: Snowflake's data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

  A. True

  B. False

  Correct Answer: B

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

• Question 266:

  Snowflake is designed for which type of workloads? (Choose two.)

  A. OLAP (Analytics) workloads

  B. OLTP (Transactional) workloads

  C. Concurrent workloads

  D. On-premise workloads

  Correct Answer: AC

  Reference: https://blog.couchbase.com/its-the-workload-stupid/ https://www.quora.com/Can-Snowflake-be-used-for-an-OLTP-system-or-is-it-only-best-suited-for-warehousing

• Question 267:

  True or False: You can query the files in an External Stage directly without having to load the data into a table.

  A. True

  B. False

  Correct Answer: A

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

  External tables are read-only, therefore no DML operations can be performed on them; however, external tables can be used for query and join operations. Views can be created against external tables.

• Question 268:

  Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

  A. The validation_mode option is used when creating an Internal Stage

  B. validation_mode=return_all_errors is a parameter of the copy command

  C. The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error

  D. The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors

  Correct Answer: BD

  Reference: https://docs.snowflake.com/en/user-guide/data-load-bulk-ts.html

• Question 269:

  True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.

  A. True

  B. False

  Correct Answer: A

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

• Question 270:

  Which of the following are options when creating a Virtual Warehouse?

  A. Auto-suspend

  B. Auto-resume

  C. Local SSD size

  D. User count

  Correct Answer: AB