Exam DAA-C01 Topic 1 Question 54 Discussion

Actual exam question for Snowflake's DAA-C01 exam
Question #: 54
Topic #: 1

You are tasked with ingesting data from a REST API that provides customer order information in JSON format. The API returns a nested JSON structure with an array of orders, each containing customer details and order items. The data volume is expected to be high. You need to efficiently load this data into Snowflake. Which of the following approaches would be MOST efficient, considering cost and performance, and taking into account potential data quality issues?

A. Load the JSON data directly into a VARIANT column, then create a view to flatten the data as needed. Use Snowflake's JSON functions for querying and transformation. B. Use Snowpipe with a stream and task to continuously ingest the JSON data into a staging table with a VARIANT column. Then, create a separate task to flatten the data into relational tables using SQL transformations after ingestion. C. Use an external function to call a Python script that parses the JSON, transforms the data into a flat relational structure, and then uses the Snowflake Python Connector to insert the data directly into relational tables. D. Use a third-party ETL tool to extract, transform, and load the data into Snowflake. E. Load the data into a temporary stage, manually parse it with SQL statements, and then load it into your target tables. Schedule the task for periodic execution.

Suggested Answer: B Vote an answer

Snowpipe with a stream and task offers continuous, near real-time ingestion. Using a staging table with a VARIANT column allows for handling the complex JSON structure initially. Subsequent tasks can then transform and flatten the data into relational tables. This approach combines efficiency, automation, and scalability, minimizing manual intervention and maximizing performance for high-volume data. Other options are less efficient or scalable: A requires constant parsing during queries, C introduces external dependencies and overhead, D adds complexity and cost of a third-party tool, and E is manual and not scalable.

by Bing at Mar 08, 2026, 10:20 AM

Limited Time Offer

15%

Off

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

Comments

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.

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.