ARA-C01 · Question #56
An Architect is integrating an application that needs to read and write data to Snowflake without installing any additional software on the application server. How can this requirement be met?
The correct answer is C. Use the Snowflake SQL REST API. The requirement is software-free read and write access from an application server. The Snowflake SQL REST API is an HTTP-based interface that accepts SQL statements over standard HTTPS requests and returns results as JSON - no drivers, connectors, or installed software are…
Question
An Architect is integrating an application that needs to read and write data to Snowflake without installing any additional software on the application server. How can this requirement be met?
Options
- AUse SnowSQL.
- BUse the Snowpipe REST API.
- CUse the Snowflake SQL REST API.
- DUse the Snowflake ODBC driver.
How the community answered
(24 responses)- A4% (1)
- C92% (22)
- D4% (1)
Explanation
The requirement is software-free read and write access from an application server. The Snowflake SQL REST API is an HTTP-based interface that accepts SQL statements over standard HTTPS requests and returns results as JSON - no drivers, connectors, or installed software are required on the application server. Any language or platform capable of making HTTP requests can use it. Option A (SnowSQL) is a CLI tool that must be installed. Option B (Snowpipe REST API) is a streaming data ingestion interface - it supports loading data into Snowflake but is not a general-purpose read/write interface. Option D (ODBC driver) requires installation and configuration of a driver on the application server.
Topics
Community Discussion
No community discussion yet for this question.