Which of the following statements is true of zero-copy cloning?
Which of the following statements is true of zero-copy cloning?
At the instance a clone is created, all micro-partitions in the original table and the clone are fully shared in the context of zero-copy cloning. This means that initially, no additional storage is used; the original data is referenced rather than being duplicated. This zero-copy cloning approach helps reduce storage costs by enabling efficient data sharing without duplicating the data.
Answer:D why not B? Note that the clone of the container itself (database or schema) does not inherit the privileges granted on the source container.
D is correct, but take into account that if the cloned or the original table make any change to the data, this change does not affect the other table. They are independent objects
From: https://docs.snowflake.com/en/sql-reference/sql/create-clone.html -- If the COPY GRANTS keywords are used, then the new object inherits any explicit access privileges granted on the original table but does not inherit any future grants defined for the object type in the schema. If the COPY GRANTS keywords are not used, then the new object clone does not inherit any explicit access privileges granted on the original table but does inherit any future grants defined for the object type in the schema (using the GRANT <privileges> … TO ROLE … ON FUTURE syntax). Answer: D
It is D
Answer D
Yes the answer is D
Answer is D
Correct
D is the answer.
Was on exam Dec 31st, 2022
D is the answer.