Answer-first summary for fast verification
Answer: Use Firestore in Native mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.
The question describes a scenario where user profiles have a dynamic schema, and changes need to automatically trigger updates to a downstream BigQuery data warehouse. Option A suggests using Bigtable, which is a good choice for large-scale, low-latency applications, but it lacks the automatic triggering mechanism for updates to BigQuery. Option B suggests using Cloud SQL, which is not ideal for dynamic schemas and lacks native integration for automatic updates to BigQuery. Option C suggests using Firestore in Native mode, which is designed for mobile and web applications with dynamic schemas and supports real-time updates. It also integrates well with BigQuery for analytics. Option D suggests using Firestore in Datastore mode, which is more suited for legacy applications and lacks some of the real-time capabilities of Native mode. Therefore, the best option is C, as it meets all the requirements: dynamic schema support, real-time updates, and integration with BigQuery.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How can you automatically update your BigQuery data warehouse when users modify their dynamically structured profiles in an application that customizes website and mobile experiences?
A
Store your data in Bigtable, and use the user identifier as the key. Use one column family to store user profile data, and use another column family to store user preferences.
B
Use Cloud SQL, and create different tables for user profile data and user preferences from your recommendations model. Use SQL to join the user profile data and preferences.
C
Use Firestore in Native mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.
D
Use Firestore in Datastore mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.
No comments yet.