What happens to the objects in a reader account when the DROP MANAGED ACCOUNT command is executed?

The correct answer is A. The objects are dropped. When a data provider executes DROP MANAGED ACCOUNT, the reader (managed) account and all objects within it are immediately and permanently dropped. There is no grace period, no Time Travel window (C), and no Fail-safe period (B) for objects in a dropped managed account. The…

Data Protection and Data Sharing

Question

Options

AThe objects are dropped.
BThe objects enter the Fail-safe period.
CThe objects enter the Time Travel period.
DThe objects are immediately moved to the provider account.

How the community answered

(48 responses)

A
85% (41)
B
2% (1)
C
8% (4)
D
4% (2)

Explanation

When a data provider executes DROP MANAGED ACCOUNT, the reader (managed) account and all objects within it are immediately and permanently dropped. There is no grace period, no Time Travel window (C), and no Fail-safe period (B) for objects in a dropped managed account. The objects are not transferred to the provider account (D) - they are simply destroyed. This is a destructive, irreversible operation, so Snowflake requires careful consideration before executing it. Any shared data the consumer was accessing via that account also becomes inaccessible.

Topics

#Reader Accounts#Managed Accounts#DROP Command#Data Deletion

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice