Snowflake NAS-C01

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

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

問題 #1
You're packaging a Snowflake Native App and need to define the minimum Snowflake version required for installation. You also want to specify an optional PARAMETER that users can configure during installation to customize the app's behavior. Which section of the manifest file allows you to achieve this?

A. The 'metadata.json' file, which only contains descriptive information about the app.
B. The 'setup.sqrl' file, where you define SQL commands to be executed during app installation.
C. The 'application.yaml' file under the 'configuration' section, where you can specify and define PARAMETERS with their types and default values.
D. The 'deployment.sql' file where you define the app's deployment settings.
E. The 'privileges.sql' file, where you define the privileges required by the application.

問題 #2
A Native App developer is using Snowflake's Event Tables for tracing the execution of their application. They have noticed a significant performance overhead when event logging is enabled, particularly for high-volume UDFs. Which of the following strategies would be MOST effective in mitigating the performance impact of event logging while still capturing valuable tracing information?

A. Implement sampling or conditional logging within the UDFs, only logging events for a subset of executions or when specific conditions are met. Utilize asynchronous logging techniques where appropriate to offload logging operations.
B. Increase the frequency of event table flushes to reduce the number of events buffered in memory. This minimizes memory pressure and write latency.
C. Disable event logging entirely for high-volume UDFs to eliminate the performance overhead.
D. Write event data directly to an external cloud storage system (e.g., AWS S3, Azure Blob Storage) bypassing Snowflake's Event Tables altogether.
E. Reduce the number of columns captured in the event tables to minimize the amount of data being written. Store all tracing data in a single large event table to simplify querying.

問題 #3
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.

問題 #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. Store the API credentials in a configuration file included within the application package. Read the credentials from this file within the stored procedure.
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 directly within the stored procedure code as encrypted strings. Decrypt them at runtime using a key stored in a separate table.
D. Use the consumer's account's environment variables to store API credentials. The application retrieves credentials from there.
E. Use Snowflake's Secret object to securely store the API credentials. Access the Secret within the stored procedure using function.

問題 #5
You are the developer of a Snowflake Native Application. You've created a new version of your application package, v2.0. You want to perform a controlled rollout, first releasing it to a subset of your consumers for testing before making it generally available. Which sequence of steps, leveraging Snowflake's lifecycle management features, would you use to achieve this?

A. 1. Create a dedicated APPLICATION role for the application. 2. Grant OWNERSHIP on the application package to the application's APPLICATION role. 3. Update the default version of the application package to v2.0.
B. 1. Instruct consumers to use the 'ALTER APPLICATION' command to upgrade to v2.0. 2. Monitor consumer feedback on the upgraded version.
C. 1. Create a new APPLICATION role for beta testers. 2. Grant USAGE privilege on the application package to the beta testers APPLICATION role. 3. Grant USAGE privilege on version v2.0 to the beta testers APPLICATION role. 4. Update the default version of the application package to v2.0.
D. 1. Create a new APPLICATION role for beta testers. 2. Grant USAGE privilege on version v2.0 to the beta testers APPLICATION role. 3. Instruct beta testers to manually specify VERSION = 'v2.0' when creating their application instances.
E. 1. Create a new APPLICATION role for beta testers. 2. Grant USAGE privilege on version v2.0 to the beta testers APPLICATION role. 3. Update the default version of the application package to v2.0.

解説：