Summer Special Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 8w52ceb345

After migrating ETL jobs to run on BigQuery, you need to verify that the output...

Google Professional-Data-Engineer Full Course Access
Google Professional-Data-Engineer View All Questions

After migrating ETL jobs to run on BigQuery, you need to verify that the output of the migrated jobs is the same as the output of the original. You’ve loaded a table containing the output of the original job and want to compare the contents with output from the migrated job to show that they are identical. The tables do not contain a primary key column that would enable you to join them together for comparison.

What should you do?

A.

Select random samples from the tables using the RAND() function and compare the samples.

B.

Select random samples from the tables using the HASH() function and compare the samples.

C.

Use a Dataproc cluster and the BigQuery Hadoop connector to read the data from each table and calculate a hash from non-timestamp columns of the table after sorting. Compare the hashes of each table.

D.

Create stratified random samples using the OVER() function and compare equivalent samples from each table.

Professional-Data-Engineer PDF/Engine
  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions
buy now Professional-Data-Engineer pdf
Get 60% Discount on All Products, Use Coupon: "8w52ceb345"
Next
You used Cloud Dataprep to create a recipe on a sample of data in a...
You are using Google BigQuery as your data warehouse.
Previous