Question 1

Snowflake data providers can share data with data consumers in a different region?

Options :

A : FALSE

B : TRUE

Answer: B

Question 2

As an Administrator, you are looking out for information which can help to determine whether the organizationâ€™s active user population which should be provisioned into Snowflake matches the users provisioned into Snowflake. Which Information schema table function can help you to provide this auditing?

Options :

A : REST_EVENT_HISTORY

B : EVENT_HISTORY

C : SCIM_API_EVENT_HISTORY

D : REST_API_EVENT_HISTORY

Answer: A

Question 3

Which one is not the Usage schema contained by SNOWFLAKE database?

Options :

A : ORGANIZATION_USAGE

B : READER_ACCOUNT_USAGE

C : DATA_SHARING_USAGE

D : CONSUMER_ACCOUNT_USAGE

E : ACCOUNT_USAGE

Answer: D

Question 4

Which command is useful to simplifying grant management i.e. as new objects are created, the defined privileges are automatically granted to a role?

Options :

A : GRANT ON

B : ON FUTURE

C : ON REVOKE

D : IN PAST

Answer: B

Question 5

When a role is dropped, which role inherits ownership of objects owned by the dropped role?

Options :

A : The SYSADMIN role

B : The role above the dropped role in the RBAC hierarchy

C : The role executing the command

D : The SECURITYADMIN role

Answer: B

Free ADA-C01 Mock Exam – Practice Online Confidently

Buying Options: