There are 10 million records in the table and the schema does not contain the ModifiedDate column. One cell was modified the next day in the table. How will you fetch that particular information that needs to be loaded into the warehouse?

Question

Accepted Answer

To fetch the modified information without ModifiedDate column from a table with 10 million records.

Create a trigger to capture the modified information and insert it into a separate table with ModifiedDate column.
Use a tool like Change Data Capture (CDC) to track changes in the table and extract the modified information.
Use a query to compare the current table with a backup copy taken the previous day to identify the modified information.

There are 10 million records in the table and the schema does not contain the ModifiedDate column. One cell was modified the next day in the table. How will you fetch that particular information that needs to be loaded into the warehouse?

Top 7 Eleven Senior Data Engineer interview questions & answers

Popular interview questions of Senior Data Engineer

Top HR questions asked in 7 Eleven Senior Data Engineer