Login / Register   My Cart (0)

Here are all the actual test exam dumps for IT exams. Most people prepare for the actual exams with our test dumps to pass their exams. So it's critical to choose and actual test pdf to succeed.

All Products Contact now

Exam DAA-C01 Topic 1 Question 141 Discussion

Actual exam question for Snowflake's DAA-C01 exam
Question #: 141
Topic #: 1
You are working with a Snowflake table called containing sales transactions. The table includes columns like 'transaction_id' (VARCHAR), 'product_id' (VARCHAR), 'transaction_date' (DATE), (NUMBER(10,2)), and (GEOGRAPHY). You need to perform the following data preparation tasks: 1. Clean the data: Remove transactions with less than or equal to 0. 2. Transform the data: Convert the 'customer_location' from GEOGRAPHY to a WKT string representation. 3. Enrich the data: Calculate the year and month from the 'transaction_date' and add them as new columns. 4. Mask the data: Partially mask the 'transaction_id' column to protect customer data by only displaying the last 4 digits of the ID. Considering performance and best practices, what is the MOST efficient way to achieve these transformations using Snowflake features? You need to achieve this in a single statement.

Suggested Answer: A,D Vote an answer

Options A and D are functionally equivalent and correct, they both performs the desired data cleansing, transformation, and enrichment in a single 'CREATE OR REPLACE TABLE' statement. The 'WHERE sales_amount > clause filters out invalid transactions. RIGHT(transaction_id, 4) masks the transaction ID. YEAR() and MONTH() extract the year and month from the date, and ST_ASTEXT() converts the GEOGRAPHY object to a WKT string. Option B uses HASH, but the question asks for partially masking so HASH isn't suitable. Option C uses CASE, that is not required. Option E makes use of SYSTEM$MASK, function which masks the entire column value, that isn't what the questions asks.

by Leo at Jan 07, 2026, 05:41 PM

Limited Time Offer

15%

Off

Get Premium DAA-C01 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

Here are all the actual test exam dumps for IT exams. Most people prepare for the actual exams with our test dumps to pass their exams. So it's critical to choose and actual test pdf to succeed.

RECENT DISCUSSIONS

Useful Links

Contact Us

Our Working Time: ( GMT 0:00-15:00 )
From Monday to Saturday

Support: Contact now 

If you have any question please leave me your email address, we will reply and send email to you in 12 hours.

Copyright © 2026 Actual4test NETWORK CO.,LIMITED. All Rights Reserved. All trademarks used are properties of their respective owners. Privacy Policy

Disclaimer:
Actual4test doesn't offer Real SANS and GIAC Exam Questions.
Oracle and Java are registered trademarks of Oracle and/or its affiliates
Actual4test material do not contain actual actual Oracle Exam Questions or material.
Actual4test doesn't offer Real Microsoft Exam Questions.
Microsoft®, Azure®, Windows®, Windows Vista®, and the Windows logo are registered trademarks of Microsoft Corporation
Actual4test Materials do not contain actual questions and answers from Cisco's Certification Exams. The brand Cisco is a registered trademark of CISCO, Inc
CFA Institute does not endorse, promote or warrant the accuracy or quality of these questions. CFA® and Chartered Financial Analyst® are registered trademarks owned by CFA Institute.
Actual4test does not offer exam dumps or questions from actual exams. We offer learning material and practice tests created by subject matter experts to assist and help learners prepare for those exams. All certification brands used on the website are owned by the respective brand owners. Actual4test does not own or claim any ownership on any of the brands.