COF-C02 practice questions 861–870

1. Question 861 · 1323 in bank

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

   • AROW_NUMBER
   • BTABLE
   • CTABULAR
   • DVALUES

   Show answer

   Answer: B

   References

   • Snowflake documentation

   Next question

2. Question 862 · 1323 in bank

   Which SQL statement will require a virtual warehouse to run?

   • ASELECT COUNT(*) FROM TBL_EMPLOYEE;
   • BALTER TABLE TBL_EMPLOYEE ADD COLUMN EMP_REGION VARCHAR(20);
   • CINSERT INTO TBL_EMPLOYEE(EMP_ID, EMP_NAME, EMP_SALARY, DEPT) VALUES(1, 'Adam', 20000, 'Finance’);
   • DCREATE OR REPLACE TABLE TBL_EMPLOYEE ( EMP_ID NUMBER, EMP_NAME VARCHAR(30), EMP_SALARY NUMBER, DEPT VARCHAR(20) );

   Show answer

   Answer: C

   Explanation

   A warehouse provides the required resources, such as CPU, memory, and temporary storage, to perform the following operations in a Snowflake session: Executing SQL SELECT statements that require compute resources (e.g. retrieving rows from tables and views). Performing DML operations, such as: Updating rows in tables (DELETE , INSERT , UPDATE). Loading data into tables (COPY INTO ). Unloading data from tables (COPY INTO ).

   Source: Adapted from community discussion — ukpino

   Next question

3. Question 863 · 1323 in bank

   Which REST API can be used with unstructured data?

   • AinsertFiles
   • BinsertReport
   • CGET /api/files/
   • DloadHistoryScan

   Show answer

   Answer: C

   References

   • Snowflake documentation

   Next question

4. Question 864 · 1323 in bank

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

   • Alist @bronzestage;
   • Bselect * from directory(@bronzestage);
   • Cselect metadata$filename from @bronzestage;
   • Dselect * from table(information_schema.stage_directory_file_registration_history( stage_name=>'bronzestage'));

   Show answer

   Answer: B

   Explanation

   Querying directory tables This topic covers how to query a directory table to retrieve a list of all files on a stage with metadata, such as the Snowflake file URL, for each file. SELECT * FROM DIRECTORY( @ ) https://docs.snowflake.com/en/user-guide/data-load-dirtables-query

   Source: Adapted from community discussion — nexerSnow

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

5. Question 865 · 1323 in bank

   Select 2

   Fail-safe is unavailable on which table types? (Choose two.)

   • ATemporary
   • BTransient
   • CProvisional
   • DPermanent

   Show answer

   Answer: AB

   Explanation

   Transient and temporary tables have no Fail-safe period. As a result, no additional data storage charges are incurred beyond the Time Travel retention period.

   Source: Adapted from community discussion — moon2351

   Next question

6. Question 866 · 1323 in bank

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

   • AAuthy
   • BDuo Security
   • COne Login
   • DRSA SecurID Access

   Show answer

   Answer: B

   Next question

7. Question 867 · 1323 in bank

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

   • ACloud Services
   • BDatabase Storage
   • CQuery Processing
   • DMetadata Management

   Show answer

   Answer: B

   Next question

8. Question 868 · 1323 in bank

   When can user session variables be accessed in a Snowflake scripting procedure?

   • AWhen the procedure is defined as STRICT.
   • BWhen the procedure is defined to execute as CALLER.
   • CWhen the procedure is defined to execute as OWNER.
   • DWhen the procedure is defined with an argument that has the same name and type as the session variable.

   Show answer

   Answer: B

   Explanation

   Using session variables in a stored procedure Session variables can only be used in a Javascript Stored Procedure when it's created with Caller rights.

   Source: Adapted from community discussion — nexerSnow

   Next question

9. Question 869 · 1323 in bank

   What computer language can be selected when creating User-Defined Functions (UDFs) using the Snowpark API?

   • ASwift
   • BJavaScript
   • CPython
   • DSQL

   Show answer

   Answer: C

   References

   • Snowflake documentation

   Next question

10. Question 870 · 1323 in bank

    A user needs to ingest 1 GB of data that is available in an external stage using a COPY INTO command. How can this be done with MAXIMUM performance and the LEAST cost?

    • AIngest the data in a compressed format as a single file.
    • BIngest the data in an uncompressed format as a single file.
    • CSplit the file into smaller files of 100-250 MB each, compress and ingest each of the smaller files.
    • DSplit the file into smaller files of 100-250 MB each and ingest each of the smaller files in an uncompressed format.

    Show answer

    Answer: C

    References

    • Snowflake documentation

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

COF-C02 practice, question 861. 1323 questions available.