최신 SnowPro Core Certification NAS-C01 무료샘플문제:

1. A provider is developing a Snowflake Native App and utilizes event sharing to communicate state changes to consumers. After initial installation, a consumer reports not receiving any event notifications. The provider has verified the event table is populated correctly. Which of the following are the MOST likely reasons for this issue and how can the provider troubleshoot them?

A) The consumer has not refreshed their application instance metadata. Ask the consumer to execute SYSTEM$REFRESH_EXTERNAL_FUNCTIONS() in the application database.
B) Event sharing is inherently unreliable and Snowflake does not guarantee event delivery. The provider should implement alternative polling mechanisms.
C) The event table function is not correctly filtering events based on the consumer's application instance I Review the function logic to ensure proper filtering using APP_INSTANCE_ID().
D) The consumer has not explicitly granted the necessary privileges on the event table function to the role used by the app. Instruct the consumer to grant USAGE on the event table function to the app role.
E) The consumer's event table function does not have the correct security invoker privileges. Grant EXECUTE TASK on the event table function to the consumer role.

2. You are developing a Snowflake Native App that uses JavaScript stored procedures for complex data transformations. You want to implement robust error handling and logging to ensure that you can effectively troubleshoot issues in both provider and consumer environments. Which of the following strategies provide the MOST comprehensive approach to error handling and logging in this scenario? (Select TWO)

A) Rely solely on the error messages displayed in the Snowflake web UI when a stored procedure fails. These messages are sufficient for most debugging scenarios.
B) Use 'CALL SYSTEM$LOG(...)'})$ within your JavaScript stored procedures to log messages at different levels (e.g., INFO, WARN, ERROR) directly to the Snowflake event table. Implement structured logging for easier analysis.
C) Implement a custom error tracking system using external functions to send error information to a third-party logging service.
D) Configure Snowflake's built-in query history to capture all query executions and analyze the query text for errors. No explicit logging within the stored procedures is necessary.
E) Use 'TRY...CATCH' blocks within your JavaScript stored procedures to catch exceptions. Log the exception message and stack trace to a dedicated logging table in the provider's account.

3. You are developing a Native App on Snowflake that needs to interact with an external REST API. To ensure proper security, you want to store the API key securely within the application package and use it for authentication. Which of the following is the MOST secure and RECOMMENDED method to accomplish this?

A) Hardcode the API key directly into the application code within a UDF (User-Defined Function).
B) Store the API key in a secure stage with encryption and grant SELECT privilege to the application role.
C) Create a key-pair stored procedure. Storing the API key as a secret, then decrypting the key during each API call.
D) Store the API key in a table within the application database with minimal access control, relying on Snowflake's data encryption at rest.
E) Store the API key as a secret using Snowflake's Secret Management feature and reference it within a secure UDE

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

5. You are responsible for managing the pricing plans for your Snowflake Native Application listed on the Marketplace. You want to offer a 'Premium' tier that includes additional features and resources. To achieve this, you need to modify the listing to include this new pricing option. Which of the following steps are NECESSARY and in the CORRECT order to successfully add the 'Premium' tier to your application's listing, ensuring existing customers are not negatively impacted? (Choose two options in their proper order)

A) 1. Modify the existing application package in place to include the code changes supporting the 'Premium' features. 2. Update the Marketplace listing with the modified application and add the 'Premium' pricing tier with appropriate settings.
B) 1. Test new Pricing in a Sandbox environment with few consumers. 2. Deploy the new version to the consumer accounts.
C) 1. Update the listing on the Marketplace with the new pricing tier. 2. Ensure backward compatibility for existing customers by implementing logic in the application to detect their current tier and maintain existing functionality.
D) 1. Update the Marketplace listing by adding the 'Premium' pricing tier with appropriate settings, but without modifying the application package. 2. Inform existing customers that the new pricing tier is available.
E) 1. Create a new version of the application package in your provider account with the code changes supporting the 'Premium' features. 2. Update the Marketplace listing with the new version of the application and add the 'Premium' pricing tier with appropriate settings.

질문과 대답: