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

1. You've built a Snowflake Native Application and are ready to test it in test mode. The application utilizes both internal stages and external stages for data storage. Which of the following statements accurately describe the behavior of stages and data access during test mode installations from the provider's perspective?

A) Internal stages defined within the application package are accessible to the application code running in test mode. Data placed in these stages before installation is available immediately.
B) External stages, regardless of their access permissions, are inaccessible during test mode installations to prevent unintended data leakage.
C) Data loaded into internal stages during test mode is automatically persisted to the consumer's account upon final installation of the application.
D) During test mode, the provider has full access to all data stored in both internal and external stages associated with the application, mimicking the access rights in a production environment.
E) The provider can configure specific external stages to be accessible in test mode by granting appropriate privileges to the application role and explicitly defining these stages in the setup script.

2. You are building a Snowflake Native App that aggregates data across multiple consumer accounts. Your app needs to securely access data in each consumer's Snowflake account without requiring them to share their credentials directly. You are evaluating different options for secure data access. Which of the following strategies are viable and recommended to implement this, maximizing security and minimizing administrative overhead for the consumer?

A) Implement a data sharing agreement where consumers create a share from their account and grant usage to your application's account using secure data sharing. The application account can then create a database from this share.

B) Have consumers create and share a JWT (JSON Web Token) with your application. The JWT will be used to authenticate against their Snowflake instance via an external function.

C) Require consumers to grant SELECT privileges on their tables directly to the application's account. This necessitates the consumer to manage grants directly.

D) Utilize Snowflake's Native App data sharing capabilities where the provider app shares data products back to the consumer account and the consumer account can use this inside their apps.

E) Use Snowflake Data Clean Rooms to allow the app to query data from the consumers accounts.

3. A data analytics company is developing a Snowflake Native App that allows customers to enrich their existing Snowflake data with external, proprietary datasets. The application requires READ access to customer tables and the ability to store processed results within the application's managed database. Which combination of Snowflake Native App Framework privileges and features is MOST appropriate to achieve this functionality?

A) The application's manifest includes REQUESTED PRIVILEGES = [ 'READ ON DATABASE', 'READ ON TABLE' l. Use stored procedures executing with definer's rights to access customer tables through a secure view, and standard INSERT statements to write to the managed database.
B) The application package grants OWNERSHIP privilege on customer tables to the application. Use standard INSERT statements within stored procedures to write enriched data into the application's managed database.
C) The application's manifest includes REQUESTED PRIVILEGES = [ 'USAGE ON DATABASE', 'READ ON TABLE' ]. Use stored procedures executing with caller's rights to access customer tables and standard INSERT statements to write to the managed database.
D) Use an API Integration to securely access the customer's data and a Stored Procedure to write the enriched data into application's stage.
E) The application's manifest includes REQUESTED PRIVILEGES = [ 'READ' l. Use stored procedures executing with definer's rights to access customer tables and external functions to write to the managed database.

4. A data engineer, Alice, is developing a Snowflake Native Application. She wants to implement event sharing to notify consumers when certain data thresholds are breached within the application's managed tables. What is the MOST effective and secure approach for implementing this event sharing mechanism, ensuring that consumers can subscribe to these events without direct access to the application's internal tables?

A) Leverage Snowflake's event tables (using EVENT TABLES) to capture significant data changes, then create an API function using 'CREATE FUNCTION' with 'RETURNS TABLE' in the application package to expose these events to consumers through a secure share. Implement RBAC within the API function to manage access.
B) Create a series of external functions that are called when the application's data changes. These functions will call an external notification service that alerts consumers.
C) Use Snowflake Streams and Tasks within the provider account to continuously monitor the managed tables and create events that are pushed to a shared data lake. Consumers then access the data lake.
D) Implement a Python UDF that queries the managed tables and sends email notifications to consumers whenever a threshold is breached.
E) Grant SELECT privileges on the managed tables directly to consumer accounts, using secure views to filter data.

5. You are developing a Snowflake Native Application and want to implement robust observability and telemetry. Which of the following approaches will enable you to effectively monitor the application's performance, identify errors, and collect usage metrics within the consumer's account?

A) The consumer is responsible for implementing observability and telemetry. The application developer cannot implement observability features that function within the consumer's account.
B) Implement custom logging using 'SYSTEM$LOG' and store application logs in a separate table within the application's container. Configure grants to allow the application developer to access these logs.
C) Rely solely on Snowflake's built-in query history and resource monitoring features in the consumer's account, as these automatically capture all application activity.
D) Directly access the consumer's system tables (e.g., 'SNOWFLAKE.ACCOUNT USAGE.QUERY HISTORY) to extract application-related metrics based on query identifiers generated by the application.
E) Utilize to write log data to a secure table within the application and leverage views granted to the consumer to expose relevant metrics and error information. Ensure appropriate roles have access to the views.

질문과 대답: