Snowflake COF-R02 Online Practice Questions and Exam Preparation

Snowflake COF-R02 Online Questions & Answers

• Question 281:

  Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)

  A. Schemas
  B. Roles
  C. Secure Views
  D. Stored Procedures
  E. Tables
  F. Secure User-Defined Functions (UDFs)
  A. Schemas
  B. Roles
  F. Secure User-Defined Functions (UDFs)

• Question 282:

  A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII.

  Which Snowflake feature will support this?

  A. Row access policies
  B. Data masking policies
  C. Data encryption
  D. Role based access control
  B. Data masking policies

• Question 283:

  What are common issues found by using the Query Profile? (Choose two.)

  A. Identifying queries that will likely run very slowly before executing them
  B. Locating queries that consume a high amount of credits
  C. Identifying logical issues with the queries
  D. Identifying inefficient micro-partition pruning
  E. Data spilling to a local or remote disk
  A. Identifying queries that will likely run very slowly before executing them
  D. Identifying inefficient micro-partition pruning

• Question 284:

  Which of the following can be executed/called with Snowpipe?

  A. A User Defined Function (UDF)
  B. A stored procedure
  C. A single copy_into statement
  D. A single insert__into statement
  C. A single copy_into statement

• Question 285:

  What is the recommended file sizing for data loading using Snowpipe?

  A. A compressed file size greater than 100 MB, and up to 250 MB
  B. A compressed file size greater than 100 GB, and up to 250 GB
  C. A compressed file size greater than 10 MB, and up to 100 MB
  D. A compressed file size greater than 1 GB, and up to 2 GB
  A. A compressed file size greater than 100 MB, and up to 250 MB

  ---

  Explanation/Reference:

  https://www.phdata.io/blog/how-to-optimize-snowpipe-data-load/#:~:text=Snowpipe%20is%20typically%20used%20to,data%20within%20one%2Dminute%20intervals.

• Question 286:

  Which of the following are characteristics of security in Snowflake?

  A. Account and user authentication is only available with the Snowflake Business Critical edition.
  B. Support for HIPAA and GDPR compliance is available for UI Snowflake editions.
  C. Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher
  D. Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.
  C. Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher

• Question 287:

  How many days is load history for Snowpipe retained?

  A. 1 day
  B. 7 days
  C. 14 days
  D. 64 days
  C. 14 days

• Question 288:

  Which Snowflake technique can be used to improve the performance of a query?

  A. Clustering
  B. Indexing
  C. Fragmenting
  D. Using INDEX__HINTS
  A. Clustering

  ---

  Explanation/Reference:

  https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

• Question 289:

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

  A. Auto-suspend
  B. Auto-resume
  C. Local SSD size
  D. User count
  A. Auto-suspend
  B. Auto-resume

• Question 290:

  Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

  A. Pipe
  B. External stage
  C. Task
  D. Stream
  A. Pipe

  ---

  Explanation/Reference:

  Snowpipe enables loading data from files as soon as they're available in a stage. This means you can load data from files in micro-batches, making it available to users within minutes, rather than manually executing COPY statements on a schedule to load larger batches. https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html