GCP-ADP Data Preparation And Ingestion Practice Question
You have a large CSV file in Cloud Storage that needs to be loaded into BigQuery. The file contains a nested JSON structure in one column. How should you best prepare this data?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Use a BigQuery load job with autodetect
Using BigQuery's native JSON support or Dataflow allows parsing nested structures during the load process.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Convert to Parquet before loading
Why it's wrong here
While effective, it is not the most direct method if the CSV can be ingested directly.
- ✗
Upload as a text file and use BigQuery federated queries
Why it's wrong here
Federated queries are slower than native loads and don't parse JSON inherently.
- ✓
Use a BigQuery load job with autodetect
Why this is correct
BigQuery can infer schema and handle nested JSON if the format is correct.
- ✗
Use Cloud Storage transfer service
Why it's wrong here
Transfer service just moves the file; it doesn't parse it.
About these practice questions
Courseiva writes every GCP-ADP question from scratch — 205 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed August 2026 · checked against the official Google Cloud exam blueprint
This GCP-ADP practice question is part of Courseiva's free Google Cloud certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the GCP-ADP exam.