Professional Data Engineer · Free Practice Question Medium
Question 8
A Web hosting company has been using a custom built data store modeled on the sparse multidimensional array data structure. The CIO no longer wants to pay to develop and maintain a custom data store. Instead, the CIO wants a managed database service if possible and if not, they want to use a well supported open source database that is also based on sparse multidimensional array data structure. The Web hosting company is already using Google Cloud Compute Engine, Cloud Storage, and Kubernetes Engine. What would you recommend to the company?
- A Cassandra
- B Cloud Bigtable
- C BigQuery
- D Cloud Spanner
Reveal correct answer
Correct answer: B
Explanation
Cloud Bigtable is a managed database service based on sparse multidimensional arrays and so meets the requirements, including using a managed database service. Cassandra is an open source database that is based on multidimensional sparse arrays but it is not a managed service and so not as good of a choice for the given requirements. BigQuery uses a compressed, columnar data model not a sparse multidimensional array and does not meet the requirements. Cloud Spanner is a global scale relational database and does not meet the requirements. See https://cloud.google.com/bigtable/docs/overview
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
