Snowflake COF-R02 SnowPro Core Recertification Exam Exam Practice Test Questions

• Question 1

  - (Exam Topic 3) Which Snowflake feature will allow small volumes of data to continuously load into Snowflake and will incrementally make the data available for analysis?

  • COPY INTO
  • CREATE PIPE
  • INSERT INTO
  • TABLE STREAM

  Show Answer Answer: B Next

• Question 2

  - (Exam Topic 3) Using variables in Snowflake is denoted by using which SQL character?

  • @
  • &
  • $
  • #

  Show Answer Answer: C Next

• Question 3

  - (Exam Topic 3) A user created a new worksheet within the Snowsight Ul and wants to share this with teammates How can this worksheet be shared?

  • Create a zero-copy clone of the worksheet and grant permissions to teammates
  • Create a private Data Exchange so that any teammate can use the worksheet
  • Share the worksheet with teammates within Snowsight
  • Create a database and grant all permissions to teammates

  Show Answer Answer: C Next

• Question 4

  - (Exam Topic 1) The number of queries that a Virtual Warehouse can concurrently process is determined by: Choose 2 answers

  • The complexity of each query
  • The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account
  • The size of the data required for each query
  • The tool that s executing the query

  Show Answer Answer: A,C Next

• Question 5

  - (Exam Topic 3) What is the default file size when unloading data from Snowflake using the COPY command?

  • 5 MB
  • 8 GB
  • 16 MB
  • 32 MB

  Show Answer Answer: C Next