ExpertMedium1 markMultiple Choice
GCP ACE · Question 28 · Domain 3.4: Deploying and implementing data solutions
You need to load a large JSONL (JSON Lines) file from Cloud Storage into a BigQuery table. Which TWO methods can you use to accomplish this? (Select TWO)
You need to load a large JSONL (JSON Lines) file from Cloud Storage into a BigQuery table. Which TWO methods can you use to accomplish this? (Select TWO)
Answer options:
A.
Use the bq load command line tool.
B.
Use the gsutil cp command.
C.
Use the BigQuery Data Transfer Service.
D.
Use Cloud SQL import.
E.
Use the gcloud compute copy-files command.
How to approach this question
Identify the tools specifically designed for interacting with BigQuery data loading.
Full Answer
To load data into BigQuery, you can use the `bq load` command from the Cloud SDK, which supports CSV, JSON, Avro, and Parquet formats. You can also use the BigQuery Data Transfer Service to schedule and automate loads from Cloud Storage.
Common mistakes
Thinking `gsutil` can load data into databases.
Practice the full GCP Associate Cloud Engineer Practice Exam 1
50 questions · hints · full answers · grading
More questions from this exam
Q01What is the highest level of the Google Cloud resource hierarchy?EasyQ02You need to enable the Compute Engine API in a new project using the command line. Which command ...EasyQ03You are setting up a new GCP environment. You need to grant a group of developers access to view ...MediumQ04You want to receive an email notification when your GCP spending exceeds $1000 this month. What s...EasyQ05You need to analyze your GCP billing data using complex SQL queries to understand cost trends acr...Medium