Identify the two true statements about alias tables.

Question

Options

• AAlias tables are set up to avoid triangular or circular joins.
• BAlias tables are set up to include best practice naming conventions for physical table names.
• CAlias tables are set up to create another physical copy of the data.
• DAlias tables are set up to create a copy of the data with a filter applied to it.

• A
  78% (32)
• C
  7% (3)
• D
  15% (6)

Explanation

It is a best practice to create aliases for all tables. Aliases are created in the Physical Layer of the repository. Some of the benefits of using aliases are given below: (A) * An alias is used to avoid circular joins and to configure self joins. * You can create a join relationship which is different than the actual foreign key relationship in the database. This helps in defining relationships to meet business model criteria. * Aliases can function in numerous ways to define business model e.g. a table can act both as a dimension and a fact using aliases. (B) * You can rename aliases to make physical and business model easier to understand.

No community discussion yet for this question.