Exam DSA-C03 Topic 1 Question 15 Discussion

Actual exam question for Snowflake's DSA-C03 exam
Question #: 15
Topic #: 1

You are tasked with preparing a Snowflake table named 'PRODUCT REVIEWS' for sentiment analysis. This table contains columns like 'REVIEW ID, 'PRODUCT ID', 'REVIEW TEXT', 'RATING', and 'TIMESTAMP'. Your goal is to remove irrelevant fields to optimize model training. Which of the following options represent valid and effective strategies, using Snowpark SQL, for identifying and removing irrelevant or problematic fields from the 'PRODUCT REVIEWS' table, considering both storage efficiency and model accuracy? Assume that the model only need review text and review id and the rating.

A. Using 'ALTER TABLE DROP COLUMN' to directly remove 'TIMESTAMP column, which is deemed irrelevant for the sentiment analysis model. SQL: 'ALTER TABLE PRODUCT REVIEWS DROP COLUMN TIMESTAMP;' B. Creating a VIEW that only selects the 'REVIEW _ TEXT , 'REVIEW_ID', and 'RATING' columns, effectively hiding the irrelevant columns from the model. SQL: 'CREATE OR REPLACE VIEW REVIEWS FOR ANALYSIS AS SELECT REVIEW TEXT, REVIEW ID, RATING FROM PRODUCT REVIEWS;' C. creating a new table 'REVIEWS_CLEANED containing only the relevant columns CREVIEW_TEXT , 'REVIEW_ID' , and 'RATING') using 'CREATE TABLE AS SELECT. SQL: 'CREATE OR REPLACE TABLE REVIEWS CLEANED AS SELECT REVIEW TEXT, REVIEW ID, RATING FROM PRODUCT REVIEWS;' D. Dropping rows with 'NULL' values in REVIEW_TEXT and then dropping the 'PRODUCT_ID' and 'TIMESTAMP' columns using 'ALTER TABLE. SQL: 'CREATE OR REPLACE TABLE PRODUCT REVIEWS AS SELECT FROM PRODUCT REVIEWS WHERE REVIEW TEXT IS NOT NULL; ALTER TABLE PRODUCT REVIEWS DROP COLUMN PRODUCT ID; ALTER TABLE PRODUCT REVIEWS DROP COLUMN TIMESTAMP;' E. All of the above.

Suggested Answer: E Vote an answer

All of the options are valid strategies. A directly removes the irrelevant 'TIMESTAMP' column, saving storage. B creates a VIEW which offers a non-destructive way to filter columns. C creates a new table with only the necessary columns. D handles rows with missing review text and removes other irrelevant columns. Therefore, choosing 'All of the above' is the correct response. Depending on use case and downstream application we can make use of any of the options, hence more than one option is correct.

by Albert at Aug 30, 2025, 04:23 PM

Limited Time Offer

15%

Off

Get Premium DSA-C03 Questions as Interactive Self Test Engine or PDF

Comments

0 Satisfied Customers

0 Shares

0 Demo Downloads

10 Years in Business