After rebuilding a PDT is complete, what happens to the cached results of any Explores using that datagroup?

After rebuilding a PDT is complete, what happens to the cached results of any Explores using that datagroup?

• A. They are preserved
• B. They are deleted
• C. They are invalidated
• D. They are merged

Answer: (C)

When a Persistent Derived Table (PDT) is rebuilt in Looker, the cached results of any Explores that utilize the associated datagroup undergo invalidation. This means that any cached queries dependent on the outdated data in the PDT will no longer be valid, as the data they are based on has changed after the rebuild. This process ensures that users always interact with the most current data when querying reports or dashboards. The invalidation of cached results prompts Looker to refresh the cache for those Explores the next time they are accessed, enabling the use of the newly built PDT data. Preservation, deletion, or merging of cache do not occur in this scenario as the architecture is designed to automatically maintain data integrity by removing stale cached results in favor of fresh data reflections from the PDT rebuild, thereby providing accurate analytics to the users.

When a Persistent Derived Table (PDT) is rebuilt in Looker, the cached results of any Explores that utilize the associated datagroup undergo invalidation. This means that any cached queries dependent on the outdated data in the PDT will no longer be valid, as the data they are based on has changed after the rebuild.

This process ensures that users always interact with the most current data when querying reports or dashboards. The invalidation of cached results prompts Looker to refresh the cache for those Explores the next time they are accessed, enabling the use of the newly built PDT data.

Preservation, deletion, or merging of cache do not occur in this scenario as the architecture is designed to automatically maintain data integrity by removing stale cached results in favor of fresh data reflections from the PDT rebuild, thereby providing accurate analytics to the users.