Snowflake NAS-C01 : SnowPro Specialty - Native Apps

You are developing a Snowflake Native App that uses JavaScript stored procedures. During consumer testing, you observe inconsistent behavior: sometimes the app works perfectly, other times it throws intermittent 'JavaScript out of memory' errors. You suspect a memory leak in your JavaScript code. Which of the following actions could help you diagnose and resolve this issue effectively?

• A. Use the 'INFORMATION SCHEMA.QUERY HISTORY view on the consumer account to examine the query profiles of the JavaScript stored procedures, looking for excessive memory consumption or spillover to local storage.
• B. Refactor your JavaScript code to minimize the creation of large, temporary objects and ensure that objects are properly garbage collected by setting unused object references to 'null'.
• C. Enable detailed logging within your JavaScript stored procedures using 'CALL SYSTEM$LOG(...)'})$ and analyze the logs for excessively large data structures or recursive function calls.
• D. Contact Snowflake support immediately, as 'JavaScript out of memory' errors always indicate a platform bug.
• E. Increase the warehouse size for the consumer's instance where the app is installed, assuming larger warehouses always provide more memory for JavaScript execution.

A data engineer, Alice, is developing a Snowflake Native Application. She wants to implement event sharing to notify consumers when certain data thresholds are breached within the application's managed tables. What is the MOST effective and secure approach for implementing this event sharing mechanism, ensuring that consumers can subscribe to these events without direct access to the application's internal tables?

• A. Use Snowflake Streams and Tasks within the provider account to continuously monitor the managed tables and create events that are pushed to a shared data lake. Consumers then access the data lake.
• B. Create a series of external functions that are called when the application's data changes. These functions will call an external notification service that alerts consumers.
• C. Grant SELECT privileges on the managed tables directly to consumer accounts, using secure views to filter data.
• D. Implement a Python UDF that queries the managed tables and sends email notifications to consumers whenever a threshold is breached.
• E. Leverage Snowflake's event tables (using EVENT TABLES) to capture significant data changes, then create an API function using 'CREATE FUNCTION' with 'RETURNS TABLE' in the application package to expose these events to consumers through a secure share. Implement RBAC within the API function to manage access.

A Native App provider wants to implement comprehensive monitoring of their application's behavior within consumer accounts. They decide to use Event Tables to capture various application events. Which of the following strategies is the MOST appropriate for designing and managing Event Tables for this purpose? Select ALL that apply.

• A. Create a single, generic Event Table with a VARIANT column for event-specific data to accommodate all event types.
• B. Create separate Event Tables for each distinct event type, with columns tailored to the specific data associated with each event.
• C. Use a centralized Event Table that is shared across all consumer accounts to simplify data aggregation and analysis.
• D. Implement a data retention policy to automatically purge older events from the Event Tables, minimizing storage costs and improving query performance.
• E. Utilize dynamic table creation based on the type of event being recorded, ensuring optimal storage and query performance for each event type. Dynamic table creation is managed programmatically.

You are using the Snowflake Visual Studio Code (VS Code) extension to develop a Snowflake Native App. After making several changes, you encounter an error that seems to stem from a syntax issue. You want to quickly pinpoint the exact location of the error in your SQL code. What functionality of the VS Code extension can best assist you in this scenario?

• A. The built-in linter that automatically identifies syntax errors, style issues, and potential security vulnerabilities in your SQL code.
• B. Using Version Control tool integration
• C. The extension's integrated debugger, which allows you to step through your SQL code line by line.
• D. The extension's integration with Snowflake's query profile tool, enabling you to analyze the query execution plan for errors.
• E. The syntax highlighting and code completion features, which help identify syntax errors and suggest valid code snippets.

You are packaging a Snowflake Native Application for distribution. You need to include a Python User-Defined Function (UDF) that reads data from a stage. Which of the following steps are REQUIRED to ensure the UDF functions correctly after installation in a consumer's account? (Choose two)

• A. Ensure the stage containing the Python file is explicitly referenced with 'OWNER' rights in the application manifest file.
• B. Grant the 'READ privilege on the stage to the schema in the provider account before building the application package.
• C. Explicitly grant 'USAGE privilege on the stage to each role within the application that will execute the UDF in the 'setup.sqr script.
• D. Include the Python code for the UDF inline within the 'CREATE FUNCTION' statement, instead of referencing an external stage.
• E. Grant on the stage and 'USAGE' on the database and schema containing the stage to the 'SNOWFLAKCORE.BUILTIN APP API' schema in the provider account before building the application package.