A company needs to ingest data from a Kafka topic into Snowflake. The data is in JSON format and needs to be loaded continuously. Which ingestion method is most appropriate?

Use the Snowflake Data Marketplace to ingest the data.

Use the COPY INTO command to load data from a stage that is populated by a separate process.

Use the Snowflake Kafka Connector to write data to an internal stage and then use Snowpipe to load it.

Use the PUT command to upload files from the Kafka consumer to an internal stage.

SnowflakeSnowPro Advanced — Data Scientist

Domain 2Objective 2

Ingest and Prepare Data in Snowflake SNOWPRO-ADVANCED-DATA-SCIENTIST Practice Questions (Page 5)

Part of the Data Pipelining domain, which makes up ~15% of our current practice bank.

23questions here

5free pages

9concepts

Questions 21–23

21foundation · easy
Which of the following file formats is NOT supported by Snowflake for loading data into tables?
Select an answer first
22application · medium
A company needs to ingest data from a Kafka topic into Snowflake. The data is in JSON format and needs to be loaded continuously. Which ingestion method is most appropriate?
Select an answer first
23foundation · easy
Which Snowflake data type is used to store semi-structured data like JSON?
Select an answer first

Finished these 3 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack to SNOWPRO-ADVANCED-DATA-SCIENTIST

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Snowflake. “SNOWPRO-ADVANCED-DATA-SCIENTIST” is a trademark of its owner, used for identification only.

Ingest and Prepare Data in Snowflake SNOWPRO-ADVANCED-DATA-SCIENTIST Practice Questions (Page 5)

Questions 21–23

Which of the following file formats is NOT supported by Snowflake for loading data into tables?

A company needs to ingest data from a Kafka topic into Snowflake. The data is in JSON format and needs to be loaded continuously. Which ingestion method is most appropriate?

Which Snowflake data type is used to store semi-structured data like JSON?

Keep studying — Data Pipelining