SnowPro Certification Study Guide Part
5 with Complete Questions and Answers
As a data consumer you can have many data shares BUT? - ANSWER - Can only create ONE
read-only database
Data shared to a Reader account? - ANSWER - Is read-only(SELECT) they can NOT perform
any DML
The same role based access is applicable to a shared database? - ANSWER - True
Snowflake sharing, no data is copied. It is just the metadata that enables the sharing of data? -
ANSWER - Since no data is copied, the target snowflake account (also called the consumer) is
not charged for any storage.
A share contains? - ANSWER - - Usage privileges on DB+Schema
- Secure views
- Consumer account to share too
You can create an unlimited amount of shares? - ANSWER - True
To create a DB as a consnumer account? - ANSWER - Must be ACCOUNTADMIN role
OR
Have import share privileges
What DB objects can be shared? - ANSWER - - Secure Views
- DBs
- Schemas
- Tables
, Lowest edition that provides customer dedicated warehouse? - ANSWER - Standard
JSON format when extracting to JSON? - ANSWER - ndjson(New Line Delimited JSON)
Lowest version Tri-Secret is available? - ANSWER - Business Critical
Database failover and failback is available starting at what edition? - ANSWER - Business
Critical
Dedicated metadata store and pool of virtual servers (used in virtual warehouses) is available in
what edition? - ANSWER - Only in VPS Edition
Materialized views, with automatic maintenance of result is available starting at? - ANSWER -
Enterprise Edition
Only one instance of data per cloud or region has to be replicated. Once the instance is
replicated more then one consumer can make use of this data - ANSWER - True
To share data with other clouds ? - ANSWER - Provider must enable replication and replicate
existing DB to other cloud provider
Load metadata expires after? - ANSWER - 64 days
Snowflake supports loading from? - ANSWER - - S3
- Google Cloud
- Azure Blob
- Internal named stage
VARIANT data type can store up to? - ANSWER - 16 MB
Snowpipe uses a server less compute which? - ANSWER - Managed by Snowflake and scales
up/down
5 with Complete Questions and Answers
As a data consumer you can have many data shares BUT? - ANSWER - Can only create ONE
read-only database
Data shared to a Reader account? - ANSWER - Is read-only(SELECT) they can NOT perform
any DML
The same role based access is applicable to a shared database? - ANSWER - True
Snowflake sharing, no data is copied. It is just the metadata that enables the sharing of data? -
ANSWER - Since no data is copied, the target snowflake account (also called the consumer) is
not charged for any storage.
A share contains? - ANSWER - - Usage privileges on DB+Schema
- Secure views
- Consumer account to share too
You can create an unlimited amount of shares? - ANSWER - True
To create a DB as a consnumer account? - ANSWER - Must be ACCOUNTADMIN role
OR
Have import share privileges
What DB objects can be shared? - ANSWER - - Secure Views
- DBs
- Schemas
- Tables
, Lowest edition that provides customer dedicated warehouse? - ANSWER - Standard
JSON format when extracting to JSON? - ANSWER - ndjson(New Line Delimited JSON)
Lowest version Tri-Secret is available? - ANSWER - Business Critical
Database failover and failback is available starting at what edition? - ANSWER - Business
Critical
Dedicated metadata store and pool of virtual servers (used in virtual warehouses) is available in
what edition? - ANSWER - Only in VPS Edition
Materialized views, with automatic maintenance of result is available starting at? - ANSWER -
Enterprise Edition
Only one instance of data per cloud or region has to be replicated. Once the instance is
replicated more then one consumer can make use of this data - ANSWER - True
To share data with other clouds ? - ANSWER - Provider must enable replication and replicate
existing DB to other cloud provider
Load metadata expires after? - ANSWER - 64 days
Snowflake supports loading from? - ANSWER - - S3
- Google Cloud
- Azure Blob
- Internal named stage
VARIANT data type can store up to? - ANSWER - 16 MB
Snowpipe uses a server less compute which? - ANSWER - Managed by Snowflake and scales
up/down
