Consider the following scenario: A customer has asked to determine their Hires, Terminations, and Movement Events using the following Event codes: H - Hire P - Promotion D - Demotion X - Transfer T
- Termination. Promotions are only counted if there is an increase in the Salary Band and Demotions are only counted if there is a decrease in the Salary Band. What is the minimum number of Hire/Movement/Termination conditions that can be created to fulfill these requirements?

• A.7: An Event List condition for each movement type. An Increase in Value for Promotions. A Decrease in Value for Demotions
• B.3: An Event List condition for Hires, Promotions, Demotions, Transfers, and Terminations. An Increase in Value for Promotions. A Decrease in Value for Demotions
• C.5: An Event List condition for Hires, Internal Movements, and Terminations. An Event List and an Increase in Value for Promotions. An Event List and a Decrease in Value for Demotions
• D.5: An Event List condition for Hires, Transfers, and Terminations. An Event List and an Increase in Value for Promotions. An Event List and a Decrease in Value for Demotions

Comment: *

Name: *

Email: *

Verification: *

What could be reasons that codes appear under the 'Unmapped' category for a SQL-generated dimension structure? Note: There are 3 correct Answers to this question.

• A.Leaf node IDs generated via SQL do NOT match the values returned in the data.
• B.The SQL statement returns the internal code and employee data uses the external code.
• C.Leaf node descriptions generated via SQL do NOT match the values returned in the data.
• D.The SQL statement returns the external code and employee data uses the internal code.
• E.The SQL statement returns the external code and employee data uses the external code.

Comment: *

Name: *

Email: *

Verification: *

The following code is used for EOP headcount and SOP headcount:
If((in([%EMP_JOB_INFO_T.EMPLOYMENT_STATUS%], 'A','U','P') OR
ISNULL([%EMP_JOB_INFO_T.EMPLOYMENT_STATUS%])), [%#CFT#.HEAD_COUNT%], 0). Which setting results in each measure produce different results?

• A.Data type
• B.Aggregation type
• C.Standard measure
• D.Measure override name

Comment: *

Name: *

Email: *

Verification: *

To which measures does the following calculation apply?
if((in([%EMP_JOB_INFO_T.EMPLOYMENT_STATUS%], 'A','U','P') OR
ISNULL([%EMP_JOB_INFO_T.EMPLOYMENT_STATUS%])), [%#CFT#.HEAD_COUNT%], 0). Note: There are
3 correct Answers to this question.

• A.Average headcount
• B.EOP headcount - inactive and other
• C.SOP headcount
• D.EOP headcount
• E.FTE headcount

Comment: *

Name: *

Email: *

Verification: *

How can a technical consultant organize multiple records with the same Effective From Date into one Fact Table record?

• A.Use a calculated column called Effective Sequence.
• B.Use the To Date Special Use Type on a date field.
• C.Use a calculated column to filter unwanted records.
• D.Use the Effective Sequence Special Use Type on a numeric field.

Comment: *

Name: *

Email: *

Verification: *