Snowflake Certification FOR
2024/2025 WITH A+ GRADED
A defined data set can be shared with customers outside the Snowflake account is?
- //Snowflakes's Data Sharing
Query statement encryption is supported on accounts?
A) Standard
B) Enterprise
C) Enterprise for Sensitive (ESD)
D) Virtual Private Snowflake (VPS) - //C) Enterprise for Sensitive (ESD)
True or False: Caching techniques are supported by Snowflake's performance
optimizing query methods? - //True
True or False: B-tree type indexes are supported by Snowflake's performance
optimizing query methods? - //False
True or False: Retrieving results of previous query from cache is supported by
Snowflake's performance optimizing query methods? - //True
True or False: Snowflake security supports user-based access control? - //True
True or False: Federated authentication in Snowflake is complaint with SAML
2.0? - //True
,True or False: Tri-secret requires that customers manage their own keys? - //True
All security information is stored in the ___________ layer in the Snowflake
architecture?
A) Storage
B) Compute
C) Service
D) All of the above - //C) Service
True or False: One benefit of client-side encryption is that it provides a secure
system for managing data in cloud storage? - //True
True or False: One benefit of client-side encryption is that the data is encrypted
before loading into storage layer? - //False
True or False: One benefit of client-side encryption is the storage service layer
only contains encrypted version of the data? - //True
True or False: One benefit of client-side encryption is that queries can be encrypted
on the client side? - //False
True or False: MFA (Multi-factor Authentication) is automatically enabled for
your account and available for all users to self-enroll? - //True
True or False: MFA (Multi-factor Authentication) is an integrated feature powered
by Duo Security service? - //True
,True or False: MFA (Multi-factor Authentication) can be used for connecting to
Snowflake via the Snowflake JDBC driver? - //True
True or False: MFA (Multi-factor Authentication) login is desired only for
connecting to Snowflake through the web interface? - //False
Snowflake includes Role-Based Access Control to enable administrators to:
A) Limit access to data and privileges
B) Manage secure access to the Snowflake account and data
C) Establish role hierarchy and privilege inheritance to align access
D) All of the above - //D) All of the above
With an IdP (identity provider) configured for your account, Snowflake supports
using SSO to connect and authenticate with ODBC Driver? - //True
With an IdP (identity provider) configured for your account, Snowflake supports
using SSO to connect and authenticate with Python Connector? - //True
With an IdP (identity provider) configured for your account, Snowflake supports
using SSO to connect and authenticate with JDBC Driver? - //True
With an IdP (identity provider) configured for your account, Snowflake supports
using SSO to connect and authenticate with SnowSQL? - //
Choosing separate accounts in Snowflake enables users to have:
, A) Different editions of Snowflake and different regions
B) Billing at the account level
C) Simpler database object deployment between environments
D) All of the above - //D) All of the above
True or False: Different editions of Snowflake instances require separate accounts?
- //True
True or False: Snowflake instances in different regions require separate accounts? -
//True
True or False: Data can be shared READ ONLY across accounts, and can be
cloned accounts? - //False
An enterprise view of data is useful because:
A) A data set can be stored once and shared multiple times
B) Data set provisioning is assigned to the owner of the data set
C) Data sets can be shared securely
D) All of the above - //D) All of the above
True or False: Data Sharing is only supported between accounts in the same
Snowflake region? - //True
True or False: A share can't be cloned by a consumer account, but the share data
CAN be copied into a table? - //True
2024/2025 WITH A+ GRADED
A defined data set can be shared with customers outside the Snowflake account is?
- //Snowflakes's Data Sharing
Query statement encryption is supported on accounts?
A) Standard
B) Enterprise
C) Enterprise for Sensitive (ESD)
D) Virtual Private Snowflake (VPS) - //C) Enterprise for Sensitive (ESD)
True or False: Caching techniques are supported by Snowflake's performance
optimizing query methods? - //True
True or False: B-tree type indexes are supported by Snowflake's performance
optimizing query methods? - //False
True or False: Retrieving results of previous query from cache is supported by
Snowflake's performance optimizing query methods? - //True
True or False: Snowflake security supports user-based access control? - //True
True or False: Federated authentication in Snowflake is complaint with SAML
2.0? - //True
,True or False: Tri-secret requires that customers manage their own keys? - //True
All security information is stored in the ___________ layer in the Snowflake
architecture?
A) Storage
B) Compute
C) Service
D) All of the above - //C) Service
True or False: One benefit of client-side encryption is that it provides a secure
system for managing data in cloud storage? - //True
True or False: One benefit of client-side encryption is that the data is encrypted
before loading into storage layer? - //False
True or False: One benefit of client-side encryption is the storage service layer
only contains encrypted version of the data? - //True
True or False: One benefit of client-side encryption is that queries can be encrypted
on the client side? - //False
True or False: MFA (Multi-factor Authentication) is automatically enabled for
your account and available for all users to self-enroll? - //True
True or False: MFA (Multi-factor Authentication) is an integrated feature powered
by Duo Security service? - //True
,True or False: MFA (Multi-factor Authentication) can be used for connecting to
Snowflake via the Snowflake JDBC driver? - //True
True or False: MFA (Multi-factor Authentication) login is desired only for
connecting to Snowflake through the web interface? - //False
Snowflake includes Role-Based Access Control to enable administrators to:
A) Limit access to data and privileges
B) Manage secure access to the Snowflake account and data
C) Establish role hierarchy and privilege inheritance to align access
D) All of the above - //D) All of the above
With an IdP (identity provider) configured for your account, Snowflake supports
using SSO to connect and authenticate with ODBC Driver? - //True
With an IdP (identity provider) configured for your account, Snowflake supports
using SSO to connect and authenticate with Python Connector? - //True
With an IdP (identity provider) configured for your account, Snowflake supports
using SSO to connect and authenticate with JDBC Driver? - //True
With an IdP (identity provider) configured for your account, Snowflake supports
using SSO to connect and authenticate with SnowSQL? - //
Choosing separate accounts in Snowflake enables users to have:
, A) Different editions of Snowflake and different regions
B) Billing at the account level
C) Simpler database object deployment between environments
D) All of the above - //D) All of the above
True or False: Different editions of Snowflake instances require separate accounts?
- //True
True or False: Snowflake instances in different regions require separate accounts? -
//True
True or False: Data can be shared READ ONLY across accounts, and can be
cloned accounts? - //False
An enterprise view of data is useful because:
A) A data set can be stored once and shared multiple times
B) Data set provisioning is assigned to the owner of the data set
C) Data sets can be shared securely
D) All of the above - //D) All of the above
True or False: Data Sharing is only supported between accounts in the same
Snowflake region? - //True
True or False: A share can't be cloned by a consumer account, but the share data
CAN be copied into a table? - //True
