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

Exam Professional Machine Learning Engineer All Questions

View all questions & answers for the Professional Machine Learning Engineer exam
Go to Exam

Exam Professional Machine Learning Engineer topic 1 question 77 discussion

Actual exam question from Google's Professional Machine Learning Engineer
Question #: 77
Topic #: 1
[All Professional Machine Learning Engineer Questions]

You need to execute a batch prediction on 100 million records in a BigQuery table with a custom TensorFlow DNN regressor model, and then store the predicted results in a BigQuery table. You want to minimize the effort required to build this inference pipeline. What should you do?

  • A. Import the TensorFlow model with BigQuery ML, and run the ml.predict function.
  • B. Use the TensorFlow BigQuery reader to load the data, and use the BigQuery API to write the results to BigQuery.
  • C. Create a Dataflow pipeline to convert the data in BigQuery to TFRecords. Run a batch inference on Vertex AI Prediction, and write the results to BigQuery.
  • D. Load the TensorFlow SavedModel in a Dataflow pipeline. Use the BigQuery I/O connector with a custom function to perform the inference within the pipeline, and write the results to BigQuery.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by LearnSodas at Dec. 11, 2022, 4:54 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
hiromi
Highly Voted 1 year, 12 months ago
Selected Answer: A
A should work with less effort - https://cloud.google.com/bigquery-ml/docs/making-predictions-with-imported-tensorflow-models#api - https://towardsdatascience.com/how-to-do-batch-predictions-of-tensorflow-models-directly-in-bigquery-ffa843ebdba6
upvoted 11 times
...
desertlotus1211
Most Recent 5 months ago
Selected Answer: D
BigQuery ML does not support importing arbitrary custom TensorFlow models for direct inference
upvoted 2 times
...
livewalk
6 months, 1 week ago
Selected Answer: D
BigQuery ML might not support custom TensorFlow DNN models directly.
upvoted 2 times
...
etienne0
9 months, 2 weeks ago
Selected Answer: C
Went with C
upvoted 1 times
...
pawan94
11 months, 1 week ago
Simplest doesn't mean it is the most effecient/optimal. If I follow the Best practices offered by Google for Serving / Inference Pipeline I would go with Vertex AI predictions. Read More for correct details : https://cloud.google.com/architecture/ml-on-gcp-best-practices#machine-learning-development
upvoted 2 times
etienne0
9 months, 2 weeks ago
Agreed, i'll also go with C.
upvoted 1 times
...
...
M25
1 year, 7 months ago
Selected Answer: A
Went with A
upvoted 2 times
...
JamesDoe
1 year, 8 months ago
Selected Answer: A
https://cloud.google.com/bigquery-ml/docs/making-predictions-with-imported-tensorflow-models
upvoted 2 times
...
enghabeth
1 year, 10 months ago
Selected Answer: A
for this: https://cloud.google.com/bigquery-ml/docs/reference/standard-sql/bigqueryml-syntax-inference-overview Predict the label, either a numerical value for regression tasks or a categorical value for classification tasks on DNN regresion
upvoted 2 times
...
ares81
2 years ago
ml.predict: https://cloud.google.com/bigquery-ml/docs/making-predictions-with-imported-tensorflow-models#api --> A
upvoted 1 times
...
LearnSodas
2 years ago
Selected Answer: A
Answer A as the simplest
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