Question 141

Which of the following statements is true of Snowflake micro-partitioning?
  • Question 142

    A user wants to add additional privileges to the system-defined roles for their virtual warehouse. How does Snowflake recommend they accomplish this?
  • Question 143

    What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?
  • Question 144

    The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?
  • Question 145

    A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:
    1. Created a user called "CONSUMER"
    2. Created a database to hold the share and an extra-small warehouse to query the data
    3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share Based on this configuration what is true of the reader account?