SOL-C01 Practice Questions
273 real SOL-C01 exam questions with expert-verified answers and explanations. Page 1 of 6.
- Question #1Querying and Performance
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...
Python PerformanceSnowflake NotebooksVectorizationData Processing - Question #2Data Loading and Unloading
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...
External StagesStorage IntegrationsAWS IAM RolesSnowflake Notebooks - Question #3Querying and Performance
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...
Python UDFsUser-Defined FunctionsData TransformationScalability - Question #4Querying and Performance
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...
Dynamic SQLSnowflake NotebooksIdentifier QuotingCREATE TABLE - Question #5Snowflake Account and Security
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...
Database CreationSQL DDLObject OwnershipRole-Based Access Control - Question #6Snowflake Overview and Architecture
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...
Database administrationCollationDESCRIBE commandDatabase properties - Question #7Snowflake Account and Security
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...
PrivilegesAccess ControlSchema PermissionsTable Permissions - Question #8Querying and Performance
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...
ViewsCross-Database QueriesSQL SyntaxSecure Views - Question #9Continuous Data Protection
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...
Database CloningZero-copy CloneCREATE DATABASEDevelopment Environment - Question #10Snowflake Account and Security
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...
SchemasAccess ControlDatabase OrganizationSecurity Best Practices - Question #11Snowflake Overview and Architecture
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...
Infrastructure as CodeSchema managementTerraformMulti-environment deployment - Question #12Snowflake Overview and Architecture
Which of the following statements are true regarding schemas in Snowflake? (Select TWO)
SchemasDatabase ObjectsObject HierarchyLogical Grouping - Question #13Snowflake Account and Security
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...
Future GrantsAccess ControlPrivilege ManagementSchema Automation - Question #14Data Loading and Unloading
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...
Data LoadingCOPY INTOPermissionsSchemas - Question #15Querying and Performance
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...
CREATE TABLEDDLSnowflake Data TypesObject Addressing - Question #16Querying and Performance
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...
Query optimizationClusteringTable featuresPerformance tuning - Question #17Querying and Performance
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...
Table creationSchema managementSQL syntaxZero-copy clone (misuse) - Question #18Data Loading and Unloading
Which of the following statements about External Tables in Snowflake are true?
External TablesData AccessRead-only AccessVirtual Warehouses - Question #19Continuous Data Protection
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...
Temporary TablesData RetentionSQL DDLTable Types - Question #20Snowflake Account and Security
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...
ViewsRole-Based Access Control (RBAC)SQL DDLData Aggregation - Question #21Snowflake Account and Security
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...
Secure ViewsAccess ControlData SecurityViews - Question #22Snowflake Overview and Architecture
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...
Snowflake objectsDatabase hierarchyCREATE DATABASECREATE SCHEMA - Question #23Querying and Performance
You have two tables, `employees' and `departments'. The `employees' table contains employee information, including 'employee_id' and The `departments' table contains department inf...
ViewsMaterialized ViewsSecure ViewsJOIN clause - Question #24Snowflake Account and Security
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...
Row Access PoliciesSecure ViewsData SecurityViews - Question #25Querying and Performance
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...
VARIANT Data TypeJSON DataSemi-structured DataFLATTEN Function - Question #26Continuous Data Protection
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...
Storage CostsTime TravelData RetentionData Compression - Question #27Querying and Performance
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...
Data TypesSQL INSERTType Coercion - Question #28Snowflake Account and Security
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...
Granting PrivilegesRole-Based Access ControlSchema PrivilegesTable Privileges - Question #29Querying and Performance
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...
SQL QueryingDate FunctionsAggregationFiltering - Question #30Snowflake Account and Security
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...
Role-Based Access Control (RBAC)Role HierarchyPrivilege ManagementLeast Privilege Principle - Question #31Snowflake Account and Security
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...
RBACCustom RolesPermissionsGRANT OPTION - Question #32Snowflake Account and Security
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...
RBACPrivilegesGRANT StatementSecurity Best Practices - Question #33Snowflake Account and Security
A Snowflake account has the following role hierarchy: - ACCOUNTADMIN - SECURITYADMIN - DB_ADMIN - ETL USER - REPORT USER SECURITYADMIN reports to ACCOUNTADMIN, DB_ADMIN reports to...
Snowflake RBACPrivilege ManagementCustom RolesLeast Privilege Principle - Question #34Snowflake Account and Security
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...
Role-Based Access ControlGrant PrivilegesUser-Defined Functions (UDFs)Future Grants - Question #35Snowflake Account and Security
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...
Role-Based Access Control (RBAC)Grants and PermissionsLeast Privilege PrincipleTemporary Tables - Question #36Data Loading and Unloading
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...
Least PrivilegeRBACData LoadingCOPY INTO - Question #37Snowflake Account and Security
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...
RBACAccount AdministrationSecurity Best PracticesRole Hierarchy - Question #38Snowflake Account and Security
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...
Role-based Access ControlGRANT statementsFuture GrantsLeast Privilege - Question #39Snowflake Account and Security
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...
Role-Based Access Control (RBAC)Role HierarchyActive RolePrivilege Management - Question #42Snowflake Account and Security
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...
Access ControlRoles and PrivilegesOWNERSHIPRole-Based Access Control - Question #43Snowflake Account and Security
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...
Masking PolicyData SecurityColumn ModificationALTER TABLE - Question #44Snowflake Account and Security
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...
Row-level SecurityRow Access PoliciesData SecurityAccess Control - Question #45Snowflake Account and Security
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...
Data MaskingRole-based Access ControlPrivilegesSecurity Policies - Question #47Snowflake Account and Security
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...
Role-based access control (RBAC)Least privilegeSecurity best practicesMulti-factor authentication (MFA) - Question #48Snowflake Account and Security
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...
Data GovernanceColumn-Level SecuritySecure ViewsAccess Control - Question #50Snowflake Account and Security
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...
Row-Level Security (RLS)Row Access PoliciesData SecurityRole-Based Access Control - Question #51Querying and Performance
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...
TasksMonitoringResource ConsumptionAccount Usage Views - Question #52Data Sharing
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...
Data SharingCross-account sharingSHARE objectPrivileges - Question #53Snowflake Account and Security
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...
Access ControlAuditingGRANTS_HISTORYACCOUNT_USAGE - Question #54Querying and Performance
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...
Temporary TablesSQL SyntaxCREATE TABLESession Management