Snowflake SnowPro Certification Quiz – Q&A
Maximum number of tasks in a tree ✔️Ans - 1000
SNOWSQL default directory ✔️Ans - ~/.snowsql%USERPROFILE%
\.snowsql
set configuration ✔️Ans - -o or --option
!set
config
Can you run snowDC for HTTP ✔️Ans - Yes
Who can create database from share ✔️Ans - AccountAdmin or the one with
Import Share permissions
Data Sharing & Data Replication - does they support Future grants ✔️Ans -
No
What will happen to PIPE when you Clone Database of Schema ✔️Ans - it
will clone PIPE
How many days - Load History in metadata for Table Copy ✔️Ans - 64
How many days - History in metadata for Snow PIPE ✔️Ans - 14
What is data exchange in snowflake ✔️Ans - It is a market place that utilize
secure data sharing
What does newly created reader account contains ✔️Ans - Only one user -
Administrator
Can you share a Standard View ✔️Ans - No
Can you share a Secure View ✔️Ans - Yes
Can you share data from multiple database ✔️Ans - Yes, as long as they
belong to same account by creating secure Views
,What access is needed to share secure View ✔️Ans - You should give
REFERENCE_USAGE privilege on each database referenced by Secure View
No Need to grant REFERENCE_USAGE on database where Secure View is
created
What does each Share consist of ✔️Ans - Privileges that grant access to the
database and schema containing.
Specific Objects
Consumer Accounts
Snowflake SCIM Can be used to ✔️Ans - Manage User
Manage Roles
Auditing
SCIM Can import roles from ✔️Ans - Okta
Azure AD
Custom build applications
Encrypted Key Hirearcy ✔️Ans - Root key
Account Master Key
Table Key
File Key
When databases is cloned,what will happen to Future Objects Privilege
✔️Ans - They copy the Privilege from source schema
Does DataSharing and Data Replication support Future granting ✔️Ans - No
Will Clone Objects will clone Privileges ✔️Ans - No
Does OUATH support Key Pair Authentication ✔️Ans - Yes
Who can Grant Privileges with Managed Access Schema ✔️Ans - Schema
Owner
Role with Mange Grants Privilege
How does SNowflake Support OAUTH ✔️Ans - Through Integration
, Native IDP Provider ✔️Ans - Okta
Microsft ADFS
Network Policies support what Protocol(IPV4 or IPV6 or both) ✔️Ans -
IPV4
Types of Parameters ✔️Ans - Account
Session
Object
Access required to Modify Resource Monitor ✔️Ans - Modify
Monitor
Data Transfer Charges ✔️Ans - Same Cloud Platform - One Region to Other
region.
Out of Cloud Platform - Everything
Compare rows in random set of tables in Primary and Secondary Databases
✔️Ans - HASH_AGG
Default Replication Duration ✔️Ans - 2 days
Can be extended to 7 days using STATEMEMT TIME OUT in SECONDS
parameter
Compute and Data Storage are dependent on each other ✔️Ans - False
Can you create Snowflake Temporary Stages ✔️Ans - False
True or False - Can you create Snowflake Temporary Tables ✔️Ans - True
Snowflake automatically Encrypt Internal Stage data ✔️Ans - True
True or False - Snowflake Automatically Encrypt data in External Stage
✔️Ans - No
All Virtual Wareshouse in your account has access to Same data ✔️Ans - Yes
Two Modes in which multi-cluster warehouse can run ✔️Ans - Maximized
Maximum number of tasks in a tree ✔️Ans - 1000
SNOWSQL default directory ✔️Ans - ~/.snowsql%USERPROFILE%
\.snowsql
set configuration ✔️Ans - -o or --option
!set
config
Can you run snowDC for HTTP ✔️Ans - Yes
Who can create database from share ✔️Ans - AccountAdmin or the one with
Import Share permissions
Data Sharing & Data Replication - does they support Future grants ✔️Ans -
No
What will happen to PIPE when you Clone Database of Schema ✔️Ans - it
will clone PIPE
How many days - Load History in metadata for Table Copy ✔️Ans - 64
How many days - History in metadata for Snow PIPE ✔️Ans - 14
What is data exchange in snowflake ✔️Ans - It is a market place that utilize
secure data sharing
What does newly created reader account contains ✔️Ans - Only one user -
Administrator
Can you share a Standard View ✔️Ans - No
Can you share a Secure View ✔️Ans - Yes
Can you share data from multiple database ✔️Ans - Yes, as long as they
belong to same account by creating secure Views
,What access is needed to share secure View ✔️Ans - You should give
REFERENCE_USAGE privilege on each database referenced by Secure View
No Need to grant REFERENCE_USAGE on database where Secure View is
created
What does each Share consist of ✔️Ans - Privileges that grant access to the
database and schema containing.
Specific Objects
Consumer Accounts
Snowflake SCIM Can be used to ✔️Ans - Manage User
Manage Roles
Auditing
SCIM Can import roles from ✔️Ans - Okta
Azure AD
Custom build applications
Encrypted Key Hirearcy ✔️Ans - Root key
Account Master Key
Table Key
File Key
When databases is cloned,what will happen to Future Objects Privilege
✔️Ans - They copy the Privilege from source schema
Does DataSharing and Data Replication support Future granting ✔️Ans - No
Will Clone Objects will clone Privileges ✔️Ans - No
Does OUATH support Key Pair Authentication ✔️Ans - Yes
Who can Grant Privileges with Managed Access Schema ✔️Ans - Schema
Owner
Role with Mange Grants Privilege
How does SNowflake Support OAUTH ✔️Ans - Through Integration
, Native IDP Provider ✔️Ans - Okta
Microsft ADFS
Network Policies support what Protocol(IPV4 or IPV6 or both) ✔️Ans -
IPV4
Types of Parameters ✔️Ans - Account
Session
Object
Access required to Modify Resource Monitor ✔️Ans - Modify
Monitor
Data Transfer Charges ✔️Ans - Same Cloud Platform - One Region to Other
region.
Out of Cloud Platform - Everything
Compare rows in random set of tables in Primary and Secondary Databases
✔️Ans - HASH_AGG
Default Replication Duration ✔️Ans - 2 days
Can be extended to 7 days using STATEMEMT TIME OUT in SECONDS
parameter
Compute and Data Storage are dependent on each other ✔️Ans - False
Can you create Snowflake Temporary Stages ✔️Ans - False
True or False - Can you create Snowflake Temporary Tables ✔️Ans - True
Snowflake automatically Encrypt Internal Stage data ✔️Ans - True
True or False - Snowflake Automatically Encrypt data in External Stage
✔️Ans - No
All Virtual Wareshouse in your account has access to Same data ✔️Ans - Yes
Two Modes in which multi-cluster warehouse can run ✔️Ans - Maximized
