EMT Practice Test

1. Question Content...

---

Question1: Which features prevent the SAP HANA-optimization of transformations in the SAP HANA database? (2)

Question2: What are benefits of separating master data from transactional data in SAP BW/4HANA? (2)

Question3: With SAP HANA 2.x. you can model information views in the SAP Web IDE for SAP HANA with SAP HANA extended application services, advanced model (XSA). Which node types for a native SAP HANA information view are ONLY available in this framework? (2)

Question4: In SAP BW/4HANA you realize that standard content data Source (New GL Balances) is delivering incorrect values into the first persistent data layer in SAP BW/4HAN A.
Which options do you have to analyze a potential extractor issue in the SAP ERP source system? (2)

Question5: In SAP BW/4HANA you realize that standard content data Source (New GL Balances) is delivering incorrect values into the first persistent data layer in SAP BW/4HAN A.
Which options do you have to analyze a potential extractor issue in the SAP ERP source system? (2)

Question6: You developed a BW information model and want to re-use a generated external SAP HANA view. Which objects are supported? (3)

Question7: What is the benefit of using an InfoSource in a data flow? (1)

Question8: You have created an SAP HANA calculation view of the SAP HANA extended appication services, advanced model (XSA) and want to integrate into an SAP BW/4HANA model. Which "Settings for HANA Consumption" in transaction SPRO can you use? (2)

Question9: Which of the following are features of the Start process in a chain? (2)

Question10: Considering the mixed modeling approach, what can you do an SAP HANA calculation view exclusively?

Question11: You defined a condition in a query for the top 10 customers based on sales revenue (key figure of type Sum). If you keep the default settings of the query, what is the total of the sales revenue on the result line? (1)

Question12: You create a transformation from a DataSource to a DataStore Object (advanced). The DataSource provides an additive-image delta for dat
a. Which key figure aggregation type do you select? (1)

Question13: How can you ensure that the delta merge process will be initiated? (3)

Question14: In a Datastore Object (advanced) of type Data Mart, which request can be deleted? (1)

Question15: You would like to highlight the deviations between budget and actual revenue in query. Which BW feature do you use? (1)

Question16: Which join types Can you use in a CompositeProvider? (3)

Question17: You create a Datastore Object (advanced) using the "data mart DataStore object" modeling property. Which behaviors are specific to this modeling property? (2)

Question18: The SAP S/4HANA virtual data model (VDM) is buit with ABAP-managed COS views.
What are some of the prerequisites for using these SAP S4HANA ABAP COS views for eextraction into SAP BW/4HANA in an ODP
context? (2)

Question19: You want to define a restricted column in an SAP HANA calculation view. What do you need to define?(2)

Question20: You created an Open ODS view based on a database table SAP RANA to virtuany &splay the data SAP BW/4HAN A.
Real-time reporting requirements have now changed and you are asked to persist the data SAP BW/4HANA Which objects will be created when using the Generate Dataflow function via Open ODS view? (3)

Question21: Which features Can be leveraged using a CompositeProvider in SAP BW/4HANA? (3)

Question22: You can NOT turn a display attribute into a navigation attribute. Which setting of this attribute could be the reason? (2)

Question23: You open an SAP Analysis for Microsoft Office workbook. On which Design Panel tabs can you verify the filter values? (2)

Question24: SAP HANA studio provides a data file import wizard to create and fill tables SAP HANA from flat files. What is an advantage of using the file wizard? (1)

Question25: Which Objects can be used in the BW query "Fixed Values" area to restrict the data? (2)

Question26: What are some of the reasons to choose the CUBE data category instead of DIMENSION data category for an SAP HANA calculation view? (3)