Which of these sources can you not load data into BigQuery from?
Suggested Answer: C
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
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
Yeah, I agree. BigQuery is more for analyzing data, not for loading it from a SQL database.
DE
Desmond
1 year ago
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
C) Google Cloud Storage
MI
Milly
1 year ago
B) Google Drive
TA
Tasia
1 year ago
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
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
D) Google Cloud SQL
SA
Sarina
1 year ago
C) Google Cloud Storage
LO
Louann
1 year ago
B) Google Drive
DA
Daisy
1 year ago
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
C) Google Cloud Storage
LU
Luisa
1 year ago
B) Google Drive
JA
Jaleesa
1 year ago
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.