COF-C02 practice questions 701–710

1. Question 701 · 1323 in bank

   Select 2

   What are the main differences between the account usage views and the information schema views? (Choose two.)

   • ANo active warehouse is needed to query account usage views but one is needed to query information schema views.
   • BAccount usage views do not contain data about tables but information schema views do.
   • CAccount usage views contain dropped objects but information schema views do not.
   • DData retention for account usage views is 1 year but is 7 days to 6 months for information schema views, depending on the view.
   • EInformation schema views are read-only but account usage views are not.

   Show answer

   Answer: CD

   Explanation

   C&D Certain account usage views provide historical usage metrics. The retention period for these views is 1 year (365 days). In contrast, the corresponding views and table functions in the Snowflake Information Schema have much shorter retention periods, ranging from 7 days to 6 months, depending on the view.

   Source: Adapted from community discussion — EmiB

   References

   • Snowflake documentation

   Next question

2. Question 702 · 1323 in bank

   True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.

   • ATrue
   • BFalse

   Show answer

   Answer: A

   Explanation

   Bulk Unloading Using Queries Snowflake supports specifying a SELECT statement instead of a table in the COPY INTO command https://docs.snowflake.com/en/user-guide/data-unload-overview.html

   Source: Adapted from community discussion — RKKare

   References

   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation

   Next question

3. Question 703 · 1323 in bank

   If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

   • A4
   • B16
   • C32
   • D128

   Show answer

   Answer: A

   Next question

4. Question 704 · 1323 in bank

   Which file function provides a URL with access to a file on a stage without the need for authentication and authorization?

   • AGET_RELATIVE_PATH
   • BGET_PRESIGNED_URL
   • CBUILD_STAGE_FILE_URL
   • DBUILD_SCOPED_FILE_URL

   Show answer

   Answer: B

   Explanation

   GET_PRESIGNED_URL Generates the pre-signed URL to a staged file using the stage name and relative file path as inputs. Access files in an external stage using the function.

   Source: Adapted from community discussion — muks86

   References

   • Snowflake documentation

   Next question

5. Question 705 · 1323 in bank

   Which view can be used to determine if a table has frequent row updates or deletes?

   • ATABLES
   • BTABLE_STORAGE_METRICS
   • CSTORAGE_DAILY_HISTORY
   • DSTORAGE_USAGE

   Show answer

   Answer: B

   Explanation

   I think B is correct https://docs.snowflake.com/en/user-guide/tables-storage-considerations High-churn dimension tables can be identified by calculating the ratio of FAILSAFE_BYTES divided by ACTIVE_BYTES in the TABLE_STORAGE_METRICS view.

   Source: Adapted from community discussion — bar_ser

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

6. Question 706 · 1323 in bank

   How does the Snowflake search optimization service improve query performance?

   • AIt improves the performance of range searches.
   • BIt defines different clustering keys on the same source table.
   • CIt improves the performance of all queries running against a given table.
   • DIt improves the performance of equality searches.

   Show answer

   Answer: D

   References

   • Snowflake documentation

   Next question

7. Question 707 · 1323 in bank

   How is unstructured data retrieved from data storage?

   • ASQL functions like the GET command can be used to copy the unstructured data to a location on the client.
   • BSQL functions can be used to create different types of URLs pointing to the unstructured data. These URLs can be used to download the data to a client.
   • CSQL functions can be used to retrieve the data from the query results cache. When the query results are output to a client. the unstructured data will be output to the client as files.
   • DSQL functions can call on different web extensions designed to display different types of files as a web page. The web extensions will allow the files to be downloaded to the client.

   Show answer

   Answer: B

   References

   • Snowflake documentation

   Next question

8. Question 708 · 1323 in bank

   What is the recommended way to obtain a cloned table with the same grants as the source table?

   • AClone the table with the COPY GRANTS command.
   • BUse an ALTER TABLE command to copy the grants.
   • CClone the schema then drop the unwanted tables.
   • DCreate a script to extract grants and apply them to the cloned table.

   Show answer

   Answer: A

   Explanation

   CREATE … CLONE statements for most objects do not copy grants on the source object to the object clone. However, CREATE commands that support the COPY GRANTS clause (e.g. CREATE TABLE, CREATE VIEW) enable you to optionally copy grants to object clones. For example, the CREATE TABLE … CLONE command syntax supports the COPY GRANTS parameter. When the COPY GRANTS parameter is specified in a CREATE TABLE statement, the create operation copies all privileges, except OWNERSHIP, from the source table to the new table. The same behavior is true for other CREATE commands that support the COPY GRANTS clause.

   Source: Adapted from community discussion — EmiB

   References

   • Snowflake documentation

   Next question

9. Question 709 · 1323 in bank

   Select 2

   What common query issues can be identified using the Query Profile? (Choose two.)

   • AData classification
   • BExploding joins
   • CUnions
   • DInefficient pruning
   • EData masking

   Show answer

   Answer: BD

   References

   • Snowflake documentation

   Next question

10. Question 710 · 1323 in bank

    What is used to extract the content of PDF files stored in Snowflake stages?

    • AFLATTEN function
    • BWindow function
    • CHyperLogLog (HLL) function
    • DJava User-Defined Function (UDF)

    Show answer

    Answer: D

    References

    • Snowflake documentation

    Next question

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

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