SnowPro Core Certification — Question 339

Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)

Answer options

• A. grant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;
• B. grant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;
• C. grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;
• D. grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;
• E. grant SELECT on all tables in database DB1 to role MYROLE;
• F. grant SELECT on future tables in database DB1 to role MYROLE;

Correct answer: C, D

Explanation

The correct answers are C and D because granting SELECT on all tables allows access to current tables, while granting SELECT on future tables ensures access to any new tables created later in the schema. Options A and B do not grant SELECT privileges, and options E and F pertain to the database level, not the schema level.