Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
SnowPro Core Certification · Snowflake
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
D.Table
The Time Travel retention period in Snowflake specifies the number of days for which historical data is preserved and, therefore, Time Travel operations (SELECT, CREATE … CLONE, UNDROP) can be performed on the data 1. The standard retention period is 1 day (24 hours) and is automatically enabled for all Snowflake accounts 1. For Snowflake Enterprise Edition (and higher), the retention period can be set to any value from 0 up to 90 days for permanent databases, schemas, and tables 12. Therefore, the most granular object that the Time Travel retention period can be defined on is a table 1. I hope this helps! https://docs.snowflake.com/en/user-guide/data-time-travel
High granularity level refers to a high level of detail, vice-versa low granularity level refers to a low level of detail. Practically speaking, the more subdividable and specific a data is, the more granular it is considered to be. Thus, “granularity” and “level of detail” of data are the same thing. In this case the most granular level is asked and that is a syntactic issue as most is defined by the perspective. Highest or Lowest level So both A and D could be correct. However I think that Most is meant als the highest level of detail and that would be D.