COF-R02 Online Practice Questions and Answers

Which type of table corresponds to a single Snowflake session?

A. Temporary

B. Translent

C. Provisional

D. Permanent

Which of the following roles is recommended to be used to create and manage users and roles?

A. SYSADMIN

B. SECURITYADMIN

C. PUBLIC

D. ACCOUNTADMIN

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

A. A single join node uses more than 50% of the query time

B. Partitions scanned is equal to partitions total

C. An AggregateOperacor node is present

D. The query is spilling to remote storage

Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)

A. SCIM

B. Federated authentication

C. TLS 1.2

D. Key-pair authentication

E. OAuth

F. OCSP authentication

What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

A. Informatica

B. Power Bl

C. Adobe

D. Data Robot

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

What impacts the credit consumption of maintaining a materialized view? (Choose two.)

A. Whether or not it is also a secure view

B. How often the underlying base table is queried

C. How often the base table changes

D. Whether the materialized view has a cluster key defined

E. How often the materialized view is queried

Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

A. STRIP_NULL_VALUES

B. SKIP_BYTE_ORDER_MARK

C. REPLACE_INVALID_CHARACTERS

D. VALIDATION_MODE

Which data type can store more than one type of data structure?

A. JSON

B. BINARY

C. VARCHAR

D. VARIANT

Which of the following significantly improves the performance of selective point lookup queries on a table?

A. Clustering

B. Materialized Views

C. Zero-copy Cloning

D. Search Optimization Service