Exhibit.

In the given scenario, where the data architect is provided with five tables, the goal is to design the most optimal data model for use in Qlik Sense. The key considerations here are to ensure a proper star schema, minimize redundancy, and ensure clear and efficient relationships among the tables.

Option Dis the most optimal model for the following reasons:

Star Schema Design:

In Option D, the Fact_Gross_Sales table is clearly defined as the central fact table, while the other tables (Dim_SalesOrg, Dim_Item, Dim_Region, Dim_Customer) serve as dimension tables. This layout adheres to the star schema model, which is generally recommended in Qlik Sense for performance and simplicity.

Minimization of Redundancies:

In this model, each dimension table is only connected directly to the fact table, and there are no unnecessary joins between dimension tables. This minimizes the chances of redundant data and ensures that each dimension is only represented once, linked through a unique key to the fact table.

Clear and Efficient Relationships:

Option D ensures that there is no ambiguity in the relationships between tables. Each key field (like Customer ID, SalesID, RegionID, ItemID) is clearly linked between the dimension and fact tables, making it easy for Qlik Sense to optimize queries and for users to perform accurate aggregations and analysis.

Hierarchical Relationships and Data Integrity:

This model effectively represents the hierarchical relationships inherent in the data. For example, each customer belongs to a region, each salesperson is associated with a sales organization, and each sales transaction involves an item. By structuring the data in this way, Option D maintains the integrity of these relationships.

Flexibility for Analysis:

The model allows users to group and filter data efficiently by different attributes (such as salesperson, region, customer, and item). Because the dimensions are not interlinked directly with each other but only through the fact table, this setup allows for more flexibility in creating visualizations and filtering data in Qlik Sense.

References:

Qlik Sense Best Practices: Adhering to star schema designs in Qlik Sense helps in simplifying the data model, which is crucial for performance optimization and ease of use.

Data Modeling Guidelines: The star schema is recommended over snowflake schema for its simplicity and performance benefits in Qlik Sense, particularly in scenarios where clear relationships are essential for the integrity and accuracy of the analysis.