When loading data into Snowflake using Snowsight, what functionalities does this method offer? (Select all that apply)

Question

Options

• AStreamlined data import from external/internal stages
• BBatch data loading
• CReal-time data loading
• DSupport for only structured data formats

• A
  89% (31)
• C
  6% (2)
• D
  6% (2)

Explanation

Loading data via Snowsight (Snowflake's web UI) supports streamlined imports from both internal and external stages (A), making it easy to browse and load staged files without writing SQL, and it operates as a batch loading mechanism (B), processing files in bulk rather than continuously. Option C is incorrect because Snowsight data loading is not real-time - continuous/streaming ingestion requires tools like Snowpipe or Kafka connectors. Option D is wrong because Snowsight supports multiple formats including semi-structured data like JSON, Parquet, and Avro, not just structured formats like CSV.

Memory tip: Think of Snowsight as a "point-and-click batch loader" - it simplifies staged file imports through a GUI, but it's not a streaming tool and it's format-flexible. If the question involves real-time or structured-only, those are red flags for Snowsight.

No community discussion yet for this question.