SOL-C01 Practice Questions

A large e-commerce company is experiencing seasonal spikes in sales traffic, leading to significant increases in data ingestion and query processing. You are tasked with optimizing...

Which of the following statements are TRUE regarding Snowflake's data sharing capabilities and its impact on storage costs and data governance? (Select TWO)

A data engineering team is tasked with building a data pipeline that ingests semi-structured data (JSON) from various sources into Snowflake. They want to optimize query performanc...

A data analyst needs to query a table named 'ORDERS' which contains sensitive customer information, including email addresses. They only need to access order IDs and order dates fo...

You are designing a data lake solution in Snowflake that requires storing and processing both structured and semi-structured data from various sources. The data lake will be used f...

A data engineering team is experiencing performance issues with their nightly ETL pipeline in Snowflake. The pipeline involves complex transformations on a large dataset (5TB) and...

A Snowflake account is configured to use Okta as its Identity Provider (ldP) for Single Sign-On (SSO). A user, 'analytics_user', reports being unable to log in to Snowflake via Okt...

A data scientist wants to leverage Snowflake's A1 Data Cloud capabilities to train a machine learning model directly on data stored in Snowflake. The data is stored in a table name...

A company utilizes Snowflake's elastic compute capabilities for its daily batch processing jobs. They have noticed that the warehouse consistently scales up to X-Large during the p...

A Snowflake architect is designing a data lake solution using Snowflake's external tables. The data lake contains JSON files stored in AWS S3. The architect needs to ensure that Sn...

A data engineer is tasked with designing a Snowflake solution for a financial services company that needs to perform real-time fraud detection. The solution needs to leverage exter...

Which of the following statements correctly describes the benefits of Snowflake's Data Cloud in the context of data sharing and collaboration?

Consider a scenario where you need to create a custom function (UDF) in Snowflake that uses an external Python library not available in the Snowflake Anaconda channel. How would yo...

You have a Snowflake table named `CUSTOMER DATA' with columns `CUSTOMER ID', `NAME, 'CITY, and 'TRANSACTION DATE. You need to implement a data masking policy that masks the 'NAME c...

A data warehouse architect is designing a Snowflake environment for a large retail company. The company has diverse data workloads, including batch data ingestion, real-time analyt...

A data engineer needs to schedule a Snowflake task to refresh a materialized view named 'mv customer summary' every hour. They want to ensure that Snowsight is used to monitor the...

You are using Snowsight to analyze query performance. You notice a query that frequently accesses a table 'orders' is slow. Which of the following Snowsight features and actions co...

A Snowflake administrator needs to grant a data analyst the ability to create dashboards and worksheets in Snowsight, but restrict them from modifying existing roles or granting pr...

You are using Snowsight to monitor a data pipeline that involves several tasks chained together using 'AFTER' dependencies. One of the intermediate tasks, is failing intermittently...

A team is using Snowsight for developing and testing SQL queries. They want to ensure that all queries executed by a specific user, analystl', are automatically tagged with a custo...

A data engineer is using Snowflake Notebooks to perform exploratory data analysis on a large dataset stored in a Snowflake table called 'ORDERS. They want to calculate the total or...

A data scientist is working on a machine learning project using Snowflake Notebooks. They have a dataset stored in Snowflake and need to perform feature engineering. They want to w...

A data analyst wants to schedule a Snowflake Notebook to automatically refresh a dashboard that relies on the results of a complex data transformation pipeline. Which of the follow...

A junior data engineer is having trouble connecting to Snowflake from a Snowflake Notebook using Snowpark. They receive the following error: `snowflake.snowpark.exceptions.Snowpark...

A data scientist wants to use a library, 'special_function', within a Snowflake Notebook, but that library is not pre-installed in the Snowflake environment. The data scientist doe...

You are using the Snowflake web interface to execute SQL queries. You want to save a specific query for future use. Which of the following methods allows you to effectively save an...

You are developing a Snowpark Python application that needs to read data from an external stage. You have already created the stage named which points to an AWS S3 bucket containin...

A Snowflake user reports that their worksheet intermittently freezes or becomes unresponsive when executing complex SQL queries that involve large datasets. Which of the following...

You have a Python script that uses Snowpark to connect to Snowflake. You want to ensure that the connection parameters, such as account identifier, username, password, and database...

A data engineer is using the Snowflake web UI to execute a complex SQL query involving multiple joins and aggregations. The query is running slower than expected. What are the most...

A Snowflake administrator is tasked with setting up role-based access control (RBAC) to manage access to different objects within Snowflake using the web UI. Which of the following...

A junior data engineer is using the Snowflake web UI to create a view based on a complex query against a large dataset. They want to optimize the view for performance. Which of the...

A data engineer needs to load data from an Amazon S3 bucket into Snowflake. The data is in CSV format, compressed with GZIP, and contains a header row. They want to use Snowpipe fo...

You are using the Snowsight user interface to monitor the performance of a Snowflake warehouse. You notice that the average query execution time is consistently high. Which of the...

A Snowflake table 'CUSTOMER DATA' contains Personally Identifiable Information (PII). You need to mask the 'EMAIL' column for users with the 'ANALYST' role, while allowing users wi...

You are tasked with loading data from a large number of small CSV files (each less than IOMB) stored in an S3 bucket into a single Snowflake table. You anticipate frequent addition...

A data engineer executed several queries in Snowflake using Snowsight, and now needs to identify the specific queries that inserted data into the 'SALES TABLE' table within the 'SA...

You are using Snowsight to monitor the performance of several queries. You notice a query that took significantly longer than expected. Which of the following actions, available di...

A junior data analyst accidentally deleted a critical table using Snowsight. After restoring the table from Time Travel, they want to prevent this from happening again. What is the...

Using Snowsight, you observe a query with the following SQL: FROM LARGE_TABLE WHERE ID IN (SELECT ID FROM SMALL_TABLE WHERE CONDITION - SELECT The query is performing poorly. When...

A data engineer needs to create a new external stage in Snowflake to access data stored in AWS S3. The S3 bucket is encrypted using AWS KMS. Which of the following SQL commands is...

Which of the following statements about creating databases and schemas in Snowflake are TRUE? (Select TWO)

A data engineer is trying to create a new internal stage named in Snowflake using the following command: 'CREATE OR REPLACE STAGE FILE FORMAT = (TYPE = CSV COMPRESSION = GZlP)f. Af...

You need to create a database named 'SALES DB' that is only accessible to users with the 'ACCOUNTADMIN' role. After the database is created, you want to grant the 'USAGE' privilege...

You are tasked with creating an external stage pointing to an Azure Blob Storage container. You need to choose the MOST SECURE method for authentication. Which combination of the f...

What does a "green" cell execution status indicate in Snowflake Notebooks?

When querying semi-structured data in Snowflake, which function extracts a specific field from a JSON document?

What MOST accurately describes Snowflake?

What is the PRIMARY purpose for using the PARSE_DOCUMENT function when using a Cortex LLM?

Which two actions are possible within a single Snowflake Notebook session? (Choose two)