Latest [Mar 16, 2026] 100% Passing Guarantee – Brilliant SOL-C01 Exam Questions PDF [Q103-Q127]

NEW QUESTION 103
What file formats can be loaded into Snowflake using the COPY INTO command? (Choose any 3 options)

NEW QUESTION 104
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 could you use to identify potential bottlenecks and improve query performance? Select all that apply.

NEW QUESTION 105
What is the primary purpose of the LIMIT clause in a Snowflake query?

NEW QUESTION 106
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 for null values, duplicate records, invalid date formats). You want to implement error handling so that if one quality check fails, the notebook continues to execute the remaining checks and logs the errors.
Which is the most robust approach to achieve this within the Snowflake Notebook environment, minimizing code complexity and maximizing fault tolerance?

NEW QUESTION 107
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 their Snowflake environment. Which of the following strategies BEST leverage Snowflake’s elastic storage and compute capabilities to handle these fluctuating workloads efficiently and cost- effectively?

NEW QUESTION 108
Role ‘DATA ENGINEER’ owns the external stage. The security team mandates that ownership be transferred to ADMIN’. Post-transfer, which privileges are automatically revoked or changed for the ‘DATA ENGINEER role?

NEW QUESTION 109
What is created in the Cloud Services layer of the Snowflake architecture?

NEW QUESTION 110
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 notice that the query performance is slow, even when filtering by ‘METADATA$FILENAME’. What strategies can you implement to optimize the performance of querying the directory table?

NEW QUESTION 111
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’ with a ‘TEXT column. However, you are consistently encountering the following error: ‘SQL compilation error:
Unsupported feature ‘External functions”. What is the MOST likely cause of this error?

NEW QUESTION 112
You have a base table called `customer data’ which contains sensitive information like credit card numbers. You need to create a view called that exposes only non-sensitive columns (e.g., customer_id, customer_name, city) and hides the logic of the underlying table’s structure.
Additionally, you want to ensure that no user can directly query the ‘customer_data’ table. Which of the following steps are necessary to achieve this?

NEW QUESTION 113
How can you query nested fields in semi-structured data in Snowflake? (Choose any 2 options)

NEW QUESTION 114
A Snowflake data provider wishes to share a database ‘PRODUCTS DB’ with a consumer account using a private data share. The provider wants to ensure the consumer can only query objects in ‘PRODUCTS DB’ but cannot create new objects within the shared database. The data provider executes the following commands:

NEW QUESTION 115
How can roles access objects in Snowflake? (Choose any 2 options)

NEW QUESTION 116
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 order amount per day and visualize the results as a line chart directly within the notebook. Which sequence of actions represents the MOST efficient and correct way to achieve this?

NEW QUESTION 117
A data engineer wants to transfer ownership of a database named ‘SALES DATA’ to a role named ‘DATA ADMIN’. The data engineer executes the following command: ‘”sql GRANT OWNERSHIP ON DATABASE SALES DATA TO ROLE DATA ADMIN; However, the command fails. Which of the following is the MOST likely reason for the failure?

NEW QUESTION 118
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. Which of the following approaches is MOST efficient and allows for easy updates to the log format without redeploying the UDF?

NEW QUESTION 119
What is the SHOW GRANTS SQL command primarily used for?

NEW QUESTION 120
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 enrich the data.
Due to network instability, the API calls occasionally fail, causing the entire task to fail. You want to implement error handling within the notebook to retry failed API calls up to a certain number of times before giving up. Assuming you are using Python within the Snowflake Notebook and Snowpark, how would you best implement this retry mechanism while ensuring minimal disruption to the notebook’s workflow and preserving error information?

NEW QUESTION 121
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 format.
However, you are encountering errors because some of the JSON documents contain deeply nested arrays and objects, leading to excessive memory consumption during the INSERT operation. Which of the following actions can you take to mitigate this issue and successfully load the data using the ‘INSERT’ command with data from a stage? Choose TWO.

NEW QUESTION 122
Which SQL clause is used to query historical data in Snowflake using Time Travel?

NEW QUESTION 123
What is the purpose of the COMPLETE function in Snowflake Cortex?

NEW QUESTION 124
Which of the following statements are true regarding the ‘SELECT ‘ command in Snowflake?

NEW QUESTION 125
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 named
‘customer_data’ and contains features like ‘age’, ‘income’, ‘transaction _ history’, and a target variable `churn’. The data scientist intends to use Snowpark ML for model training. Which of the following steps are REQUIRED to enable this scenario?

NEW QUESTION 126
A data engineer has created a custom role `ETL ROLE responsible for loading data into a Snowflake warehouse. This role needs to be able to truncate tables within a specific schema
`RAW DATA. Which of the following is the most secure and appropriate way to grant this privilege to ‘ETL ROLE?

NEW QUESTION 127
You are working with a Snowflake environment where cost optimization is critical. You need to limit the amount of data scanned by a specific query executed by a user with the ‘ANALYST role.
Which of the following options represent valid methods to achieve this, considering both query- level and account- level settings?