QuizizzSnowflake from dump base part 2

If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

• 4.0
• 8.0
• 16.0
• 32.0

A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?

• GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE:
• GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USERI;
• GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB. MYSCHEMA TO USER1;
• GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDE.MYSCHEMA TO MYROLE;

A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?

• Yes, because a table owner has full control and can unset masking policies.
• Yes, because masking policies only apply to cloned tables.
• No, because masking policies must always reference specific access roles.
• No, because ownership of a table does not include the ability to change masking policies

Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

• Custom
• Economy
• Economy
• Standard

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

• Verdadero
• falso

In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

• Compute Credits = 50 Credits Cloud Services = 10
• Compute Credits = 80 Credits Cloud Services = 5
• Compute Credits = 10 Credits Cloud Services = 9
• Compute Credits = 120 Credits Cloud Services = 10
• Compute Credits = 200 Credits Cloud Services = 26

When is the result set cache no longer available? (Select TWO)

• When another warehouse is used to execute the query
• When another user executes the query
• When the underlying data has changed
• When the warehouse used to execute the query is suspended
• When it has been 24 hours since the last query

True or False: Snowflake charges additional fees to Data providers for each share they create.

• Verdadero
• falso

Which data type can be used to store geospatial data in Snowflake?

• Variant
• Object
• Geometry
• Geography

True or False: A Virtual Warehouse consumes Snowflake credits even when inactive

• Verdadero
• falso