To expose a hierarchy to SQL, the following conditions must be met:
* B. The hierarchy must be a shared hierarchy: This ensures the hierarchy is reusable and can be consumed in other scenarios.
* D. The hierarchy must be exposed by a CUBE calculation view with a star join: Only a cube view with a star join supports SQL exposure for hierarchies.
Local hierarchies and those defined in non-cube calculation views are not SQL-exposed.

To assign a user-provided service to your database module in an XS Advanced project, you configure it in the.
yamlfile. This file is used to define the bindings between the project modules and the required services, such as user-provided services for accessing external schemas.

When creating a calculation view that accesses a table in an external schema:
* A. Synonym: Synonyms act as aliases to access external schema objects. They are required to integrate external tables into the calculation view.
* D. Authorization: You need appropriate schema authorizations to access the external table through the synonym.
A remote source (B) is used for accessing remote systems, and an SQL view (C) is not necessary for this scenario.