This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Senior Data Engineer at Robinhood. The product team needs a comprehensive position report that shows who owns each position, which portfolio it belongs to, and what security it represents. This requires linking four tables: positions connect to portfolios (for account context), portfolios connect to users (for ownership), and positions connect to securities (for ticker details). Build this denormalized view so the team can analyze holdings across users.
You are a Senior Data Engineer at Robinhood. The product team needs a comprehensive position report that shows who owns each position, which portfolio it belongs to, and what security it represents. This requires linking four tables: positions connect to portfolios (for account context), portfolios connect to users (for ownership), and positions connect to securities (for ticker details). Build this denormalized view so the team can analyze holdings across users.