Which Database to choose for this scenario ?

It’s a GCP certification question but I couldn’t find a correct answer. Can anyone help ? (Please explain your rational along with your choice).

You are designing the database schema for a machine learning-based food ordering service that will predict what users want to eat. Here is some of the information you need to store:
✑ The user profile: What the user likes and doesn’t like to eat
✑ The user account information: Name, address, preferred meal times
✑ The order information: When orders are made, from where, to whom
The database will be used to store all the transactional data of the product. You want to optimise the data schema. Which Google Cloud Platform product should you use?

1 Like

Hi @ahmad
I think cloud firestore will be good option here as it is better fit for storing user profile and account info
as it supports schema less entities and supports transaction as well here is link
firestore