Google Cloud Professional Data Engineer PDE — Topic 1 Question 335

Question

You are developing a fraud detection model using BigQuery ML. You have a raw transaction dataset and need to create new features such as the average_transaction_amount_last_24_hours and time_since_last_transaction. These features require aggregation and time-window calculations on the existing data. The goal is to ensure that these features are consistently applied during both model training and prediction without manual intervention. You need to prepare these features efficiently for your model. What should you do?

Accepted Answer

Correct answer: C. The correct answer is C. Option C: Use the TRANSFORM clause within the CREATE MODEL statement, leveraging SQL functions for aggregations and time-based calculations.

Google Cloud Professional Data Engineer PDE — Question 335