SnowPro Core Exam Questions and
Answers 100% Verified
SQL Standards Organization - ANSWER - ANSI
Transaction Compliance - ANSWER - ACID
Storage cost per terabyte - ANSWER - $42
Service Layer Components (5) - ANSWER - Authentication
Infrastructure Management
Metadata
Security
Transaction Manager
Data Science Partners - ANSWER - Sagemaker
Dataiku
Datarobot
Account-level Objects (7) - ANSWER - Network Policy
User
Role
Database
Warehouse
Share
Resource Monitor
Credit usage rate for cloud services - ANSWER - 4.4 credits per hour
,Snowflake Scripting - ANSWER - Extension of Snowflake SQL that allows for additional
functionality in SQL (variable declarations, exception handling, if/else branching, loops, etc)
Snowpark - ANSWER - API accessed outside of the snowflake interface using Java, Scala,
Python, or SQL
Two access control frameworks used by Snowflake - ANSWER - Role-based and Discretionary
Schema-level Objects (8) - ANSWER - Stage
Pipe
Procedure
Function
Table
View
Task
Stream
Namespace Format - ANSWER - DB_Name. Schema_Name
DB and Schema Naming Rules - ANSWER - Must have unique identifier
Must start with letter
No spaces or special characters
If enclosed in double quotes - null above rule and case sensitive
Time Travel Retention Period for Permanent Tables - ANSWER - 1 (default) to 90 days
Time Travel Retention Period for Temporary Tables - ANSWER - 1 day
Time Travel Retention Period for Transient Tables - ANSWER - 1 day
Time Travel Retention Period for External Tables - ANSWER - 0 days
, Fail-safe for Permanent Tables - ANSWER - 7 days
Materialized views bill compute resources as a - ANSWER - serverless feature
UDFs can return what result types - ANSWER - scalar
tabular
Limitations of external functions - ANSWER - slower
scalar only
not shared
less secure
extra charges
You can create a tree with up to ___ total tasks - ANSWER - 1000
Parent tasks can have up to ___ tasks - ANSWER - 100
Streams are used to view and track ___ changes on a table - ANSWER - DML
Two account types (billing) - ANSWER - Pay-as-you-go
Capacity
Billable Resources (5) - ANSWER - Virtual Warehouses
Cloud Services
Serverless Services
Storage ($)
Data Transfer ($)
What SQL commands use cloud services instead of VWs (3) - ANSWER - CREATE TABLE
Answers 100% Verified
SQL Standards Organization - ANSWER - ANSI
Transaction Compliance - ANSWER - ACID
Storage cost per terabyte - ANSWER - $42
Service Layer Components (5) - ANSWER - Authentication
Infrastructure Management
Metadata
Security
Transaction Manager
Data Science Partners - ANSWER - Sagemaker
Dataiku
Datarobot
Account-level Objects (7) - ANSWER - Network Policy
User
Role
Database
Warehouse
Share
Resource Monitor
Credit usage rate for cloud services - ANSWER - 4.4 credits per hour
,Snowflake Scripting - ANSWER - Extension of Snowflake SQL that allows for additional
functionality in SQL (variable declarations, exception handling, if/else branching, loops, etc)
Snowpark - ANSWER - API accessed outside of the snowflake interface using Java, Scala,
Python, or SQL
Two access control frameworks used by Snowflake - ANSWER - Role-based and Discretionary
Schema-level Objects (8) - ANSWER - Stage
Pipe
Procedure
Function
Table
View
Task
Stream
Namespace Format - ANSWER - DB_Name. Schema_Name
DB and Schema Naming Rules - ANSWER - Must have unique identifier
Must start with letter
No spaces or special characters
If enclosed in double quotes - null above rule and case sensitive
Time Travel Retention Period for Permanent Tables - ANSWER - 1 (default) to 90 days
Time Travel Retention Period for Temporary Tables - ANSWER - 1 day
Time Travel Retention Period for Transient Tables - ANSWER - 1 day
Time Travel Retention Period for External Tables - ANSWER - 0 days
, Fail-safe for Permanent Tables - ANSWER - 7 days
Materialized views bill compute resources as a - ANSWER - serverless feature
UDFs can return what result types - ANSWER - scalar
tabular
Limitations of external functions - ANSWER - slower
scalar only
not shared
less secure
extra charges
You can create a tree with up to ___ total tasks - ANSWER - 1000
Parent tasks can have up to ___ tasks - ANSWER - 100
Streams are used to view and track ___ changes on a table - ANSWER - DML
Two account types (billing) - ANSWER - Pay-as-you-go
Capacity
Billable Resources (5) - ANSWER - Virtual Warehouses
Cloud Services
Serverless Services
Storage ($)
Data Transfer ($)
What SQL commands use cloud services instead of VWs (3) - ANSWER - CREATE TABLE
