Free COF-R02 Exam Braindumps (page: 37)

Page 36 of 83

In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

  1. Compute Credits = 50 Credits Cloud Services = 10
  2. Compute Credits = 80 Credits Cloud Services = 5
  3. Compute Credits = 10 Credits Cloud Services = 9
  4. Compute Credits = 120 Credits Cloud Services = 10
  5. Compute Credits = 200 Credits Cloud Services = 26

Answer(s): B,D



What transformations are supported in a CREATE PIPE ... AS COPY ... FROM ( ...) statement? (Select TWO.)

  1. Data can be filtered by an optional where clause
  2. Incoming data can be joined with other tables
  3. Columns can be reordered
  4. Columns can be omitted
  5. Row level access can be defined

Answer(s): C,D



What is a responsibility of Snowflake's virtual warehouses?

  1. Infrastructure management
  2. Metadata management
  3. Query execution
  4. Query parsing and optimization
  5. Management of the storage layer

Answer(s): C



Which of the following compute resources or features are managed by Snowflake? (Select TWO).

  1. Execute a COPY command
  2. Updating data
  3. Snowpipe
  4. AUTOMATIC CLUSTERING
  5. Scaling up a warehouse

Answer(s): A,D






Post your Comments and Discuss Snowflake COF-R02 exam with other Community members:

COF-R02 Discussions & Posts