SnowPro Advanced: Data Engineer — Question 46

While running an external function, the following error message is received:
Error: Function received the wrong number of rows
What is causing this to occur?

Answer options

• A. External functions do not support multiple rows.
• B. Nested arrays are not supported in the JSON response.
• C. The JSON returned by the remote service is not constructed correctly.
• D. The return message did not produce the same number of rows that it received.

Correct answer: D

Explanation

The correct answer is D because the error specifically indicates a mismatch between the number of rows returned and the number of rows expected. Option A is incorrect as external functions can handle multiple rows, while B and C address issues unrelated to the row count error.