Here you can find all the free questions related with Snowflake SnowPro Advanced: Administrator Certification (ADA-C01) exam. You can also find on this page links to recently updated premium files with which you can practice for actual Snowflake SnowPro Advanced: Administrator Certification Exam. These premium versions are provided as ADA-C01 exam practice tests, both as desktop software and browser based application, you can use whatever suits your style. Feel free to try the SnowPro Advanced: Administrator Certification Exam premium files for free, Good luck with your Snowflake SnowPro Advanced: Administrator Certification Exam.
Question No: 1
MultipleChoice
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
Database
Options
Answer C, EExplanation
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.