WFA Exam 2025 Questions and Answers
When would you use a lookup? - ANS Most lookups are used only to change/replace internal
codes into a label (or external code). There are occasions however, where the label (or external
code) is specifically required in the processing of the data
what is a restricted measure? - ANS Not displayed in measures tab of the worforce analytics
portal?
if logic hire
promotion
transfer and job change
Other Movement
Termination
how any event lists are needed? - ANS
If have Headcount 'A', 'U', 'P', what measures do these impact? and what can change them? -
ANS rollu type / aggregation type
Event code and event reasons have... - ANS standard vs custom codes and code reasons
What is built from the data questionaire? - ANS The specification document
Pg. 1 Copyright © 2025 Jasonmcconell. ALL RIGHTS RESERVED.
, If hierarchies are greyed out, preventing from mapping codes located in unmapped -
ANS Generated dimension structures use SQL code or Selected Fields to define the nodes
and hierarchy for the dimension.
What measures are commonly used in benchmark comparisons? - ANS Result Measures
Make event lists for the following event codes:
using conditions as well
hires, Internal Movements, Terminations
Promotions Demotions
increase in value for promotions
decrease in value for demotions
event lists or - ANS Think it's hires movements terminations, then internal movement events
Condition for internal movements events
Import Export configuration in data factory tool - ANS Export config for backup or importing
to another instance or import configuration from another instance
Why doesHC fall under unmapped category for a sql-generated dimension structure -
ANS leaf node IDs in generated via SQL doesn't match the values returned in the data. A
common mistake is to return external code in SQL statement while the column dragged into
that top right window is internal code or vice versa.
Pg. 2 Copyright © 2025 Jasonmcconell. ALL RIGHTS RESERVED.
When would you use a lookup? - ANS Most lookups are used only to change/replace internal
codes into a label (or external code). There are occasions however, where the label (or external
code) is specifically required in the processing of the data
what is a restricted measure? - ANS Not displayed in measures tab of the worforce analytics
portal?
if logic hire
promotion
transfer and job change
Other Movement
Termination
how any event lists are needed? - ANS
If have Headcount 'A', 'U', 'P', what measures do these impact? and what can change them? -
ANS rollu type / aggregation type
Event code and event reasons have... - ANS standard vs custom codes and code reasons
What is built from the data questionaire? - ANS The specification document
Pg. 1 Copyright © 2025 Jasonmcconell. ALL RIGHTS RESERVED.
, If hierarchies are greyed out, preventing from mapping codes located in unmapped -
ANS Generated dimension structures use SQL code or Selected Fields to define the nodes
and hierarchy for the dimension.
What measures are commonly used in benchmark comparisons? - ANS Result Measures
Make event lists for the following event codes:
using conditions as well
hires, Internal Movements, Terminations
Promotions Demotions
increase in value for promotions
decrease in value for demotions
event lists or - ANS Think it's hires movements terminations, then internal movement events
Condition for internal movements events
Import Export configuration in data factory tool - ANS Export config for backup or importing
to another instance or import configuration from another instance
Why doesHC fall under unmapped category for a sql-generated dimension structure -
ANS leaf node IDs in generated via SQL doesn't match the values returned in the data. A
common mistake is to return external code in SQL statement while the column dragged into
that top right window is internal code or vice versa.
Pg. 2 Copyright © 2025 Jasonmcconell. ALL RIGHTS RESERVED.
