COF-R02 Online Practice Questions and Answers

True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.

A. True

B. False

When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:

A. Concurrency

B. Performance

Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

A. The validation_mode option is used when creating an Internal Stage

B. validation_mode=return_all_errors is a parameter of the copy command

C. The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error

D. The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors

True or False: A Virtual Warehouse can be resized while suspended.

A. True

B. False

What features does Snowflake Time Travel enable?

A. Querying data-related objects that were created within the past 365 days

B. Restoring data-related objects that have been deleted within the past 90 days

C. Conducting point-in-time analysis for Bl reporting

D. Analyzing data usage/manipulation over all periods of time

Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

A. An FTP server with TLS encryption

B. An HTTPS server with WebDAV

C. A Google Cloud storage bucket

D. A Windows server file share on Azure

Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

A. Customer-managed encryption keys through Tri-Secret Secure

B. Automatic encryption of all data

C. Up to 90 days of data recovery through Time Travel

D. Object-level access control

E. Column-level security to apply data masking policies to tables and views

Which Snowflake layer is always leveraged when accessing a query from the result cache?

A. Metadata

B. Data Storage

C. Compute

D. Cloud Services

What is the following SQL command used for?

Select * from table(validate(t1, job_id => '_last'));

A. To validate external table files in table t1 across all sessions

B. To validate task SQL statements against table t1 in the last 14 days

C. To validate a file for errors before it gets executed using a COPY command

D. To return errors from the last executed COPY command into table t1 in the current session

Which statement describes pruning?

A. The filtering or disregarding of micro-partitions that are not needed to return a query.

B. The return of micro-partitions values that overlap with each other to reduce a query's runtime.

C. A service that is handled by the Snowflake Cloud Services layer to optimize caching.

D. The ability to allow the result of a query to be accessed as if it were a table.

A user is preparing to load data from an external stage Which practice will provide the MOST efficient loading performance?

A. Organize files into logical paths

B. Store the files on the external stage to ensure caching is maintained

C. Use pattern matching for regular expression execution

D. Load the data in one large file

Which data types are supported by Snowflake when using semi-structured data? (Choose two.)

A. VARIANT

B. VARRAY

C. STRUCT

D. ARRAY

E. QUEUE

How many days is load history for Snowpipe retained?

A. 1 day

B. 7 days

C. 14 days

D. 64 days

Users are responsible for data storage costs until what occurs?

A. Data expires from Time Travel

B. Data expires from Fail-safe

C. Data is deleted from a table

D. Data is truncated from a table

When cloning a database, what is cloned with the database? (Choose two.)

A. Privileges on the database

B. Existing child objects within the database

C. Future child objects within the database

D. Privileges on the schemas within the database

E. Only schemas and tables within the database