SOL-C01 Question #85: Real Exam Question with Answer & Explanation

Question

A data engineer needs to grant SELECT privileges on all tables within a newly created schema named 'SALES DATA' to a role called 'ANALYST ROLE'. However, new tables may be added to this schema in the future. What is the most efficient and secure way to achieve this, ensuring that future tables automatically inherit the necessary permissions?

Options

• AGrant SELECT privilege to `ANALYST ROLE directly on each table using `GRANT SELECT ON
• BGrant the USAGE privilege on the database containing the schema and SELECT privilege on
• CCreate a custom role that inherits from 'ANALYST ROLE and grant 'SELECT privilege on all tables
• DGrant 'SELECT privilege to the PUBLIC role on all tables within the 'SALES_DATX schema.
• EUse a stored procedure to automatically grant the SELECT privilege to 'ANALYST ROLE

Explanation

Using GRANT SELECT ON FUTURE TABLES' ensures that any new tables created in the schema automatically inherit the SELECT privilege for the specified role. Option A requires manual intervention for each new table. Options C and E are unnecessarily complex. Option D poses a security risk by granting privileges to the PUBLIC role.

No community discussion yet for this question.