Google Professional Cloud Developer Question 173
Single answerGoogle Cloud PlatformYou are designing a cloud-native application that needs to store user profile data, such as names, email addresses, preferences, and activity logs. The application requires flexible schema evolution for new features and high write scalability for logging data, but it also needs to support complex queries on user profiles. Which type of database is most appropriate for this scenario?
- A
Relational database using SQL
- B
Document-oriented NoSQL database
- C
Key-value NoSQL database
- D
Time-series database
Show answer and explanation
Correct answer: B
Explanation
Document-oriented NoSQL databases, such as Firestore or MongoDB, are ideal for this scenario because they provide the flexibility to evolve schemas as application features change. They also support high write scalability for activity logs and can handle complex queries on semi-structured data like user profiles. These capabilities align well with the application's requirements.
- A. Incorrect.
Relational databases using SQL are best suited for structured data with predefined schemas and strong consistency requirements. However, they are less flexible for schema evolution and high write scalability compared to NoSQL databases, making them less ideal for this scenario.
- B. Correct.
Document-oriented NoSQL databases are highly flexible for schema evolution, allowing you to store semi-structured data like user profiles and activity logs. They also support high write scalability and complex queries, making them a good fit for this scenario.
- C. Incorrect.
Key-value NoSQL databases are optimized for fast lookups of simple key-value pairs. While they offer high write scalability, they do not support complex queries or semi-structured data well, which makes them unsuitable for this use case.
- D. Incorrect.
Time-series databases are designed for storing and querying time-stamped data, such as metrics or logs. While they can handle activity logs, they are not appropriate for storing user profiles or supporting complex queries.