A prospect wants to be able to store and analyze data. Their analysts already know SQL, but are not familiar with other technologies. Which of these databases can the analysts use without addi…

The correct answer is B. Spanner, Cloud SQL, BigQuery. All three databases in option B support standard SQL interfaces, making them usable by analysts who already know SQL without additional training. Cloud SQL is a fully managed relational database service (MySQL, PostgreSQL, SQL Server) - natively SQL. BigQuery is Google's…

Identify appropriate Google Cloud data management and analytics solutions

Question

A prospect wants to be able to store and analyze data. Their analysts already know SQL, but are not familiar with other technologies. Which of these databases can the analysts use without addi- tional training?

Options

ACloud SQL, BigQuery, Datastore
BSpanner, Cloud SQL, BigQuery
CCloud SQL, Firestore, Datastore
DCloud SQL, Bigtable, BigQuery

How the community answered

(45 responses)

A
2% (1)
B
89% (40)
C
2% (1)
D
7% (3)

Explanation

All three databases in option B support standard SQL interfaces, making them usable by analysts who already know SQL without additional training. Cloud SQL is a fully managed relational database service (MySQL, PostgreSQL, SQL Server) - natively SQL. BigQuery is Google's serverless data warehouse that uses standard SQL for analytics. Cloud Spanner is a globally distributed relational database that also supports ANSI SQL. The other options include non-SQL databases: Datastore (A) uses a NoSQL key-value/document model with its own query language (GQL), Firestore (C) is a NoSQL document database, and Bigtable (D) is a wide-column NoSQL store with no native SQL support. Any option containing Datastore, Firestore, or Bigtable would require the analysts to learn a new query paradigm.

Topics

#GCP Databases#SQL capabilities#Data storage#Data analysis

Community Discussion

No community discussion yet for this question.

Full CLOUD-DIGITAL-LEADER Practice