Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 471:

  What privileges are necessary for a consumer in the Data Exchange to make a request and receive data? (Choose two.)

  A. CREATE DATABASE

  B. IMPORT SHARE

  C. OWNERSHIP

  D. REFERENCE_USAGE

  E. USAGE

  Correct Answer: AB

• Question 472:

  What are benefits of using Snowpark with Snowflake? (Choose two.)

  A. Snowpark uses a Spark engine to generate optimized SQL query plans.

  B. Snowpark automatically sets up Spark within Snowflake virtual warehouses.

  C. Snowpark does not require that a separate cluster be running outside of Snowflake.

  D. Snowpark allows users to run existing Spark code on virtual warehouses without the need to reconfigure the code.

  E. Snowpark executes as much work as possible in the source databases for all operations including User-Defined Functions (UDFs).

  Correct Answer: CD

• Question 473:

  What are Snowflake best practices when assigning the ACCOUNTADMIN role to users? (Choose two.)

  A. The ACCOUNTADMIN role should be assigned to at least two users.

  B. The ACCOUNTADMIN role should be used to create Snowflake objects.

  C. The ACCOUNTADMIN role should be used for running automated scripts.

  D. The ACCOUNTADMIN role should be given to any user who needs a high level of authority.

  E. All users assigned the ACCOUNTADMIN role should use Multi-Factor Authentication (MFA).

  Correct Answer: AE

• Question 474:

  How does a Snowflake stored procedure compare to a User-Defined Function (UDF)?

  A. A single executable statement can call only two stored procedures. In contrast, a single SQL statement can call multiple UDFs.

  B. A single executable statement can call only one stored procedure. In contrast, a single SQL statement can call multiple UDFs.

  C. A single executable statement can call multiple stored procedures. In contrast, multiple SQL statements can call the same UDFs.

  D. Multiple executable statements can call more than one stored procedure. In contrast, a single SQL statement can call multiple UDFs.

  Correct Answer: B

• Question 475:

  Which Snowflake URL type allows users or applications to download or access files directly from Snowflake stage without authentication?

  A. Directory

  B. File

  C. Pre-signed

  D. Scoped

  Correct Answer: C

• Question 476:

  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;

  Correct Answer: A

• Question 477:

  How can the COPY command be used to unload data from a table to an internal stage?

  A. COPY INTO

  B. COPY INTO

  C. COPY INTO with single-true

  D. COPY INTO S3://

  Correct Answer: AB

• Question 478:

  The use of which Snowflake table type will reduce costs when working with ETL workflows?

  A. External

  B. Permanent

  C. Temporary

  D. Transient

  Correct Answer: C

• Question 479:

  What is one of the characteristics of data shares?

  A. Data shares support full DML operations.

  B. Data shares work by copying data to consumer accounts.

  C. Data shares utilize secure views for sharing view objects.

  D. Data shares are cloud agnostic and can cross regions by default.

  Correct Answer: A

• Question 480:

  What is the MINIMUM configurable idle timeout value for a session policy in Snowflake?

  A. 2 minutes

  B. 5 minutes

  C. 10 minutes

  D. 15 minutes

  Correct Answer: B