最新のNAS-C01問題集で試験を準備する

Snowflake NAS-C01 試験概要:

Snowflake NAS-C01 試験シラバストピック:

Snowflake SnowPro Specialty - Native Apps 認定 NAS-C01 試験問題：

問題 #1

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.

問題 #2

You are developing a Snowflake Native Application that includes a Streamlit UI. The application needs to read configuration parameters such as API keys and database connection strings. Which of the following methods are the recommended and secure ways to manage these configuration parameters within a Snowflake Native App?

A. Store the configuration parameters as environment variables within the Snowflake environment where the Streamlit application is running.
B. Use Streamlit secrets Cst.secretS) configured within the Streamlit application's settings in Snowflake. Store sensitive information like API keys and database credentials there.
C. Store the configuration parameters in a dedicated table within the Snowflake managed database and read them using SQL queries from the Streamlit application. Grant appropriate privileges to the Streamlit application's role on this table.
D. Store the configuration parameters directly within the Streamlit code as Python variables.
E. Store configuration parameters in an external file (e.g., a JSON or YAML file) and include it in the application's deployment package. Read the file from the Streamlit application.

問題 #3

You have created a Snowflake Native Application that includes a User-Defined Function (UDF) written in Python. The UDF processes JSON data and performs complex calculations. During testing in a consumer's account, you discover that the UDF is running slower than expected. What steps can you take to optimize the UDF's performance? (Select TWO)

A. Recompile the UDF with the latest version of the Snowflake runtime environment.
B. Reduce the complexity of the UDF by simplifying the calculations and minimizing the amount of data processed.
C. Leverage vectorization techniques within the Python UDF using libraries like NumPy to perform operations on entire arrays instead of individual elements.
D. Increase the warehouse size allocated to the consumer's account, as this directly impacts UDF execution speed.
E. Switch the UDF implementation from Python to SQL, as SQL UDFs are generally faster than Python UDFs.

問題 #4

You are building a Snowflake Native Application that includes a stored procedure to perform data transformation. This stored procedure needs to access external data sources using a secure API. Which of the following methods provides the MOST secure and recommended approach for managing API credentials within the Snowflake Native Application context?

A. Use the consumer's account's environment variables to store API credentials. The application retrieves credentials from there.
B. Hardcode the API credentials directly within the stored procedure code. This is the simplest approach for development and testing.
C. Store the API credentials in a configuration file included within the application package. Read the credentials from this file within the stored procedure.
D. Store the API credentials directly within the stored procedure code as encrypted strings. Decrypt them at runtime using a key stored in a separate table.
E. Use Snowflake's Secret object to securely store the API credentials. Access the Secret within the stored procedure using function.

問題 #5

You are developing a Snowflake Native Application that provides a data enrichment service. This service requires the consumer to grant the application access to a specific table in their account. You want to ensure that upgrades to your application do not inadvertently break existing consumer configurations. You decide to use a versioned schem a. Which of the following steps are essential during the setup script execution to achieve this and maintain backward compatibility during future upgrades?

A. Define a custom role within the application package and grant it the necessary privileges to read the consumer's table via a secure view. Then, grant the application role the USAGE privilege on this custom role. This ensures that the application role can assume the custom role's privileges for data access.
B. Create a versioned schema using 'CREATE SCHEMA VERSION = ' . Grant the application role 'USAGE on this versioned schema, and ensure all application logic references objects within this schema.
C. Grant the application role 'OWNERSHIP on the consumer's table directly. This allows the application full control and ensures consistent data access regardless of future schema changes within the application.
D. Create a secure view in the versioned schema that accesses the consumer's table. Grant the application role 'SELECT on this secure view. This provides a stable interface that isolates the application from direct changes to the consumer's table.
E. Create a new unversioned schema named 'APPLICATION' and install all application objects within it. This provides a consistent namespace for all consumers, regardless of the application version.

解説：