SOL-C01 Practice Questions

You have a Python script running in a Snowflake Notebook that retrieves data from a Snowflake table, performs some complex calculations, and then visualizes the results using Matpl...

You are tasked with creating a Snowflake Notebook that reads data from an external stage (AWS S3), transforms it using Python, and then loads the transformed data into a Snowflake...

You are using a Snowflake Notebook to perform data analysis on a large dataset. As part of your analysis, you need to create a custom Python function that calculates a complex metr...

You're writing a Snowflake Notebook that needs to dynamically create tables based on a list of table names stored in a Python list called 'table_names'. You want to iterate through...

A data engineer needs to create a new database named `SALES DATA in Snowflake. They want to ensure that only users with the 'ACCOUNTADMIN' role can initially modify the database. A...

A Snowflake administrator needs to determine the default collation setting for a newly created database. Which of the following methods can be used to identify the default collatio...

A Snowflake user is attempting to query a table named 'CUSTOMERS within the `SALES DB.PUBLIC' schema. However, they are receiving an error indicating insufficient privileges. Assum...

A Snowflake environment has two databases, 'DEV DB' and 'PROD DB'. A table 'EMPLOYEES' exists in both databases with identical schemas. A developer needs to create a view in 'DEV D...

A data analyst wants to clone the 'SALES DB' database to create a development environment called "DEV SALES DB'. The analyst needs to ensure that all schemas within 'SALES DB' , in...

A data engineer is tasked with creating multiple schemas within a Snowflake database called 'SALES DB'. These schemas need to be isolated from each other to prevent accidental data...

You are tasked with deploying a new data application to Snowflake. This application requires several schemas for staging, transformation, and reporting. What is the recommended app...

Which of the following statements are true regarding schemas in Snowflake? (Select TWO)

A Snowflake administrator wants to ensure that all newly created schemas in a specific database automatically inherit certain grants (e.g., 'SELECT' privilege on all tables in the...

You have a Snowflake environment with a database named 'ANALYTICS DB'. You need to load data into a table named 'CUSTOMER DATA' that resides in a schema called 'RAW DATA" within 'A...

A data engineer needs to create a table named 'EMPLOYEES in the `PUBLIC' schema of the database 'COMPANY DATA'. The table should store employee IDs as integers, names as strings, a...

You are tasked with optimizing a frequently queried table 'SALES DATA' that experiences many updates. Which of the following Snowflake table features can significantly improve quer...

You have a table named 'CUSTOMER ORDERS' with columns 'ORDER ID', 'CUSTOMER ID', and 'ORDER DATE'. You want to create a clone of this table for testing purposes, ensuring the clone...

Which of the following statements about External Tables in Snowflake are true?

You have a permanent table 'ORDERS' in your Snowflake database. You want to create a temporary table 'TEMP ORDERS' that will automatically be dropped at the end of your session. Yo...

A data analyst needs to create a view named that aggregates sales data by month. The base table sales_transactions' contains columns 'transaction_id' , 'transaction_date' , and 'sa...

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

A data engineer is tasked with creating a hierarchical structure for managing data access. They need to create a database named 'analytics db', a schema named 'reporting schema', a...

You have two tables, `employees' and `departments'. The `employees' table contains employee information, including 'employee_id' and The `departments' table contains department inf...

You have a large table called with columns such as and `event_data' . You want to create a view named that calculates the number of distinct users active each day. This view will b...

A data engineer needs to create a table in Snowflake to store JSON data from an external API. The API returns a nested JSON structure that is frequently updated with new fields. Wh...

A Snowflake administrator is tasked with managing storage costs. They notice that several large tables are rarely queried. Which of the following strategies are MOST effective for...

Consider the following SQL code snippet intended to insert data into a Snowflake table named 'employees'. However, the execution results in a data type mismatch error. Analyze the...

You have a Snowflake database named 'SALES DB' containing schemas 'RAW' and 'TRANSFORMED'. The 'RAW' schema holds raw data ingested from various sources, and the 'TRANSFORMED' sche...

A Snowflake table 'ORDERS' contains a 'ORDER DATE' column of data type DATE. You need to write a query that returns the order count for each month in the year 2023. Which of the fo...

A security architect is designing a role hierarchy in Snowflake for a data analytics team. They need to grant specific privileges to different user groups. 'DATA ENGINEER' role sho...

A Snowflake administrator needs to implement RBAC for accessing a highly sensitive dataset. They decide to create several custom roles: 'DATA OWNER, `DATA CURATOR, 'DATA ANALYST, a...

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

A Snowflake account has the following role hierarchy: - ACCOUNTADMIN - SECURITYADMIN - DB_ADMIN - ETL USER - REPORT USER SECURITYADMIN reports to ACCOUNTADMIN, DB_ADMIN reports to...

A data warehouse has a role hierarchy where 'ANALYST' reports to 'DATA SCIENTIST' and 'DATA SCIENTIST' reports to 'DATA ENGINEER'. The 'ANALYST' role needs to create and use user-d...

A data engineer needs to grant a business analyst role ('BI ANALYST) the ability to query data in a specific schema ('SALES DATA) within a database ('REPORTING DB'). The business a...

You have a custom role named 'TRANSFORM ROLE that needs to load data into a table called 'ORDERS'. You want to ensure that this role can only load data into this specific table and...

A security auditor has identified that several users have been granted the role directly. Your company's security policy mandates that 'ACCOUNTADMIN' should only be used in emergen...

A data science team needs to access data from several databases and schemas for model training. To simplify access management, you create a custom role, `DATA SCIENCE ROLE. You nee...

You have a role hierarchy where 'ROLE A' has been granted to 'ROLE B', and 'ROLE B" has been granted to User 'USER X' 'ROLE R has 'SELECT privilege on 'TABLE_I' and 'INSERT' privil...

A Snowflake account has multiple custom roles, including `DATA ADMIN', 'ANALYST , and 'REPORTING'. The `DATA ADMIN role should be able to grant all privileges on any object in the...

You are designing a data warehouse in Snowflake. You need to ensure that users in the 'REPORTING TEAM' can only view data in the 'SALES TABLE table after it has been masked to hide...

A company wants to implement row-level security in their Snowflake data warehouse to restrict access to sales data based on the user's region. They have a table 'SALES with a 'REGI...

A data engineer needs to grant a group of analysts the ability to query data in the 'SALES DB.PUBLIC.ORDERS table, but prevent them from seeing any personally identifiable informat...

A security auditor discovers that multiple users are using the 'ACCOUNTADMIN' role directly for their daily tasks. This violates the principle of least privilege. Which of the foll...

You need to implement a data governance strategy that ensures data stewards can only access specific columns within a table to perform data quality checks. The table is `RAW DATA.P...

A data engineer is tasked with ensuring that only authorized personnel can access sensitive data within a Snowflake database named 'SALES DB'. They need to implement a row-level se...

You are responsible for managing a Snowflake environment where data loading and transformation are performed. You need to monitor the resource consumption of various tasks and iden...

You are tasked with creating a secure data sharing environment in Snowflake. You need to share a table named 'CUSTOMER RECORDS' from the `SALES DB' database in your account (Accoun...

A Snowflake administrator needs to audit all grants and revocations performed on a specific table named 'EMPLOYEES' within the DATABASE. They want to capture the timestamp, grantor...

A data scientist needs to create a temporary table in Snowflake to perform some data analysis. The table should only be accessible within their current session and should be automa...