Google Cloud Professional Cloud Database Engineer — Question 15

You are building an application that allows users to customize their website and mobile experiences. The application will capture user information and preferences. User profiles have a dynamic schema, and users can add or delete information from their profile. You need to ensure that user changes automatically trigger updates to your downstream BigQuery data warehouse. What should you do?

Answer options

• 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.

Correct answer: C

Explanation

The correct answer is C because Firestore in Native mode allows for real-time synchronization of changes, ensuring that any updates to user profiles and preferences are automatically reflected in downstream systems like BigQuery. Options A and B do not provide the necessary real-time capabilities for dynamic user profiles, and option D, while similar to C, does not leverage the benefits of Native mode which is more suited for this use case.