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

Exam Professional Cloud Architect All Questions

View all questions & answers for the Professional Cloud Architect exam
Go to Exam

Exam Professional Cloud Architect topic 1 question 74 discussion

Actual exam question from Google's Professional Cloud Architect
Question #: 74
Topic #: 1
[All Professional Cloud Architect Questions]

You are tasked with building an online analytical processing (OLAP) marketing analytics and reporting tool. This requires a relational database that can operate on hundreds of terabytes of data. What is the Google-recommended tool for such applications?

  • A. Cloud Spanner, because it is globally distributed
  • B. Cloud SQL, because it is a fully managed relational database
  • C. Cloud Firestore, because it offers real-time synchronization across devices
  • D. BigQuery, because it is designed for large-scale processing of tabular data
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by AWS56 at Jan. 12, 2020, 2:42 p.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
AWS56
Highly Voted 5 years, 3 months ago
Agree D
upvoted 21 times
tartar
4 years, 9 months ago
D is ok
upvoted 5 times
Nastrand
4 years, 3 months ago
What about the relational part? BigQuery uses SQL but it's not relational... I'm not sure its D
upvoted 4 times
riflerrick
3 years, 10 months ago
BigQuery is relational!
upvoted 5 times
...
lovingsmart2000
3 years, 9 months ago
Pls do not confuse - Cloud SQL and BigQuery are RDBMS. Cloud Datastore, Bigtable are NoSQL. Right answer is D - BQ
upvoted 15 times
...
...
...
kumarp6
4 years, 6 months ago
Yes it is D
upvoted 2 times
...
nitinz
4 years, 2 months ago
D, OLAP=BQ
upvoted 5 times
Sur_Nikki
1 year, 12 months ago
Well Said
upvoted 1 times
...
...
JasonL_GCP
3 years, 6 months ago
The question asks "This requires a relational database that can operate on hundreds of terabytes of data", but bq doesn't meet this condition?
upvoted 2 times
elaineshi
2 years, 11 months ago
BigQuery supports relational and query of join tables.
upvoted 2 times
...
...
...
gfhbox0083
Highly Voted 4 years, 10 months ago
D, for sure. BigQuery for OLAP Google Cloud Spanner for OLTP.
upvoted 16 times
...
gracjanborowiak
Most Recent 9 months, 3 weeks ago
Selected Answer: D
sql is oltp olap is data cube. lots of data which we try to process somehow. biq query is for that. firestore is for mobile and web apps. not so fast nosql db.
upvoted 1 times
...
Anandmrk
1 year, 2 months ago
Agreed
upvoted 1 times
...
AdityaGupta
1 year, 6 months ago
Selected Answer: D
4 reasons to choose BQ (Supports Petabytes of data) - OLAP Data - Relational DB (SQL) - 100s of TB data - Analystics and Reporting
upvoted 1 times
...
Ashish1995
2 years, 1 month ago
Selected Answer: D
D is obvious
upvoted 1 times
...
CGS22
2 years, 1 month ago
Selected Answer: D
D is the right one
upvoted 1 times
...
SudhirAhirkar
2 years, 4 months ago
Cloud SQL/Spanner is OLTP DB but not OLAP. BQ is a well-known OLAP for analytics and also supports RBMS feature too... so I would got with D
upvoted 1 times
...
AniketD
2 years, 5 months ago
Selected Answer: D
D is correct. BigQuery is relational. Cloud SQL is not OLAP; moreover it can not store/process hundreds of TB of data. Max size is 64 TB only.
upvoted 1 times
...
megumin
2 years, 5 months ago
Selected Answer: D
D is ok
upvoted 1 times
...
SerGCP
2 years, 6 months ago
Selected Answer: D
https://cloud.google.com/products/databases.
upvoted 1 times
...
zr79
2 years, 6 months ago
The words you need to focus "You are tasked with building an online analytical processing (OLAP) marketing analytics and reporting tool" which is BigQuery
upvoted 1 times
...
AzureDP900
2 years, 6 months ago
Big Query for large analytics , D is right
upvoted 1 times
...
Andre777
2 years, 7 months ago
Selected Answer: D
The keyword in this context is OLAP. CloudSQL is Relational SQL for OLTP. Capacity wise, BQ supports for PB+ while CloudSQL only have max capacity of up to ~10TB. Again the questions specifically mention "hundreds of TB of data". So D is the answer.
upvoted 2 times
...
deepdowndave
2 years, 7 months ago
Why is it not CloudSQL? It supports TB data storage and the question is about a relational database, not a data warehouse such as BigQuery.
upvoted 1 times
Andre777
2 years, 7 months ago
The keyword in this context is OLAP. CloudSQL is Relational SQL for OLTP. Capacity wise, BQ supports for PB+ while CloudSQL only have max capacity of up to ~10TB. Again the questions specifically mention "hundreds of TB of data". So D is the answer.
upvoted 1 times
...
...
alexandercamachop
2 years, 7 months ago
The answer is Big Query, D Secret: Analytical, Hundreds of TBTs. Relational. All of this are strictly meet by Big Query, if it had not said Analytical but rather, other keywords like High Availability then Cloud Spanner.
upvoted 1 times
...
Thornadoo
2 years, 9 months ago
Selected Answer: D
Guys, this is easy: OLTP - Cloud Spanner & Cloud SQL OLAP - Big Query NoSQL - Filestore and Big Table So answer is D.
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago