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 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
Gail
9 days 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
11 days 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
12 days 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
13 days ago
Ah, I see. So we need to clone the production database and then disable Fail-safe. That makes sense.
upvoted 0 times
...
Devorah
15 days 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
17 days 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