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 29 Discussion

Actual exam question for Snowflake's DEA-C01 exam
Question #: 29
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 Leota at Jul 15, 2024, 01:00 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel
Elly
7 months ago
B is the clear winner here. Keep it simple, create the dev database as a clone of the production database, and let Snowflake handle the fail-safe settings. No need to get fancy.
upvoted 0 times
...
Eric
7 months ago
Haha, I love how option D includes 'CLOSE PROD' instead of 'CLONE PROD'. Looks like someone had a little too much coffee before writing this exam.
upvoted 0 times
Whitley
7 months ago
User2
upvoted 0 times
...
Jess
7 months ago
User1
upvoted 0 times
...
...
Rosann
8 months ago
D looks like it might work, but setting the data retention time to zero days seems a bit extreme. Don't we want to keep some historical data in the dev environment?
upvoted 0 times
France
7 months ago
A) I think we should go with A) CREATE DATABASE DEV CLONE PROD; and keep some historical data for reference in the dev environment.
upvoted 0 times
...
Kathrine
7 months ago
B) Yeah, I agree. Option A seems to be the best choice for creating the new development database.
upvoted 0 times
...
Celeste
7 months ago
A) CREATE DATABASE DEV CLONE PROD; sounds like the right command to use.
upvoted 0 times
...
...
Laticia
8 months ago
I agree with Leontine, A seems to be the most appropriate command for the task.
upvoted 0 times
...
Leontine
8 months ago
But A includes disabling Fail-safe for all tables, which is a requirement.
upvoted 0 times
...
Isadora
8 months ago
I disagree, I believe the correct answer is B.
upvoted 0 times
...
Shizue
8 months ago
Hmm, I'm not sure about the spelling on option C. 'RPOD' instead of 'PROD'? Seems a bit suspicious to me.
upvoted 0 times
...
Theodora
8 months ago
Option A looks good to me. Disabling Fail-safe for all tables is the requirement, and this command does that.
upvoted 0 times
Renay
8 months ago
I agree, option A disables Fail-safe for all tables.
upvoted 0 times
...
Rosendo
8 months ago
I think option A is the correct command to meet the requirements.
upvoted 0 times
...
...
Leontine
9 months ago
I think the answer is A.
upvoted 0 times
...

Save Cancel