DSA-C03 Exam Dumps | You're building a customer segmentation model and need to aggregate data from various tables. You have

<< Prev Question Next Question >>

Question 20/143

You're building a customer segmentation model and need to aggregate data from various tables. You have the following tables in Snowflake: 'customer demographics' (customer id, age, city, income) 'customer transactionS (transaction_id, customer id, transaction_date, amount) 'product_details' (product_id, category) 'transaction_products' (transaction_id, product_id) Your goal is to create a single Snowpark DataFrame containing customer demographics along with the total amount spent by each customer on products within the 'Electronics' category in the last year. However, ensure that only customers with income greater than 50000 are considered and handle cases where customers have no transaction records, assigning a value of 0 to the 'total_electronics_spending' column for those customers. How can we achieve this using snowpark? Choose the correct options

A. Use a series of INNER JOINs to connect the tables and filter data, followed by grouping and aggregation. This approach guarantees accurate results with good performance.

B. Use a combination of LEFT JOINs and filtering. Start with 'customer_demographics' (filtered for income > 50000) as the base table and LEFT JOIN to subsequent tables. Use the 'coalesce' function to handle customers without transaction data.

C. Create a temporary view to store total electronics expenditure of each customer and left join with customer demographics table.

D. Create a complex SQL query within Snowpark using 'session.sql()' to perform all the joins, filtering, and aggregation in a single step. This will be the most efficient approach.

E. Create a Python UDF that performs the joins and aggregations. This offers flexibility and good performance when dealing with complex data transformations.

Question 20/143

LEAVE A REPLY

Download PDF File