COF-C02 practice questions 211–220

1. Question 211 · 1323 in bank

   Select 2

   Which database objects can be shared with Secure Data Sharing? (Choose two.)

   • AViews
   • BMaterialized views
   • CExternal stages
   • DExternal tables
   • EDynamic tables

   Show answer

   Answer: DE

   Explanation

   https://docs.snowflake.com/en/user-guide/data-sharing-intro Secure Data Sharing lets you share selected objects in a database in your account with other Snowflake accounts. You can share the following Snowflake objects: Databases Tables Dynamic tables External tables Apache Iceberg™ tables Secure views Secure materialized views Secure user-defined functions (UDFs) Models without code (such as CORTEX_FINETUNED)

   Source: Adapted from community discussion — rranjanssr

   References

   • Snowflake documentation

   Next question

2. Question 212 · 1323 in bank

   When a transient table in Snowflake is dropped, what happens to the table?

   • AThe table is no longer available for use.
   • BThe table can be undropped using Fail-safe.
   • CThe table can be recovered for 1 day only and after that it is no longer available.
   • DThe table can be recovered only with the assistance of Snowflake Support.

   Show answer

   Answer: C

   Explanation

   Time Travel for Temporary and Transient tables is 0 or 1. Hence, even if the tables itself is no longer available for being used, it is possible to use it for 1 more day, if the Time Travel was set to 1. Hence, I vote C.

   Source: Adapted from community discussion — 37ceea2

   Next question

3. Question 213 · 1323 in bank

   A data provider needs to securely collaborate with data consumers who do not reside in the same region. What Snowflake sharing mechanism should be used?

   • ADirect share
   • BData Exchange
   • CData replication
   • DListing

   Show answer

   Answer: D

   Next question

4. Question 214 · 1323 in bank

   What is the default File Format used in the COPY command if one is not specified?

   • ACSV
   • BJSON
   • CParquet
   • DXML

   Show answer

   Answer: A

   Next question

5. Question 215 · 1323 in bank

   A user needs to know the maximum value of a date field in a table, and runs the following query: select max(o_orderdate) from ORDERS; Which part of Snowflake architecture will this query use?

   • ADatabase Storage
   • BQuery Processing
   • CCloud Services
   • DCompute

   Show answer

   Answer: C

   Explanation

   First of all, Compute does not exist. Second, the way the question is addressed can take us to the thought of Metadata Cache. Metadata Cache, stores statistics and Metadata about Objects, such as Max/Min values for a column. Hence, I reply C. Metadata Cache is stored on Cloud Services, based on what I found in the courses.

   Source: Adapted from community discussion — 37ceea2

   Next question

6. Question 216 · 1323 in bank

   When cloning a schema, which Snowflake object will not be included in the clone?

   • AAn external stage
   • BA named internal stage
   • CA task
   • DA User-Defined Function (UDF)

   Show answer

   Answer: B

   Next question

7. Question 217 · 1323 in bank

   Which command will change the name of shared database role r1 to r4?

   • AALTER ROLE d1.r1 RENAME TO d1.r4;
   • BALTER ROLE d1.r1 RENAME TO d2.r4;
   • CALTER DATABASE ROLE d1.r1 RENAME TO d2.r4;
   • DALTER DATABASE ROLE d1.r1 RENAME TO d1.r4;

   Show answer

   Answer: D

   References

   • Snowflake documentation

   Next question

8. Question 218 · 1323 in bank

   What does the Remote Disk I/O statistic in the Query Profile indicate?

   • ATime spent reading from the result cache.
   • BTime spent reading from the virtual warehouse cache.
   • CTime when the query processing was blocked by remote disk access.
   • DThe level of network activity between the Cloud Services layer and the virtual warehouse.

   Show answer

   Answer: C

   Explanation

   Remote Disk I/O = TIME SPENT reading and writing data from and to remote storage, when data are being accessed, does not fit into either Virtual Warehouse memory or the Local Disk. But reading and writing does not look like being blocked by remote disk access. Difficult to reply. I am selecting an answer, just for being able to post.

   Source: Adapted from community discussion — 37ceea2

   Next question

9. Question 219 · 1323 in bank

   Which role has the privileges to describe a share?

   • AORGADMIN
   • BSECURITYADMIN
   • CSYSADMIN
   • DACCOUNTADMIN

   Show answer

   Answer: D

   Explanation

   https://docs.snowflake.com/en/sql-reference/sql/desc-share Only the ACCOUNTADMIN role has the privileges to describe a share. Executing this command with any role other than ACCOUNTADMIN returns an error. To post-process the output of this command, you can use the RESULT_SCAN function, which treats the output as a table that can be queried. The ANSWER is D

   Source: Adapted from community discussion — 37ceea2

   References

   • Snowflake documentation

   Next question

10. Question 220 · 1323 in bank

    This command is executed: CREATE TABLE new_table CLONE existing_table COPY GRANT; What will happen to the privileges of any cloned objects?

    • AThe clone will only inherit SELECT privileges from the source object.
    • BThe clone will inherit all privileges, including OWNERSHIP, from the source object.
    • CThe clone will inherit all privileges except OWNERSHIP from the source object.
    • DThe clone will not inherit any privileges from the source object.

    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 211. 1323 questions available.