一番質高い NAS-C01 試験問題集

You are designing a Snowflake Native App that relies on a specific version of a shared library. You want to ensure that your application continues to function correctly even if the provider of the shared library releases a new, incompatible version. How can you achieve version isolation for your application's dependencies within the Snowflake Native App Framework?

• A. Utilize Snowflake's 'API_INTEGRATION' to create endpoint where you have version control for the shared library.
• B. Implement a custom version compatibility check within your application code to gracefully handle potential incompatibilities with newer versions of the shared library.
• C. Utilize the ' feature to directly link your application to a specific version of the shared library hosted in an external repository.
• D. Leverage Snowflake's dependency management system to specify a version range for the shared library in your application's setup script.
• E. Package the required version of the shared library directly within your application's code bundle, ensuring it is isolated from any external updates.

解説: (Tech4Exam メンバーにのみ表示されます)

You are preparing a Snowflake Native Application for its initial release. You have a 'setup.sqP file that creates necessary tables and roles. You are also planning for future updates. Which of the following practices will BEST ensure smooth, version-upgrade compatible deployments for your application's consumers?

• A. Include detailed comments in 'setup.sql' explaining the purpose of each SQL statement and the logic behind schema changes.
• B. Always drop and recreate all application objects in each new version's 'setup.sqr to ensure a clean slate.
• C. Avoid using 'CREATE OR REPLACE TABLE in 'setup.sqr and always use 'CREATE TABLE IF NOT EXISTS.
• D. Use a consistent naming convention for all application objects and clearly document any breaking changes in release notes.
• E. Use stored procedures within 'setup.sqr to encapsulate schema changes and data migrations, making them idempotent.

解説: (Tech4Exam メンバーにのみ表示されます)

Consider the following Snowflake Native App setup script snippet. The intention is to create an application role and grant it the necessary privileges to execute a stored procedure named 'MY PROCEDURE' within the application's data container. However, the script is not working as expected, and the stored procedure is failing with permission errors. Identify ALL of the issues in the following code.

• A. The application role 'app_public' cannot be created inside the setup script.
• B. The 'USAGE privilege on the schema containing the stored procedure is missing.
• C. The application role must be granted the 'USAGE privilege on the database that contains the schema.
• D. The setup script does not require any additional privileges to assign 'EXECUTE on PROCEDURE
• E. The 'EXECUTE' privilege on the stored procedure should be granted to the 'application' role, not 'app_public' .

解説: (Tech4Exam メンバーにのみ表示されます)

You are developing a Snowflake Native Application that uses a UDF to process data in the consumer's account. The UDF needs to access a specific table in the consumer's account but the UDF is running as Invoker's Rights (IR). Select all that apply to securely configure data access for this scenario using a data access framework and least privilege principles:

• A. Create an API integration that enables the UDF to securely authenticate and access the data through an external service.
• B. Create a stored procedure running as OWNER, grant necessary privileges, then call this SP from UDF running as Invoker.
• C. Grant 'SELECT privilege on the specific table to the application's service user role. Configure the UDF to run as OWNER, and use 'EXECUTE AS OWNER.
• D. Create a secure view that exposes only the necessary columns of the table, granting 'SELECT privilege on the secure view to the application's invoker role. Configure the UDF to select from this secure view.
• E. Grant 'SELECT privilege on the specific table directly to the application's invoker role.

解説: (Tech4Exam メンバーにのみ表示されます)

A provider develops a Snowflake Native Application that requires access to consumer's 'ORDERS' table for data enrichment. The provider has created an object role 'app_role'. Which of the following steps are REQUIRED for the application to successfully access and query the 'ORDERS table in the consumer's environment during the installation phase?

• A. The consumer grants IMPORTED PRIVILEGES on the share containing the 'ORDERS table to the 'app_role' in the provider account.
• B. The consumer grants USAGE privilege on the database containing the 'ORDERS' table to the provider account.
• C. The consumer grants USAGE privilege on the schema containing the 'ORDERS' table to the provider account.
• D. The consumer creates a new role, grants SELECT on the 'ORDERS' table to this role, and then grants the role to the application's 'app_role' in the consumer account. The application manifest specifies the consumer_role.
• E. The provider grants OWNERSHIP on the 'app_role' role to the application.

解説: (Tech4Exam メンバーにのみ表示されます)