AWS Exams GCP Exams Azure Exams GitHub Exams Jira Exams ISC2 Exams

Video: You have recently migrated your ETL workflows to gcp video

Question 1
« Back   Next gcp data-engineer-pro Question »

Full Certification Question

You have recently migrated your ETL workflows to run on BigQuery. To ensure correctness, you need to verify that the output data from the migrated jobs exactly matches the output produced by the original ETL jobs. You’ve loaded the original job’s results into a BigQuery table. However, neither table contains a primary key, so you cannot use a direct join for row-by-row comparison. How can you verify that the contents of the two tables are identical?