Free COF-R02 – SnowPro Core Recertification Exam Practice Test Question

Free demo downloads

Loading demo links...

Showing 1–3 of 15 questions

Question 1 (Exam pool B)

Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)

Select all that apply, then click Submit answer.

  • ○

    SCIM

  • ○

    Federated authentication

  • ○

    TLS 1.2

  • ○

    Key-pair authentication

  • ○

    OAuth

  • ○

    OCSP authentication

Question 2 (Exam pool B)

The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

Select all that apply, then click Submit answer.

  • ○

    Users

  • ○

    Tables

  • ○

    Databases

  • ○

    Internal Stages

Question 3 (Exam pool B)

What happens when an external or an internal stage is dropped? (Select TWO).

Select all that apply, then click Submit answer.

  • ○

    When dropping an external stage, the files are not removed and only the stage is dropped

  • ○

    When dropping an external stage, both the stage and the files within the stage are removed

  • ○

    When dropping an internal stage, the files are deleted with the stage and the files are recoverable

  • ○

    When dropping an internal stage, the files are deleted with the stage and the files are not recoverable

  • ○

    When dropping an internal stage, only selected files are deleted with the stage and are not recoverable