EMT Practice Test

1. Question Content...

---

Question1: Which of the following delivered task profiles allows you to maintain environment? (1)

Question2: You want to use work status in Analysis for Office. Which steps are required? (2)

Question3: What dimensions are used to configure the carry forward business rule? 3 BPC440

Question4: The access rights you can assign to the sets of members are (3)

Question5: You are using B PC 11.0 for SAP BW/4HANA.
From which objects can you create an aggregation level?
Note: There are 3 correct answers to this question

Question6: You are using BPC 11.0.
From which of the following objects can you import data using the "Load Transaction Data from BW infoProvider" data manager package?

Question7: 47. You have two models: one for Expense, and another for Sales. Both models have the same Profit Center dimension. You would like users to perform reporting on both models as follows:
In column A: Expense values fn column B: Profit centers in column C Sales values Which methods can you use to accomplish this requirement?
Note: There are 2 correct answers to this question.

Question8: Which object in BW is equivalent to a model in SAP business Object Planning and Consolidation for NetWeaver? (1)

Question9: You are using BPC Standard You want to calculate revenue as a product of the units sold and price per unit and save the results in the database How can you achieve this?

Question10: Your customer wants to use a unique business rule to translate currency for selected entities. Which property do you set for the selected entities to meet this requirement? (1)

Question11: Name the folder that the users has access to depend his/ her access account (1)

Question12: How can characteristic relationships be used? Note: There are 3 correct answers to this question

Question13: What are the two modes of transport supported? (2)

Question14: A user has measures containing plan and actual data within the columns of a crosstab. How can you create a dynamic variance using standard Analysis for Office features? Note: There are 2 correct answers to this question

Question15: You are working with BPC Embedded in a replicated scenario. You need to create a Local Provider. Aside from the Native SAP HANA table, which other objects are system generated? Note: There are 2 correct answers to this question.

Question16: Data is loaded only in the 'F_OPE' flow/subtable. When executing the currency translation for the first time, the CTA_ACT in F_CTA is empty. What is the problem with the logic? (1)

Question17: Which InfoProvider car access data from ACDOCA? Note: There are 2 correct answers to this question.

Question18: What allows you to type the Dimension Member values in your worksheet (1)

Question19: You are the administrator on a BPC 11.0 for SAP BW/4HANA system. You need to optimize an Advanced DataStore Object by activating the dat a. What happens when you do this? Note: There are 2 correct answers to this question.

Question20: What are the Out of the Box solution for loading the transaction data load? 2

Question21: Which data source types are processed by the Balance Carry Forward rule? Note: There are 2 correct answers to this question.

Question22: You are working in BPC Standard.
Which of the following calculation options is HANA optimized?

Question23: What is entered in the group account when you configure AR/AP intercompany eliminations and adjustment business rule?
Please choose the correct answer.

Question24: Running control could include the following steps. Identify them. 2 BPC440

Question25: When validating the 'FXTrans.LGF' file, you get a validation error stating that the currency dimension is missing a property. What property is missing? 1

Question26: What rows are displayed in an EVDRE report for the MemberSet 'SELF.DEP*? (1)

Question27: SAP BPC 11.0 is based on SAP BW/4HANA.
Which traditional BW InfoProviders were replaced with Advanced DataStore Object?
Note: There are 2 correct answers to this question

Question28: You are working in a B PC Standard System.
The users are complaining about a message that the system in office
What might be the issue?

Question29: You use an account-by-product report and want to drill down on parent accounts for one product at a time as in the attached screenshot. What do you need to select to achieve this drilldown behavior?

Question30: Business warehouse, Planning and consolidation Leads to.......? (1)

Question31: Which of the following tasks can you perform using a data manager package delivered by SAP? Note: There are 3 correct answers to this question.
Load master data and texts from a BW infoObject.

Question32: You have developed an EPM input form and would like to ensure a validation of cells message box pops up after a user saves dat a. How can you accomplish this? (2)

Question33: Find out Step which is not taking part in The Information Gathering Process. (1)

Question34: Which of the following steps are mandatory if you want to perform a transport from the development system to the production system(administration)? (2)

Question35: Which of the following conventions apply to dimension property Ids? (2)

Question36: Identify the action required for the value of Planning and Consolidation (1)

Question37: How many journal templates are in a model. 1 BPC440

Question38: Which of the following tasks can you perform using the Consolidation Monitor? 2 BPC440

Question39: What value for the property DATASRC_TYPE in the datasource dimension allows you to identify system postings? (1)

Question40: What value is used in the destination flow column of the currency conversion business rule when there is no subtable type dimension in the Application? (1)

Question41: You are building an EPM report and would like to leverage local members. What can you use to maintain local members? Note: There are 3 correct answers to this question

Question42: Which tool can you use in the EPM Office Acid-in Excel to email a list of static files? (2)

Question43: Which properties are required to carry out currency translation for legal consolidation? (2)

Question44: You are working in a BPC Embedded system. What object can you maintain immediately after creating an environment? (1)

Question45: Which of the following options can you use for drill through? (1)

Question46: Which of the following dimensions is automatically selected when you create a business process flow template? Please choose the correct answer.

Question47: 64. Identify the 3 different types of Logic. 3 BPC440

Question48: You want to set up a consolidation model. Which of the following dimensions should be the same for consolidation, rate and ownwership models? There are 2 correct answers to this question.

Question49: Find out the options uses to optimize your model for improvement in system performance: (2)

Question50: Which parameters are mandatory for a EVDRE function? There are 2 correct answers to this question.

Question51: How to reset the consolidation status? (1)

Question52: You need to calculate ownership using these values:
Company D owns 70% of company A and 10% of company B.
Company A owns 50% of company B.
Using the Group share method, what percentage ownership does company D have of company B?

Question53: Which of the following interfaces can you use when you define actions using the business process flow templates. (3)

Question54: Process for importing flat file dat
a. Select from the following choose the correct answer Response:

Question55: You use the INC account type for revenue accounts and the EXP account type for expense accounts. What is displayed in a planning and consolidation report when incomes are stored as negative values and expenses are stored as a positive values (dimensions)? 2 BPC440

Question56: You are implementing a planning solution that uses BPC Embedded When you run a planning function, you notice that it is NOT optimized. How can you resolve this issue?
Note; There are 3 correct answers to this question

Question57: You are working in a BPC Optimized system.You need a planning function to copy actual data to plan data.Which of the following characteristics must be included in the fileds to change? (1)

Question58: How do you configure the data Manager package to execute a specific logic script file? (1)

Question59: What tasks are accomplished during full optimization in BPC for NetWeaver? (2)

Question60: Which step is required to store a comment to a filled cell in an Excel pop-up in BPC for NetWeaver? (1)

Question61: You have created an EPM report containing Time' in the columns and 'Product' in the rows. You would like to leverage a function to display the hierarchy level for a given product in the rows Which EPM functions are used for this purpose? Note: There are 2 correct answers to this question.

Question62: You are working in BPC Standard and you need to use a BAdl to perform a calculation. Which object is used to link the code to the script logic file?

Question63: How to set a work status in the consolidation monitor. 2 BPC440

Question64: When executing the ownership calculation you receive an error message. You therefore analyze the group/entity structure in the attached screenshot Which method type is missing in the consolidations method?

Question65: Find out the Environment models from the following (3)

Question66: Which implementation step is mandatory to set up an on-the-fly KPI calculation? (1)

Question67: Where do you change a BPC report to an input schedule? Please choose the correct answer.

Question68: Which of the following business Rules can you use in a financial models? 1BPC440

Question69: Script Logic and Calculations
You are testing script logic to perform a loop aver months
You save budget data for months 2018.01 to 2018.06.
*XDIM MEMBERSET CATEGORY-BUDGET *XDIM_MEMBERSET TIME- %TIME_SET% *XDIM_MEMBERSET P_COSTELEMENT = LABOR
'WHEN P_COSTELEMENT *IS LABOR
"FOR %COUNTER%= 1.2.3.4.5.6,7 8.9.10, T1.12
*REC(EXPRESSION = %VALUE%(12*2.TIME=TMVL(%COUMTER%.%TIME_SET%),CATEGORY=FORECAST)
*NEXT
*ENDWHEM
When this script logic executed, what months receive data?

Question70: Which function do you use to display a dimension name? (1)

Question71: Each Work Book contains two work sheets. Identify them: (2)

Question72: The Ownership Account contains? 2 BPC440

Question73: You use the DESTINATION_APP keyword in your script logic. If the source model contains fewer dimensions that the target, which operator do you use to derive the missing dimensions? 1

Question74: You are working in BPC Embedded
What options do you have for modeling persistent data?
Note: There are 2 correct answers to this question.

Question75: Currency translation calculations typically work as follows: 2 BPC440

Question76: 7. If the FOX formula is:
{key figure 1 ,#(unit),USD(currency);variable for material group} =
{key figere2;PC(unit:),#(currency).=variable for material group} *
{key figure3.#(unit),USD(currency):variable for material group}.
How is the planning function configured?
Note: There are 2 correct answers to this question.

Question77: A report has been created with products in the rows displayed in a hierarchy.
You would like to display the product members and parents in different colors based on their relative position in the hierarchy.
Which of the following options in the EPM add-in will allow you to accomplish this?
Note: There are 2 correct answers to this question.

Question78: You are working in a BPC Standard system and you want to check the member combinations for incoming transaction dat a. Which step is mandatory?

Question79: How can you add a property other than a hierarchy to a dimension? (1)