Google Cloud Professional Data Engineer — Question 63

Your company uses a proprietary system to send inventory data every 6 hours to a data ingestion service in the cloud. Transmitted data includes a payload of several fields and the timestamp of the transmission. If there are any concerns about a transmission, the system re-transmits the data. How should you deduplicate the data most efficiency?

Answer options

• A. Assign global unique identifiers (GUID) to each data entry.
• B. Compute the hash value of each data entry, and compare it with all historical data.
• C. Store each data entry as the primary key in a separate database and apply an index.
• D. Maintain a database table to store the hash value and other metadata for each data entry.

Correct answer: A

Explanation

Assigning global unique identifiers (GUID) ensures that each data entry can be distinctly identified, making it the most efficient method for deduplication. The other options, while potentially effective, involve additional overhead in terms of computation and storage that could slow down the deduplication process.