BlackFriday 2024! 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 DEA-C01 Topic 1 Question 20 Discussion

Actual exam question for Snowflake's DEA-C01 exam
Question #: 20
Topic #: 1
[All DEA-C01 Questions]

A Data Engineer wants to create a new development database (DEV) as a clone of the permanent production database (PROD) There is a requirement to disable Fail-safe for all tables.

Which command will meet these requirements?

Show Suggested Answer Hide Answer
Suggested Answer: C

This option will meet the requirements of creating a new development database (DEV) as a clone of the permanent production database (PROD) and disabling Fail-safe for all tables. By using the CREATE TRANSIENT DATABASE command, the Data Engineer can create a transient database that does not have Fail-safe enabled by default. Fail-safe is a feature in Snowflake that provides additional protection against data loss by retaining historical data for seven days beyond the time travel retention period. Transient databases do not have Fail-safe enabled, which means that they do not incur additional storage costs for historical data beyond their time travel retention period. By using the CLONE option, the Data Engineer can create an exact copy of the PROD database, including its schemas, tables, views, and other objects.


by Galen at Apr 12, 2024, 10:52 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel
Kati
6 months ago
That's a good point, Maybe we need to consider data retention time as well for the development database.
upvoted 0 times
...
Desmond
6 months ago
I'm not sure guys. I think the answer might be D. It mentions about data retention time, which is important for development databases.
upvoted 0 times
...
Sheron
6 months ago
I disagree with you I believe the correct answer is A. We need to disable Fail-safe for all tables as well.
upvoted 0 times
...
Kati
7 months ago
I think the answer is B. We just need to clone the production database to create the development database.
upvoted 0 times
Herman
6 months ago
I think option A is the one that includes disabling Fail-safe.
upvoted 0 times
...
Galen
6 months ago
But shouldn't we also disable Fail-safe for all tables as per the requirement?
upvoted 0 times
...
Brandon
6 months ago
I agree, option B seems to be the correct one.
upvoted 0 times
...
...
Gail
7 months ago
Haha, I bet one of the answers is just 'CREATE DATABASE DEV CLONE PROD' and doesn't mention Fail-safe at all. Classic trick question!
upvoted 0 times
...
Kaitlyn
7 months ago
Good point. Maybe there's a specific use case where the engineers want more control over the data retention policies in the development environment.
upvoted 0 times
...
Danica
7 months ago
Wait, I'm a little confused. Isn't Fail-safe a feature to protect against data loss? Why would we want to disable that?
upvoted 0 times
...
Ma
7 months ago
Ah, I see. So we need to clone the production database and then disable Fail-safe. That makes sense.
upvoted 0 times
...
Devorah
7 months ago
Hmm, I think I've seen this kind of question before. The key here is to look for the option that specifically mentions disabling Fail-safe.
upvoted 0 times
...
Sherita
8 months ago
This is a tricky question. I'm not sure if I can recall the exact syntax for disabling Fail-safe on all tables when creating a cloned database. Let me think through this step-by-step.
upvoted 0 times
...

Save Cancel