Snowflake Exam DEA-C01 Topic 1 Question 27 Discussion

Actual exam question for Snowflake's DEA-C01 exam

Question #: 27
Topic #: 1

A stream called TRANSACTIONS_STM is created on top of a transactions table in a continuous pipeline running in Snowflake. After a couple of months, the TRANSACTIONS table is renamed transactiok3_raw to comply with new naming standards

What will happen to the TRANSACTIONS _STM object?

ATRANSACTIONS _STM will keep working as expected

BTRANSACTIONS _STM will be stale and will need to be re-created

CTRANSACTIONS _STM will be automatically renamed TRANSACTIONS _RAW_STM.

DReading from the traksactioks_3T>: stream will succeed for some time after the expected STALE_TIME.

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

Joaquin

3 months ago

Wait, they renamed the table to 'transactiok3_raw'? I guess the person in charge of naming conventions was a little 'transactioked' that day.

upvoted 0 times

...

Hildred

3 months ago

Hmm, this is a tricky one. I bet the answer is hidden in some obscure Snowflake documentation. *opens laptop and starts frantically searching*

upvoted 0 times

Vicente

1 months ago

User 3: Maybe it's C) TRANSACTIONS _STM will be automatically renamed TRANSACTIONS _RAW_STM.

upvoted 0 times

...

Huey

2 months ago

User 2: No, I believe it's D) Reading from the transactiok3_raw stream will succeed for some time after the expected STALE_TIME.

upvoted 0 times

...

Shaniqua

2 months ago

User 1: I think the answer is B) TRANSACTIONS _STM will be stale and will need to be re-created

upvoted 0 times

...

Stevie

3 months ago

I'm going with D. The stream might continue to work for a while, but eventually, it will start failing when the STALE_TIME period expires.

upvoted 0 times

...

Talia

3 months ago

C looks like the correct answer to me. Snowflake should automatically rename the stream to match the new table name.

upvoted 0 times

Fletcher

2 months ago

Yes, it definitely simplifies the process for users when dealing with table renaming.

upvoted 0 times

...

Cecily

2 months ago

It's good to know that Snowflake handles the renaming process automatically.

upvoted 0 times

...

Cortney

2 months ago

That would make sense for Snowflake to automatically rename the stream.

upvoted 0 times

...

Alfred

2 months ago

I agree, option C seems like the most logical choice.

upvoted 0 times

...

Alesia

4 months ago

I think the answer is B. The stream is created on top of the TRANSACTIONS table, so when the table is renamed, the stream will become stale and need to be re-created.

upvoted 0 times

Joanne

2 months ago

That's right. You'll have to manually re-create the stream with the new table name to keep it working.

upvoted 0 times

...

Glory

3 months ago

So, it means that the stream won't automatically adjust to the new table name?

upvoted 0 times

...

Weldon

3 months ago

Yes, that's correct. The stream will indeed be stale and will need to be re-created after the table is renamed.

upvoted 0 times

...

Haydee

3 months ago

I think the answer is B. The stream is created on top of the TRANSACTIONS table, so when the table is renamed, the stream will become stale and need to be re-created.

upvoted 0 times

...

Kanisha

4 months ago

I'm not sure, but I think C) TRANSACTIONS _STM will be automatically renamed TRANSACTIONS _RAW_STM. Snowflake might handle the renaming automatically.

upvoted 0 times

...

Rochell

4 months ago

I disagree, I believe the correct answer is D) Reading from the transactiok3_raw stream will succeed for some time after the expected STALE_TIME. It will still work for a while.

upvoted 0 times

...

Latosha

4 months ago

I think the answer is B) TRANSACTIONS _STM will be stale and will need to be re-created. The name change will affect it.

upvoted 0 times

...