You are developing a Snowflake Native Application intended for the Snowflake Marketplace. The application provides data transformation services, leveraging external functions (UDFs) that invoke a REST API hosted on AWS Lambd a. You need to ensure the secure and compliant invocation of this external API from your application while adhering to Snowflake's best practices. Which of the following steps represent the MOST secure and recommended approach for configuring and invoking the external function?
Correct Answer: C
The MOST secure and recommended approach (Option C) involves creating an API integration object in Snowflake with secure authentication (IAM roles or OAuth 2.0), defining the external function to use the integration, and leveraging network policies and secrets for enhanced security. This aligns with Snowflake's security best practices. Option A is less secure as it stores the API key directly in the integration. Option B is completely insecure. Option D poses a security risk storing credentials within a table. Option E involves blanket outbound access and storing the API key directly in the UDF (bad).