The recommended architecture is to maintain a single governed dashboard and enforce data visibility through application roles and row-level security in the semantic model . Oracle Analytics allows semantic-model data filters to be assigned to specific application roles. When a user queries an object protected by those filters, Oracle Analytics incorporates the applicable security predicates into the generated query, restricting results to the rows that user's roles are authorized to access.

For example, executives can all open the same Revenue dashboard while a Business Unit data filter automatically restricts each executive to the appropriate organizational data. This approach centralizes dashboard maintenance and security policy while avoiding duplicated content.

Dashboard prompts are useful for interactive filtering, but user-controlled prompts are not a substitute for authorization. Separate dashboards or subject areas for every executive create unnecessary maintenance and introduce the risk of inconsistent logic.

Oracle specifically recommends applying data filters to application roles rather than individual users for scalable row-level security. Therefore, C is the correct governed implementation.

Reference Topic: Managing Administration, Security, and Performance — Application Roles and Row-Level Security

===============