Snowflake Snowflake Certifications COF-R02 Questions & Answers

• Question 71:

  Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)

  A. CONTENT

  B. PATH

  C. BYTE_SIZE

  D. INDEX

  E. DATATYPE

  Correct Answer: BC

• Question 72:

  Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)

  A. UPDATE TABLE FROM STREAM

  B. SELECT FROM STREAM

  C. INSERT INTO TABLE SELECT FROM STREAM

  D. ALTER TABLE AS SELECT FROM STREAM

  E. BEGIN COMMIT

  Correct Answer: CD

• Question 73:

  What internal stages are available in Snowflake? (Choose three.)

  A. Schema stage

  B. Named stage

  C. User stage

  D. Stream stage

  E. Table stage

  F. Database stage

  Correct Answer: ABE

• Question 74:

  What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)

  A. The clone always stays in sync with the original table.

  B. The clone has better query performance.

  C. The clone is created almost instantly.

  D. The clone will have time travel history from the original table.

  E. The clone saves space by not duplicating storage.

  Correct Answer: CE

• Question 75:

  How many days is load history for Snowpipe retained?

  A. 1 day

  B. 7 days

  C. 14 days

  D. 64 days

  Correct Answer: C

• Question 76:

  What is the maximum Time Travel retention period for a temporary Snowflake table?

  A. 90 days

  B. 1 day

  C. 7 days

  D. 45 days

  Correct Answer: B

• Question 77:

  The Snowflake Search Optimization Services supports improved performance of which kind of query?

  A. Queries against large tables where frequent DML occurs

  B. Queries against tables larger than 1 TB

  C. Selective point lookup queries

  D. Queries against a subset of columns in a table

  Correct Answer: C

  Reference: https://docs.snowflake.com/en/user-guide/search-optimization-service.html#:~:text=The%20search%20optimization%20service%20can%20improve%20the%20performance%20of%20point,OBJECT%2C%20and%20ARRAY% 20columns)

• Question 78:

  Which services does the Snowflake Cloud Services layer manage? (Choose two.)

  A. Compute resources

  B. Query execution

  C. Authentication

  D. Data storage

  E. Metadata

  Correct Answer: CE

• Question 79:

  Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select THREE),

  A. Snowflake data and services are deployed in a single availability zone within a cloud provider's region.

  B. Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.

  C. Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage

  D. Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage

  E. All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform

  F. Snowflake data and services are deployed in at least three availability zones within a cloud provider's region

  Correct Answer: DEF

• Question 80:

  Which of the following describes a Snowflake stored procedure?

  A. They can be created as secure and hide the underlying metadata from the user.

  B. They can only access tables from a single database.

  C. They can contain only a single SQL statement.

  D. They can be created to run with a caller's rights or an owner's rights.

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/sql-reference/stored-procedures-overview.html