Google Exam Professional Data Engineer Topic 5 Question 75 Discussion

Actual exam question for Google's Professional Data Engineer exam

Question #: 75
Topic #: 5

[All Professional Data Engineer Questions]

Your company is loading comma-separated values (CSV) files into Google BigQuery. The data is fully imported successfully; however, the imported data is not matching byte-to-byte to the source file. What is the most likely cause of this problem?

AThe CSV data loaded in BigQuery is not flagged as CSV.

BThe CSV data has invalid rows that were skipped on import.

CThe CSV data loaded in BigQuery is not using BigQuery's default encoding.

DThe CSV data has not gone through an ETL phase before loading into BigQuery.

Show Suggested Answer

Suggested Answer: D

by Karl at Dec 21, 2023, 08:28 PM

Limited Time Offer

25%

Off

Get Premium Professional Data Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Vincent

7 days ago

I agree with Ayesha, option B makes the most sense because invalid rows could cause the mismatch.

upvoted 0 times

...

Cordell

8 days ago

I disagree, I believe it could be option C.

upvoted 0 times

...

Ayesha

10 days ago

I think the most likely cause is option B.

upvoted 0 times

...

Sue

13 days ago

I think the most likely cause is option C - the CSV data loaded in BigQuery is not using BigQuery's default encoding. I've seen this issue before when the source file uses a different encoding than what BigQuery expects.

upvoted 0 times

...