COF-C02 Exam Question 11

True or False: Snowpipe via REST API can only reference External Stages as source.
  • COF-C02 Exam Question 12

    Which Snowflake layer is always leveraged when accessing a query from the result cache?
  • COF-C02 Exam Question 13

    A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes.
    The warehouse is currently suspended and the user performs the following actions:
    1. Runs a query that takes 3 minutes to complete
    2. Leaves for 15 minutes
    3. Returns and runs a query that takes 10 seconds to complete
    4. Manually suspends the warehouse as soon as the last query was completed When the user returns, how much billable compute time will have been consumed?
  • COF-C02 Exam Question 14

    Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.
    Which SQL command should be used to delete the files?
  • COF-C02 Exam Question 15

    True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.