Snowflake SnowPro Specialty - Native Apps - NAS-C01 Exam Practice Test

A. Grant the 'APPLY APPLICATION' privilege on the application package to the user role.

B. Grant the 'SELECT' privilege on all tables within the application instance to the user role.

C. Grant the USAGE privilege on the application package to the user role.

D. Grant the 'IMPORTED PRIVILEGES privilege on the application package to the user role.

E. Create a custom role in the consumer account and grant the 'MONITOR EXECUTION' privilege on the application instance to that role, then grant that role to the user.

A. The syntax highlighting and code completion features, which help identify syntax errors and suggest valid code snippets.

B. The built-in linter that automatically identifies syntax errors, style issues, and potential security vulnerabilities in your SQL code.

C. The extension's integrated debugger, which allows you to step through your SQL code line by line.

D. Using Version Control tool integration

E. The extension's integration with Snowflake's query profile tool, enabling you to analyze the query execution plan for errors.

A. Manually create the Compute Pool in each region using the Snowflake web interface, ensuring the parameters are identical across all instances.

B. Use a Snowflake Script (SnowSQL) to create the Compute Pool, retrieving the available instance families dynamically using 'SYSTEM$GET_CP POLICY' and selecting the appropriate instance family based on regional availability. Store common configurations in environment variables.

C. Use a Snowflake Script (SnowSQL) to create the Compute Pool, hardcoding the instance family and other parameters directly into the script.

D. Create a Compute Pool in one region and then clone it to all other regions using the 'CREATE CLONE syntax.

E. Compute Pools created are global objects, so the pool automatically exists across all regions.

A. Create a temporary table, write the transformed data to the temporary table, and then atomically rename the temporary table to the original table name.

B. Use a 'MERGE statement to selectively update only changed rows, while ignoring existing ones.

C. Wrap the 'df.write' operation in a retry mechanism with exponential backoff to handle intermittent network errors.

D.

E. Leverage Snowflake's 'TRANSACTIONAL_REPLICATION' to replicate the operations to minimize data loss in between failures.

A. The provider must grant the EXECUTE MANAGED PROCEDURE privilege to the consumer's account and the consumer must be granted USAGE on the application package.

B. The provider must create a custom role within the application package with the EXECUTE privilege on the stored procedures, and the consumer must be granted authorization to assume that role.

C. The provider must grant the EXECUTE privilege on the application package and the consumer must create a local role that inherits privileges from the application.

D. No special actions are required. Consumers can execute any stored procedure within a Native App once the application is installed.

E. The consumer must be granted the EXECUTE privilege on each stored procedure individually.

A. Grant OWNERSHIP on to the APP_ROLE with the GRANT OPTION, then have the application create the tables. The CONSUMER ROLE will then have implicit access.

B. Manually create tables outside of the application and grant the privileges.

C. Grant future grants on the schema for 'SELECT privilege to the 'CONSUMER_ROLE when tables are created.

D. Include code in the stored procedure that creates the table to immediately grant SELECT privilege to CONSUMER_ROLE.

E. Use a task that runs periodically to discover new tables and grant SELECT privilege to CONSUMER_ROLE.

A. To guarantee that the 'app_data.configuration' table always contains the latest version of the 'api_endpoint' parameter, overwriting any existing value.

B. To handle potential errors that may occur if the 'api_endpoint' parameter is already defined in the consumer's account.

C. To ensure that the 'INSERT statement only executes if the table is empty.

D. To optimize the performance of the 'INSERT statement by avoiding unnecessary insertions when the configuration parameter already exists.

E. To prevent duplicate rows with the same 'param_name' from being inserted into the 'app_data.configuration' table during subsequent installations or upgrades of the application.

A. Modify the existing application's code and schema, create a new listing for the updated version, and remove the old listing.

B. Create a new version of the application with the updated logic and schema, test it thoroughly, and then release it as an upgrade on the Marketplace.

C. Directly modify the application's code and schema in the production environment, then announce the changes to consumers.

D. Create a patch version with bug fixes and create a new minor version with schema changes, and release it as an upgrade on the Marketplace.

E. Deprecate the existing version of the application and force all consumers to upgrade to the new version within 24 hours.

A. Store the API credentials in a publicly accessible stage and instruct consumers to download and configure them manually.

B. Store the API credentials as environment variables within the application's deployment environment.

C. Encrypt the API credentials using a simple symmetric key and include the decryption key in the setup script.

D. 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.

E. Hardcode the API credentials directly into the setup script and distribute them to consumers.

A. Implement row-level security policies on the 'aggregated_data' table to restrict access to sensitive rows.

B. Remove the 'GRANT EXECUTE privilege on the 'export_data' procedure from the 'app_public' role.

C. Require the consumer to explicitly grant the application usage privilege on a secure external stage controlled by the consumer, and modify the procedure to validate the stage's existence and permissions before exporting data.

D. Encrypt the data written to the external stage using client-side encryption with a key managed by the application provider.

E. Modify the stored procedure to only export data to a table within the application container instead of an external stage.

A. When creating the authorization grant for for the APPLICATION ROLE, specify VERSION = '1.01.

B. The provider must first create a new version of the application package containing only version 1 .C , and then create an authorization grant for the role to CUSTOMER A that includes version '1.0'

C. Specify the version '1.0' when creating the share object for 'CUSTOMER_A'.

D. No specific steps are required. By default, consumers will automatically receive the latest version of the application.

E. Create a new application package specifically for 'CUSTOMER A' and only include version '1.0' in that package.

A.

B.

C.

D.

E.

A. Create a table with a retention period in the application database using the APPLICATION role. Configure the retention period to be very short (e.g., 1 day).

B. Create an external stage linked to cloud storage. Store temporary data in cloud storage and implement cleanup logic using an uninstall script.

C. Create a schema named 'temp' in the application database using the APPLICATION role. The application setup script will create temporary tables inside this schema. Use an uninstall script to drop the entire schema upon uninstall.

D. Create a temporary stage and use it to persist data. Use a SQL statement in your uninstall script to remove the data from the stage when the application is uninstalled.

E. Create a temporary table in the application database using the APPLICATION role. The application is responsible for dropping the table when uninstalled.

A. Integrate a third-party logging framework (e.g., Log4j) into the application code and configure it to write logs to an external logging service accessible over the internet.

B. Rely solely on the error messages returned by Snowflake during application execution, as these are sufficient for identifying most installation issues.

C. Utilize the view to analyze query execution patterns and identify potential bottlenecks within the application's SQL code.

D. Leverage Snowflake's event tables and configure the application to emit custom events to these tables. Consumers can then subscribe to these events to monitor application behavior.

E. Implement calls within the application code to write log messages directly to a Snowflake table owned by the application provider. Consumers can then query this table to view logs.