SOL-C01 Exam Questions

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...

You have a Snowflake table named 'employees' with columns 'employee_id', 'name', 'department', and 'salary'. You need to load data from a fixed-width file located in an internal st...

You are tasked with loading JSON log files stored in an external stage named "s3_logs' into a Snowflake table called 'raw_logs'. The JSON files contain a 'timestamp' field as a str...

You have a Snowflake external stage configured to access Parquet files in an AWS S3 bucket. You want to query these Parquet files directly using Snowflake without explicitly loadin...

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...

You are using a virtual warehouse 'X-SMALL' to load data from a large CSV file (50GB) residing in an external stage into a Snowflake table. During the data loading process, you obs...

You have enabled directory tables on an external stage pointing to an AWS S3 bucket. The S3 bucket contains millions of small JSON files. When you query the directory table, you no...

A data engineer is tasked with loading JSON files containing customer reviews from an external stage into a Snowflake table. The JSON files have varying schemas and nested structur...

You have enabled auto-ingest using Snowpipe for a stage containing image files. You want to create a Directory Table to track the metadata of these image files (name, size, last mo...

You are using Snowpipe to load data into a table. You need to monitor the data loading process and identify any files that failed to load. Which of the following actions will provi...

A data engineer needs to load JSON files containing customer reviews stored in an external stage 's3://my-bucket/reviews/'. The JSON structure varies significantly between files, b...

You have a requirement to grant a third-party vendor access to specific data files stored in an internal stage within your Snowflake environment. You want to use pre-signed URLs fo...

You are designing a Snowflake UDF to parse log files. The UDF needs to accept the log file content as a string argument and a configuration parameter that specifies the log format....

You have a Snowflake virtual warehouse named 'COMPUTE that is experiencing performance issues during peak hours. The workload consists of a mix of complex analytical queries and hi...

Consider the following Snowflake SQL code snippet that attempts to load data from a CSV file into a table. Assume the file format 'MY CSV FORMAT' is correctly defined with appropri...

A company stores unstructured text data (PDFs, DOCX) in an external stage (AWS S3). They want to use Snowflake Cortex's PARSE DOCUMENT function to extract specific information, but...

You are tasked with using the 'PARSE DOCUMENT' function in Snowflake to extract key information (name, address, phone number) from a large collection of scanned invoices stored as...

You are using PARSE DOCUMENT on documents stored in an external stage. You notice that some documents are skipped during processing without any explicit error messages. Which of th...

You're using Snowflake Cortex's 'PARSE DOCUMENT function to extract data from a large number of PDF documents stored in an AWS S3 bucket. You want to optimize costs by minimizing t...

A data engineer needs to translate product names stored in a 'PRODUCTS' table from English to French using Snowflake Cortex LLM. The 'PRODUCTS' table has a 'PRODUCT ID' and 'PRODUC...

A Snowflake administrator wants to use the 'TRANSLATE function from Snowflake Cortex LLM within a user-defined function (UDF). However, they encounter a 'permission denied' error....

A data analyst is tasked with translating customer reviews from various languages into English to perform sentiment analysis. The customer reviews are stored in a table named 'CUST...

A financial institution is using Snowflake to store customer communications. They need to translate all incoming emails from various languages into English for compliance purposes....

A data analyst is using Snowflake Cortex's CLASSIFY TEXT function to categorize customer feedback. They notice that some feedback containing sarcasm is consistently misclassified....

You have a table 'CUSTOMER REVIEWS' with a column 'REVIEW TEXT containing unstructured customer feedback. You want to use CLASSIFY TEXT to categorize these reviews into predefined...

You are tasked with classifying a large dataset of customer support tickets using Snowflake Cortex's CLASSIFY TEXT function. You need to ensure optimal performance and cost- effect...

A company uses Snowflake Cortex's CLASSIFY TEXT to categorize product reviews. They want to track the daily distribution of reviews across different categories ('Positive', 'Negati...

You're using Snowflake Cortex's CLASSIFY TEXT function to analyze customer survey responses. A particular survey question asks respondents to list their favorite features of a prod...

A data engineer is tasked with using Snowflake Cortex's COMPLETE function to generate concise summaries of customer reviews stored in a table named `CUSTOMER REVIEWS. The 'CUSTOMER...

A data scientist wants to use the COMPLETE function in Snowflake Cortex to perform sentiment analysis on social media posts. They have a table named 'SOCIAL MEDIA POSTS with a colu...

You are using the 'SNOWFLAKE.ML.COMPLETE function in Snowflake Cortex to generate creative text formats, specifically poems, based on customer feedback. You have a table 'FEEDBACK'...

You're building a data pipeline in Snowflake that utilizes the 'SNOWFLAKE.ML.COMPLETE function to translate product descriptions from English to French. You have a table 'PRODUCT D...

You are working with Snowflake Cortex and the COMPLETE function to generate marketing copy from product specifications. You have a table `PRODUCT SPECS containing 'PRODUCT NAME, 'K...

A data engineer accidentally drops a critical table named 'CUSTOMER DATA in the 'SALES DB' database. They immediately realize the mistake. Which sequence of actions would be the MO...

A Snowflake account has the 'DATA RETENTION TIME IN DAYS' parameter set to the maximum allowed value for Enterprise Edition. A user executes a large DELETE statement against a tabl...

A financial institution needs to maintain a record of all changes made to its customer data for regulatory compliance. They are using Snowflake and want to leverage Time Travel and...

A data warehouse contains a table 'SALES TRANSACTIONS that is frequently updated. You need to ensure that the data is protected against accidental deletions and updates, and you ne...

You are designing a data pipeline in Snowflake that involves frequent updates to a staging table `STG CUSTOMERS before merging the data into a production table `PROD CUSTOMERS. The...

You are tasked with creating a development environment from a production database in Snowflake. The production database, 'PROD DB', is very large and you need to minimize the stora...

You have a table named 'SALES DATA' in your Snowflake account. You want to create a clone of this table for testing purposes, but you also want to mask certain columns containing s...

You are managing a Snowflake environment with continuous data protection enabled. A critical table, `CUSTOMER ORDERS , was accidentally dropped by a user. You need to restore this...

Consider the following scenario: A Snowflake database `SALES DB contains a table 'CUSTOMER DATA' that is actively being updated. You need to create a historical snapshot of 'CUSTOM...

You are working with a Snowflake database that contains sensitive personal data. You need to create a development environment for testing purposes, but you want to ensure that the...