COF-C02 Online Practice Questions and Answers

What type of query benefits the MOST from search optimization?

A. A query that uses only disjunction (i.e., OR) predicates

B. A query that includes analytical expressions

C. A query that uses equality predicates or predicates that use IN

D. A query that filters on semi-structured data types

If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

A. 4

B. 8

C. 16

D. 32

What is the MINIMUM role required to set the value for the parameter ENABLE_ACCOUNT_DATABASE_REPLICATION?

A. ACCOUNTADMIN

B. SECURITYADMIN

C. SYSADMIN

D. ORGADMIN

What is the advantage of using a reader account?

A. It can be used by a client that does not have a Snowflake account

B. It is read-only and prevents the shared data from being updated by the provider.

C. It can be connected to a Snowflake account in a different region.

D. It provides limited access to the data share and is therefore cheaper for the data provider.

Which data types can be used in a Snowflake table that holds semi-structured data? (Choose two.)

A. ARRAY

B. BINARY

C. TEXT

D. VARIANT

E. VARCHAR

How can a Snowflake user load duplicate files with a COPY INTO command?

A. The COPY INTO options should be set to PURGE = FALSE

B. The COPY INTO options should be set to FORCE = TRUE

C. The COPY INTO options should be set to RETURN_FAILED_ONLY = FALSE

D. The COPY INTO options should be set to ON_ERROR = CONTINUE

What is used to denote a pre-computed data set derived from a SELECT query specification and stored for later use?

A. View

B. Secure view

C. Materialized view

D. External table

Which command allows for continuous loading of data files as soon as they are available in a stage?

A. COPY INTO [table]

B. PUT

C. CREATE PIPE

D. GET

Which command should be used to assign a key to a Snowflake user who needs to connect using key pair authentication?

A. ALTER USER jsmith SET RSA_P8_KEY='MIIBIjANBgkqh...';

B. ALTER USER jsmith SET ENCRYPTED_KEY='MIIBIjANBgkqh...';

C. ALTER USER jsmith SET RSA_PRIVATE_KEY='MIIBIjANBgkqh...';

D. ALTER USER jsmith SET RSA_PUBLIC_KEY='MIIBIjANBgkqh...';

Which data type can be used for floating-point numbers without losing precision?

A. BINARY

B. VARIANT

C. INTEGER

D. DOUBLE