Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1211:

  Which item in the Data Warehouse migration process does not apply in Snowflake? (Select two)

  A. Migrate Users
  B. Migrate Schemas
  C. Migrate Indexes
  D. Build the Data pipeline
  C. Migrate Indexes
  D. Build the Data pipeline

  ---

  Explanation

• Question 1212:

  Which of the following query profiler variables will indicate that a virtual warehouse is not sized correctly for the query being executed?

  A. Bytes sent over the network
  B. Synchronization
  C. Initialization
  D. Remote spillage
  D. Remote spillage

  ---

  Explanation

• Question 1213:

  Which function, when added to a select statement, will return a randomly-selected, specified number of rows from a table?

  A. AVERAGE( ROWS)
  B. MEDIAN { ROWS)
  C. SAMPLE { ROWS)
  D. RANDOM( ROWS)
  C. SAMPLE { ROWS)

  ---

  Explanation

  The SAMPLE clause allows users to retrieve a randomly selected subset of rows from a table.

  Syntax:

  SELECT * FROM my_table SAMPLE (10 ROWS);

  This statement selects 10 random rows from my_table.

  Why Other Options Are Incorrect:

  A. AVERAGE( ROWS): Does not exist; AVERAGE() is an aggregate function for numeric columns.

  B. MEDIAN( ROWS): Does not exist; MEDIAN() calculates the median value of a numeric column.

  D. RANDOM( ROWS): No such function in Snowflake for selecting rows.

  References:

  Snowflake SAMPLE Clause

• Question 1214:

  Which commands support a multiple-statement request to access and update Snowflake data? (Choose two.)

  A. CALL
  B. COMMIT
  C. GET
  D. PUT
  E. ROLLBACK
  B. COMMIT
  E. ROLLBACK

  ---

  Explanation

• Question 1215:

  Which key access control concept does Snowflake describe as a defined level of access to an object?

  A. Grant
  B. Privilege
  C. Role
  D. Session
  B. Privilege

  ---

  Explanation

• Question 1216:

  When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

  A. The cloned views and the stored procedures will reference the cloned tables in the cloned database.
  B. An error will occur, as views with qualified references cannot be cloned.
  C. An error will occur, as stored objects cannot be cloned.
  D. The stored procedures and views will refer to tables in the source database.
  D. The stored procedures and views will refer to tables in the source database.

  ---

  Explanation

• Question 1217:

  In order to access Snowflake Marketplace listings, who needs to accept the Snowflake Consumer Terms of Service?

  A. SYSADMIN
  B. SECURITYADMIN
  C. ACCOUNTADMIN
  D. ORGADMIN
  D. ORGADMIN

  ---

  Explanation

• Question 1218:

  What is used to limit the credit usage of a virtual warehouse within a Snowflake account?

  A. Load monitor
  B. Resource monitor
  C. Query Profile
  D. Stream
  B. Resource monitor

  ---

  Explanation

• Question 1219:

  What is the effect of configuring a virtual warehouse auto-suspend value to `0'?

  A. The warehouse will never suspend.
  B. The warehouse will suspend immediately upon work completion.
  C. The warehouse will not resume automatically.
  D. All clusters in the multi-cluster warehouse will resume immediately.
  A. The warehouse will never suspend.

  ---

  Explanation

  Any integer 0 or greater, or NULL:

  Setting a value less than 60 is allowed, but might not result in the desired/expected behavior because the background process that suspends a warehouse runs approximately every 60 seconds and, therefore, is not intended for enabling

  exact control over warehouse suspension.

  Setting a 0 or NULL value means the warehouse never suspends.

• Question 1220:

  When does Snowflake automatically encrypt data that is loaded into Snowflake? (Choose two.)

  A. After the data is micro-partitioned.
  B. After loading the data into a table.
  C. After loading the data into an internal stage.
  D. After loading data into an external stage.
  E. Only when using an encrypted stage.
  B. After loading the data into a table.
  C. After loading the data into an internal stage.

  ---

  Explanation