Data Engineering y BigQuery V1

Data Engineering y BigQuery V1

12th Grade

10 Qs

quiz-placeholder

Similar activities

EMPTECH L4 Q3

EMPTECH L4 Q3

12th Grade

10 Qs

Microcontroller

Microcontroller

11th Grade - University

10 Qs

Input, output and storage de

Input, output and storage de

8th Grade - Professional Development

14 Qs

คำถาม เรื่อง การวิเคราะห์ข้อมูลเชิงพรรณนา

คำถาม เรื่อง การวิเคราะห์ข้อมูลเชิงพรรณนา

12th Grade

15 Qs

1.4 Data structures - graphs #1

1.4 Data structures - graphs #1

12th Grade

12 Qs

ZOOM QUIZ

ZOOM QUIZ

1st - 12th Grade

10 Qs

loop while/do while

loop while/do while

7th - 12th Grade

10 Qs

Chapter 6 Part 2 - 4

Chapter 6 Part 2 - 4

11th - 12th Grade

11 Qs

Data Engineering y BigQuery V1

Data Engineering y BigQuery V1

Assessment

Quiz

Computers

12th Grade

Hard

Created by

Academia Google

Used 9+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

5 mins • 1 pt

Media Image

What should you do?

Use Prophet on Vertex AI Training to build a custom model.

Use Vertex AI Forecast to build a NN-based model.

Use BigQuery ML to build a statistical ARIMA_PLUS model.

Use TensorFlow on Vertex AI Training to build a custom model.

2.

MULTIPLE CHOICE QUESTION

5 mins • 1 pt

Media Image

Media Image
Media Image
Media Image
Media Image

3.

MULTIPLE CHOICE QUESTION

5 mins • 1 pt

Media Image

How should you implement the preprocessing workflow?

Implement a preprocessing pipeline by using Apache Spark, and run the pipeline on Dataproc. Save the preprocessed data as CSV files in a Cloud Storage bucket

Load the data into a pandas DataFrame. Implement the preprocessing steps using pandas transformations, and train the model directly on the DataFrame.

Perform preprocessing in BigQuery by using SQL. Use the BigQueryClient in TensorFlow to read the data directly from BigQuery.

Implement a preprocessing pipeline by using Apache Beam, and run the pipeline on Dataflow. Save the preprocessed data as CSV files in a Cloud Storage bucket.

4.

MULTIPLE CHOICE QUESTION

5 mins • 1 pt

Media Image

What should you do?

Media Image
Media Image
Media Image
Media Image

5.

MULTIPLE SELECT QUESTION

5 mins • 1 pt

You are developing a model to help your company create more targeted online advertising campaigns. You need to create a dataset that you will use to train the model. You want to avoid creating or reinforcing unfair bias in the model. What should you do? (Choose two.)

Include a comprehensive set of demographic features.

Include only the demographic groups that most frequently interact with advertisements.

Collect a random sample of production traffic to build the training dataset.

Collect a stratified sample of production traffic to build the training dataset.

Conduct fairness tests across sensitive categories and demographics on the trained model.

6.

MULTIPLE CHOICE QUESTION

5 mins • 1 pt

You work at a gaming startup that has several terabytes of structured data in Cloud Storage. This data includes gameplay time data, user metadata, and game metadata. You want to build a model that recommends new games to users that requires the least amount of coding. What should you do?

Load the data in BigQuery. Use BigQuery ML to train an Autoencoder model.

Load the data in BigQuery. Use BigQuery ML to train a matrix factorization model.

Read data to a Vertex AI Workbench notebook. Use TensorFlow to train a two-tower model.

Read data to a Vertex AI Workbench notebook. Use TensorFlow to train a matrix factorization model.

7.

MULTIPLE CHOICE QUESTION

5 mins • 1 pt

Media Image

How should you configure this workflow?

Write the transformations into Spark that uses the spark-bigquery-connector, and use Dataproc to preprocess the data.

Write SQL queries to transform the data in-place in BigQuery.

Add the transformations as a preprocessing layer in the TensorFlow models.

Create a Dataflow pipeline that uses the BigQuerylO connector to ingest the data, process it, and write it back to BigQuery.

Create a free account and access millions of resources

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?

Discover more resources for Computers