Tableau : Duel axis chart why do you use it? SQL: Difference between having and where clause? Familiarity with different JOIN concept? Behavioral: What approach due you use in choosing among multiple high priority tasks? Suppose you're a B.A in a team does overseas credit card payment conflict. You witnessed multiple such conflicts at once and you'd need to prioritize your attention towards any of the conflict. How'd you go about it? What would be your approach? Consider yourself as a Product manager. A new product is being introduced (for instance Copilot in Organization MS suite). You have go ahead from your Product team and data engineering team. But you face setback from your legal team, security team. How'd you tackle such situation? What factors would you consider in adopting Copilot? What would be your approach? Scenario based Problem solving: Bank of America wants to introduce a new credit card that would cost customer $90/ annum (collected at the end of the 12 months) with 10% APR. The operation and collaboration with other vendors cost the bank 4% on every transaction. The bank makes it cut of 3% on every transaction. Assuming the sample population who took the cards is 1 lacs (out of which only 80% used the credit card, rest 20% didn't used it at all). Also, the bank do not charge any amount if you have never used the credit card. As a B.A How'd you determine whether the bank should introduce this card to nationwide with large audience in USA. At what average transaction value per customer per day will this credit card system will prove to be profitable for bank? Agile: How do you manage product backlog in JIRA? How do you prioritize your work when a urgent request from stakeholders comes up in a sprint?
Sigiloso
SQL , Agile and Tableau question was quite easy. The section that put me off balance was the Problem solving question. This reminded me more of a Management consultancy questions. You need to assume a lot, ask a lot of follow-up question. Since, my inexperience in the field led me to ask fewer follow-up questions on it.