Exam WFA UPDATED ACTUAL Exam
Questions and CORRECT Answers
Where do you maintain an MDF object - CORRECT ANSWER -
When would you use a lookup? - CORRECT ANSWER - 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? - CORRECT ANSWER - 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? - CORRECT ANSWER -
If have Headcount 'A', 'U', 'P', what measures do these impact? and what can change them? -
CORRECT ANSWER - rollu type / aggregation type
Event code and event reasons have... - CORRECT ANSWER - standard vs custom codes
and code reasons
What is built from the data questionaire? - CORRECT ANSWER - The specification
document
, If hierarchies are greyed out, preventing from mapping codes located in unmapped - CORRECT
ANSWER - 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? - CORRECT ANSWER -
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 - CORRECT ANSWER - Think it's hires movements terminations, then
internal movement events
Condition for internal movements events
Import Export configuration in data factory tool - CORRECT ANSWER - 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 - CORRECT
ANSWER - 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.
Questions and CORRECT Answers
Where do you maintain an MDF object - CORRECT ANSWER -
When would you use a lookup? - CORRECT ANSWER - 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? - CORRECT ANSWER - 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? - CORRECT ANSWER -
If have Headcount 'A', 'U', 'P', what measures do these impact? and what can change them? -
CORRECT ANSWER - rollu type / aggregation type
Event code and event reasons have... - CORRECT ANSWER - standard vs custom codes
and code reasons
What is built from the data questionaire? - CORRECT ANSWER - The specification
document
, If hierarchies are greyed out, preventing from mapping codes located in unmapped - CORRECT
ANSWER - 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? - CORRECT ANSWER -
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 - CORRECT ANSWER - Think it's hires movements terminations, then
internal movement events
Condition for internal movements events
Import Export configuration in data factory tool - CORRECT ANSWER - 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 - CORRECT
ANSWER - 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.
