SOL-C01 Practice Questions

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

A data provider wants to share a secure view called 'SALES SUMMARY' from the 'RETAIL DATA' database with a consumer. The provider needs to ensure that the consumer can only query t...

A data consumer subscribes to a listing on the Snowflake Marketplace. After creating the database from the share, they execute the following query: However, they receive an error i...

You are a data provider on the Snowflake Marketplace. You want to restrict access to specific rows in a shared table based on the consumer's account ID. Which of the following feat...

Which of the following statements are TRUE regarding Snowflake Marketplace listings and data sharing (Select all that apply)?

A data provider wants to share a secure view 'SECURE VIEW SALES' from database 'DB RETAIL' to a consumer account using a private listing within the Snowflake Data Exchange. The pro...

A data consumer creates a database 'DB CONSUMER from a share provided through Snowflake Data Sharing. After some time, the data provider revokes access to the share. What is the st...

You are a data provider and want to share a table 'SALES DATA with two different consumer accounts, and 'ACCOUNT B' , using direct shares. However, you want to provide a filtered v...

Which of the following statements are correct regarding Snowflake Data Exchange and Data Marketplace? (Select TWO)