Ultimate access to all questions.
When migrating an application that tracks library books and their details (like author or publication year) from an on-premises data warehouse to BigQuery, how should you structure the data to optimize query speed about the authors of borrowed books, adhering to Google's schema design best practices?