A Data Scientist Has Created a BigQuery ML Model and Asks

question 201

Multiple Choice

A data scientist has created a BigQuery ML model and asks you to create an ML pipeline to serve predictions. You have a REST API application with the requirement to serve predictions for an individual user ID with latency under 100 milliseconds. You use the following query to generate predictions: SELECT predicted_label, user_id FROM ML.PREDICT (MODEL 'dataset.model', table user_features) . How should you create the ML pipeline?

• A) Add a WHERE clause to the query, and grant the BigQuery Data Viewer role to the application service account.
• B) Create an Authorized View with the provided query. Share the dataset that contains the view with the application service account.
• C) Create a Cloud Dataflow pipeline using BigQueryIO to read results from the query. Grant the Dataflow Worker role to the application service account. Create a Cloud Dataflow pipeline using BigQueryIO to read results from the query. Grant the Dataflow Worker role to the application service account.
• D) Create a Cloud Dataflow pipeline using BigQueryIO to read predictions for all users from the query. Write the results to Cloud Bigtable using BigtableIO . Grant the Bigtable Reader role to the application service account so that the application can read predictions for individual users from Cloud Bigtable. to read predictions for all users from the query. Write the results to Cloud Bigtable using BigtableIO . Grant the Bigtable Reader role to the application service account so that the application can read predictions for individual users from Cloud Bigtable.

---

Definitions:

Single-Line Consolidation

A method of accounting in which an investor records the value of its investment in a subsidiary at cost plus any changes due to the investor's share in the subsidiary's income or loss, displayed in a single line in financial statements.

Equity Method

An accounting technique used by a company to record investments in other companies, where the investment is initially recorded at cost and subsequently adjusted for the investor’s share of the investee’s net assets and income.

Investment Balance

The amount currently held in investment accounts, reflecting gains, losses, and contributions to date.

Consolidations

The process of combining multiple financial statements or businesses into one comprehensive financial report or corporate entity, typically to provide a more unified view of financial performance or corporate structure.