COF-C02 practice questions 1,241–1,250

1. Question 1241 · 1323 in bank

   Which command can be used to delete staged files from a Snowflake stage when the files are no longer needed?

   • ADELETE
   • BDROP
   • CREMOVE
   • DTRUNCATE TABLE

   Show answer

   Answer: C

   Explanation

   REMOVE Removes files from either an external (external cloud storage) or internal (i.e. Snowflake) stage. https://docs.snowflake.com/en/sql-reference/sql/remove Staged files can be deleted from a Snowflake stage (user stage, table stage, or named stage) using the following methods: Files that were loaded successfully can be deleted from the stage during a load by specifying the PURGE copy option in the COPY INTO command. After the load completes, use the REMOVE command to remove the files in the stage. https://docs.snowflake.com/en/user-guide/data-load-considerations-manage

   Source: Adapted from community discussion — 0e504b5

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

2. Question 1242 · 1323 in bank

   A virtual warehouse initially suffers from poor performance as a result of queries from multiple concurrent processes that are queuing. Over time, the problem resolved. What action can be taken to prevent this from happening again?

   • AIncrease the size of the virtual warehouse.
   • BAdd a cluster key to the most used JOIN key.
   • CChange the multi-cluster settings to add additional clusters.
   • DEnable the search optimization service for the underlying tables.

   Show answer

   Answer: C

   References

   • Snowflake documentation

   Next question

3. Question 1243 · 1323 in bank

   What action can be performed using the GET command in Snowflake?

   • AAutomatically rename downloaded files.
   • BAutomatically decrypt downloaded data on a client machine.
   • CDownload data files from Snowflake internal stages to a local directory/folder.
   • DDownload data files from Snowflake external stages to a local directory/folder.

   Show answer

   Answer: C

   Explanation

   GET Downloads data files from one of the following Snowflake stages to a local directory/folder on a client machine: Named internal stage. Internal stage for a specified table. Internal stage for the current user. GET does not support downloading files from external stages. To download files from external stages, use the utilities provided by the cloud service. PUT has the same limitation: doesn't support uploading files to an external stage: https://docs.snowflake.com/en/sql-reference/sql/put

   Source: Adapted from community discussion — 0e504b5

   References

   • Snowflake documentation

   Next question

4. Question 1244 · 1323 in bank

   What is the lowest Snowflake edition that offers Time Travel up to 90 days?

   • AStandard Edition
   • BPremier Edition
   • CEnterprise Edition
   • DBusiness Critical Edition

   Show answer

   Answer: C

   Next question

5. Question 1245 · 1323 in bank

   Which validation option is the only one that supports the COPY INTO [location] command?

   • ARETURN_ROWS
   • BRETURN_[n]_ROWS
   • CRETURN_ERRORS
   • DRETURN_ALL_ERRORS

   Show answer

   Answer: A

   Explanation

   For sure, those who designed these questions did not have complete intellectual and mental health. Also, I believe that it will be a big problem for the Snowflake company over time because the way the questions are designed and the content is very stereotyped and memory-oriented. Answer these questions correctly

   Source: Adapted from community discussion — imransh

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

6. Question 1246 · 1323 in bank

   Where does Snowflake store the data output from a query that was executed in the past 24 hours?

   • AIn a micro-partition
   • BIn a remote disk
   • CIn the result cache layer
   • DIn the local disk cache layer

   Show answer

   Answer: C

   Next question

7. Question 1247 · 1323 in bank

   What are the correct settings for column and element names, regardless of which notation is used while accessing elements in a JSON object?

   • ABoth the column name and the element name are case-insensitive.
   • BBoth the column name and the element name are case-sensitive.
   • CThe column name is case-sensitive and the element names are case-insensitive.
   • DThe column name is case-insensitive and the element name is case-sensitive.

   Show answer

   Answer: D

   Explanation

   D. The column name is case-insensitive and the element name is case-sensitive. https://docs.snowflake.com/en/user-guide/querying-semistructured Important Regardless of which notation you use, the column name is case-insensitive but element names are case-sensitive. For example, in the following list, the first two paths are equivalent, but the third is not: src:salesperson.name SRC:salesperson.name SRC:Salesperson.Name

   Source: Adapted from community discussion — 0e504b5

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

8. Question 1248 · 1323 in bank

   How can the Query Profile be used to identify the costliest operator of a query?

   • ASelect any node in the operator tree and look at the number of micro-partitions scanned.
   • BFind the operator node with the highest fraction of time or percentage of total time.
   • CSelect the TableScan operator node and look at the percentage scanned from cache.
   • DLook at the number of rows between operator nodes across the operator tree.

   Show answer

   Answer: B

   References

   • Snowflake documentation

   Next question

9. Question 1249 · 1323 in bank

   In order to access Snowflake Marketplace listings, who needs to accept the Snowflake Consumer Terms of Service?

   • ASYSADMIN
   • BSECURITYADMIN
   • CACCOUNTADMIN
   • DORGADMIN

   Show answer

   Answer: D

   Explanation

   D. ORGADMIN https://other-docs.snowflake.com/en/collaboration/consumer-becoming The organization administrator only needs to accept the Snowflake Provider and Consumer Terms once for your organization. After the terms have been accepted, anyone in your organization that has a role with the necessary privileges can become a consumer of listings. Note You must be an organization administrator (i.e. a user granted the ORGADMIN role) to accept the terms.

   Source: Adapted from community discussion — 0e504b5

   Next question

10. Question 1250 · 1323 in bank

    Select 2

    Which statistics are displayed in a Query Profile that indicate that intermediate results do not fit in memory? (Choose two.)

    • ABytes scanned
    • BPartitions scanned
    • CBytes spilled to local storage
    • DBytes spilled to remote storage
    • EPercentage scanned from cache

    Show answer

    Answer: CD

    References

    • Snowflake documentation

    Next question

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

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