Study SnowPro DEA-C02 Sharing and Failover: key concepts, common traps, and exam decision cues.
Delivery questions are where many candidates confuse live access with copying. Snowflake wants you to know whether the consumer needs a governed live view, a copied replica, or a continuity design.
| Requirement | Better first instinct |
|---|---|
| consumer already has a Snowflake account and needs live governed access | secure share |
| need copied state across region or account for continuity | replication |
| need recovery path if primary environment is unavailable | failover design |
| need broader downstream marketplace-style exposure | listing or broader delivery pattern |
| If the requirement is… | Stronger first answer |
|---|---|
| live governed reads from provider-owned data | secure sharing |
| copied state for continuity | replication |
| continuity action when primary is unavailable | failover |
| broader distribution or catalog-style exposure | listing pattern |
| If the stem says… | Strong reading |
|---|---|
| “partner needs current data continuously” | think sharing before unloading files |
| “cross-region continuity” | replication and failover may matter more than sharing |
| “provider retains central control” | live governed access is often the better lane |
Both can involve another account or region, but they solve different responsibilities:
If the consumer only needs live reads, a copied-state answer is often heavier than necessary.
| Trap | Better rule |
|---|---|
| unloading files when the requirement is live access | copying is not the same as governed sharing |
| using replication when the consumer really just needs shared reads | replication creates a copied state |
| treating failover as the same thing as sharing | continuity and delivery are different responsibilities |
| Scenario clue | Stronger answer shape |
|---|---|
| “partner has Snowflake and needs live governed access” | secure share |
| “cross-region copied continuity” | replication |
| “primary environment unavailable” | failover |
| “broader productized exposure” | listing or broader delivery path |
This lesson usually tests whether the requirement is live governed access or copied state for continuity. If consumers should query current provider data while the provider keeps revocation control, secure sharing is usually the first answer. If the requirement is copied regional state or failover readiness, replication or failover groups become stronger. The weak answer usually copies data when live governed reads were the real need.