Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake Exam ARA-C01 Topic 5 Question 35 Discussion

Actual exam question for Snowflake's ARA-C01 exam
Question #: 35
Topic #: 5
[All ARA-C01 Questions]

An Architect is implementing a CI/CD process. When attempting to clone a table from a production to a development environment, the cloning operation fails.

What could be causing this to happen?

Show Suggested Answer Hide Answer
Suggested Answer: B

Cloning a table with a masking policy can cause the cloning operation to fail because the masking policy is not automatically cloned with the table. This is due to the fact that the masking policy is considered a separate object with its own set of privileges1.


Snowflake Documentation on Cloning Considerations1.

by Jillian at Sep 08, 2024, 12:21 PM

Limited Time Offer

25%

Off

Get Premium ARA-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Lon
6 months ago
Retention time set to zero? Sounds like someone's been playing with the delete button. Option C is the culprit!
upvoted 0 times
...
Alberto
6 months ago
The table is transient, so it's probably dancing its way out of the cloning process. Option A is the way to go!
upvoted 0 times
Galen
5 months ago
User4: I don't think it's the retention time, maybe it's the cloning direction.
upvoted 0 times
...
Wilford
5 months ago
Maybe the table has a masking policy causing the issue.
upvoted 0 times
...
Thomasena
5 months ago
Yeah, I think option A is the reason.
upvoted 0 times
...
Anthony
5 months ago
The table is probably transient, that's why it's failing.
upvoted 0 times
...
...
Rosalyn
6 months ago
Option D is too obvious. Tables can't be cloned from production to dev? What is this, amateur hour?
upvoted 0 times
Page
5 months ago
C) The retention time for the table is set to zero.
upvoted 0 times
...
Lynelle
5 months ago
B) The table has a masking policy.
upvoted 0 times
...
Pearly
5 months ago
A) The table is transient.
upvoted 0 times
...
Trina
6 months ago
C) The retention time for the table is set to zero.
upvoted 0 times
...
Lavonda
6 months ago
B) The table has a masking policy.
upvoted 0 times
...
Patti
6 months ago
A) The table is transient.
upvoted 0 times
...
...
Felice
6 months ago
Could it be that tables cannot be cloned from a higher environment to a lower environment?
upvoted 0 times
...
Laticia
6 months ago
I believe the retention time for the table is set to zero.
upvoted 0 times
...
Judy
6 months ago
I think the table has a masking policy.
upvoted 0 times
...
Penney
7 months ago
I think option B is the correct answer. A masking policy would prevent the table from being cloned, right?
upvoted 0 times
...
Jamal
7 months ago
Haha, the table is probably sentient and doesn't want to be cloned. Clearly, the production environment is trying to protect its secrets!
upvoted 0 times
Dalene
6 months ago
B) The table has a masking policy.
upvoted 0 times
...
Kaycee
6 months ago
A) The table is transient.
upvoted 0 times
...
Nadine
6 months ago
B) The table has a masking policy.
upvoted 0 times
...
Carylon
6 months ago
A) The table is transient.
upvoted 0 times
...
...

Save Cancel