COF-C03 Question 47
Single answerApplicationsA company wants to make a third-party analytics solution available to its Snowflake users without requiring users to leave Snowflake or manage a separate sign-in. The security team also wants the application to run with Snowflake-native governance and be installable directly by consumers into their own Snowflake accounts. Which Snowflake feature best meets these requirements?
- A
Create a reader account for each consumer so they can access shared data and run the application logic there
- B
Publish the solution as a Snowflake Native App so consumers can install and run it inside their Snowflake accounts
- C
Expose the application through an external function so users can call the third-party service from SQL
- D
Package the application as a Java UDF and share it through a database role
Show answer and explanation
Correct answer: B
Explanation
The best answer is to publish the solution as a Snowflake Native App. For SnowPro Core, candidates should understand at a high level that Snowflake applications can be distributed and installed using Snowflake-native capabilities rather than requiring separate platforms or credentials. The Snowflake Native App Framework is intended for application providers who want consumers to install an app directly into their Snowflake accounts. This approach is more appropriate than reader accounts, which focus on data sharing access for non-Snowflake customers, or external functions, which integrate remote services but do not package a native app. Likewise, UDFs are executable code objects, not a full application distribution framework. This aligns with Snowflake best practices for application distribution and in-account consumption.
- A. Incorrect.
Incorrect. Reader accounts let a provider give data access to consumers who do not have their own Snowflake account, but they are not the primary mechanism for distributing installable applications into customer-owned Snowflake accounts. Reader accounts also do not address the requirement to package and distribute a full application experience for direct installation by consumers.
- B. Correct.
Correct. Snowflake Native App Framework is designed for providers to package and distribute applications that consumers install directly in their own Snowflake accounts. This supports a Snowflake-native experience, avoids separate sign-in patterns for using the app inside Snowflake, and aligns with governance and security controls available in Snowflake.
- C. Incorrect.
Incorrect. External functions are used to call externally hosted services from Snowflake, typically through API integration and a remote service layer. While useful for integrating external logic, they do not by themselves provide a distributable, installable application running natively in the consumer's Snowflake account.
- D. Incorrect.
Incorrect. Java UDFs can encapsulate code for execution in Snowflake, but a UDF is not a complete application packaging and distribution model. Sharing a Java UDF through roles does not satisfy the requirement for a consumer-installable application with an application experience and lifecycle managed as a Snowflake app.