SOL-C01 Practice Questions

You are loading semi-structured JSON data into a Snowflake table named 'ORDERS'. The JSON files contain nested arrays and occasionally have missing fields. You need to load only th...

You are loading data from a CSV file stored in an AWS S3 bucket into a Snowflake table. The CSV file uses a custom delimiter and contains a date field that needs to be explicitly f...

A Snowflake administrator needs to load data from multiple compressed (gzip) CSV files located in an external stage into a Snowflake table. Which *COPY INTO' command options can im...

You are tasked with loading data from a Parquet file into a Snowflake table. The Parquet file contains a column with a timestamp datatype. However, the timestamp values are being i...

Your team has set up an automated data pipeline to load data into Snowflake using the *COPY INTO' command from an S3 bucket. After some time, you notice that some files in the buck...

You are tasked with loading data into a Snowflake table 'SALES DATA' that contains columns 'SALE ID (NUMBER)' , 'PRODUCT ID (NUMBERY, 'SALE DATE (DATE), and 'SALE AMOUNT (NUMBER)'....

You are responsible for optimizing the data loading process into a Snowflake table 'PRODUCT REVIEWS'. The source data is in JSON format and contains nested structures. You notice t...

You are inserting data into a table named 'EVENTS' which contains a column 'EVENT DATA' of type 'VARIANT'. The data being inserted comes from an external stage and is in JSON forma...

A data engineer is tasked with loading JSON data containing nested arrays into Snowflake. Some JSON files exceed Snowflake's maximum single row size limit. Which of the following s...

You are using Snowflake to store sensor data, which comes in the form of JSON. Each JSON document contains fields like `timestamp' , 'sensor_id' , and a variable number of readings...

You are tasked with loading data from a series of CSV files stored in an Amazon S3 bucket into Snowflake. The CSV files contain a header row, but some files have slight variations...

A Snowflake data warehouse has a large table named 'ORDERS' that is frequently queried by multiple virtual warehouses of different sizes for various analytical workloads. The data...

You are managing a Snowflake environment that ingests data from various sources, including structured data (CSV files) and semi-structured data (JSON files). You notice that query...

A data engineer is experiencing inconsistent query performance during peak hours. They have a single X- Small warehouse currently configured. After analyzing query history, they ob...

You need to load a large CSV file (1 TB) into a Snowflake table. Which of the following methods would generally provide the fastest loading performance?

A data team is using a Snowflake virtual warehouse for both ETL processes and ad-hoc reporting. During peak ETL hours, reporting queries are significantly slowed down. What is the...

Consider the following Snowflake warehouse definition: 'CREATE OR REPLACE WAREHOUSE MY WAREHOUSE WITH WAREHOUSE SIZE = 'MEDIUM' WAREHOUSE TYPE = 'STANDARD' AUTO SUSPEND = 300 AUTO...

A Snowflake account has two virtual warehouses, 'WH ETC and 'WH REPORTING'. You need to ensure that the cost of running queries against a specific table, 'SALES DATA' , is accurate...

A data engineering team is tasked with loading a large dataset (5TB) into Snowflake from an external S3 bucket. The data loading process is experiencing significant performance bot...

You are designing a data pipeline in Snowflake to process streaming data from Apache Kafka. You need to choose the appropriate virtual warehouse size. The data arrives at a rate of...

A Snowflake environment hosts two distinct workloads: daily ETL processes that require significant compute power and ad-hoc analytical queries from business users. You want to opti...

A data engineering team is experiencing significant delays during their nightly ETL process in Snowflake. The process involves loading data from several external cloud storage loca...

Your team is loading data into Snowflake using Snowpipe. You've noticed that data loading is significantly slower than expected, even though your virtual warehouse is sized appropr...

You have a virtual warehouse named `REPORTING that you want to resize from 'MEDIUM' to 'LARGE. You execute the following SQL command: ALTER WAREHOUSE REPORTING WH SET WAREHOUSE SIZ...

A Snowflake account has a virtual warehouse named `ANALYTICS WH' configured with multi- clustering. The MIN CLUSTER COUNT is set to 1, and the MAX CLUSTER COUNT is set to 3. During...

A data engineering team uses Snowflake to load and transform large datasets. They have observed that a specific transformation job consistently takes an unacceptably long time to c...

A Snowflake virtual warehouse named 'TRANSFORM WH' is configured with the following parameters: 'WAREHOUSE SIZE = XSMALL', 'AUTO SUSPEND = , and 'AUTO RESUME = TRUE. During peak ho...

A data team is designing a data pipeline that loads data from S3 into Snowflake. The raw data in S3 is compressed using gzip and stored in multiple files. They want to use a Snowfl...

A Snowflake administrator notices that a virtual warehouse named 'REPORTING WH' is frequently idle during off-peak hours. They want to optimize costs by ensuring the warehouse susp...

A company is experiencing inconsistent query performance in their Snowflake environment. Some queries execute quickly, while others, seemingly similar, take significantly longer. T...

You are tasked with creating a table `EMPLOYEES in Snowflake to store employee data. The table should have columns for 'employee_id' (INT, primary key), 'first_name' (VARCHAR(50)),...

You have a Snowflake virtual warehouse named 'REPORTING that is consistently experiencing performance issues during peak hours. You suspect that resource contention is the primary...

You are responsible for managing a Snowflake environment where data is loaded from various external sources. You want to use Snowsight to quickly identify all tables within a speci...

You are tasked with creating a table in Snowflake to store customer order data. You need to ensure that the 'order date' column always defaults to the current date if no value is p...

You are using the 'COPY INTO' command to load data from an Amazon S3 bucket into a Snowflake table named 'employees'. The data in S3 is in CSV format, compressed with gzip, and con...

You have a Snowflake table named 'products' with columns 'product id', 'product_name', and 'price'. You need to create a view called 'expensive_products' that only shows products w...

You are working with a Snowflake table named 'transactions' that contains a 'transaction_time' column of data type 'TIMESTAMP NTZ'. You need to retrieve all transactions that occur...

You have created a virtual warehouse in Snowflake and loaded data into several tables. You observe that query performance is inconsistent, with some queries running quickly and oth...

You are using a named file format called to load data from CSV files into a Snowflake table named `PRODUCTS'. However, you are encountering errors during the data loading process b...

You have a table 'SALES DATA' with columns 'PRODUCT_ID' ONT), 'SALE_DATE' (DATE), and 'SALE AMOUNT' You want to load data into this table from various sources. You need to insert m...

You have a table 'PRODUCT_PRICES' defined as 'CREATE TABLE PRODUCT_PRICES (PRODUCT_ID INT, PRICE LAST UPDATED TIMESTAMP NTZ)'. You want to insert new prices for some products, but...

You are loading data into a Snowflake table 'EMPLOYEE DATA (EMP_ID INT, EMP NAME VARCHAR, DEPARTMENT VARCHAR)' using 'INSERT' statements. You notice that some of the 'EMP NAME valu...

You are creating a table 'ORDERS' to store customer orders and need to include an 'ORDER ID' column that automatically increments with each new order. You want to achieve this with...

You are tasked with loading data from a set of CSV files located in an Amazon S3 bucket into a Snowflake table named 'CUSTOMER DATA'. The files have headers, but some files might h...

You have a Snowflake table named 'SALES DATA' that you load data into daily from a CSV file using Snowsight. Recently, the load times have increased significantly. You suspect the...

You are designing a data ingestion pipeline in Snowflake using Snowsight to load JSON data from an external stage (AWS S3). The JSON files contain nested arrays and objects, and yo...

You are using Snowsight to load data into a Snowflake table 'PRODUCT DATA' from a CSV file stored in an internal stage. The CSV file contains a column named 'PRICE' which represent...

A Snowflake data engineer is tasked with optimizing the performance of daily data loads into a fact table named `SALES FACT. The data is loaded from multiple CSV files stored in an...

A Snowflake table 'product catalog' exists with columns 'product id', 'product_name', and 'price'. You have a pipe-delimited file in an external stage named 's3 stage' containing p...

You are loading data from a set of compressed (gzip) JSON files in an external stage named 'json_stage'. The target table is named raw_event' , and it has a single VARIANT column n...