Google Cloud Associate Data Practitioner — Question 85

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?

Answer options

• 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.

Correct answer: C

Explanation

The correct answer is C, as executing the bq load command directly on your local machine allows for a straightforward one-time import of files into BigQuery with minimal setup. Options A, B, and D involve more complex setups, such as writing scripts or setting up clusters, which are not necessary for a simple one-time load.