Try Snowflake : NAS-C01 valid & accurate questions and answers

A Snowflake Native App provider is troubleshooting an issue where consumer installations intermittently fail. The provider suspects that certain installation parameters are causing conflicts. The provider has implemented an event table to track installation attempts and errors. Which of the following SQL statements is the MOST effective way to identify the installation parameters that are most frequently associated with failed installations? Assume the event table is named "INSTALLATION EVENTS and contains columns 'INSTALLATION ID, 'STATUS' (success/failure), and PARAMETERS' (a VARIANT column storing a JSON object of installation parameters).

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

Your Snowflake Native Application provides a data transformation service. A consumer reports slow performance when processing large datasets. Profiling indicates that a specific SQL query within a UDF is the bottleneck. The query aggregates data from a table and uses a custom function to calculate a derived value. Assume the UDF runs with invoker rights. Which of the following strategies, used in combination, would MOST effectively improve the query's performance while adhering to security best practices for native applications and least privileges?

• A. Rewrite the UDF to use a SQL UDF instead of a Python UDF, create a secure view exposing only the necessary data, and use clustering on the underlying consumer table.
• B. Replace the UDF with a materialized view in the consumer's account that pre-computes the derived value, and grant SELECT privilege on the materialized view to the consumer role.
• C. Distribute the processing workload by using Snowflake's Snowpark to create a DataFrame, distribute using custom python code and scale out.
• D. Implement caching for the custom function's results using Snowflake's result caching mechanism, rewrite the UDF to use a SQL UDF instead ofa Python UDF, and utilize a data access framework using secure view, which enables the invoker right to be succesfull.
• E. Rewrite the UDF to use a SQL UDF instead of a Python UDF, grant the necessary privileges to the application's invoker role, and create appropriate indexes on the underlying table in consumer account.

You are building a Snowflake Native App that needs to store configuration settings specific to each consumer account. These settings will influence the behavior of the application. Which of the following methods is the MOST secure and recommended approach for managing these configuration settings within the Snowflake Native App Framework?

• A. Utilize parameters defined in the 'setup.sql' script and accessible via SQL commands like 'SYSTEM$GET APP PARAMETER. This allows consumers to configure the application during installation.
• B. Store the configuration settings in a public database table within the application's share. This makes the settings easily accessible to all consumers.
• C. Store the configuration settings directly within the application's code. This allows for easy access and modification during development.
• D. Use external configuration files stored in an Amazon S3 bucket and accessed via external functions. This provides flexibility and scalability.
• E. Hardcode the configuration settings directly into the manifest file as environment variables.

You've developed a Snowflake Native Application. During the installation process in a consumer's account, the installation fails. The error message is vague and doesn't pinpoint the exact cause. What are the MOST effective steps you can take, in order , to diagnose the installation failure and provide the consumer with a resolution? (Select the top 3 steps)

• A. Review the event logs generated by the application during the installation process using Snowflake Event Tables. Use the appropriate filtering and querying techniques to narrow down the relevant events.
• B. Request the consumer to share their entire Snowflake account metadata with you for debugging purposes.
• C. Leverage the 'SYSTEM$GET PKG INSTALLATION ERRORS function in the provider account to retrieve detailed error messages and debugging information related to the failed installation. Correlate this with the installation version and consumer account I
• D. Examine the consumer's ACCOUNT_USAGE views, specifically related to query history and errors that occurred during the installation timeframe.
• E. Ask the consumer to manually create all the required roles and grants before attempting the installation again.

You are designing a Snowflake Native App that needs to store temporary state information specific to each consumer account. This state information should not be directly accessible to the consumer but must be persistent across application sessions. Which of the following approaches are valid and recommended for storing this data?

• A. Store the state information in a private schema within the application package, ensuring that consumers do not have direct access.
• B. Create a public schema in the application package and store the state information in tables within that schema. Grant SELECT access to the consumer's account on these tables.
• C. Create secured views that expose the state data but control access through application roles.
• D. Utilize internal stages within the application package to store the state data as files.
• E. Use external stages connected to a provider controlled AWS S3 bucket or similar.