COF-C02 practice questions 1,031–1,040

1. Question 1031 · 1323 in bank

   What is the recommended way to change the existing file format type in my_format from CSV to JSON?

   • AALTER FILE FORMAT my_format SET TYPE=JSON;
   • BALTER FILE FORMAT my_format SWAP TYPE WITH JSON;
   • CCREATE OR REPLACE FILE FORMAT my_format TYPE=JSON;
   • DREPLACE FILE FORMAT my_format TYPE=JSON;

   Show answer

   Answer: C

   Explanation

   ALTER FILE FORMAT does not support the following actions: - Changing the type (CSV, JSON, etc.) for the file format. To make any of these changes, you must recreate the file format.

   Source: Adapted from community discussion — romega2

   References

   • Snowflake documentation

   Next question

2. Question 1032 · 1323 in bank

   Select 2

   Which features are included in Snowsight? (Choose two.)

   • AWorksheet sharing
   • BReferencing SnowSQL
   • CExploring the Snowflake Marketplace
   • DChanging the Snowflake account cloud provider
   • EDownloading query result data larger than 100 MB

   Show answer

   Answer: AC

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

3. Question 1033 · 1323 in bank

   How long can a data consumer who has a pre-signed URL access data files using Snowflake?

   • AIndefinitely
   • BUntil the result_cache expires
   • CUntil the retention_time is met
   • DUntil the expiration_time is exceeded

   Show answer

   Answer: D

   References

   • Snowflake documentation

   Next question

4. Question 1034 · 1323 in bank

   Select 2

   What mechanisms can be used to inform Snowpipe that there are staged files available to load into a Snowflake table? (Choose two.)

   • ACloud messaging
   • BEmail integrations
   • CError notifications
   • DREST endpoints
   • ESnowsight interactions

   Show answer

   Answer: AD

   References

   • Snowflake documentation

   Next question

5. Question 1035 · 1323 in bank

   A Snowflake user needs to import a JSON file larger than 16 MB. What file format option could be used?

   • Atrim_space = true
   • Bcompression = auto
   • Cstrip_outer_array = true
   • Dstrip_outer_array = false

   Show answer

   Answer: C

   Explanation

   The correct answer is C. strip_outer_array = true will remove the outer array structure and copy the file into multiple table rows instead of row. (the limitation for table rows is max 16MB) with this solution it will be fine. https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare#semi-structured-data-size-limitations

   Source: Adapted from community discussion — BobFar

   References

   • Snowflake documentation

   Next question

6. Question 1036 · 1323 in bank

   What is a feature of column-level security in Snowflake?

   • ARole access policies
   • BNetwork policies
   • CInternal tokenization
   • DExternal tokenization

   Show answer

   Answer: D

   References

   • Snowflake documentation

   Next question

7. Question 1037 · 1323 in bank

   Select 2

   Which common query problems can the Query Profile help a user identify and troubleshoot? (Choose two.)

   • AWhen window functions are used incorrectly
   • BWhen there are exploding joins
   • CWhen there is a UNION without ALL
   • DWhen the SELECT DISTINCT command returns too many values
   • EWhen there are Common Table Expressions (CTEs) without a final SELECT statement

   Show answer

   Answer: BC

   Explanation

   B - Exploding JOIN well they are almost always bad produces a ton of result records C - UNION without ALL needs extra compute to dedupe the combined results

   Source: Adapted from community discussion — induna

   Next question

8. Question 1038 · 1323 in bank

   Select 2

   Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

   • AThe VALIDATION_MODE option is used when creating an Internal Stage
   • BVALIDATION_MODE=RETURN_ALL_ERRORS is a parameter of the COPY command
   • CThe VALIDATION_MODE option will validate data to be loaded by the COPY statement while completing the load and will return the rows that could not be loaded without error
   • DThe VALIDATION_MODE option will validate data to be loaded by the COPY statement without completing the load and will return possible errors

   Show answer

   Answer: BD

   Explanation

   https://docs.snowflake.com/en/user-guide/data-load-bulk-ts.html#step-2-validating-the-data-load The VALIDATION_MODE copy option instructs a COPY statement to validate the data to be loaded and return results based on the validation option specified. No data is loaded when this copy option is specified.

   Source: Adapted from community discussion — aqmdla2002

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

9. Question 1039 · 1323 in bank

   What is the Fail-safe retention period for transient and temporary tables?

   • A0 days
   • B1 day
   • C7 days
   • D90 days

   Show answer

   Answer: A

   References

   • Snowflake documentation

   Next question

10. Question 1040 · 1323 in bank

    Select 2

    Which Snowflake features can be enabled by calling the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function by a user with the ORGADMIN role? (Choose two.)

    • AClustering
    • BClient redirect
    • CFail-safe
    • DSearch optimization service
    • EAccount and database replication

    Show answer

    Answer: BE

    References

    • Snowflake documentation

    Next question

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

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