Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
After migrating an ETL job to BigQuery, how can you compare its output with the original job's output when the tables lack a primary key for joining, but you have the original job's output table?
A
Use the RAND() function to select random samples from each table and compare these samples.
B
Employ the HASH() function to select random samples from the tables and compare these samples.
C
Utilize a Dataproc cluster with the BigQuery Hadoop connector to read data from each table, sort the data, and calculate a hash from non-timestamp columns for comparison.
D
Create stratified random samples using the OVER() function and compare equivalent samples from each table.