SOL-C01 · Question #180
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 file
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #180. The question stem and answer options stay visible for context.
Question
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?
Options
- ACreate two separate views, one for the CSV files and one for the JSON files, using the
- BCreate a single view that uses the 'METADATA$FILENAME column in the directory table to
- CCreate a single external table that automatically detects the file format and schema based on the
- DIt's not possible to combine data from different file formats (CSV and JSON) directly using directory
- ECreate a stored procedure that reads the directory table metadata, determines the file type for
Unlock SOL-C01 to see the answer
You've previewed enough free SOL-C01 questions. Unlock SOL-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.