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, what schema design should you adopt to optimize query speed for author information of borrowed books, adhering to Google's best practices?