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

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

What is a non-configurable feature that provides historical data that Snowflake may recover during a 7-day period?

• A.Time Travel
• B.Cloning
• C.Fail-safe
• D.Account replication

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.Customer-managed encryption keys through Tri-Secret Secure
• E.Object-level access control

Comment: *

Name: *

Email: *

Verification: *

Which privilege is required to use the search optimization service in Snowflake?

• A.GRANT ADD SEARCH OPTIMIZATION ON SCHEMA <schema_name> TO ROLE <role>
• B.GRANT ADD SEARCH OPTIMIZATION ON DATABASE <database name> TO ROLE <role>
• C.GRANT SEARCH OPTIMIZATION ON DATABASE <database_name> TO ROLE <role>
• D.GRANT SEARCH OPTIMIZATION ON SCHEMA <schema_name> TO ROLE <role>

Comment: *

Name: *

Email: *

Verification: *

What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

• A.Default Time Travel Retention is set to 0 days.
  Maximum Time Travel Retention is 90 days.
  Fail Safe retention time is 7 days.
• B.Default Time Travel Retention is set to 7 days.
  Maximum Time Travel Retention is 1 day.
  Fail Safe retention time is 90 days.
• C.Default Time Travel Retention is set to 90 days.
  Maximum Time Travel Retention is 7 days.
  Fail Safe retention time is 356 days.
• D.Default Time Travel Retention is set to 1 day.
  Maximum Time Travel Retention is 365 days.
  Fail Safe retention time is 7 days.
• E.Default Time Travel Retention is set to 1 day.
  Maximum Time Travel Retention is 90 days.
  Fail Safe retention time is 7 days.
• F.Default Time Travel Retention is set to 0 days.
  Maximum Time Travel Retention is 30 days.
  Fail Safe retention time is 1 day.

Comment: *

Name: *

Email: *

Verification: *