COF-C02 practice questions 691–700

1. Question 691 · 1323 in bank

   Select 3

   Which of the following are common use cases for zero-copy cloning? (Choose three.)

   • AQuick provisioning of Dev and Test/QA environments
   • BData backups
   • CPoint in time snapshots
   • DPerformance optimization

   Show answer

   Answer: ABC

   Explanation

   I think replication better represents data backup. Zero copy clone does not create physical backups, it's two logical data objects pointing to the same physical location.

   Source: Adapted from community discussion — Honeybii

   Next question

2. Question 692 · 1323 in bank

   Select 2

   What actions does the use of the PUT command do automatically? (Choose two.)

   • AIt creates a file format object.
   • BIt uses the last stage created.
   • CIt compresses all files using GZIP.
   • DIt encrypts the file data in transit.
   • EIt creates an empty target table.

   Show answer

   Answer: CD

   References

   • Snowflake documentation

   Next question

3. Question 693 · 1323 in bank

   Which command should a Snowflake user execute to load data into a table?

   • Acopy into mytable purge_mode = TRUE;
   • Bcopy into mytable from @my_int_stage;
   • Ccopy into mytable file_format = (format_name);
   • Dcopy into mytable validation = ‘RETURN_ERRORS’;

   Show answer

   Answer: B

   Next question

4. Question 694 · 1323 in bank

   Which function returns the URL of a stage using the stage name as the input?

   • ABUILD_STAGE_FILE_URL
   • BBUILD_SCOPED_FILE_URL
   • CGET_PRESIGNED_URL
   • DGET_STAGE_LOCATION

   Show answer

   Answer: D

   References

   • Snowflake documentation

   Next question

5. Question 695 · 1323 in bank

   What is the MAXIMUM number of clusters that can be provisioned with a multi-cluster virtual warehouse?

   • A1
   • B5
   • C10
   • D100

   Show answer

   Answer: C

   References

   • Snowflake documentation

   Next question

6. Question 696 · 1323 in bank

   Which Snowflake table supports unstructured data?

   • ADirectory
   • BTransient
   • CTemporary
   • DPermanent

   Show answer

   Answer: A

   Next question

7. Question 697 · 1323 in bank

   When unloading data, which file format preserves the data values for floating-point number columns?

   • AAvro
   • BCSV
   • CJSON
   • DParquet

   Show answer

   Answer: D

   Explanation

   Correct Answer is D. * When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately (15,9). * The values are not truncated when unloading floating-point number columns to Parquet files. https://docs.snowflake.com/en/user-guide/data-unload-considerations#floating-point-numbers-truncated

   Source: Adapted from community discussion — BobFar

   References

   • Snowflake documentation

   Next question

8. Question 698 · 1323 in bank

   Which virtual warehouse privilege is required to view a load-monitoring chart?

   • AMONTTOR
   • BMODIFY
   • COPERATE
   • DUSAGE

   Show answer

   Answer: A

   References

   • Snowflake documentation

   Next question

9. Question 699 · 1323 in bank

   Which use case will always cause an exploding join in Snowflake?

   • AA query that has more than 10 left outer joins.
   • BA query that is using a UNION without an ALL.
   • CA query that has not specified join criteria for tables.
   • DA query that has requested too many columns of data.

   Show answer

   Answer: C

   References

   • Snowflake documentation

   Next question

10. Question 700 · 1323 in bank

    How many resource monitors can be applied to a single virtual warehouse?

    • AZero
    • BOne
    • CEight
    • DUnlimited

    Show answer

    Answer: B

    Explanation

    B is the answer. https://thinketl.com/snowflake-resource-monitors/ A resource monitor can be set to monitor multiple warehouses but a warehouse can be assigned only to a single resource monitor.

    Source: Adapted from community discussion — bar_ser

    Next question

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

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