SnowPro Core free question 10 / 10 · Domain 5: Data Collaboration
How many databases can a consumer create from a single share?
- Up to two databases per share
- None, since sharing is read-only
- Any number of databases
- Only one database per share
Show the answer and explanation
Answer: D
Why this is correct
A data consumer can consume as many shares as they want from data providers, but can only create one database per share.
Why the other options are wrong
"Up to two databases per share" … The limit is one, not two.
"Any number of databases" … The number is not unlimited. One database per share is the limit.
"None, since sharing is read-only" … A consumer does create a database from a share, and one is allowed.
Key point
There is no limit on how many shares you can consume; the limit is on the number of databases per share. An imported database can be queried like any other database in the account.
Go to the SnowPro Core practice app (10 free questions; purchase unlocks all questions)