ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Cloud Digital Leader All Questions

View all questions & answers for the Cloud Digital Leader exam
Go to Exam

Exam Cloud Digital Leader topic 1 question 27 discussion

Actual exam question from Google's Cloud Digital Leader
Question #: 27
Topic #: 1
[All Cloud Digital Leader Questions]

Your organization wants to migrate its data management solutions to Google Cloud because it needs to dynamically scale up or down and to run transactional
SQL queries against historical data at scale. Which Google Cloud product or service should your organization use?

  • A. BigQuery
  • B. Cloud Bigtable
  • C. Pub/Sub
  • D. Cloud Spanner
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by SURJK at Jan. 4, 2022, 4:59 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
SURJK
Highly Voted 3 years, 7 months ago
Answer: D --> Q? states transactional SQL, so its Spanner
upvoted 9 times
...
oncleled
Highly Voted 2 years, 8 months ago
Selected Answer: D
Google BigQuery does not support transactions and does not allow updating of existing records. On the other hand, Google Cloud Spanner supports OLTP along with scalability and high availability.
upvoted 8 times
...
Alpha111
Most Recent 5 months ago
Selected Answer: D
Spanner decouples compute resources from data storage, which makes it possible to transparently scale in and out processing resources. Each additional compute capacity can process both reads and writes, providing effortless horizontal scalability. Spanner optimizes performance by automatically handling the sharding, replication, and transaction processing.
upvoted 1 times
...
nsjag_1
5 months ago
Selected Answer: A
BigQuery for scalable, serverless, and cost-effective SQL-based analytics.
upvoted 1 times
...
sp2020
7 months ago
Selected Answer: A
"transactional SQL queries against HISTORICAL data at scale" sounds more like data analytics on historical data than OLTP, I'm leaning towards BigQuery (A)
upvoted 1 times
...
trkmdu
7 months ago
Selected Answer: A
It's definitely BigQuery. Do not get carried away by the word 'Transactional'. It simply means running simple SQL queries. The keyword to look for is historical data. You wouldn't use Spanner for storing historical data. It's always BigQuery.
upvoted 1 times
...
Viztvm
8 months, 4 weeks ago
Selected Answer: D
Specifically says transations which means Spanner.
upvoted 1 times
...
JJV19
9 months, 2 weeks ago
Selected Answer: A
Bigquery all the way. Spanner is HUGE for big companies like Google so it's overkill
upvoted 1 times
...
developersean
9 months, 3 weeks ago
The answer is A; hint being transactional as oppose to unstructured
upvoted 1 times
...
7c3bc28
11 months, 1 week ago
Selected Answer: A
I challenge the votes - it is Bigquery IMHO as it only ask "to run transactional SQL queries against historical data", Spanner would be quite expensive for this purpose.
upvoted 1 times
...
philopino
11 months, 3 weeks ago
Selected Answer: D
BQ for Analytics and ML, Spanner for OLTP
upvoted 2 times
...
trustud
1 year, 1 month ago
A, analyze HISTORICAL data, not real time DB processing data. Its BQ. They want to analyze data mgt. It's not Spanner.
upvoted 2 times
...
Surek
1 year, 7 months ago
Go for D
upvoted 1 times
...
chai_gpt
1 year, 9 months ago
Selected Answer: D
D is correct
upvoted 1 times
...
__rajan__
1 year, 9 months ago
Selected Answer: D
Cloud Spanner is a globally distributed, strongly consistent, and horizontally scalable database service on Google Cloud. It's designed for high availability, scalability, and transactional consistency, making it a great choice for applications that require both transactional and analytical capabilities.
upvoted 3 times
...
mdsarfraz69
1 year, 10 months ago
Selected Answer: D
D is correct
upvoted 1 times
...
Chinaar
1 year, 11 months ago
Correct Answer is A Big query
upvoted 1 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel