True or False: A Virtual Warehouse can be resized while suspended.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

• A.Column-level security to apply data masking policies to tables and views
• B.Up to 90 days of data recovery through Time Travel
• C.Automatic encryption of all data
• D.Object-level access control
• E.Customer-managed encryption keys through Tri-Secret Secure

Comment: *

Name: *

Email: *

Verification: *

Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)

• A.SHOW TABLES;
• B.Information Schema -> TABLE_FUNCTION
• C.Information Schema -> TABLE_HISTORY
• D.SHOW STORAGE BY TABLE;
• E.Information Schema -> TABLE_STORAGE_METRICS

Comment: *

Name: *

Email: *

Verification: *

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

• A.GRANT ROLE MYROLE TO USER USER1;
  CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;
• B.GRANT ROLE MYROLE TO USER USER1;
  CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;
• C.GRANT ROLE MYROLE TO USER USER1;
  CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;
• D.GRANT ROLE MYROLE TO USER USER1;
  CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

Comment: *

Name: *

Email: *

Verification: *

Which security models are used in Snowflake to manage access control? (Select TWO).

• A.Discretionary Access Control (DAC)
• B.Identity Access Management (1AM)
• C.Mandatory Access Control (MAC)
• D.Role-Based Access Control (RBAC)
• E.Security Assertion Markup Language (SAML)

Comment: *

Name: *

Email: *

Verification: *