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 optimize the data schema. Which Google Cloud Platform product should you use?
A. BigQuery
B. Cloud SQL
C. Cloud Bigtable
D. Cloud Datastore
D
BigQuery isn’t transactiona:
https://cloud.google.com/bigquery/docs/loading-data
datastore. is transactional and can be use as part of a ml pipeline:
https://cloud.google.com/bigquery/docs/loading-data
Structured and analytical hence A BigQuery is correct.
It cannot be datastore. Datastore is for web and mobile. The keyword is “database schema for a machine learning” The answer is A BigQuery
Is datastore, the key words here are “transactional data of the product” and “optimize the data schema” Datastore is the document database perfect for this.