Question 680
A consumer can see an incoming provider share but has no database through which to query it. Which SQL operation is needed?
Explanation
Correct Answer
Correct: creating a database from that share. CREATE DATABASE FROM SHARE creates an imported read-only database from an available provider share.
Incorrect Answers
Not correct for the collaboration need: IMPORTED PRIVILEGES grant authorizes an account role to use imported privileges on a shared database; this scenario calls for creating a database from that share.
Not correct for the collaboration need: USE WAREHOUSE selects the consumer's warehouse for running queries; this scenario calls for creating a database from that share.
Not correct for the collaboration need: SHOW SHARES lists applicable incoming or outgoing shares visible to the active role; this scenario calls for creating a database from that share.