You're developing a Snowpark Container Services application. Your 'service.yaml' file defines a service named 'data_processor'. You want to create a service endpoint, 'ingest_endpoint' , that is secured and accessible only by authorized consumers of your Snowflake Native Application. Select the TWO SQL statements that, when used together, will correctly create and bind the service endpoint, ensuring proper OAuth authentication and authorization.

• A. BIND SERVICE ENDPOINT ingest_endpoint FOR SERVICE data_processor WITH AUTHENTICATION TYPE = OAUTH TO APPLICATION PACKAGE;
• B. CREATE SERVICE ENDPOINT ingest_endpoint FOR SERVICE data_processor WITH AUTHENTICATION TYPE = OAUTH;
• C. BIND SERVICE ENDPOINT ingest_endpoint FOR SERVICE data_processor WITH AUTHENTICATION TYPE = NONE TO APPLICATION PACKAGE;
• D. ALTER SERVICE data_processor ADD ENDPOINT ingest_endpoint WITH AUTHENTICATION TYPE = OAUTH;
• E. CREATE OR REPLACE SERVICE ENDPOINT ingest_endpoint FOR SERVICE data_processor WITH AUTHENTICATION TYPE = SNOWFLAKE_JWT;

You are the developer of a Snowflake Native App, and you're designing a feature that allows consumer accounts to create custom reports based on data exposed by the application. These reports will be defined using SQL queries and stored as views within the consumer's account, referencing objects (tables, views) provided by the application. The application does NOT want to provide direct 'SELECT access on underlying application's tables. How can you enable this feature while adhering to best practices for security and access control within the Snowflake Native App Framework? (Select all that apply)

• A. Expose secure views within the application package. Consumer accounts can then create views in their account that reference these secure views.
• B. Create stored procedures that execute 'CREATE VIEW' statements in the consumer's account, controlled by parameters passed from the consumer, using EXECUTE AS OWNER.
• C. Implement a UDF that constructs and executes the user's SQL query against the application's data and returns the results.
• D. Utilize Data Sharing to share the underlying tables directly with the consumer account.
• E. Grant the 'SELECT privilege directly on the application's underlying tables to a role in the consumer account.

A developer is creating a Snowsight dashboard to monitor the performance of a Snowflake Native App. They want to display a real-time graph of the number of API calls made to the app per minute. The app logs each API call to a Snowflake table named 'APP LOGS' with a timestamp column named 'CALL TIMESTAMP'. Which of the following SQL queries, when used within a Snowsight chart, would MOST accurately achieve this?

• A.
  
• B.
  
• C.
  
• D.
  
• E.
  

You are managing a Snowflake Native Application that provides data enrichment services. Over time, you've accumulated several application package versions: v1 .0 (initial release), v1.1 (bug fixes), v2.0 (new features and schema changes), and v2.1 (performance improvements for v2.0). Some consumers are still using v1 .0, while others have upgraded to v2.1. You need to retire v1.0 to reduce maintenance overhead. Which of the following actions and considerations are MOST important when deprecating vl .0? Select TWO that apply.

• A. Identify consumers still using v1.0. Communicate the deprecation timeline and provide clear instructions on how to upgrade to a supported version. Offer support during the transition.
• B. Automatically migrate all consumers still using v1.0 to the latest version (v2.1 ) without their consent to simplify management.
• C. Update the application's metadata in the Snowflake Marketplace to indicate that v1.0 is no longer supported.
• D. Keep v1.0 indefinitely to ensure compatibility with all existing application instances, regardless of usage.
• E. Immediately drop version v1.0 from the application package to free up storage space.