DEA-C02 Exam Dumps | You're tasked with building an external function in Snowflake that calls an API to enrich customer data

<< Prev Question Next Question >>

Question 113/149

You're tasked with building an external function in Snowflake that calls an API to enrich customer data with geographical information (latitude and longitude) based on their IP address. The API endpoint requires an API key passed in the headen Your external function definition looks like this: "'sql CREATE OR REPLACE EXTERNAL FUNCTION VARCHAR) RETURNS VARIANT VOLATILE MAX BATCH ROWS = 100 RETURNS NULL ON NULL INPUT API INTEGRATION = AS 'https://api.example.com/geo'; Which of the following steps are essential to ensure the external function correctly passes the API key to the external service, handles rate limiting from the API, and correctly parses the JSON response from the external service (Assume the API returns a JSON object with 'latitude' and 'longitude' fields)?

A. Create a Snowflake API integration object that includes the 'ALLOWED_HOSTS parameter pointing to 'https://api.example.com', and configure the service to return retry-after header on rate limit and ensure retryPolicy is set to 3 retries.

B. Modify the external function code within the external service (e.g., AWS Lambda or Azure Function) to read the API key from an environment variable, construct the appropriate request headers (including the API key), implement exponential backoff with jitter for handling rate limits based on retry-after header if received, and ensure proper error handling for JSON parsing failures and return Snowflake compatible results.

C. Ensure the Snowflake user executing the function has the 'USAGE' privilege on the API integration object.

D. Modify the 'enrich_ip' function to directly embed the API key within the API endpoint URL as a query parameter.

E. Implement robust logging within the external service (e.g., AWS Lambda or Azure Function) to capture details of requests, responses, and any errors encountered. Monitor these logs regularly to identify and address potential issues.

Question 113/149

LEAVE A REPLY

Download PDF File