Valid SOL-C01 Dumps shared by ExamDiscuss.com for Helping Passing SOL-C01 Exam! ExamDiscuss.com now offer the newest SOL-C01 exam dumps, the ExamDiscuss.com SOL-C01 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com SOL-C01 dumps with Test Engine here:
A data engineer needs to load data into a Snowflake table 'SALES DATA'. They want to grant a specific role, 'LOADER ROLE', the minimum necessary privileges to load data from an internal stage named 'RAW DATA STAGE into the 'SALES DATA' table, which resides in the 'SALES SCHEMA' schema of the 'ANALYTICS DB' database. Which set of SQL commands achieves this with the principle of least privilege?
Correct Answer: C
Option C provides the minimum required privileges. `USAGE on the database and schema allows the role to access objects within them. `INSERT' on the table allows data loading. `READ on the stage allows reading files from the stage. `SELECT' is not required for loading data. `WRITE on the stage is not needed as the role only needs to read. 'EXECUTE TASK is for tasks not data loading