Snowflake : DEA-C02 Questions & Answers

You are implementing a data share between two Snowflake accounts. The provider account wants to grant the consumer account access to a function that returns anonymized customer data based on a complex algorithm. The provider wants to ensure that the consumer cannot see the underlying implementation details of the anonymization algorithm. Which of the following approaches can achieve this goal? (Select TWO)

• A. Create an external function in the provider account and grant usage to the share. Share the share with the consumer account.
• B. Create a view that calls the secure UDF and share that view with the consumer account.
• C. Create a standard UDF in the provider account and grant usage on the UDF to the share. Share the share with the consumer account.
• D. Create a secure UDF in the provider account and grant usage on the secure UDF to the share. Share the share with the consumer account.
• E. Share the underlying table and provide the consumer account with the anonymization algorithm separately.

You have a complex data pipeline implemented using Snow park Python. The pipeline involves multiple Data Frame transformations, joins, aggregations, and window functions. To enhance the maintainability and readability of the code, you want to modularize the pipeline into reusable functions. You also need to handle potential errors and exceptions gracefully. Consider the following code snippet:

• A.
  
• B.
  
• C.
  
• D.
  

A data engineering team is using a Snowflake stream to capture changes made to a source table named 'orders'. They want to only capture 'INSERT and 'UPDATE operations but exclude 'DELETE operations from being captured in the stream. Which of the following configurations will achieve this requirement? Assume the stream has already been created and is named 'orders_stream'.

• A. It's impossible to configure a stream to exclude specific DML operations. All changes are always tracked.
• B. Alter the stream using the 'HIDE_DELETES parameter: 'ALTER STREAM orders_stream SET HIDE_DELETES = TRUE;'
• C. Create a Snowflake task that periodically truncates the stream's metadata table, removing DELETE records.
• D. Create a view on top of the base table that filters out deleted rows, and then create a stream on the view.
• E. Use task and stream combination. In the task, create view using 'select from orders where metadata$isDelete = false' and create stream on that view.

Which of the following statements are TRUE regarding Snowflake's Fail-safe mechanism and its relation to Time Travel? (Select all that apply)

• A. Fail-safe is exclusively used by Snowflake to recover data in the event of a catastrophic system failure, and users have no direct access.
• B. Fail-safe provides a historical data retention period of 7 days, similar to the default Time Travel setting.
• C. Users can query data directly from Fail-safe using SQL commands if Time Travel is insufficient.
• D. Fail-safe is automatically enabled for all Snowflake accounts and requires no configuration.
• E. The Fail-safe period starts immediately after the Time Travel retention period ends.

A data engineering team has created a Snowflake Listing to share their company's sales data'. They want to allow consumers to access the Listing programmatically. The consumers need to know when new versions of the Listing are available. What is the MOST efficient method for consumers to be notified about new Listing versions without continuously polling Snowflake?

• A. The consumer sets up a scheduled task in Snowflake to periodically query the 'SHOW VERSIONS command for the Listing.
• B. The data provider manually sends email notifications to each consumer whenever a new version is created.
• C. Snowflake automatically notifies consumers via an event notification service (e.g., AWS SNS, Azure Event Grid) integrated with the Data Marketplace when a new version is available.
• D. The data consumer implements a custom webhook endpoint that the data provider calls whenever a new Listing version is published. The data provider will need to maintain a list of all consumers.