Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
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.
lol632
4 months, 3 weeks agoMikeTQ
5 months, 3 weeks agoAdahSimonis
7 months agoMarge23
7 months, 3 weeks agoMultiCloudIronMan
9 months, 2 weeks agoMayuri917233
11 months, 2 weeks agoSV1122
1 year, 3 months agoDerekSlade
1 year, 4 months agoaalonso
1 year, 4 months ago[Removed]
1 year, 11 months agoRajokkiyam
2 years, 2 months ago