When cloning a database, what is cloned with the database? (Choose two.)

The correct answer is A. Privileges on the database B. Existing child objects within the database. A is correct: When you clone a database, the privileges granted directly on the database object itself are included in the clone. B is correct: All existing child objects at the time of cloning - such as schemas, tables, views, and stored procedures - are cloned as zero-copy…

Storage and Data Protection

Question

Options

APrivileges on the database
BExisting child objects within the database
CFuture child objects within the database
DPrivileges on the schemas within the database
EOnly schemas and tables within the database

How the community answered

(33 responses)

A
91% (30)
D
6% (2)
E
3% (1)

Explanation

A is correct: When you clone a database, the privileges granted directly on the database object itself are included in the clone. B is correct: All existing child objects at the time of cloning - such as schemas, tables, views, and stored procedures - are cloned as zero-copy clones. C is incorrect: Future objects created after the clone operation are not retroactively included in the clone. D is incorrect: Privileges granted on child objects (like schemas or tables) are NOT carried over to the clone; only the privileges on the top-level cloned object are transferred. E is incorrect: It is incomplete and misleading; all child objects (not just schemas and tables) are cloned.

Topics

#Database Cloning#Object Cloning#Privileges#Zero-Copy Cloning

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice