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
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
MohamedBen
3 weeks, 4 days agolol632
1 year agoMikeTQ
1 year, 1 month agoAdahSimonis
1 year, 3 months agoMarge23
1 year, 3 months agoMultiCloudIronMan
1 year, 5 months agoMayuri917233
1 year, 7 months agoSV1122
1 year, 11 months agoDerekSlade
2 years agoaalonso
2 years ago[Removed]
2 years, 7 months agoRajokkiyam
2 years, 10 months ago