Data Engineering y BigQuery V1
Quiz
•
Computers
•
12th Grade
•
Hard
Academia Google
Used 9+ times
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
5 mins • 1 pt
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
3.
MULTIPLE CHOICE QUESTION
5 mins • 1 pt
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
What should you do?
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
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

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
Similar Resources on Wayground
12 questions
Wee Word Intro
Quiz
•
7th - 12th Grade
15 questions
หน่วยที่ 1 ความรู้พื้นฐานการจัดการ ข้อมูลขนาดใหญ่ (Big Data)
Quiz
•
9th - 12th Grade
10 questions
Hour of Code
Quiz
•
2nd - 12th Grade
15 questions
ONLINE Quiz - Computer Hardware Basics (COMSYS 1)
Quiz
•
12th Grade
14 questions
TCP/IP & other protocols [A Level]
Quiz
•
12th Grade
13 questions
Five Nights At Freddy's: Security Breach Quiz
Quiz
•
KG - Professional Dev...
10 questions
My Sql
Quiz
•
12th Grade
15 questions
4.6.4 Logic Gates
Quiz
•
10th Grade - Professi...
Popular Resources on Wayground
20 questions
Halloween Trivia
Quiz
•
6th - 8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
Order of Operations
Quiz
•
5th Grade
20 questions
Halloween
Quiz
•
5th Grade
16 questions
Halloween
Quiz
•
3rd Grade
12 questions
It's The Great Pumpkin Charlie Brown
Quiz
•
1st - 5th Grade
20 questions
Possessive Nouns
Quiz
•
5th Grade
10 questions
Halloween Traditions and Origins
Interactive video
•
5th - 10th Grade
