SOL-C01 Exam Questions
282 real SOL-C01 exam questions with expert-verified answers and explanations. Page 6 of 6.
- Question #280Data Loading and Unloading
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...
Session ContextInternal StagesDDLError Troubleshooting - Question #281Snowflake Account and Security
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...
Role-Based Access ControlDatabase ManagementPermissionsDDL/DCL - Question #282Data Loading and Unloading
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...
External StagesAzure AuthenticationSecurity Best PracticesStorage Integration - Question #283Querying and Performance
What does a "green" cell execution status indicate in Snowflake Notebooks?
Snowflake NotebooksCell Execution StatusUI IndicatorsQuery Execution - Question #284Querying and Performance
When querying semi-structured data in Snowflake, which function extracts a specific field from a JSON document?
semi-structured dataJSONPARSE_JSON functiondata extraction - Question #285Snowflake Overview and Architecture
What MOST accurately describes Snowflake?
Snowflake platformData CloudAI capabilitiesPlatform overview - Question #286Querying and Performance
What is the PRIMARY purpose for using the PARSE_DOCUMENT function when using a Cortex LLM?
PARSE_DOCUMENTCortex LLMContent ExtractionDocument Processing - Question #287Querying and Performance
Which two actions are possible within a single Snowflake Notebook session? (Choose two)
Snowflake NotebooksSQL ExecutionData LoadingData Querying - Question #288Data Loading and Unloading
How can a directory table be enabled in Snowflake?
Directory TablesExternal StagesData LoadingSQL Commands - Question #289Virtual Warehouses
What will occur if a virtual warehouse size is increased from Small to Medium?
Virtual WarehousesWarehouse ScalingCompute CapacityPerformance Tuning - Question #290Querying and Performance
A data scientist is using Snowflake Notebooks to analyze sales data. They have encountered a situation where a specific cell containing a complex UDF that calculates customer lifet...
Snowflake NotebooksUDFDebuggingStored Procedures - Question #291Virtual Warehouses
A Snowflake Notebook is being used to train a machine learning model. The notebook contains multiple cells: one to load data, one to perform feature engineering, and one to train t...
Virtual Warehouse SizingResource ManagementSnowpark MLNotebook Troubleshooting - Question #293Querying and Performance
You're using a Snowflake Notebook to collaboratively develop a data pipeline. Several team members are working on the same notebook concurrently. One team member accidentally delet...
Snowflake NotebooksCode RecoveryVersion ControlQuery History - Question #294Querying and Performance
A Snowflake Notebook is configured to run a series of data processing steps on a schedule using the Snowflake Task feature. One of the steps involves calling an external API to enr...
Python Error HandlingAPI IntegrationRetry MechanismsSnowflake Notebooks - Question #295Querying and Performance
You are developing a Snowflake Notebook to analyze sales data. You want to create a dynamic SQL query that filters data based on a parameter passed from a user interface element (e...
Dynamic SQLParameterizationSQL Injection MitigationSnowflake Notebooks - Question #296Querying and Performance
You have a Snowflake Notebook that performs several complex data transformations. The notebook is taking longer than expected to run, and you need to optimize its performance. Whic...
Snowflake NotebooksPerformance TuningVirtual Warehouse SizingSQL Optimization - Question #297Querying and Performance
In a Snowflake Notebook, you're attempting to read data from a Snowflake table named 'CUSTOMER DATA into a Pandas DataFrame for further analysis. The table contains a column named...
Snowflake NotebooksPandas integrationData retrievalDatetime handling - Question #298Data Loading and Unloading
You are working with a Snowflake Notebook to process data from an external stage (AWS S3). You need to access the S3 stage using a named stage object and a storage integration conf...
Storage IntegrationExternal StageAWS S3Data Loading - Question #299Querying and Performance
You're building a Snowflake Notebook to automate data quality checks on a daily basis. You have a series of SQL queries, each representing a different quality rule (e.g., checking...
Error HandlingSnowflake NotebooksStored ProceduresData Quality Automation - Question #301Data Loading and Unloading
Within a Snowflake Notebook, you have a Python script that performs several data transformations using Pandas DataFrames and then attempts to load the transformed data into a new S...
Snowflake NotebooksPython/Pandas memory optimizationLarge data processingSnowflake data loading - Question #302Querying and Performance
A data engineer is using Snowflake Notebooks to perform a series of transformations on a large dataset. After executing a cell containing a complex SQL query that includes user-def...
Query performance tuningUDF optimizationWarehouse sizingData skew - Question #303Querying and Performance
You are working with a Snowflake Notebook and need to execute a series of SQL statements that include both DDL (Data Definition Language) and DML (Data Manipulation Language) opera...
TransactionsStored ProceduresSnowflake Scripting - Question #304Querying and Performance
You are developing a data pipeline in Snowflake Notebooks. One cell contains Python code that uses the Snowpark DataFrame API to perform several data transformations. After executi...
Snowflake NotebooksSnowparkQuery ExecutionQuery Management - Question #305Querying and Performance
You are using Snowflake Notebooks to create a visualization based on data retrieved from a Snowflake table. You have the following code in a cell:
Snowflake NotebooksData VisualizationPython LibrariesDML Operations - Question #306Querying and Performance
In Snowflake Notebooks, you execute a cell containing a SQL query that retrieves data from a view based on multiple underlying tables. The execution status shows 'Success', but the...
Result CachingView DefinitionsMaterialized ViewsTroubleshooting - Question #307Snowflake Account and Security
A data engineer is building a Snowflake Notebook to perform some data transformations. The notebook interacts with a Snowflake table named 'SALES DATA' which contains columns like...
AuthenticationSecurity Best PracticesStreamlit IntegrationApplication Access Control - Question #308Querying and Performance
You are developing a Streamlit application that visualizes data from a Snowflake table called `CUSTOMER ORDERS. The application needs to display the total order amount for each cus...
Query OptimizationSnowflake ViewsData AggregationCost Optimization - Question #311Querying and Performance
A data scientist has developed a Streamlit application within a Snowflake Notebook to perform predictive analytics on customer churn. The application uses a pre-trained machine lea...
SnowparkUser-Defined Functions (UDFs)Machine Learning InferenceStreamlit - Question #315Querying and Performance
You are developing a Snowflake Notebook to perform data transformations using Snowpark. As part of the transformation, you need to filter a DataFrame based on a dynamically generat...
SnowparkDataFrame FilteringDynamic SQLData Type Handling - Question #316Snowflake Account and Security
What is the purpose of using the SHOW GRANTS ON SQL command for a specific object?
SHOW GRANTSPermissionsSQL commandsSecurity - Question #317Snowflake Overview and Architecture
Which two statements describe Snowflake's elasticity features? (Choose two)
ElasticityCompute ScalingStorage ScalingCloud Architecture - Question #318Snowflake Overview and Architecture
Which task is performed in the Cloud Services layer in the Snowflake architecture?
Snowflake ArchitectureCloud Services LayerQuery Optimization