L3 Round:
1)What are the last 10 versions of the Delta architecture? only last 10 versions. How do they compare?
2)I have a scenario where I have a data table, a one terabyte, which has been fed in with data every day. Now, there is a business requirement that my data table should be synced over incrementally to a SQL server once a day. The data table does not have any watermark, it doesn't have any timestamp, it doesn't have any unique identifier. Now, how do I build the solution to move only the incremental data to SQL?
3)In the SQL server, I have created a staging table in which I have loaded all the incremental data. Now, there is a main table in the SQL server where the staging data needs to go into the main table. How do I load the data from staging to main without the main table being locked, without any downtime, without any performance implications?
4)assume that you have an API with 500 pages. How do you download the data from this API?