SnowPro Certification Study Guide Part 5; Questions & Answers

SnowPro Certification Study Guide Part 5; Questions &
Answers
As a data consumer you can have many data shares BUT? Correct Ans-Can only create ONE

read-only database




Data shared to a Reader account? Correct Ans-Is read-only(SELECT) they can NOT perform

any DML




The same role based access is applicable to a shared database? Correct Ans-True




Snowflake sharing, no data is copied. It is just the metadata that enables the sharing of data?

Correct Ans-Since no data is copied, the target snowflake account (also called the

consumer) is not charged for any storage.




A share contains? Correct Ans-- Usage privileges on DB+Schema


- Secure views


- Consumer account to share too




You can create an unlimited amount of shares? Correct Ans-True

, SnowPro Certification Study Guide Part 5; Questions &
Answers
To create a DB as a consnumer account? Correct Ans-Must be ACCOUNTADMIN role


OR


Have import share privileges




What DB objects can be shared? Correct Ans-- Secure Views


- DBs


- Schemas


- Tables




Lowest edition that provides customer dedicated warehouse? Correct 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 Correct Ans-True




To share data with other clouds ? Correct Ans-Provider must enable replication and

replicate existing DB to other cloud provider