Snowflake Exam DEA-C01 Topic 1 Question 27 Discussion

Actual exam question for Snowflake's DEA-C01 exam

Question #: 27
Topic #: 1

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?

ACREATE DATABASE DEV
CLONE PROD
FAIL_SAFE=FALSE;

BCREATE DATABASE DEV
CLONE PROD;

CCREATE TRANSIENT DATABASE DEV
CLONE RPOD

DCREATE DATABASE DEV
CLOSE PROD
DATA_RETENTION_TIME_IN_DAYS =0L

Show Suggested 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 Telma at Jun 29, 2024, 10:03 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Raina

4 months ago

Wait, is 'FAIL_SAFE=FALSE' a real thing? I thought it was just a myth, like unicorns or politicians telling the truth.

upvoted 0 times

...

Ettie

4 months ago

I bet the engineer who wrote this question is a real comedian, huh? 'CLONE RPOD' - classic!

upvoted 0 times

...

Darrin

4 months ago

Option D is way off. 'CLOSE PROD' is not a thing, and 'DATA_RETENTION_TIME_IN_DAYS =0L' is not relevant to the question.

upvoted 0 times

Julieta

4 months ago

Option D is incorrect. 'CLOSE PROD' and 'DATA_RETENTION_TIME_IN_DAYS =0L' are not relevant.

upvoted 0 times

...

Alpha

4 months ago

C) CREATE TRANSIENT DATABASE DEV\nCLONE RPOD

upvoted 0 times

...

Loise

4 months ago

B) CREATE DATABASE DEV\nCLONE PROD;

upvoted 0 times

...

Jaime

4 months ago

A) CREATE DATABASE DEV\nCLONE PROD\nFAIL_SAFE=FALSE;

upvoted 0 times

...

Jamal

5 months ago

Option C is clearly wrong. 'CREATE TRANSIENT DATABASE' is not a valid command, and 'CLONE RPOD' is just weird.

upvoted 0 times

...

Stevie

5 months ago

I agree with Leonora, A seems to be the best option for meeting the requirements.

upvoted 0 times

...

Leonora

5 months ago

But A includes disabling Fail-safe for all tables, which is a requirement.

upvoted 0 times

...

Gerald

5 months ago

Option B seems the most straightforward. Why bother with all the extra stuff in option A? Just clone the PROD database and you're good to go.

upvoted 0 times

...

Sunny

5 months ago

I disagree, I believe the correct answer is B.

upvoted 0 times

...

Malinda

5 months ago

I'm not sure about option A. Isn't there a typo in the command? It should be 'FAIL_SAFE=FALSE' instead of 'FAIL_SAFE=FALSE;'.

upvoted 0 times

Misty

3 months ago

Thanks for clarifying, I will go with option A then.

upvoted 0 times

...

Earleen

3 months ago

I agree, the correct command is CREATE DATABASE DEV CLONE PROD FAIL_SAFE=FALSE.

upvoted 0 times

...

Beth

3 months ago

Option A is correct. The semicolon at the end is not necessary.

upvoted 0 times

...

Laticia

4 months ago

Yes, option A is the right choice. Let's use 'FAIL_SAFE=FALSE'.

upvoted 0 times

...

Christoper

4 months ago

I agree, let's go with option A.

upvoted 0 times

...

Darnell

4 months ago

I think option A is correct. It should be 'FAIL_SAFE=FALSE' without the semicolon.

upvoted 0 times

...

Leonora

5 months ago

I think the answer is A.

upvoted 0 times

...

Justine

5 months ago

Option A looks good to me. Disabling Fail-safe for all tables is exactly what the requirement asks for.

upvoted 0 times

Shaniqua

4 months ago

Let's go with option A then, it seems like the best choice.

upvoted 0 times

...

Romana

4 months ago

Yes, option A meets the requirements perfectly.

upvoted 0 times

...

Rusty

4 months ago

I agree, disabling Fail-safe for all tables is important.

upvoted 0 times

...

Hassie

4 months ago

I think option A is the correct one.

upvoted 0 times

...