COF-C02 practice questions 351–360

1. Question 351 · 1323 in bank

   When unloading to a stage, which of the following is a recommended practice or approach?

   • ASet SINGLE = TRUE for larger files.
   • BUse OBJECT_CONSTRUCT(*) when using Parquet.
   • CAvoid the use of the CAST function.
   • DDefine an individual file format.

   Show answer

   Answer: D

   Explanation

   Data Unloading Considerations: A. Defining a File Format: File format defines the type of data to be unloaded into the stage or S3. It is best practice to define an individual file format when regularly used to unload a certain type of data based on the characteristics of the file needed. https://community.snowflake.com/s/article/Best-Practices-for-Data-Unloading

   Source: Adapted from community discussion — SV1122

   References

   • Snowflake documentation

   Next question

2. Question 352 · 1323 in bank

   Select 2

   Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)

   • AUPDATE TABLE FROM STREAM
   • BSELECT FROM STREAM
   • CINSERT INTO TABLE SELECT FROM STREAM
   • DALTER TABLE AS SELECT FROM STREAM
   • EBEGIN COMMIT

   Show answer

   Answer: AC

   Explanation

   AC The stream position (i.e. offset) is advanced when the stream is used in a DML statement. The position is updated at the end of the transaction to the beginning timestamp of the transaction. The stream describes change records starting from the current position of the stream and ending at the current transactional timestamp. To ensure multiple statements access the same change records in the stream, surround them with an explicit transaction statement (BEGIN .. COMMIT). An explicit transaction locks the stream, so that DML updates to the source object are not reported to the stream until the transaction is committed.

   Source: Adapted from community discussion — Raju039

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

3. Question 353 · 1323 in bank

   Select 2

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

   • AUse the DROP [file] command after the load completes.
   • BSpecify the TEMPORARY option when creating the file format.
   • CSpecify the PURGE copy option in the COPY INTO [table] command.
   • DUse the REMOVE command after the load completes.
   • EUse the DELETE LOAD HISTORY command after the load completes.

   Show answer

   Answer: CD

   References

   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation

   Next question

4. Question 354 · 1323 in bank

   Select 3

   On which of the following cloud platforms can a Snowflake account be hosted? (Choose three.)

   • AAmazon Web Services
   • BPrivate Virtual Cloud
   • COracle Cloud
   • DMicrosoft Azure Cloud
   • EGoogle Cloud Platform
   • FAlibaba Cloud

   Show answer

   Answer: ADE

   References

   • Snowflake documentation

   Next question

5. Question 355 · 1323 in bank

   What Snowflake role must be granted for a user to create and manage accounts?

   • AACCOUNTADMIN
   • BORGADMIN
   • CSECURITYADMIN
   • DSYSADMIN

   Show answer

   Answer: B

   Explanation

   The key phrase is : "a user to create and manage accounts? An ORGADMIN can create / manage Accounts and hence AccountADMINs.

   Source: Adapted from community discussion — singhks

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

6. Question 356 · 1323 in bank

   What feature can be used to reorganize a very large table on one or more columns?

   • AMicro-partitions
   • BClustering keys
   • CKey partitions
   • DClustered partitions

   Show answer

   Answer: B

   References

   • Snowflake documentation

   Next question

7. Question 357 · 1323 in bank

   What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?

   • AThe explain plan output is available graphically.
   • BAn explain plan can be used to conduct performance analysis without executing a query.
   • CAn explain plan will handle queries with temporary tables and the query profiler will not.
   • DAn explain plan's output will display automatic data skew optimization information.

   Show answer

   Answer: B

   Explanation

   EXPLAIN compiles the SQL statement, but does not execute it, so EXPLAIN does not require a running warehouse. Although EXPLAIN does not consume any compute credits, the compilation of the query does consume Cloud Service credits, just as other metadata operations do. https://docs.snowflake.com/en/sql-reference/sql/explain.html

   Source: Adapted from community discussion — SV1122

   References

   • Snowflake documentation

   Next question

8. Question 358 · 1323 in bank

   Select 2

   Which data types are supported by Snowflake when using semi-structured data? (Choose two.)

   • AVARIANT
   • BVARRAY
   • CSTRUCT
   • DARRAY
   • EQUEUE

   Show answer

   Answer: AD

   References

   • Snowflake documentation

   Next question

9. Question 359 · 1323 in bank

   Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

   • AOptimizes the virtual warehouse size and multi-cluster setting to economy mode
   • BAllows a user to import the files in a sequential order
   • CIncreases the latency staging and accuracy when loading the data
   • DAllows optimization of parallel operations

   Show answer

   Answer: D

   Explanation

   To optimize the number of parallel operations for a load, we recommend aiming to produce data files roughly 100-250 MB (or larger) in size compressed.

   Source: Adapted from community discussion — SV1122

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

10. Question 360 · 1323 in bank

    Select 5

    Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting? (Choose all that apply.)

    • AJDBC
    • BSnowSQL
    • CSnowflake Web Interface (UI)
    • DODBC
    • EPython

    Show answer

    Answer: ABCDE

    Explanation

    MFA login is designed primarily for connecting to Snowflake through the - web interface - but is also fully-supported by SnowSQL - and the Snowflake JDBC and ODBC drivers. Snowflake supports MFA token caching with the following drivers and connectors on macOS and Windows. This feature is not supported on Linux. - ODBC driver version 2.23.0 (or later). - JDBC driver version 3.12.16 (or later). - Python Connector for Snowflake version 2.3.7 (or later).

    Source: Adapted from community discussion — EmiB

    References

    • Snowflake documentation
    • Snowflake documentation

    Next question

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

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