ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Associate Data Practitioner All Questions

View all questions & answers for the Associate Data Practitioner exam
Go to Exam

Exam Associate Data Practitioner topic 1 question 27 discussion

Actual exam question from Google's Associate Data Practitioner
Question #: 27
Topic #: 1
[All Associate Data Practitioner Questions]

You are using your own data to demonstrate the capabilities of BigQuery to your organization’s leadership team. You need to perform a one- time load of the files stored on your local machine into BigQuery using as little effort as possible. What should you do?

  • A. Write and execute a Python script using the BigQuery Storage Write API library.
  • B. Create a Dataproc cluster, copy the files to Cloud Storage, and write an Apache Spark job using the spark-bigquery-connector.
  • C. Execute the bq load command on your local machine.
  • D. Create a Dataflow job using the Apache Beam FileIO and BigQueryIO connectors with a local runner.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by n2183712847 at Feb. 27, 2025, 6 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
n2183712847
2 months ago
Selected Answer: C
C. bq load is best for one-time transfer from local machine to BQ
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago