SnowPro Advanced: Data Engineer — Question 78

Which of the following grants are required for the role kafka_load_role_1 running the Snowflake Connector for Kafka, with the intent of loading data to Snowflake? (Choose three.)

(Assume this role already exists and has usage access to the schema kafka_schema in database kafka_db, the target for data loading.)

Answer options

• A. grant create pipe on schema kafka_schema to role kafka_load_role_1;
• B. grant create stream on schema kafka_schema to role kafka_load_role_1;
• C. grant create stage on schema kafka_schema to role kafka_load_role_1;
• D. grant create table on schema kafka_schema to role kafka_load_role_1;
• E. grant create task on schema kafka_schema to role kafka_load_role_1;
• F. grant create external table on schema kafka_schema to role kafka_load_role_1;

Correct answer: A, C, D

Explanation

The correct grants are needed to enable the loading of data into Snowflake. Granting 'create pipe' allows data to be ingested from Kafka, 'create stage' is necessary for staging the data, and 'create table' is required to write the data into a table. The other options do not directly facilitate the loading process for the intended role.