Star and Snowflake. Based on requirement the schema is selected. But if you have choice Star is preferred considering it's performance efficiency as fact is directly connected to dimension tables. Less
The interview questions were primarily focused on my area of expertise and comfort with the development tools I would be using in my role. There were not a standard set of STAR questions asked, but instead it was a practical interview focused on finding the right candidate for the team. The interviewers were not interested in throwing me curveballs, the interview process was honest and straightforward.