Exam DSA-C03 Topic 1 Question 209 Discussion

Actual exam question for Snowflake's DSA-C03 exam
Question #: 209
Topic #: 1

You are developing a Python stored procedure in Snowflake to predict sales for a retail company. You want to incorporate external data (e.g., weather forecasts) into your model. Which of the following methods are valid and efficient ways to access and use external data within your Snowflake Python stored procedure?

A. Directly call external APIs within the Python stored procedure using libraries like 'requests'. Snowflake's network policy must be configured to allow outbound connections. B. Load the external data into a Snowflake table and then query the table from within the Python stored procedure using the Snowflake Connector for Pythom C. Use a Snowflake external function to pre-process the external data and then pass the processed data as input parameters to the Python stored procedure. D. Embed the external data directly into the Python stored procedure's code as a dictionary or JSON object. E. Use a Snowflake Pipe to continuously ingest external data from a cloud storage location and access the data within the stored procedure.

Suggested Answer: A,B,C,E Vote an answer

Options A, B, C and E are all valid methods. Calling external APIs (A) requires network policy configuration. Loading data into tables (B) is a standard approach. Using external functions (C) allows pre-processing. Option D is highly impractical for large or frequently updated datasets. Snowflake Pipes (E) are an effective way to continually ingest external data into Snowflake.

by Amelia at Aug 18, 2026, 10:19 PM

Limited Time Offer

15%

Off

Get Premium DSA-C03 Questions as Interactive Self Test Engine or PDF

Comments

0 Happy Clients

0 Shares

0 Demo Downloads

10 Years in Business