Which tables contain the spotlight data and detailed per-record scores?

The option indicating "Spotlight and spotlight_audit" is the right choice because the Spotlight feature is specifically designed to aggregate and analyze data related to the performance and usage of records within the platform. The Spotlight table holds the aggregated data, while the spotlight_audit table tracks audit details, ensuring that the score and the insights derived from various records are recorded and accessible. This combination allows users to delve into detailed per-record scores and also provides oversight on changes or trends over time.

In contrast, the other options do not directly address the specific features of Spotlight data. While other tables, like "record_audit," may provide historical changes to records, they are not tailored for performance scoring. Similarly, the "Data and record_summary" option mentions general data structuring but lacks the specific components used for Spotlight analysis. The "Analytics and metrics" option is too broad and does not pinpoint the tables focused on scoring per record in the context of Spotlight.