Question 11

Which types of subqueries does Snowflake support? (Select TWO).
  • Question 12

    Which table function should be used to view details on a Directed Acyclic Graphic (DAG) run that is presently scheduled or is executing?
  • Question 13

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

    A virtual warehouse is created using the following command:
    Create warehouse my_WH with
    warehouse_size = MEDIUM
    min_cluster_count = 1
    max_cluster_count = 1
    auto_suspend = 60
    auto_resume = true;
    The image below is a graphical representation of the warehouse utilization across two days.

    What action should be taken to address this situation?
  • Question 15

    Using variables in Snowflake is denoted by using which SQL character?