Exam SOL-C01 Topic 3 Question 146 Discussion

Actual exam question for Snowflake's SOL-C01 exam
Question #: 146
Topic #: 3

You are working with a Snowflake external stage that contains a mix of structured and unstructured data. Specifically, you have a directory in your S3 bucket that contains both CSV files and JSON files. You have enabled directory tables for this stage. You want to create a view that combines data from both the CSV and JSON files. How can you effectively achieve this using the directory table, considering that the CSV and JSON files have different schemas?

A. Create two separate views, one for the CSV files and one for the JSON files, using the
'METADATA$FILENAME column in the directory table to filter the files for each view. Then, create a UNION ALL view on top of those views. B. Create a single view that uses the 'METADATA$FILENAME column in the directory table to dynamically parse the data based on the file extension (CSV or JSON) using conditional functions within the view definition. C. Create a single external table that automatically detects the file format and schema based on the file extension and loads the data accordingly. Directory tables will then work automatically with this table. D. It's not possible to combine data from different file formats (CSV and JSON) directly using directory tables. You need to load the data into separate internal Snowflake tables first. E. Create a stored procedure that reads the directory table metadata, determines the file type for each file, and then dynamically creates and executes SQL statements to load the data into a single table.

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.