SOL-C01 Practice Questions

A data engineer needs to create a new database named `SALES DATA for storing sales transactions. They want to ensure that only users with the 'DB_ADMIN' role can manage the databas...

A user named 'DATA LOADER is responsible for loading data into a table named 'ORDERS' in the 'PUBLIC' schema of the 'SALES DB' database. Initially, 'DATA LOADER had the 'INSERT' pr...

You have been tasked with configuring a session parameter for all users connecting to a specific Snowflake database named REPORTING DB'. You want to set the 'TIMEZONE parameter to...

You are working with a table named 'EMPLOYEES in the 'PUBLIC' schema of the 'COMPANY DATA' database. The table contains sensitive Personally Identifiable Information (PII). You nee...

A table 'CUSTOMER DATA' exists within the 'PUBLIC" schema of the database 'CUSTOMER DB'. The table contains a column named 'CUSTOMER ID. You need to create a sequence named 'CUSTOM...

A data engineer is tasked with creating a new database called `SALES DATA within a Snowflake account. They want to ensure that only users with the 'ACCOUNTADMIN' role or a custom r...

A user executes the following SQL command in Snowflake: `SELECT CURRENT DATABASE(), CURRENT SCHEMA(), CURRENT ROLE(), CURRENT The user's current role is , and they are connected to...

A Snowflake administrator is configuring network policies for their organization. They need to restrict access to their Snowflake account to only specific IP addresses associated w...

You are exploring a large dataset in Snowflake with millions of rows. You want to get a quick overview of the data types and basic statistics for each column in a table named 'ORDE...

A user is trying to transfer ownership of a view from role `role_a' to The user executes the following command: ALTER VIEW employee_view TRANSFER OWNERSHIP TO ROLE role_b; The comm...

A data warehouse contains a table named 'ORDERS in schema `SALES'. The current owner of the `ORDERS' table is the `ANALYST role. The compliance team requires that the ownership be...

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

A data engineer is tasked with migrating a legacy data warehouse to Snowflake. They need to create a database named 'SALES DATA and a schema named 'TRANSACTIONS within it. The sche...

A Snowflake account administrator needs to configure a resource monitor to limit the credit consumption of a specific virtual warehouse named 'ANALYTICS WH'. The resource monitor s...

A junior data analyst accidentally dropped a schema named 'STAGING' in the 'RAW DATA' database. They need to recover the schema and its contents as quickly as possible. Which of th...

You are designing a data pipeline in Snowflake where raw data is ingested into a staging schema, transformed, and then loaded into a production schema. You want to ensure that only...

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

You need to configure Snowflake to automatically suspend a virtual warehouse named `ANALYTICS after 10 minutes of inactivity and resume it when a query is submitted. Which of the f...

You are tasked with securing sensitive data in a table called `CUSTOMER DATA'. You want to grant the 'SELECT privilege on this table to a role called 'ANALYST ROLE, but prevent the...

You have a table named 'ORDERS' with a column 'ORDER DATE of data type DATE. You need to write a SQL query to retrieve all orders placed in the month of January 2023. Which of the...

A Snowflake account has the following network policy configured: { "name": "corporate_network", "allowed_ip_list": ["192.168.1.0/24", "10.0.0.10"], "blocked_ip_list": ["192.168.1.5...

A data engineer needs to transfer ownership of a database named 'SALES DATA' to a role named 'DATA GOVERNANCE The engineer attempts to use the following command: 'GRANT OWNERSHIP O...

You have created a new database named 'DEV DB' and want to grant the "SELECT' privilege on all tables within this database to the 'ANALYST' role. You want to ensure that any new ta...

Which of the following statements are true regarding the 'SELECT ' command in Snowflake?

You are tasked with optimizing a Snowflake query that frequently uses the 'SALES' table. This table has a large number of rows, and users often filter the data based on the 'ORDER...

A user executes the following SQL statement in Snowflake: SELECT FROM MY TABLE; The user reports that the query is running very slowly. Assuming the user has the necessary permissi...

A data engineer needs to grant SELECT privileges on all tables within a newly created schema named 'SALES DATA' to a role called 'ANALYST ROLE'. However, new tables may be added to...

You have a table named 'CUSTOMER ORDERS with columns `customer id', `order date' , and 'order amount'. You want to retrieve the top 5 customers who placed orders on a specific date...

You are tasked with transferring ownership of a database named 'FINANCIAL DATA' from the 'ACCOUNTADMIN' role to a custom role named 'DATA GOVERNANCE'. After the transfer, the 'DATA...

You have a table named 'PRODUCT SALES' with columns 'product id', 'sale date', 'region', and 'sales_amount'. You need to create a query that returns the top 3 products by total sal...

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

A data engineer is tasked with loading JSON data representing customer interactions into Snowflake. The JSON files contain varying schemas and nested arrays. To optimize query perf...

A Snowflake administrator observes slow query performance when querying data loaded from a large set of compressed CSV files stored in an external stage (AWS S3). Which of the foll...

You are loading data from an external stage into a Snowflake table. Some of the rows in the data files contain invalid characters that cause the load operation to fail. You want to...

A team is developing a data pipeline to load data from various sources into Snowflake. They are using external stages pointing to AWS S3 buckets and want to ensure maximum security...

A data engineering team is loading data from a CSV file containing customer information into a Snowflake table. The CSV file occasionally contains malformed data, such as missing f...

A Snowflake account uses separate virtual warehouses for different workloads: 'REPORTING WI- 4' for reporting queries and 'TRANSFORM WH' for data transformation jobs. A user, Alice...

You are loading JSON data into Snowflake. The JSON data contains nested arrays and objects. You need to flatten specific arrays while retaining other nested structures for analysis...

You are tasked with loading data from an external stage containing gzipped CSV files into a Snowflake table. The CSV files have a header row that you want to skip during the load p...

You have a Snowflake virtual warehouse named 'ANALYTICS WH' that is used for complex data transformations. You need to ensure that the warehouse automatically suspends itself when...

You are designing a data ingestion pipeline for a SaaS application that generates JSON log files daily. These files are uploaded to an AWS S3 bucket. You need to load this data int...

A data engineer is loading data into Snowflake from an external stage. They need to transform data during the load process. Which of the following is the MOST efficient and recomme...

You have a JSON file stored in an internal stage containing customer data with varying schem

A data warehouse contains a table 'ORDERS' with columns 'ORDER ID', 'CUSTOMER ID', 'ORDER DATE, and `ORDER TOTAL' You need to optimize a query that frequently retrieves the total o...

Which of the following statements are true regarding considerations when working with VARIANT data types in Snowflake? (Select all that apply)

You are working with a very large table 'TRANSACTIONS' and need to improve the performance of queries that filter data based on a specific range of transaction timestamps. Which of...

You are tasked with loading JSON data containing customer information into Snowflake. The JSON structure is complex and varies across records. You want to optimize query performanc...

You have a Snowflake virtual warehouse named 'XSMALL WI-4' configured to auto-suspend after 5 minutes of inactivity. You execute a complex query that takes 7 minutes to complete. W...

Consider a scenario where you are loading data from an external stage (AWS S3) into a Snowflake table. The data contains date fields in various formats. You want to ensure that all...

You are responsible for optimizing data loading into Snowflake from a large set of CSV files stored in Azure Blob Storage. The files contain millions of records and are updated dai...