There are two databases in an account, named fin_db and hr_db which contain payroll and employee data, respectively. Accountants and Analysts in the company require different permissions on the objects in these databases to perform their jobs. Accountants need read-write access to fin_db but only require read-only access to hr_db because the database is maintained by human resources personnel. An Architect needs to create a read-only role for certain employees working in the human resources department. Which permission sets must be granted to this role?
Correct Answer: A
Explanation * To create a read-only role for certain employees working in the human resources department, the role needs to have the following permissions on the hr_db database: * USAGE on the database: This allows the role to access the database and see its schemas and objects. * USAGE on all schemas in the database: This allows the role to access the schemas and see their objects. * SELECT on all tables in the database: This allows the role to query the data in the tables. * Option A is the correct answer because it grants the minimum permissions required for a read-only role on the hr_db database. * Option B is incorrect because SELECT on schemas is not a valid permission. Schemas only support USAGE and CREATE permissions. * Option C is incorrect because MODIFY on the database is not a valid permission. Databases only support USAGE, CREATE, MONITOR, and OWNERSHIP permissions. Moreover, USAGE on tables is not sufficient for querying the data. Tables support SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, and OWNERSHIP permissions. * Option D is incorrect because REFERENCES on tables is not relevant for querying the data. REFERENCES permission allows the role to create foreign key constraints on the tables. References: * : https://docs.snowflake.com/en/user-guide/security-access-control-privileges.html#database-privileges * : https://docs.snowflake.com/en/user-guide/security-access-control-privileges.html#schema-privileges * : https://docs.snowflake.com/en/user-guide/security-access-control-privileges.html#table-privileges
Question 177
Following objects can be cloned in snowflake
Correct Answer: A,B,D
* Snowflake supports cloning of various objects, such as databases, schemas, tables, stages, file formats, sequences, streams, tasks, and roles. Cloning creates a copy of an existing object in the system without copying the data or metadata. Cloning is also known as zero-copy cloning1. * Among the objects listed in the question, the following ones can be cloned in Snowflake: * Permanent table: A permanent table is a type of table that has a Fail-safe period and a Time Travel retention period of up to 90 days. A permanent table can be cloned using the CREATE TABLE ... CLONE command2. Therefore, option A is correct. * Transient table: A transient table is a type of table that does not have a Fail-safe period and can have a Time Travel retention period of either 0 or 1 day. A transient table can also be cloned using the CREATE TABLE ... CLONE command2. Therefore, option B is correct. * External table: An external table is a type of table that references data files stored in an external location, such as Amazon S3, Google Cloud Storage, or Microsoft Azure Blob Storage. An external table can be cloned using the CREATE EXTERNAL TABLE ... CLONE command3. Therefore, option D is correct. * The following objects listed in the question cannot be cloned in Snowflake: * Temporary table: A temporary table is a type of table that is automatically dropped when the session ends or the current user logs out. Temporary tables do not support cloning4. Therefore, option C is incorrect. * Internal stage: An internal stage is a type of stage that is managed by Snowflake and stores files in Snowflake's internal cloud storage. Internal stages do not support cloning5. Therefore, option E is * incorrect. References: : Cloning Considerations : CREATE TABLE ... CLONE : CREATE EXTERNAL TABLE ... CLONE : Temporary Tables : Internal Stages
Newest ARA-C01 Exam PDF Dumps shared by BraindumpsPass.com for Helping Passing ARA-C01 Exam! BraindumpsPass.com now offer the updated ARA-C01 exam dumps, the BraindumpsPass.com ARA-C01 exam questions have been updated and answers have been corrected get the latest BraindumpsPass.com ARA-C01 pdf dumps with Exam Engine here:
