A company wants to use BigQuery ML to train a DNN_CLASSIFIER model on a dataset with 100 million rows. They are concerned about training time and cost. Which approach can help optimize training performance while staying within BigQuery ML?
Trap 1: Use OPTIONS('MAX_ITERATIONS' = 10) to limit training iterations
While this can reduce time, it may result in underfitting; not an optimization recommendation.
Trap 2: Use Vertex AI AutoML Tables instead of BigQuery ML
This introduces additional complexity and data export; the question asks to stay within BigQuery ML.
Trap 3: Train on a 10% random sample of the data to reduce cost
Sampling reduces representativeness and may not be acceptable for production models.
- A
Use OPTIONS('MAX_ITERATIONS' = 10) to limit training iterations
Why it fails: While this can reduce time, it may result in underfitting; not an optimization recommendation.
- B
Use Vertex AI AutoML Tables instead of BigQuery ML
Why it fails: This introduces additional complexity and data export; the question asks to stay within BigQuery ML.
- C
Train on a 10% random sample of the data to reduce cost
Why it fails: Sampling reduces representativeness and may not be acceptable for production models.
- D
BigQuery ML automatically optimizes training; no additional configuration needed
BigQuery ML handles optimization internally, adjusting training parameters for efficiency.