COF-C02 practice questions 971–980

1. Question 971 · 1323 in bank

   Which command should be used to implement a masking policy that was already created in Snowflake?

   • AALTER MASKING POLICY
   • BAPPLY MASKING POLICY
   • CCREATE MASKING POLICY
   • DSET MASKING POLICY

   Show answer

   Answer: D

   Explanation

   -- apply masking policy to a table column ALTER TABLE IF EXISTS user_info MODIFY COLUMN email SET MASKING POLICY email_mask; -- apply the masking policy to a view column ALTER VIEW user_info_v MODIFY COLUMN email SET MASKING POLICY email_mask; https://docs.snowflake.com/en/user-guide/security-column-ddm-use

   Source: Adapted from community discussion — pvskbrod

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

2. Question 972 · 1323 in bank

   Which statement accurately describes a characteristic of a materialized view?

   • AA materialized view can query only a single table.
   • BData accessed through materialized views can be stale.
   • CMaterialized view refreshes need to be maintained by the user.
   • DQuerying a materialized view is slower than executing a query against the base table of the view.

   Show answer

   Answer: A

   References

   • Snowflake documentation

   Next question

3. Question 973 · 1323 in bank

   A user wants to unload data from a relational table into a CSV file in an external stage. The table must be named exactly as specified by the user. Which file format option MUST be used to do this?

   • Aencoding
   • Bescape
   • Cfile_extension
   • Dsingle

   Show answer

   Answer: C

   Explanation

   D If the SINGLE copy option is TRUE, then the COPY command unloads a file without a file extension by default. To specify a file extension, provide a file name and extension in the internal_location or external_location path (e.g. copy into @stage/data.csv). https://docs.snowflake.com/en/sql-reference/sql/create-file-format

   Source: Adapted from community discussion — Marcusbraga

   References

   • Snowflake documentation

   Next question

4. Question 974 · 1323 in bank

   Which account usage view in Snowflake can be used to identify the most-frequently accessed tables?

   • AAccess_History
   • BObject_Dependencies
   • CTable_Storage_Metrics
   • DTables

   Show answer

   Answer: A

   Explanation

   The "Access_History" view in Snowflake can be used to identify the most frequently accessed tables. This view contains information about the historical access patterns for tables and views in your Snowflake account, including details on queries, users, and access frequency. By querying this view, you can analyze which tables are being accessed most frequently in your Snowflake environment.

   Source: Adapted from community discussion — JG1984

   Next question

5. Question 975 · 1323 in bank

   Select 2

   What metadata does Snowflake store concerning all rows stored in a micro-partition? (Choose two.)

   • AA count of the number of total values in the micro-partition
   • BThe range of values for each partition in the micro-partition
   • CThe range of values for each of the rows in the micro-partition
   • DThe range of values for each of the columns in the micro-partition
   • EThe number of distinct values for each column in the micro-partition

   Show answer

   Answer: DE

   Explanation

   DE, according to the doc https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions Snowflake stores metadata about all rows stored in a micro-partition, including: The range of values for each of the columns in the micro-partition. The number of distinct values. Additional properties used for both optimization and efficient query processing. AD according to my testing I ran the following queries. Only COUNT (DISTINCT) used the warehouse. Scanned only 1 partition. This contradicts the documentation> select min(cc_call_center_sk) from snowflake_sample_data.tpcds_sf100tcl.call_center; select max(cc_call_center_sk) from snowflake_sample_data.tpcds_sf100tcl.call_center; select count(distinct cc_call_center_sk) from snowflake_sample_data.tpcds_sf100tcl.call_center; select count(*) from snowflake_sample_data.tpcds_sf100tcl.call_center; Also see related Q157

   Source: Adapted from community discussion — 0e504b5

   References

   • Snowflake documentation

   Next question

6. Question 976 · 1323 in bank

   What role has the privileges to create and manage data shares by default?

   • AACCOUNTADMIN
   • BSECURITYADMIN
   • CSYSADMIN
   • DUSERADMIN

   Show answer

   Answer: A

   Next question

7. Question 977 · 1323 in bank

   Which function determines the kind of value stored in a VARIANT column?

   • ACHECK_JSON
   • BIS_ARRAY
   • CIS_JSON
   • DTYPEOF

   Show answer

   Answer: D

   References

   • Snowflake documentation

   Next question

8. Question 978 · 1323 in bank

   What operation can be performed using Time Travel?

   • ARestoring tables that have been dropped from a data share
   • BExtending a permanent table’s retention duration from 90 to 100 days
   • CCreating a clone of an entire table at a specific point in the past from a permanent table
   • DDisabling Time Travel for a specific object by setting DATA_RETENTION_TIME_IN_DAYS to NULL

   Show answer

   Answer: C

   References

   • Snowflake documentation

   Next question

9. Question 979 · 1323 in bank

   Select 2

   What are characteristics of Snowflake directory fables? (Choose two.)

   • ADirectory tables are separate database objects.
   • BDirectory tables can only be used with an external stage.
   • CDirectory tables contain copies of staged files in binary format.
   • DDirectory tables store file-level metadata about the data files in a stage.
   • EA directory table can be added to a stage when the stage is created, or later.

   Show answer

   Answer: DE

   Explanation

   A. Directory tables are separate database objects. —> No, they are not the separate objects B. Directory tables can only be used with an external stage. —> No, it supports both internal and external stages C. Directory tables contain copies of staged files in binary format. -> No, it stores file URLs D. Directory tables store file-level metadata about the data files in a stage. -> Yes E. A directory table can be added to a stage when the stage is created, or later. -> Yes https://docs.snowflake.com/en/user-guide/data-load-dirtables#Both%20%external

   Source: Adapted from community discussion — Shipra123

   References

   • Snowflake documentation

   Next question

10. Question 980 · 1323 in bank

    What does the VARIANT data type impose a 16 MB size limit on?

    • AAll rows
    • BAll columns
    • CIndividual rows
    • DIndividual columns

    Show answer

    Answer: C

    References

    • Snowflake documentation

    Next question

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

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