Snowflake SnowPro Specialty - Native Apps Sample Questions:

1. You are developing a Snowflake Native App that requires specific Snowflake features and functionalities. To ensure compatibility and proper execution across different consumer environments, you need to define the minimum required Snowflake version. Which section in the manifest file is used to specify the minimum Snowflake version required by the application and what is the correct syntax?

A) The 'application' section. Syntax: '"application": {"min_snowflake_version": "7.0"}'
B) The 'api_version' section. Syntax: '"api_version": along with in the 'applications section.
C) The 'configuration' section. Syntax: '"configuration": {"required_snowflake_version": "7.0"}'
D) The 'setup' section. Syntax:

E) The 'dependencies' section. Syntax: '"dependencies": [{"snowflake_version":">=7.0"}]

2. You are designing a Snowflake Native Application that allows consumers to upload data files to a stage within their account, which your application then processes. To enhance security and data governance, you need to implement a callback function that validates the uploaded data before it is processed by your application. The callback function must verify the file format and size. Which of the following options correctly outlines the necessary steps and considerations for implementing this callback function?

A) Implement a stored procedure within the application package that receives the file path as input. Register this stored procedure as a callback using 'ALTER APPLICATION ... SET callback_procedure = ..:. The stored procedure performs the validation and raises an error if the file is invalid.
B) Set up an AWS Lambda function triggered by S3 events when files are uploaded to the consumer's stage. The Lambda function validates the file format and size and sends a message to a Snowflake queue, which your application then reads.
C) Define an event table in the provider account and configure a Snowflake Notification to trigger when a new file is uploaded to the consumer's stage. The notification invokes a remote service that validates the file and updates the event table.
D) Create an external function pointing to an API Gateway endpoint that performs the validation. The application logic calls this external function, passing the file path. The external function then returns a boolean indicating success or failure.
E) Create a UDF that resides within the consumer's account and is called using the 'CALL' command from the provider's application logic. The UDF validates the file properties and returns a boolean indicating success or failure.

3. A customer is attempting to install your Snowflake Native Application from the Snowflake Marketplace, but the installation fails. You need to troubleshoot the issue. Which of the following steps would provide the most direct and relevant information for diagnosing the cause of the installation failure?

A) Ask the customer to share their Snowflake account identifier to check internal logs.
B) Query the view in the consumers account to retrieve detailed information about the installation attempt, including error messages and status codes.
C) Check the Snowflake system status page for any reported outages or incidents that might be affecting the Marketplace.
D) Review the Snowflake Marketplace listing details to ensure all required components and dependencies are accurately specified.
E) Examine the application's code repository for any recent changes that might have introduced errors.

4. A data engineer, Alice, is developing a Snowflake Native Application that exposes a stored procedure, 'calculate_aggregate' , within the application schema 'app_schema'. She initially granted privilege on the application database to the 'analyst_role' and EXECUTE privilege on 'calculate_aggregate' to the same role. Later, due to a security audit, she needs to revoke the 'EXECUTE privilege from 'analyst_role' but wants to ensure users assigned to 'analyst_role' can still access other objects in the application database (but not execute this specific stored procedure). Which of the following actions achieves this goal MOST efficiently and securely?

A)

B)

C)

D)

E)

5. You are developing a Snowflake Native Application package and want to publish it. You have created the necessary setup script, version, and patch. However, you encounter an error during the 'ALTER APPLICATION PACKAGE' command. The error message indicates an issue with the setup script. Identify the most probable cause of this error and the solution.

A) All of the above.
B) The setup script uses unqualified object names (e.g., TABLEI instead of MY DATABASE.MY SCHEMA.TABLEI). Fully qualify all object names in the setup script.
C) The setup script attempts to create objects that already exist. Implement IF NOT EXISTS clauses in your CREATE statements to prevent errors.
D) The setup script lacks necessary privileges on the objects it attempts to create or modify. Grant appropriate privileges to the application package owner role.
E) The setup script contains syntax errors. Run the setup script manually in a Snowflake worksheet to identify and correct the errors before creating the application package version.

Solutions: