exam questions

Exam SnowPro Advanced Data Engineer All Questions

View all questions & answers for the SnowPro Advanced Data Engineer exam

Exam SnowPro Advanced Data Engineer topic 1 question 86 discussion

Actual exam question from Snowflake's SnowPro Advanced Data Engineer
Question #: 86
Topic #: 1
[All SnowPro Advanced Data Engineer Questions]

A table, mytable, is created using the following command in a schema called raw:

create table mytable(col1 number, col2 date) data_retention_time_in_days=90;

The DATA_RETENTION_TIME_IN_DAYS is set to 30 days for the raw schema.

If the raw schema gets dropped today, for how many days will the data in mytable be accessible through Time Travel?

  • A. 0 days
  • B. 30 days
  • C. 90 days
  • D. 120 days
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
e970753
17 hours, 37 minutes ago
Selected Answer: B
When a schema is dropped, the data retention period for child tables, if explicitly set to be different from the retention of the schema, is not honored. The child tables are retained for the same period of time as the schema. https://docs.snowflake.com/en/en/user-guide/data-time-travel
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...