Adobe Data Science Engineer interview questions

Asked basic questions based on joins and data extraction: 1. Tv campaign sees increase in traffic after campaign. How would you understand the data? what's the impact of campaign? How to calculate the Avg of last weeks. 2. Table created_date, user_id, event_type (like, comment, post). List of users who neither liked nor commented) 3.Create cumulative sum of revenue which reset every start of year. (With and without windows function) 4.How to detect anomaly in data traffic. How will you build a system to identify this