Which operation is NOT allowed on a Shared database?

Master the SnowPro Advanced Architect Test with flashcards, multiple-choice questions, and detailed explanations. Prepare thoroughly for your certification!

Multiple Choice

Which operation is NOT allowed on a Shared database?

Explanation:
Shared databases are data that another account has granted you access to, appearing in your account as a database but effectively read-only from your side. You can run queries to read the data and build read-only objects on top of it, but you cannot modify the underlying share. Cloning would create a new, writable copy of that data in your own account, which isn’t permitted because it would defeat the purpose of the shared, read-only access and could lead to inconsistencies with the source data. That’s why cloning a Shared database isn’t allowed. The other options are compatible with the shared setup because they don’t require creating a writable duplicate of the source data; you can read the data with SELECT and use it in your analyses.

Shared databases are data that another account has granted you access to, appearing in your account as a database but effectively read-only from your side. You can run queries to read the data and build read-only objects on top of it, but you cannot modify the underlying share. Cloning would create a new, writable copy of that data in your own account, which isn’t permitted because it would defeat the purpose of the shared, read-only access and could lead to inconsistencies with the source data. That’s why cloning a Shared database isn’t allowed. The other options are compatible with the shared setup because they don’t require creating a writable duplicate of the source data; you can read the data with SELECT and use it in your analyses.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy