nerdexam
Snowflake

DEA-C02 · Question #67

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

Sign in or unlock DEA-C02 to reveal the answer and full explanation for question #67. The question stem and answer options stay visible for context.

Data Movement

Question

Which of the following grants are required for the role running the kafka_load_role_1 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 in kafka_schema database kafka_db, the target for data loading.)

Options

  • Agrant create pipe on schema kafka_schema to role kafka_load_role_1;
  • Bgrant create stream on schema kafka_schema to role kafka_load_role_1;
  • Dgrant create table on schema kafka_schema to role kafka_load_role_1;
  • Egrant create task on schema kafka_schema to role kafka_load_role_1;

Unlock DEA-C02 to see the answer

You've previewed enough free DEA-C02 questions. Unlock DEA-C02 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.

Topics

#Snowflake Connector for Kafka#Data Loading#Snowpipe#Access Control
Full DEA-C02 Practice