ADA-C01 · Question #11
DatabaseA has a single schema called Schema1. This schema contains many tables and views. The ANALYST role has privileges to select from all objects in DatabaseA. Schema1. The SYSADMIN role clones…
The correct answer is C. SELECT on all tables, and only non-secure views in DatabaseA_clone. Schemal E. SELECT on all tables and views in DatabaseA_clone. Schema1. According to the Snowflake documentation, when a database or schema is cloned, the clone inherits all granted privileges on the clones of all child objects contained in the source object, such as tables and views. However, the clone of the container itself does not inherit the…
Question
DatabaseA has a single schema called Schema1. This schema contains many tables and views. The ANALYST role has privileges to select from all objects in DatabaseA. Schema1. The SYSADMIN role clones DatabaseA to DatabaseA_clone. What privileges does the ANALYST role have on tables and views in DatabaseA_clone? (Choose two.)
Options
- AUSAGE on the schema DatabaseA clone
- BUSAGE on the database DatabaseA_clone. Schemal
- CSELECT on all tables, and only non-secure views in DatabaseA_clone. Schemal
- DSELECT on all tables, and only secure views in DatabaseA_clone. Schemal
- ESELECT on all tables and views in DatabaseA_clone. Schema1
How the community answered
(27 responses)- A7% (2)
- B7% (2)
- C81% (22)
- D4% (1)
Explanation
According to the Snowflake documentation, when a database or schema is cloned, the clone inherits all granted privileges on the clones of all child objects contained in the source object, such as tables and views. However, the clone of the container itself does not inherit the privileges granted on the source container. Therefore, the ANALYST role will have SELECT privilege on all tables and views in DatabaseA_clone.Schema1, but not USAGE privilege on the database or schema. The type of view (secure or non-secure) does not affect the cloning of privileges.
Topics
Community Discussion
No community discussion yet for this question.