As a data consumer you can have many data shares BUT? ✔️Ans - Can
only create ONE read-only database
Data shared to a Reader account? ✔️Ans - Is read-only(SELECT) they can
NOT perform any DML
The same role based access is applicable to a shared database? ✔️Ans -
True
Snowflake sharing, no data is copied. It is just the metadata that enables the
sharing of data? ✔️Ans - Since no data is copied, the target snowflake
account (also called the consumer) is not charged for any storage.
A share contains? ✔️Ans - - Usage privileges on DB+Schema
- Secure views
- Consumer account to share too
You can create an unlimited amount of shares? ✔️Ans - True
To create a DB as a consnumer account? ✔️Ans - Must be
ACCOUNTADMIN role
OR
Have import share privileges
What DB objects can be shared? ✔️Ans - - Secure Views
- DBs
- Schemas
- Tables
Lowest edition that provides customer dedicated warehouse? ✔️Ans -
Standard
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
✔️Ans - True