* Data Mart DataStore Object Properties:
* Designed for flexible reporting scenarios where data is treated with minimal restrictions.
* Key Behaviors:
* Union for Reporting (Answer C):Combines inbound and active tables for reporting, allowing real-time insights.
* Key Handling (Answer D):All characteristics are treated as part of the key, ensuring no duplicate records in the Data Mart.
* Change Log Activation (Option A):The change log is irrelevant for Data Mart DSOs.
* Query Results (Option B):Query results can be shown even before data activation.
Incorrect Options:References:
* SAP BW/4HANA Advanced DataStore Object Documentation
* SAP Data Mart Modeling Guide

In SAP BW queries, external hierarchy properties can be modified within the query definition to control the display and behavior of hierarchical data. The following properties can be customized:
* Position of Child Nodes (Answer A):
* Allows rearranging the order in which child nodes appear under their parent nodes.
* This customization provides better alignment with user requirements or logical presentation of data.
* Sort Direction (Answer B):
* Enables sorting of nodes in ascending or descending order.
* The sorting can be applied to meet reporting requirements and improve data readability.
* Expand to Level (Answer C):
* Controls the hierarchy's initial expansion level when the query is executed.
* This is particularly useful for displaying specific levels of the hierarchy based on user preferences.
* Display Text Nodes (Option D):Text node display is not directly adjustable via query definition.
* Time Dependency (Option E):Time dependency of hierarchies is maintained during hierarchy creation but cannot be altered within the query definition.
Incorrect Options:References:
* SAP Help Portal - Hierarchies in BW Queries
* SAP BW Query Design Documentation

Deleting master data in SAP BW/4HANA requires careful consideration of dependencies to ensure data integrity and system stability. Below is a detailed explanation of the prerequisites for deleting business partner attribute master data:
* Explanation: While it is important to ensure that queries do not rely on specific master data values, this is not a strict prerequisite for deleting master data. Queries using business partner as a free characteristic will not prevent the deletion of master data, as long as there are no active dependencies such as transaction data or authorizations tied to those values.

In SAP Data Engineer - Data Fabric, particularly when working with hierarchies in query definitions, external hierarchies are used to organize and structure data in a meaningful way for reporting and analysis. External hierarchies are predefined hierarchies that can be integrated into queries, and certain properties of these hierarchies can be adjusted within the query definition to meet specific reporting requirements.
* B. Sort direction
* The sort direction determines the order in which the hierarchy nodes are displayed in the query results. You can choose to sort the hierarchy in ascending or descending order based on node names, key values, or other attributes. This property is adjustable in the query definition to allow flexibility in how the data is presented to end users.