Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 551:

  Which file function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs?

  A. BUILD_STAGE_FILE_URL

  B. GET_ABSOLUTE_PATH

  C. GET_RELATIVE_PATH

  D. GET_STAGE_LOCATION

  Correct Answer: A

• Question 552:

  Which query contains a Snowflake hosted file URL in a directory table for a stage named bronzestage?

  A. list @bronzestage;

  B. select * from directory(@bronzestage);

  C. select metadata$filename from @bronzestage;

  D. select * from table(information_schema.stage_directory_file_registration_history( stage_name=>'bronzestage'));

  Correct Answer: B

• Question 553:

  Which feature is integrated to support Multi-Factor Authentication (MFA) at Snowflake?

  A. Authy

  B. Duo Security

  C. One Login

  D. RSA SecurID Access

  Correct Answer: B

• Question 554:

  In which Snowflake layer does Snowflake reorganize data into its internal optimized, compressed, columnar format?

  A. Cloud Services

  B. Database Storage

  C. Query Processing

  D. Metadata Management

  Correct Answer: B

• Question 555:

  What is the recommended approach for unloading data to a cloud storage location from Snowflake?

  A. Use a third-party tool to unload the data to cloud storage.

  B. Unload the data directly to the cloud storage location.

  C. Unload the data to a local file system, then upload it to cloud storage.

  D. Unload the data to a user stage, then upload the data to cloud storage

  Correct Answer: B

• Question 556:

  Which command is used to unload files from an internal or external stage to a local file system?

  A. COPY INTO

  B. GET

  C. PUT

  D. TRANSFER

  Correct Answer: B

• Question 557:

  A tabular User-Defined Function (UDF) is defined by specifying a return clause that contains which keyword?

  A. ROW_NUMBER

  B. TABLE

  C. TABULAR

  D. VALUES

  Correct Answer: B

• Question 558:

  Which SQL statement will require a virtual warehouse to run?

  A. SELECT COUNT(*) FROM TBL_EMPLOYEE;

  B. ALTER TABLE TBL_EMPLOYEE ADD COLUMN EMP_REGION VARCHAR(20);

  C. INSERT INTO TBL_EMPLOYEE(EMP_ID, EMP_NAME, EMP_SALARY, DEPT) VALUES(1, 'Adam', 20000, 'Finance');

  D. CREATE OR REPLACE TABLE TBL_EMPLOYEE ( EMP_ID NUMBER, EMP_NAME VARCHAR(30), EMP_SALARY NUMBER, DEPT VARCHAR(20) );

  Correct Answer: C

• Question 559:

  Which REST API can be used with unstructured data?

  A. insertFiles

  B. insertReport

  C. GET /api/files/

  D. loadHistoryScan

  Correct Answer: C

• Question 560:

  Which Snowflake object can be created to be temporary?

  A. Role

  B. Stage

  C. User

  D. Storage integration

  Correct Answer: B