Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Google Professional Data Engineer Exam - Topic 5 Question 89 Discussion

Posted by Penney on Jul 18, 2024 at 01:13 AM

Which of these sources can you not load data into BigQuery from?

Get Premium Professional Data Engineer Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test
37 comments · newest first
MI
Mike 11 months ago
File upload, Google Drive, and Google Cloud Storage are all valid sources.
EL
Elke 11 months ago
I thought you could load from any Google service, but I guess not!
KR
Kris 11 months ago
Wait, you can't load from Google Cloud SQL? That seems weird.
LE
Leonie 11 months ago
Totally agree, D is the odd one out!
TA
Tashia 12 months ago
You can load data from all those sources except D.
TH
Theola 12 months ago
I’m pretty sure you can load from Google Cloud Storage and file uploads, but I can't recall if Cloud SQL is included.
JU
Julieta 1 year ago
I feel like file uploads and Google Drive are definitely options, but I’m uncertain if Cloud SQL is a valid source for loading data.
LE
Lettie 1 year ago
I remember practicing a question like this, and I think you can load from Google Drive and Cloud Storage, but I’m confused about Cloud SQL.
CA
Carlene 1 year ago
I think we can load data from all these sources, but I’m not entirely sure about Google Cloud SQL.
VE
Verona 1 year ago
I'm a bit confused on this one. I know we can load data from various sources into BigQuery, but I'm not sure which one is the exception. I'll have to review the material on BigQuery data sources again before answering this.
LE
Letha 1 year ago
Okay, let me think this through step-by-step. BigQuery is a data warehouse service, so it makes sense that we can load data from file uploads, Google Drive, and Google Cloud Storage, which are all common data sources. But Google Cloud SQL is a relational database service, so that's probably not a valid option for loading data directly into BigQuery. I'm feeling confident about this one.
SI
Simona 1 year ago
Hmm, I'm a bit unsure about this one. I know we can load data from Google Drive, Google Cloud Storage, and file uploads, but I'm not 100% certain about Google Cloud SQL. I'll have to think this through carefully.
TO
Tonja 1 year ago
This one seems pretty straightforward. I'm pretty sure Google Cloud SQL is the only option that can't be used to load data into BigQuery.
BR
Brigette 1 year ago
Hmm, I'm not too sure about this one. I know there are a few different package management commands, but I'm not sure which one is specifically for dealing with partially installed packages. I'll have to think about this a bit more.
BE
Beata 1 year ago
Hmm, I'm a bit confused by the options here. I know the incident handling process has different phases, but I'm not sure which one specifically deals with identifying an event vs. an incident.
IL
Ilene 1 year ago
D) Google Cloud SQL? As if! That's like trying to load data from Excel into a spreadsheet. Clearly the wrong answer here.
YU
Yuki 1 year ago
Ooh, this is a tough one. I'm gonna go with D. Can't imagine BigQuery playing nice with a full-fledged SQL database.
BR
Britt 1 year ago
↳ replying to Yuki
I'm not so sure about that. I think Google Cloud SQL could still be a valid option for loading data into BigQuery.
YV
Yvonne 1 year ago
↳ replying to Yuki
Yeah, I agree. BigQuery is more for analyzing data, not for loading it from a SQL database.
DE
Desmond 1 year ago
↳ replying to Yuki
I think you're right, D does seem like the odd one out here.
ST
Stephen 1 year ago
I'm going with C. Google Cloud Storage is the go-to option for loading data into BigQuery. The other choices seem too obvious.
RO
Rosendo 1 year ago
↳ replying to Stephen
C) Google Cloud Storage
MI
Milly 1 year ago
↳ replying to Stephen
B) Google Drive
TA
Tasia 1 year ago
↳ replying to Stephen
A) File upload
SH
Sharika 1 year ago
Hmm, I'm pretty sure the answer is D. BigQuery is more for unstructured data, not relational databases like Cloud SQL.
RU
Rusty 1 year ago
↳ replying to Sharika
I agree, D is the correct answer. BigQuery is not designed for loading data from relational databases like Cloud SQL.
CA
Cassi 1 year ago
↳ replying to Sharika
D) Google Cloud SQL
SA
Sarina 1 year ago
↳ replying to Sharika
C) Google Cloud Storage
LO
Louann 1 year ago
↳ replying to Sharika
B) Google Drive
DA
Daisy 1 year ago
↳ replying to Sharika
A) File upload
CY
Cyndy 2 years ago
D) Google Cloud SQL? Really? I thought we could load data from any Google service into BigQuery. This is a tricky one!
GE
Gerardo 1 year ago
↳ replying to Cyndy
C) Google Cloud Storage
LU
Luisa 1 year ago
↳ replying to Cyndy
B) Google Drive
JA
Jaleesa 1 year ago
↳ replying to Cyndy
A) File upload
CH
Chauncey 2 years ago
I'm not sure, but I think it's actually A) File upload.
AI
Ailene 2 years ago
No, I believe you can't load data from Google Drive.
CH
Chauncey 2 years ago
I think the answer is D) Google Cloud SQL.
0/2000 characters

Save Cancel