Question 116

A user needs access to create materialized view on a shema mydb.myschema.
What is the appropriate command to provide the access?
  • Question 117

    You are a snowflake architect in an organization. The business team came to to deploy an use case which requires you to load some data which they can visualize through tableau. Everyday new data comes in and the old data is no longer required.
    What type of table you will use in this case to optimize cost
  • Question 118

    What built-in Snowflake features make use of the change tracking metadata for a table? (Choose two.)
  • Question 119

    Snowflake includes administration settings for resource consumption in order to
  • Question 120

    A new user user_01 is created within Snowflake. The following two commands are executed:
    Command 1-> show grants to user user_01;
    Command 2 ~> show grants on user user 01;
    What inferences can be made about these commands?