Snowflake
COF-R02 · Question #326
COF-R02 Question #326: Real Exam Question with Answer & Explanation
Sign in or unlock COF-R02 to reveal the answer and full explanation for question #326. The question stem and answer options stay visible for context.
Question
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.)
Options
- Agrant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;
- Bgrant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;
- Cgrant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;
- Dgrant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;
- Egrant SELECT on all tables in database DB1 to role MYROLE;
- Fgrant SELECT on future tables in database DB1 to role MYROLE;
Unlock COF-R02 to see the answer
You've previewed enough free COF-R02 questions. Unlock COF-R02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.