COF-C02 Online Practice Questions and Answers

Which of the following statements would be used to export/unload data from Snowflake?

A. COPY INTO @stage

B. EXPORT TO @stage

C. INSERT INTO @stage

D. EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);

Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)

A. Is available to all Snowflake Editions

B. Is only available to customers with Business Critical Edition

C. Restricts or enables access to specific IP addresses

D. Is activated using an "ALTER DATABASE" command

The fail-safe retention period is how many days?

A. 1 day

B. 7 days

C. 45 days

D. 90 days

Which activities are managed by Snowflake's Cloud Services layer? (Choose two.)

A. Authentication

B. Access delegation

C. Data pruning

D. Data compression

E. Query parsing and optimization

Which of the following commands are valid options for the VALIDATION_MODE parameter within the Snowflake COPY_INTO command? (Choose two.)

A. TRUE

B. RETURN_ERROR_SUM

C. RETURN_ALL_ERRORS

D. RETURN__ROWS

E. RETURN_FIRST__ERRORS

Users with the ACCOUNTADMIN role can execute which of the following commands on existing users?

A. Can SHOW users DESCRIBE a given user, or ALTER or DROP a user

B. Can DEFINE users, DESCRIBE a given user, or ALTER or DELETE a user

C. Can SHOW users, INDEX a given user, or ALTER or DELETE a user

D. Can SHOW users, DEFINE a given user or ALTER, DROP, or MODIFY a user

At which point is data encrypted when using a PUT command?

A. When it reaches the virtual warehouse

B. When it gets micro-partitioned

C. Before it is sent from the user's machine

D. After it reaches the internal stage

What activities can be monitored by a user directly from Snowsight's Activity tab without using the Account_Usage views? (Choose two.)

A. Login history

B. Query history

C. Copy history

D. Event usage history

E. Virtual warehouse metering history

Which SQL command will download all the data files from an internal table stage named TBL_EMPLOYEE to a local window directory or folder on a client machine in a folder named folder with space within the C drive?

A. GET @%TBL_EMPLOYEE 'file://C:\folder with space\';

B. GET @%TBL_EMPLOYEE 'file://C:/folder with space/';

C. PUT 'file://C:\folder with space\*' @%TBL_EMPLOYEE;

D. PUT 'file://C:/folder with space/*' @%TBL_EMPLOYEE;

What metadata does Snowflake store concerning all rows stored in a micro-partition? (Choose two.)

A. A count of the number of total values in the micro-partition

B. The range of values for each partition in the micro-partition

C. The range of values for each of the rows in the micro-partition

D. The range of values for each of the columns in the micro-partition

E. The number of distinct values for each column in the micro-partition

What service is provided as an integrated Snowflake feature to enhance Multi-Factor Authentication (MFA) support?

A. Duo Security

B. OAuth

C. Okta

D. Single Sign-On (SSO)

When using the ALLOW_CLIENT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?

A. 1 hour

B. 2 hours

C. 4 hours

D. 8 hours

Which levels can apply network policies? (Choose two.)

A. Account

B. Database

C. Role

D. Schema

E. User

Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

A. Use the DROP [file] command after the load completes.

B. Specify the TEMPORARY option when creating the file format.

C. Specify the PURGE copy option in the COPY INTO [table] command.

D. Use the REMOVE command after the load completes.

E. Use the DELETE LOAD HISTORY command after the load completes.

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

A. Metadata

B. Data Storage

C. Compute

D. Cloud Services