EMT Practice Test

1. Question Content...


Question List

Question1: Which of the following describes an analytical dimension? Note: There are 2 correct answers to this question.

Question2: What tool on the WFA on HANA Data Factory home page do you use to configure measure and dimension combinations?

Question3: What is the correct order of phases in the SAP SuccessFactors Workforce Analytics implementation timeline?

Question4: Which rollup types are available when a record is spliced? Note: There are 3 correct answers to this question.

Question5: Where can you access the configuration screens for SAP SuccessFactors Workforce Analytics OLAP cube on SAP HANA?

Question6: When using the Build Fact Data and Cube Command, the initial load fails with the following message in the log: Error: System.ArgumentException: Item has already been added. Key in dictionary:
'[location].[location].[level1_che_zznostateprovince_geneva]' Key being added:
'[location].[location].[level1_che_zznostateprovince_geneva]' at System.Collections.SortedList.Add(Object key, Object value) at System.Collections.SortedList.SyncSortedList.Add(Object key, Object value) at Hrml.DataObjects.HrmlOrgCubeDimensionTree.AddTreeNode(String path, String parentPath, Int32 depth, String caption) in. What is the cause of this error?

Question7: Which of the following functions are managed in the WFA on HANA Data Factory tool? Note: There are 3 correct answers to this question.

Question8: Which of the following describes a structural dimension? Note: There are 2 correct answers to this question.

Question9: How do you validate the value of a local salary that has been converted to the unified target currency for the Annual Salary calculated column? Note: There are 3 correct answers to this question.

Question10: Which measures are examples of a Base Input measure? Note: There are 2 correct answers to this question.

Question11: What prerequisites must be met for a user to implement SAP SuccessFactors Workforce Analytics on SAP HANA? Note: There are 3 correct answers to this question.

Question12: Some dimension hierarchies in the Dimension Editor tool are greyed out, which prevents you from remapping codes located in the Unmapped node. Why are the hierarches greyed out?

Question13: During an SAP SuccessFactors Workforce Analytics on SAP HANA configuration, when can you select the Termination event list?

Question14: What can you use the Edit SQL button for when you add a dimension in the Dimensions screen? Note: There are 2 correct answers to this question.

Question15: What is included in a Fact table? Note: There are 2 correct answers to this question.

Question16: You are building a Fact table for a customer with SAP SuccessFactors Workforce Analytics on SAP HANA.
What needs to be included in this table? Note: There are 3 correct answers to this question.

Question17: What are the foundations of an Analytics Cube? Note: There are 2 correct answers to this question.

Question18: How do you disable a Fact table temporarily if it is NOT going to be included in SAP SuccessFactors Workforce Analytics?

Question19: What field is the unique identifier for each record of data for a Metadata Framework (MDF) object?

Question20: 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?

Question21: Which of the following is configurable and can only be implemented by SAP admin users in the Technical Services team? Note: There are 2 correct answers to this question.

Question22: When using the Build Fact Data and Cube Command, the initial load fails with the following message in the log: Error: System.ArgumentException: Item has already been added. Key in dictionary:
'[location].[location].[level1_che_zznostateprovince_geneva]' Key being added:
'[location].[location].[level1_che_zznostateprovince_geneva]' at System.Collections.SortedList.Add(Object key, Object value) at System.Collections.SortedList.SyncSortedList.Add(Object key, Object value) at Hrml.DataObjects.HrmlOrgCubeDimensionTree.AddTreeNode(String path, String parentPath, Int32 depth, String caption) in. How do you fix the error?

Question23: What document is created from the responses to the Data Questionnaire?

Question24: Why would you use a complex fact table instead of a simple fact table? Note: There are 3 correct answers to this question.

Question25: What can you configure within the Dimension tab while you are configuring a Fact table? Note: There are 2 correct answers to this question.

Question26: A base input measure configured in data factory does NOT produce any result. Which of the following actions could be helpful to debug the error? Note: There are 3 correct answers to this question.

Question27: Consider the following scenario: EOP headcount has Age, Disability, EEO Job Category, Employment Level, and Employment Status dimensions turned on. SOP headcount has Age and EEO Job Category dimensions turned on. Average headcount has Gender and Future Leader dimensions turned on. Hires has Age, Disability, EEO Job Category, Employment Level, and Employment Status dimensions turned on. Terminations has Age, Disability, EEO Job Category, Employment Level, and Employment Status dimensions turned on. You are required to perform the following task: Turn on Age, Disability, EEO Job Category, Employment Level, Employment Status and Gender dimensions on for EOP Headcount, SOP Headcount, and Average Headcount.
How would you complete this task? Note: There are 2 correct answers to this question.

Question28: What is a Condition, in terms of Hires, Movements, and Terminations? Note: There are 2 correct answers to this question.

Question29: How are standard time dimensions grouped from top to bottom?

Question30: Which of the following describes an analytical dimension? Note: There are 2 correct answers to this question.

Question31: How does the Realize phase differ when implementing an SAP SuccessFactors Workforce Analytics on SAP HANA customer, compared to a traditional implementation? Note: There are 2 correct answers to this question.

Question32: Which table requires values for the columns Event and Event Reason Icode?

Question33: How do you validate the value of a local salary that has been converted to the unified target currency for the Annual Salary calculated column? Note: There are 3 correct answers to this question.

Question34: How do you implement Promotion Out, Demotion Out, and Transfer Out metrics? Note: There are 3 correct answers to this question.

Question35: 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.

Question36: How do you add columns to the Workforce Fact table?

Question37: Which of the following SAP SuccessFactors Employee Central tables will be used most often as a Lookup table in SAP SuccessFactors Workforce Analytics on SAP HANA? Note: There are 2 correct answers to this question.

Question38: Which of the following tools can you use to restrict user access to metrics and dimensions?

Question39: How would you validate a result measure 'retention rate' if the customer has a concern that the number is NOT accurate? Please refer to the formula below: Retention Rate = (SOP Headcount + External Hires - Terminations)/(SOP Headcount + External Hires) *100. Note: There are 3 correct answers to this question.

Question40: How do you configure Effective End Date in SAP SuccessFactors Workforce Analytics on SAP HANA? Note:
There are 2 correct answers to this question.