You Work for a Large Real Estate Firm and Are

question 206

Multiple Choice

You work for a large real estate firm and are preparing 6 TB of home sales data to be used for machine learning. You will use SQL to transform the data and use BigQuery ML to create a machine learning model. You plan to use the model for predictions against a raw dataset that has not been transformed. How should you set up your workflow in order to prevent skew at prediction time?

• A) When creating your model, use BigQuery's TRANSFORM clause to define preprocessing steps. At prediction time, use BigQuery's ML.EVALUATE clause without specifying any transformations on the raw input data.
• B) When creating your model, use BigQuery's TRANSFORM clause to define preprocessing steps. Before requesting predictions, use a saved query to transform your raw input data, and then use ML.EVALUATE.
• C) Use a BigQuery view to define your preprocessing logic. When creating your model, use the view as your model training data. At prediction time, use BigQuery's ML.EVALUATE clause without specifying any transformations on the raw input data.
• D) Preprocess all data using Dataflow. At prediction time, use BigQuery's ML.EVALUATE clause without specifying any further transformations on the input data.

---

Definitions:

Subordinated-Debt Capital

A type of loan that ranks below other loans and securities with respect to claims on assets or earnings in the event of a liquidation or bankruptcy.

Fixed Coupon

A bond or debt security that pays a specified rate of interest throughout its entire term.

Maturity

The state of being fully developed in the body or the mind, or the point at which an instrument of credit becomes due.

Mainstream Venture Capitalists

Investors that focus on providing capital to firms considered to have high growth potential in well-established markets.