Which Snowflake objects can be defined with future grants? (Select TWO).

• A.Virtual warehouses
• B.Schemas
• C.External functions
• D.Masking policies
• E.Databases

Comment: *

Name: *

Email: *

Verification: *

Which Snowflake feature enables loading data from cloud storage as soon as files are available in a stage?

• A.C0PY_INT0 <location> command
• B.Data replication
• C.Snowpipe
• D.Direct share

Comment: *

Name: *

Email: *

Verification: *

A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days.
Which of the following statements will return the required information?
A)

B)

C)

D)

• A.Option D
• B.Option C
• C.Option A
• D.Option B

Comment: *

Name: *

Email: *

Verification: *

Which access control entity in Snowflake can be created as part of a hierarchy within an account?

• A.Securable object
• B.Role
• C.Privilege
• D.User

Comment: *

Name: *

Email: *

Verification: *

Which use case does the search optimization service support?

• A.Disjuncts (OR) in join predicates
• B.LIKE/ILIKE/RLIKE join predicates
• C.Join predicates on VARIANT columns
• D.Conjunctions (AND) of multiple equality predicates

Comment: *

Name: *

Email: *

Verification: *