COF-C02 practice questions 1,061–1,070

1. Question 1061 · 1323 in bank

   By default, how long is the standard retention period for Time Travel across all Snowflake accounts?

   • A0 days
   • B1 day
   • C7 days
   • D14 days

   Show answer

   Answer: B

   References

   • Snowflake documentation

   Next question

2. Question 1062 · 1323 in bank

   What type of query will benefit from the query acceleration service?

   • AQueries without filters or aggregation
   • BQueries with large scans and selective filters
   • CQueries where the GROUP BY has high cardinality
   • DQueries of tables that have search optimization service enabled

   Show answer

   Answer: B

   Explanation

   B is correct. Examples of the types of workloads that might benefit from the query acceleration service: 1) Ad hoc analytics. 2) Workloads with unpredictable data volume per query. 3) Queries with large scans and selective filters. https://docs.snowflake.com/en/user-guide/query-acceleration-service#label-query-acceleration-scale-factor

   Source: Adapted from community discussion — BobFar

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

3. Question 1063 · 1323 in bank

   How does the search optimization service help Snowflake users improve query performance?

   • AIt scans the micro-partitions based on the joins used in the queries and scans only join columns.
   • BIt maintains a persistent data structure that keeps track of the values of the table’s columns in each of its micro-partitions.
   • CIt scans the local disk cache to avoid scans on the tables used in the query.
   • DIt keeps track of running queries and their results and saves those extra scans on the table.

   Show answer

   Answer: B

   Explanation

   B Correct . To improve performance for point lookups, the search optimization service creates and maintains a persistent data structure called a search access path. The search access path keeps track of which values of the table’s columns might be found in each of its micro-partitions, allowing some to be skipped when scanning the table. https://docs.snowflake.com/en/user-guide/search-optimization-service#how-does-the-search-optimization-service-work

   Source: Adapted from community discussion — BobFar

   References

   • Snowflake documentation

   Next question

4. Question 1064 · 1323 in bank

   What can be done to reduce queueing on a virtual warehouse?

   • AIncrease the AUTO_SUSPEND setting for the warehouse.
   • BChange the warehouse to a multi-cluster warehouse.
   • CIncrease the warehouse size.
   • DLower the MAX_CONCURRENCY_LEVEL setting for the warehouse.

   Show answer

   Answer: B

   References

   • Snowflake documentation

   Next question

5. Question 1065 · 1323 in bank

   Select 2

   What are characteristics of Snowsight worksheets? (Choose two.)

   • AWorksheets can be grouped under folders, and a folder of folders.
   • BEach worksheet is a unique Snowflake session.
   • CUsers are limited to running only one query on a worksheet.
   • DThe Snowflake session ends when a user switches worksheets.
   • EUsers can import worksheets and share them with other users.

   Show answer

   Answer: BE

   Explanation

   BE Each worksheet is a separate session with its own id, which you can see if you run SELECT CURRENT_SESSION(); in each sheet. You can import worksheets as described here: https://docs.snowflake.com/en/user-guide/ui-snowsight-worksheets-gs#import-worksheets-from-the-sf-legacy-interface-caps You can share them too: https://docs.snowflake.com/en/user-guide/ui-snowsight-worksheets-gs

   Source: Adapted from community discussion — 0e504b5

   References

   • Snowflake documentation

   Next question

6. Question 1066 · 1323 in bank

   Select 2

   What are reasons for using the VALIDATE function in Snowflake after a COPY INTO command execution? (Choose two.)

   • ATo validate the files that have been loaded earlier using the COPY INTO command
   • BTo fix errors that were made during the execution of the COPY INTO command
   • CTo return errors encountered during the execution of the COPY INTO command
   • DTo identify potential issues in the COPY INTO command before it is executed
   • ETo count the number of errors encountered during the execution of the COPY INTO command

   Show answer

   Answer: AC

   Explanation

   Thanks, easy to confuse this with VALIDATION_MODE option for COPY INTO. This question is about VALIDATE after the COPY INTO

   Source: Adapted from community discussion — induna

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

7. Question 1067 · 1323 in bank

   Select 2

   Which types of URLs are provided by Snowflake to access unstructured data files? (Choose two).

   • AAbsolute URL
   • BDynamic URL
   • CFile URL
   • DRelative URL
   • EScoped URL

   Show answer

   Answer: CE

   References

   • Snowflake documentation

   Next question

8. Question 1068 · 1323 in bank

   Which query will return a sample of a table with 1000 rows named testtable, in which each row has a 10% probability of being included in the sample?

   • Aselect * from testtable sample (0.1);
   • Bselect * from testtable sample (10);
   • Cselect * from testtable sample (0.1 rows);
   • Dselect * from testtable sample (10 rows);

   Show answer

   Answer: B

   References

   • Snowflake documentation

   Next question

9. Question 1069 · 1323 in bank

   Which system function can be used to manage access to the data in a share and display certain data only to paying customers?

   • ASYSTEM$ALLOWLIST
   • BSYSTEM$ALLOWLIST_PRIVATELINK
   • CSYSTEM$AUTHORIZE_PRIVATELINK
   • DSYSTEM$IS_LISTING_PURCHASED

   Show answer

   Answer: D

   Next question

10. Question 1070 · 1323 in bank

    Which Snowflake object does not consume any storage costs?

    • ASecure view
    • BMaterialized view
    • CTemporary table
    • DTransient table

    Show answer

    Answer: A

    Next question

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

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