Snowflake SnowPro Specialty - Native Apps - NAS-C01 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

A data analytics company, 'Data Insights Pro', develops a Snowflake Native Application that provides advanced data visualizations. They want to publish this application on the Snowflake Marketplace as a public listing. Which of the following steps are required in addition to the standard application creation and packaging, specifically focusing on the public listing aspects? Assume the necessary roles and privileges are already granted.

A. Define a pricing model using Snowflake's monetization features and configure the listing visibility to 'Public'. B. Submit the application package to Snowflake for security and compliance review before making it available on the Marketplace. C. Ensure that the application is compatible with all Snowflake regions before publishing to a public listing. D. Implement robust application usage monitoring and metering to ensure accurate billing if a commercial model is used. E. Create a detailed listing description, including features, benefits, and example use cases, and define the support channels.

Discussion 0

Correct Answer: A,B,E Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 2

You are developing a Snowflake Native Application with a custom setup script. Within the setup script, you need to perform different actions based on whether the application is being installed for the first time in a consumer's account, or if it's an upgrade from a previous version. Which of the following functions or techniques can you reliably use within the setup script to determine if the current execution is a fresh installation vs. an upgrade? (Assume the app version is maintained and accessible as a variable 'current_version' .)

A. Check if the current version is '1.0', assuming the initial version of the application will always be '1.0'. B. Use the table 'APPLICATION_REGISTRY' function to check for an existing entry for the application in the current account. C. Query the 'INFORMATION_SCHEMAPPLICATIONS' view to check if the application name already exists in the consumer's account. D. Use 'SYSTEM$GET_PREVIOUS_VERSION()' function inside the setup script. If it returns NULL, it is the first install. E. Attempt to read a known persistent setting from the application's metadata. If the setting exists, it's an upgrade; otherwise, it's a fresh install. (Requires metadata setup in a previous version)

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 3

You are developing a Snowflake Native Application for a data enrichment service and plan to list it on the Snowflake Marketplace. You want to control the costs incurred by consumers of your application while maximizing its accessibility. Which of the following strategies represent Snowflake Marketplace best practices for cost management and pricing?

A. Offer a free trial period with limited functionality to allow potential consumers to evaluate the application before committing to a paid subscription. B. Refrain from providing any cost-related information upfront to encourage broader adoption, deferring cost discussions until after installation and usage. C. Implement a tiered pricing model based on data volume processed, compute resources consumed, or number of users accessing the application. Offer a free basic tier with limited functionality. D. Provide detailed cost estimation documentation outlining the expected costs for different usage scenarios and data volumes. E. Use Snowflake's built-in resource monitors to proactively track application consumption and alert consumers when they approach predefined spending limits.

Discussion 0

Correct Answer: A,C,D,E Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 4

You have a Snowflake Native Application listed on the Marketplace. You need to update the application to add a new feature, which requires changes to both the application code and the database schema within the application package. You want to ensure a seamless upgrade experience for existing consumers, minimizing downtime and data loss. What is the MOST appropriate strategy for deploying this update?

A. Modify the existing application package directly with the updated code and schema. This will automatically update the application for all consumers. B. Create a new version of the application package. Implement a Snowpark Python stored procedure within the new version that handles schema migrations and data transformations. This procedure should be automatically executed during the upgrade process. C. Create a new version of the application package. Include a setup script that detects the existing version of the application and performs any necessary schema migrations or data transformations. Announce the new version and instruct consumers to manually upgrade. D. Create a new version of the application package. Before releasing, use a feature flag system to gradually roll out the new feature to a subset of consumers, monitoring for any issues before a full release. E. Create a new version of the application package with the updated code and schema. Consumers will automatically be upgraded to the new version upon release.

Discussion 0

Correct Answer: C,D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 5

A provider is testing their Snowflake Native Application in a consumer environment. The application includes a Streamlit app that displays data from a table provisioned in the consumer account. The consumer reports that the Streamlit app is displaying an errorrelated to accessing the table. The 'streamlit.secretS dictionary is used to store the database connection details. The application role app_role' is designed to have access to the table. Which of the following could be potential causes of the problem, assuming the connection details are valid?

A. The 'app_role' does not have the 'SELECT privilege on the table. B. The 'app_role' does not have the privilege on the database containing the table. C. The consumer has not shared the database containing the table with the provider account. D. The Streamlit app is not properly configured to assume the when executing queries. E. The 'streamlit.secretS dictionary is not accessible to the application due to incorrect file permissions.

Discussion 0

Correct Answer: A,B,D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 6

You are designing a Snowflake Native App that interacts with sensitive customer dat a. You need to ensure that the application only accesses the data it absolutely needs and adheres to the principle of least privilege. Which of the following strategies are crucial for maintaining data security within your application?

A. Implement data masking policies to redact sensitive information before it's accessed by the application. B. Grant the application role the 'OWNERSHIP' privilege on all tables containing customer data. C. Create specific roles with granular access privileges (e.g., 'SELECT on specific columns) and grant these roles to the application's managed service account. D. Store sensitive customer data directly within the application package to avoid external access. E. Utilize Snowflake's secure UDFs with invoker's rights to perform data transformations and access control based on the user's role.

Discussion 0

Correct Answer: A,C,E Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 7

You have successfully deployed your Snowflake Native Application Package to an external stage (AWS S3), but consumers are reporting they are not receiving updates after you deploy new versions to the external stage. You have verified that the IAM role, Snowflake integration, and S3 bucket policy are correctly configured. What steps should you take to troubleshoot and resolve this issue?

A. Verify that the SNOWFLAKE DEPLOYMENT role has been granted ownership of the Integration object used for accessing the external stage. B. Ensure the S3 bucket has versioning enabled. Snowflake relies on S3 versioning to detect new application package versions. C. Consumers must manually refresh their installed application instance using the command 'ALTER APPLICATION REFRESH;' after a new package version is deployed. D. Execute the 'ALTER APPLICATION PACKAGE REFRESH' command after each deployment to the external stage. This explicitly informs Snowflake to refresh the application package metadata. E. Grant the APPLICATION ROLE to the SNOWFLAKE DEPLOYMENT role on the application package. This allows the deployment process to automatically update the consumer instances.

Discussion 0

Correct Answer: C,D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 8

Consider the following scenario: You are tasked with designing a setup script for a Snowflake Native Application. This script needs to perform several tasks including creating a database role, granting privileges to the role, and creating a schem a. Your application also provides a configuration table that needs to be populated during the setup process. Which of the following set of statements are true regarding the order of operations and security best practices within the setup script? (Choose all that apply)

A. It is best practice to create the database role before creating the schema, to immediately grant ownership on the schema to the created role. B. Setup Scripts should be designed in a way that it requires multiple manual interventions during execution. C. When granting privileges to the database role, use the 'APPLICATION' keyword to grant privileges on application objects, enhancing security and control. D. The setup script should always be designed to be idempotent, meaning it can be executed multiple times without causing errors or unintended side effects. Use 'CREATE ... IF NOT EXISTS' where appropriate. E. Populating the configuration table should be done before creating any other objects, as other parts of the application might rely on the configuration during object creation.

Discussion 0

Correct Answer: A,C,D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 9

You have a Snowflake Native Application that utilizes a managed table. After upgrading your application to version 2.0, some users report that they are missing data in the managed table. After investigation, you realize version 2.0 changed the schema of the managed table and also did not properly migrate all the data from old format into new format. Which of the following steps should be taken to address the missing data after upgrading a Snowflake Native Application?

A. Create a new version 2.1. Within version 2.1's setup script, dynamically detect if the application is an upgrade from 1.0 and, if so, execute the data migration script to transfer data from the old schema to the new schema. B. Create a new version 2.1 that includes a data migration script to transfer data from the old schema (as it existed in version 1.0) to the new schema in version 2.0. Use release directives to upgrade affected users to version 2.1 after staging. C. Rollback all users to version 1.0 and then perform the schema migration directly on the consumer's account using custom SQL scripts. D. Manually insert the missing data into the managed table in each consumer's account, contacting affected users to coordinate the data entry. E. Since managed tables are fully managed by Snowflake, contact Snowflake support to initiate a data recovery process in each affected consumer account.

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 10

You are developing a Snowflake Native Application that requires secure access to external services for data enrichment. You choose to implement an External Function with API Integration. Which of the following security best practices are MOST important to implement when configuring the API Integration and the External Function to minimize security risks?

A. Grant usage on the API integration to PUBLIC role to allow all users to invoke the external function. B. Store any sensitive credentials required by the external service directly in the External Function's code body for easy access. C. Use the parameter in the API Integration to restrict access to only the trusted IP addresses of the external service. D. Disable network policies on the API Integration to avoid accidental blocking of traffic. E. Configure 'AWS IAM ROLE ARNS or similar parameters (depending on cloud provider) to grant Snowflake the least privilege access to the specific resources on the external service required by the function.

Discussion 0

Correct Answer: C,E Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 11

An organization is building a Snowflake Native App that performs complex data transformations. The transformation logic is encapsulated in a stored procedure. They want to allow consumer accounts to execute this stored procedure, but ONLY with the privileges of the application itself, preventing access to the consumer's data through the procedure. Which set of actions are required to achieve this?

A. Create the stored procedure with the 'EXECUTE AS OWNER clause and grant the 'USAGE privilege on the application package to the consumer's role. B. Create the stored procedure with the ' EXECUTE AS CALLER clause and grant the 'EXECUTE APPLICATION' privilege on the application instance to the consumer's role. C. Create the stored procedure with the 'EXECUTE AS CALLER clause and grant the 'APPLY APPLICATION' privilege on the application package to the consumer's role. D. Create the stored procedure with the ' EXECUTE AS OWNER clause and grant the ' EXECUTE APPLICATION' privilege on the application instance to the consumer's role. E. Create the stored procedure with the ' EXECUTE AS OWNER' clause and grant the ' IMPORTED PRIVILEGES' on the application package to the consumer's role.

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 12

As a Native App Provider, you've identified a performance bottleneck in a query against a table within your application's container due to an inefficient join. The query is part of a view exposed to consumers. Which of the following actions would be MOST effective in improving the query performance while minimizing disruption to consumers?

A. Create a search optimization policy on columns used in the 'WHERE' clause in the view. This does not require any changes from the consumers. B. Create a materialized view in place of the existing view, pre-computing the join results. This will require consumers to update their queries to use the new materialized view name. C. Add a 'CLUSTER BY clause to the underlying table based on the join keys. Consumers will automatically benefit from improved query performance without any changes on their end. D. Implement a scheduled task to regularly update the statistics of the table involved in the join. This will help the query optimizer make better decisions, and consumers will see improved performance gradually. E. Rewrite the query in the view definition to use a more efficient join algorithm (e.g., using hints). Consumers will automatically benefit from the improved performance.

Discussion 0

Correct Answer: A,C,D,E Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 13

You are developing a Snowflake Native Application that integrates with an external API to enrich data within the consumer's account. You need to design the setup script to handle API credentials securely and ensure that consumers can configure their own API keys. Which of the following methods is the MOST secure and recommended approach for managing API credentials within a Snowflake Native Application?

A. Store the API credentials in a publicly accessible stage and instruct consumers to download and configure them manually. B. Hardcode the API credentials directly into the setup script and distribute them to consumers. C. Store the API credentials as environment variables within the application's deployment environment. D. Encrypt the API credentials using a simple symmetric key and include the decryption key in the setup script. E. Use Snowflake's secret management capabilities (e.g., SECRETS feature) to store the API credentials securely, allowing consumers to create and manage their own secrets and reference them within the application.

Discussion 0

Correct Answer: E Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 14

You are packaging a Snowflake Native App for distribution. Which of the following artifacts are essential components of the application bundle that must be included?

A. The application's source code (e.g., SQL scripts, Python files). B. The manifest file (snowflake.yml). C. Compiled Java JAR files if the app includes Java UDFs. D. Binary executables compiled for a specific operating system. E. The 'setup.sql file containing the application's initialization logic.

Discussion 0

Correct Answer: B,C,E Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).