CREAR TEST

TEST BORRADO, QUIZÁS LE INTERESE: MY_TEST_11

COMENTARIOS	ESTADÍSTICAS	RÉCORDS

REALIZAR TEST

Título del Test: MY_TEST_11 Descripción: MY_TEST_11 Autor: MY_TEST_11 OTROS TESTS DEL AUTOR Fecha de Creación: 30/03/2021 Categoría: Otros Número Preguntas: 80

COMPARTE EL TEST

COMENTAR

No hay ningún comentario sobre este test.

Temario:

1. You are working in BPC Embedded- Data audit is enabled for a local provider. What fields are added to the local provider database table? Note: There are 3 correct answers to this question. Source of data Audit trail Time stamp Request ID Audit mode. 2. What siep is required to configure data audit for BPC standard? Activate the collection of data by model Activate the collection of data by environment Add a parameter to data manager packages. Add a global parameter in Customizing (SPRO). 3. You are working in a BPC Standard system and you want to check the member combinations for incoming transaction data. Which step is mandatory? Activate the validations for the environment. Assign a driver dimension to the validation rule. Configure controls. Imptement a BAdl. 4. You are working in а В PC Standard System. The users are complaining about a message that the system in office What might be the issue? The workbook is offline. The InfoProvider is set to 'Load Mode'. A BPC transport is in process. The system is saving a new member to a dimension. 5. You need to run a planning sequence while data is being saved Which object do you attach the planning sequence to? Planning query Process chain Advanced DataStore Object CompositeProvider. 6. You are working in a BPC Optimized system and you are setting up data retraction. Which of the Following SAP S/4HANA core tables does retraction book to? COSS_BAK FAGLBSAS_BAK ACDOCP COSP. 7. If the FOX formula is: {key figure 1 ,#(unit),USD(currency);variable for material group} = {key figere2;РС(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. Material group is a data declaration. Material group is a field to change Key figure is a data declaration. Key figure is a field to change. 8. You are working in а В PC Embedded system. Which objects are needed to run a calculation based on custom HANA SQL? Note: There are 2 correct answers to this question Native HANA table Function type Method class Data foundation. 9. 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 fields to change? Version Fiscal year Client InfoProvider. 10. How can an Aggregation Level be used? Note: There are 3 correct answers to this question As an InfoProvider for characteristic relationships. To determine the level of granularity. To store summary data. As an InfoProvider for consolidation models. As an InfoProvider for planning queries. 11. 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 Create a planning function that runs HANA SQL. Set the RSPLS_HDB_SUPPORT parameter to HDB_ON. Set the RS_DEBUGLEVEL parameter to 2. Activate Deep HANA Integration. Activate the BPC Embedded Model. 12. How can characteristic relationships be used? Note: There are 3 correct answers to this question To disaggregate based on reference data. To distribute data based on valid combinations. To delete data based on invalid combinations. To derive data based on BW hierarchies. To check combinations based on S/4HANA data. 13. To run a script logic file in a data manager package, where do yen assign it? In the REPLACEPARAM property . In the TASK MODIFYSCRIPT setting In the SELECTION property In the START_ROUTINE parameter. 14. You imported a transaction data file into an empty model using a data manager package. An hour later, a finance team member brings a new data file that needs to be imported. As you can see in the graphic, the new fiie has exactly the same records, with two exceptions: 1 The value of the Benefit Account has increased from 1500 to 1600. 2 There is a new record for the Direct Labor Account with a value of 160 Which options can you use to update the data so that the latest flat file and the model have the same data? Note: There are 2 correct answers to this question. Merge Replace and Clear Append Replace. 15. 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. Execute a BAdi Export master data to SAP ECC. Export transaction data to a flat file Load transaction data from a BW InfoProvider. Load master data and texts from a BW infoObject. 16. You are using ВPC 11.0. From which of the following objects can you import data using the "Load Transaction Data from BW infoProvider" data manager package? Advanced DataStore Object MultiProvider InfoCube InfoObject. 17. You need to work with BPC Embedded environments. What are your options? Note: There are 2 correct answers to this question Change the status. Create from scratch. Copy with reference Change the description. 18. After running consolidation you notice that the elimination offset account is wrong What property could have the incorrect value? ACCTYPE TYPE TEPELIM ELIМАСС DIMLIST_ACC. 19. You are working in а В PC Embedded system. What object can you maintain immediately after creating an environment? Dimension Business Process Flow Report Team. 20. Vol are working in a BPC Standard system Which of the following dimension types can be used as reference dimensions for referential integrity? Note: There are 2 correct answers to this question. Audit Entity Time Subtables. 21. What is the maximum length of a characteristic value in BPC Embedded? 32 characters 250 characters 255 characters 1333 characters. 22. You are working in a BPC Embedded System. What options do you have when maintaining members and properties of local dimensions? Note: There are 2 correct answers to this question. Update property values for global members. Enable time dependent properties. Delete global members Add a member that does NOT exist in a global dimension. 23. You are working in а В PC Standard system. Your customer has the following requirements: Report with key dates Enable comments at the account level Track data updates by account Calculate KPIs on the fly What do you configure in your Note: There are 2 correct answers to this question. Enable data audit Enable time dependent hierarchies Enable dimension member formulas Enable comments. 24. You are using BPC Embedded and want to plan on new members. You decide to implement Master Data on the Fly and implement the method class. What are the function type parameters? Note: There are 3 correct answers to this question Member ID InfoProvider Parent ID Property ID InfoObject. 25. You want to hardcotfe a query to run only for the country value 'Germany' Where in the BW Query do you specify 'Germany' as a "Fixed Value"? Dependencies Free characteristics Filter Conditions. 26. You are using В 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 LocalProviders Advanced Data Store Objects CompositeProviders MultiProviders infoCubes. 27.You need characteristics for Real Time Consolidation. Which characteristics are 'Persistent'? Note: There are 2 correct answers to this question Account Category Group Audit. 28. You are using SAP BP С Optimized for SAP S/4HANA Which InfoProvider stores the comment entered in an input-ready query? Real-Time InfoCube VirtualProvider CompositeProvider DataStore Object. 29. 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 InfoCube Persistent Staging Area MultiProvider VirtualProvider. 30. Your customer needs a blank input template that allows users to enter product groups as needed and plan revenue for them. The BW Query has product group in the rows, revenue in the columns, and product in the free characteristics. When the BW Query is inserted into Analysis for Office, all data rows are blank. How is the BW Query configured? The query is set to "Disaggregate To All Valid Combinations". Product group is set to display based on "Characteristic Relationships". The query has "New Lines on Every Level" selected. Revenue is set to "Disaggregate Difference to Entered Value". 31. You are configuring comments in BPC Embedded. Which objects are required? Note: There are 2 correct answers to this question A system-generated data table An Advanced Data Store Object A CompositeProvider A Characteristic as key figure. 32. To add custom dimensions automatically to BPC Optimized structures, what do you use? BW Modeling Tool Model Extension Tool RTC Modeling Tool Planning Application . 33. Which InfoProvider car access data from ACDOCA? Note: There are 2 correct answers to this question. /ERP/SFIN_V01 /ERP/SFIN_R01 /ERP/SFIN_M01 /ERP/SFIN_V20. 34. Which data source types are processed by the Balance Carry Forward rule? Note: There are 2 correct answers to this question. Automatic Level Input Manual. 35. You are developing the following script logic to perform an allocation. *RUNALLOCATION *FACTOR USING/TOTAL *DIM ACCOUNT WHAT=LEASECOST; WHERE=<<<; USING=SQUAREFOOTAGE; TOTAL=<<< *DIM ENTITY WHAT=GLOBALOPS: WHERE=»>: USING=»>: TOTAL=BAS(EUROPE) *DIM COSTCTR WHAT=CORPORATE: WHERE=BAS(SERVICES]: USING=»>'. TOTAL=BAS (DIRECT) *ENDALLOCATION To which destination members is the above script logic writing the records? Note: There are 3 correct answers to this question. EUROPE base members LEASECOST SERVICES base members SQUAREFOOTAGE base members DIRECT base members. 36. 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? 2018.07 to 2019.06 2019.01 to 2019.06 2016.07 to 2018.12 2019.01 to 2019.12. 37. When does default logic run? When table-based logic is executed When data is sent from an input form When data is refreshed When business rules are executed. 38. You are working in BPC Standard. Which of the following calculation options is HANA optimized? Business rules Local member formulas Dimension member formulas Consolidation logic. 39. 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? Filter Value BAdl Definition Enhancement Implementation BAdl Implementation. 40. You have a business requirement to calculate 3 bonus amounts based on revenue. You must calculate the following: Bonus account 1: 10% of revenue Bonus account 2: 5% of revenue Bonus account 3: 2% of revenue How do you proceed using script logic? Use a scoping statement for the three bonus accounts. Use a WHEN statement for each bonus account. Use a REC statement for each bonus account. Use one WHEN statement and separate the bonus accounts with commas. 41. 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? Use the worksheet logic Use the dimension member formula Use a data manager package. Use business rules. 42. In Analysis for Office you have an input-ready query with accounts in the rows and all periods (month) of 2019 as well as the total for 2019 in the columns. You have a value of '1200' for 2019 and "100' for JAN to DEC. You lock the cells for JAN and FEB and enter '1500" for 2019. When you recalculate the data; what happens? Note: There are 2 correct answers to this question. The non-locked cells will update to 150 The total remains as 1500 The total will be changed to 1700. The non-locked cells will update to 130. 43. What can be used as a data source in Analysis for Office? Note: There are 3 correct answers to this question. Crystal Report HANA Calculation View Web Intelligence BW Query Universe . 44. 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 Use the Calculation from the Analysis ribbon. Use a VB script Use a New Line rule type Use an MS Excel formula. 45. You insert an input-enabled query as a data source in Analysis for Office. You update values and would like to work with data in the planning buffer without storing data persistently in the database Which standard Analysis for Office methods can you use to accomplish this? Use the "SAPSetData" formula. Switch to 'Display Mode'. Select the'Recalculate' button. Select the 'Smart Copy' button. 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 С Sales values Which methods can you use to accomplish this requirement? Note: There are 2 correct answers to this question. The 'repeat row headers' property 'Shared axis' reporting. The 'outer dimension1 option. 'EPMRetrieveData' formulas. 48. You have developed an EPM input form and would like to ensure a validation of cells message box pops up after a user saves data. How can you accomplish this? Note: There are 2 correct answers to this question Use the dialog option when saving data. Use data validation in the formatting sheet. Use 'Sheet protection'. Use a custom VBA macro. 49. 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. Formatting on Specific Member/Property Formatting on Specific Level Calculate Parents in Hierarchies Highlight Selected Hierarchies. 50. You are formatting an EPM Report. Which of the following features are configured in the EPM formatting sheet? Note: There are 2 correct answers to this question Data validation Indent children Repeat row headers Hierarchy levels. 51. You use the INC account type for revenue accounts and the EXP account type for expense accounts. What is displayed in an EPM report when revenues are stored as negative values and expends are stored as positive values? Note: There are 2 correct answers to this question Positive revenue values Positive expense values Negative expense values Negative revenue values. 52.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? 'Member and Children' 'Expand Collapse on Single Member' 'Keep I Exclude on Single Member' 'Member and Descendants'. 53. 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 Report editor Excel formulas Dimension member formulas Row axis Page axis. 55. 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. EPMDimensionPropertyValues EPMLocalMember EPMDimensionProperty EPMMemberProperty. 56. Which tasks can you perform using the Consolidation Monitor in BPC embedded? Note: There are 3 correct answers to this question. Run ownership calculation Run US Elimination Run planning function Run controls Run reclassification. 57.You are working in BPC 11.0 Embedded. Which design parameters are available for a Journat Template? Note: There are 2 correct answers to this question Allow Journals to be Reopened Enable Auto Reverse Enable Ungrouping Enforce Balanced Journal . 58. The Consolidation Monitor displays a blank screen for the current period although the previous period has been displayed properly. What is missing? Ownership data Exchange rate data Master data Trial balance data. 59. You have automated ownership eliminations by using the BPC business rules and ownership data. Your requirement is to use the same rule tor both purchase and equity subsidiaries. The ownership in one of the subsidiaries went from 45 to 55 percent. What changes should you make in the ownership manager for this subsidiary? Method is changed to 'New' "PCON* is changed to 100 Method is changed to 'Holding" 'PCON'is changed to 55 . 60. Which of the following model-specific business rules requires the environment-specific business rules? US Eliminations Currency translation Account-Based Calculations Eliminations and adjustments. 61. You are using BPC Standard 11.0. Which of the following do you define in the US Elimination Business Rule? Note: There are 2 correct answers to this question. Source accounts Entity dimension Multipliers Source audit. 62. Which dimensions or properties can you use to determine the ruie type and source values in a currency translation business rule? Note: There are 2 correct answers to this question. FLOW CURRENCY RATETYPE GROUP_CURRENCY. 63. Which dimensions can you use to configure the Balance Carry Forward business rule? Note: There are 3 correct answers to this question. Account Audit Trail Flow Entity Currency. 64. What dimension and value does the Method Based Multiplier determine? Debit account Source flow Debit flow Source account. 65. You select a parent in the detailed section of the control definition. Which option do you choose to ensure that the control will be executed for each member of the selected parent? Control Status Breakdown Dimension Threshold Level Control Level. 66. You have created controls and a user has tested them for the current period However the user does not see the controis for the foflowing period in the Controls Monitor. How do you resolve this issue? Grant authorization to the user to view the controls "for following period. Assign the control set to the following period. Change the work status in the Consolidation Monitor for the following period. Assign the control level to the following period. 67. 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? 10% 35% 45% 60%. 68. You are working in а В PC Standard system For which of the following models do you have to create at least two "Drivers and Rates" type models? Standard Consolidation Ownership Financial. 69. When you create a new model from an existing model which items can be copied? Note: There are 2 correct answers to this question. Transaction data Control definitions Data Manager packages Journal templates. 70. You are working in a BPC Standard system. Which are unique settings of the ownership model? Note: There are 2 correct answers to this question. Parent child properly Non-Interco Member Enable comments Use as source data. 71. You are configuring consolidation for BPC Standard. Which dimensions must be the same for consolidation, rate, and ownership models? Note: There are 2 correct answers to this question. Account Entity Category Time. 72. 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. Workspace BW Query External calculation view Aggregation level. 73. You are working in BPC Embedded What options do you have for modeling persistent data'? Note: There are 2 correct answers to this question. Advanced DataStore Object MultiProvider InfoObject CompositeProvider. 74. You are working in BPC Standard. Which of the following dimension types are required for an ownership type model? Note: There are 3 correct answers to this question Account Currency Intercompany Audit Group. 75. You are working in BPC Standard. Which dimensions must be identical in all models that use the Exchange Rate Model? Note: There are 2 correct answers to this question Time Account Currency Category. 76. You want to use work status in Analysis for Office Which steps are required? Note: There are 2 correct answers to this question Link the model to the data source. Select the data region in the crosstab. Select the data region in the filter tab. Link the model to the workbook. 77. You are configuring work status in a BPC Embedded environment with a Sales InfoProvider. The requirement is to determine the owners via a characteristic that is NOT contained in the InfoProvider How can the work status "Locking Dimensions" be determined? By using a customer implementation By using a property By using an external dimension By using a reference dimension. 78. You are using BPC Embedded. In the BPC web client, a user can access Environment #1 but not Environment #2. What change is required for the user to access Environment #2? Assign an analysis authorization to the Environment. Add the user to the BPC team Assign a data access profile to the user Add the user to the 'RSBPC_ID' authorization object. 79. Which steps are required to use data access profiles in BPC Embedded? Note: There are 2 correct answers to this question. Set a characteristic to be authorization relevant. Assign authorizations to the user. Set the mode! dimensions to be authorization relevant. Assign authorizations to the environment. 80. What is an advantage of BPC Optimized compared to Classic ERP Planning? Optimized data toads Summarized data Contains an Enterprise Data Warehouse Reconciled data. 81. Which components does BPC Embedded Consolidation use in a Replicated Scenario? Note: There are 2 correct answers to this question. Exchange Rate InfoProvider CompositeProvider as the Consolidation InfoProvider VirtualProvider as the Consolidation InfoProvider Exchange Rate TCURR tables. 82. You CANNOT view the final data in Real Time Consolidation. What could be the issue? Note: There are 2 correct answers to this question The data needs to be validated. The process needs to be submitted. The work state needs to be complete. The entity needs to be approved.

Denunciar Test