COF-C02 practice questions 961–970

1. Question 961 · 1323 in bank

   Select 2

   When using SnowSQL, which configuration options are required when unloading data from a SQL query run on a local machine? (Choose two.)

   • Aecho
   • Bquiet
   • Coutput_file
   • Doutput_format
   • Eforce_put_overwrite

   Show answer

   Answer: CD

   References

   • Snowflake documentation

   Next question

2. Question 962 · 1323 in bank

   Which Snowflake view is used to support compliance auditing?

   • AACCESS_HISTORY
   • BCOPY_HISTORY
   • CQUERY_HISTORY
   • DROW_ACCESS_POLICIES

   Show answer

   Answer: A

   References

   • Snowflake documentation

   Next question

3. Question 963 · 1323 in bank

   How can a Snowflake user load duplicate files with a COPY INTO command?

   • AThe COPY INTO options should be set to PURGE = FALSE
   • BThe COPY INTO options should be set to FORCE = TRUE
   • CThe COPY INTO options should be set to RETURN_FAILED_ONLY = FALSE
   • DThe COPY INTO options should be set to ON_ERROR = CONTINUE

   Show answer

   Answer: B

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

4. Question 964 · 1323 in bank

   True or False: Pipes can be suspended and resumed.

   • ATrue
   • BFalse

   Show answer

   Answer: A

   Explanation

   https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html#pausing-or-resuming-pipes Pausing or Resuming Pipes In addition to the pipe owner, a role that has the following minimum permissions can pause or resume the pipe:

   Source: Adapted from community discussion — jjordan

   References

   • Snowflake documentation

   Next question

5. Question 965 · 1323 in bank

   Select 2

   Which transformation techniques are supported for bulk loading data into Snowflake using the COPY INTO [table] command? (Choose two.)

   • AColumn grouping
   • BColumn omission
   • CColumn reordering
   • DColumn aggregation
   • ESelection of a limited number of rows

   Show answer

   Answer: BC

   Next question

6. Question 966 · 1323 in bank

   Which type of charts are supported by Snowsight? (Choose two.)

   • AFlowcharts
   • BGantt charts
   • CLine charts
   • DPie charts S3
   • EScatterplots

   Show answer

   Answer: E

   Explanation

   76. Snow sight supports the following types of charts: • Bar charts • Line charts • Scatterplots • Heat grids • Scorecards

   Source: Adapted from community discussion — JG1984

   Next question

7. Question 967 · 1323 in bank

   Select 2

   A user wants to upload a file to an internal Snowflake stage using a PUT command. Which tools and/or connectors could be used to execute this command? (Choose two.)

   • ASnowCD
   • BSnowSQL
   • CSQL API
   • DPython connector
   • ESnowsight worksheets

   Show answer

   Answer: BD

   Explanation

   https://docs.snowflake.com/en/developer-guide/sql-api/intro#label-sql-api-limitations: The following commands are not supported: The PUT command (in Snowflake SQL) The GET command (in Snowflake SQL) https://docs.snowflake.com/en/sql-reference/sql/put: The command cannot be executed from the Worksheets Worksheet tab page in either Snowflake web interface; instead, use the SnowSQL client or Drivers to upload data files, or check the documentation for a specific Snowflake client to verify support for this command.

   Source: Adapted from community discussion — pvskbrod

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

8. Question 968 · 1323 in bank

   Which Snowflake table is an implicit object layered on a stage, where the stage can be either internal or external?

   • ADirectory table
   • BTemporary table
   • CTransient table
   • DA table with a materialized view

   Show answer

   Answer: A

   Next question

9. Question 969 · 1323 in bank

   The Query Profile in the image is for a query executed in Snowsight. Four of the key nodes are highlighted in yellow.

   

   Which highlighted node will be the MOST expensive?

   • AAggregate[1]
   • BJoin[5]
   • CTableScan[2]
   • DTableScan[3]

   Show answer

   Answer: D

   References

   • Snowflake documentation

   Next question

10. Question 970 · 1323 in bank

    What is a characteristic of the maintenance of a materialized view?

    • AMaterialized views cannot be refreshed automatically.
    • BAn additional set of scripts is needed to refresh data in materialized views.
    • CA materialized view is automatically refreshed by a Snowflake managed warehouse.
    • DA materialized view can be set up with the auto-refresh feature using the SQL SET command.

    Show answer

    Answer: C

    Next question

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

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