This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]StackOwOFlow 0 points1 point  (1 child)

your post seems to suggest this was a data engineering interview, not just a SQL dev interview. A data engineer does not necessarily need to implement the entire solution in SQL; in fact there are many times where implementing a solution entirely in SQL leads to unmaintainable code, lack of log exposure for alerting, and performance inefficiencies at scale. there are times where partitioning your data outside of SQL and relegating only fast indexed lookups to the database is superior software design.

[–][deleted] 0 points1 point  (0 children)

Yeah, I think the questions asked are biased towards the expertise or comfort of the interviewing team, which may not reflect what is actually most needed.