Q41. Which objetcs can be affected by the key date in a BW query? Note: There are 3 correct answers to this question.

Q42. You want to combine an existing SAP BW/4HANA Data Model with virtual data from a new non-SAP source system for test purposes. Which approach should you consider fro rapid prototyping?

Q43. Which objects can be affected by the key date in a BW query? Note: There are 2 correct answers to this question.

Q44. Which source types are available to create a generic DataSource in SAP ERP? Note: There are 3 correct answers to this question.

Q45. Which join types Can you use in a CompositeProvider? (3)

Q46. In a query with cells you need to Override some of the automatically created cell values with other values. Which Cell types do you use instead of automatically-created cell? (2)

Q47. You set up the 2LIS_02_ITM (Purchasing Line Item) data source in SAP ERP using the logistics cockpit. Afterward, you successfully run the initialization into SAP BW/4HANA.
Your delta load into SAP BW/4HANA shows zero records even though new purchase orders were created. How do you explain that the delta records do NOT appear in SAP BW/4HANA?

Q48. You create a DataStore object (advanced) using model template Standard DataStore Object. Which flags are set?
Note: There are 2 correct answers to this question.

Q49. To achieve an urgent business requirement, you choose the field-based modeling approach, but you also want to leverage a characteristic hierarchy. On which level does LSA++ architecture recommend the appropriate InfoObjet to be associated?

Q50. Which actions can you perform with an SAP HANA calculation view that has the DIMENSION data category assigned?
Note: There are 2 correct answers to this question.

Q51. In an SAP HANA smart data integration flowgraph, which transformation options are available? Note: There are 3 correct answers to this question.

Q52. Which external hierarchy properties can be changed the query definition? (3)

Q53. In an SAP HANA Calculation View, you need to combine attributes data (left table) and the data’s language-dependent texts (right table) using a text join. What should you select to restrict the result set to the logon language?

Q54. For a BW query, you want to have the first month of the current quarter as a default value for an input- ready BW variable for the characteristic 0CALMONTH. Which processing type do you use?

Q55. You have created a custom characteristic with the technical name “COSTOBJ”. Depending on the controlling area, you need to have different attribute values assigned. How do you design the model?

Q56. You want to model an SAP HANA calculation view by combining the sales orders with the corresponding customer status, which was assigned to the customer when the order was issued. Which join properties do you assign to the required join type?

Q57. Which features of an SAP BW/4HANA InfoObjet are intended to reduce the physical data volume? Note; There are 2 correct answers to this question.

Q58. You use SAP HANA to integrate an HDI Calculation View (data category Dimension) into another HDI Calculation View (data category Cube with Star Join). What do you need to do before you can integrate the HDI Calculation View (data category Dimension)?

Q59. In which ODP context is the operational delta queue (ODQ) managed by the target system?

Q60. From which SAP BW/4HANA objetcs can you start generating an external View? Note: There are 2 correct answers to this question.

Q61. You create a report with SAP Crystal Reports for Enteprise and need an analysis view as a data source. Which tool can you use to create this analysis view?

Q62. In which sequence does SAP recommen

Q63. Using SAP HANA as modeling focus, you want to combine data from different sources. Which techniques can you use? Note: There are 2 correct answers to this question.