EMT Practice Test

1. Question Content...

---

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

Question2: You want to run a BW query, but you only have partial authorization for the data selection. What happens related to the BW query in this scenario?

Question3: You define a temporal condition for a temporal join in a calculation view. Which column data types are supported?
Note: There are 3 correct answers to this question.

Question4: What is the maximum number of characteristics that can be used for a multi-dimensional exception aggregation in a BW query?

Question5: You expect to have more than 2 billion records as master data references for a characteristic in your data model and want to use the high cardinality option. What do you need to consider in reporting?

Question6: What is the request handling default setting for error handling in a data transfer process (DTP) in SAP BW/4HANA?

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

Question8: You define a remote subscription Of type INSERT in an SAP RANA Smart Data Integration (SOI) real-tine update scenario. Which fields are added to the DataSource automatically? (3)

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

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

Question11: What must you do first if you need to define help cells for formulas in the cell editor?

Question12: You create a DataStore object (advanced) using the "Data Mart DataStore Object" modeling property.
Which behaviors are specific to this modeling property? Note: There are 2 correct Answers to this question.

Question13: To achieve an urgent business requirement, you choose the field-based approach because no complex harmonization is needed. Assuming the LSA++ architecture is considered, and you want to leverage a characteristic hierarchy, on which level do you have to assign an InfoObject last? (1)

Question14: In the Web IDE for SAP HANA workspace, you have imported a project including an HDB module with calculation views. What do you need to do in the project sittings before you can successfully build the HDB module?

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

Question16: In a DataStore object (advanced) of type Data Mart, which request-based deletion is possible?

Question17: You want to attivate an SAP HANA calculation view of data category CUBE, but you get the "no measure defined" error. For the business requirement a measure does not make sense. Besides changing the category to DIMENSION, what do vou have to do? (1)

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

Question19: In a DatStore object (advanced) of type Data Mart, which request-based deletion is possibel?

Question20: Which properties determine the delta process within the Operational Data Provisioning (ODP) delta management for DataSources?
Note: There are 2 correct answers to this question.

Question21: What are some of the prerequisites for using SAP S/4HANA ABAP CDS views for extraction into SAP BW/4HANA in an ODP context? Note: There are 2 correct Answers to this question.

Question22: Which features are related to the start process in a process chain? Note: There are 2 correct Answers to this question.

Question23: In which sequence does SAP recommen

Question24: Where can you automatically generate a process chain?

Question25: Which interface do you use to create a BW InfoObjet with access type "SAP HANA view!?

Question26: In which ODP context is the operational delta queue (ODQ) managed by the target system? (1)

Question27: You have created a custom characteristic with the technical name "COSTOBJ". Depending on the controlling area, you need to have different atribute values assigned. How do you desing the model?

Question28: Which features does SAP Analysis for Microsoft Office provide? Note: There are 3 correct Answers to this question.

Question29: What are the possible ways to fill a pre-calculated value set (bucket)? Note: There are 3 correct Answers to this question.

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

Question31: Which features can be leveraged using a CompositeProvider in SAP BW/4HANA? Note: There are 3 correct answers to this question.

Question32: You expeCt to have more than 2 billion records as master data references for a characteristic your data model and want to use the high cardinality option. What do you need to Consider in reporting? (1)

Question33: Which SAP BVW4HANA Objects are possible Sources for data load processes? (3)

Question34: You create a report with SAP Crystal Reports for Enterprise and need analysis view as a data source. Which tool can you use to create this analysis view? (1)

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

Question36: Which interface do you use to create a BW InfoObject with access type "SAP HANA view"?

Question37: You are involved in an SAP BW/4HANA project focusing on General Ledger reporting and want to use the SAP ERP Standard DataSource 0FI_GL_14 (New GL Items). Which transactions can be used to activate this DataSource? Note: There are 2 correct Answers to this question.

Question38: The Database Explorer in the Web IDE for SAP HANA provides a data file import wizard to create a table in SAP HANA from a flat file. What are possible actions after the system suggests the target structure?
Note: There are 3 correct Answers to this question.

Question39: For which InfoProvider types can you select navigation attributes? Note: There are 2 correct answers to this question.

Question40: You are required to provide an analysis allowing selections among specific months (for seasonal reasons). Therefore you want to prefil a variable for processing this request. Which processing type should you use? (1)

Question41: What are desired outcomes of an SAP BW/4HANA pilot project?
There are 3 correct answers to this question.

Question42: What happens if a query with time-dependent attributes is executed but NO query key date is set?

Question43: Your company decided to use a Hadoop cluster as a data storage location. Which components can be used to consume remote Hadoop data in your SAP HANA native app? (3)

Question44: You created an Open ODS view of type Facts. Which object type can you associate with a view field in the characteristics folder? Note: There are 2 correct Answers to this question.

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

Question46: 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)

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

Question48: You use a measure wah semantic type "Amount Currency Code" in your SAP HANA calculation view. Which kind of currency reference can be assigned to measure? (2)

Question49: Which layers Offer the virilization approach for layered scalabie archRecWre (LSA++) Of SAP BW/4HANA? (3)

Question50: With SAP BW/4HANA the new HANA-optimized business content is designed according to the LSA++ framework. Which technical namespace is assigned to identify new SAP ERP-related business content? (1)

Question51: 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)

Question52: What can you do when you use process chains? Note: There are 2 correct answers to this question.

Question53: You create a transformation from a DataSource to a DataStore object (advanced). The DataSource provides an after-image delt a. Which key figure aggregation type do you select?

Question54: Which SAP tool do you suggest to create a pixel-precise formatted report?

Question55: You notice that an SAP ERP ODP_SAP DataSource is delivering incorrect values into the first persistent data layer in SAP BW/4HANA. Which options do you have to analyze a potential extractor issue? Note:
There are 2 correct Answers to this question.

Question56: With SAP HANA 2.x, you can model Calculation Views in the SAP Web IDE for SAP HANA. Which node types for a native SAP HANA Calculation View are available in the SAP Web IDE, and not available in SAP HANA studio? Note: There are 2 correct Answers to this question.

Question57: What are the key benefits of using the SAP Landscape Transformation Rep5cation Server for data provisioning into SAP HANA? (2)

Question58: You defined a condition in a BW query for the top 10 of 100 customers based on sales revenue (key figure of aggregation type Sum) If you keep the default settings of the BW query, what is presented regarding the result rows?

Question59: Which tables belong to the hierarchy for characteristic OCOUNTRY? Note: There are 3 correct answers to this question.

Question60: You would like to highlight the deviation from predefined theshold values for key figures actual revenue. Which BW feature do you use?

Question61: Which development object needs to be built to generate an HDI Container?

Question62: In which sequence can you create a reusable key figure structure? Note: There are 2 correct answers to this question.

Question63: You want to define a restricted column in an SAP HANA calculation view. What do you need to define? Note: There are 2 correct answers to this question.

Question64: You loaded a 5 MB table from a source system to SAP BW/4HANA.
How do you explain that the size of the table is reduced to 1 MB?

Question65: You created an Open ODS view based on a database table in SAP HANA virtually display the data in SAP BW/4HANA.
Real-time reporting requirements have now changed and you are asked to persist the data in SAP BW/4HANA. Which objetcs will be created when using te Generate Dataflow function via the Open ODS view? Note: There are 3 correct answers to this question.

Question66: Which of the following are posible delta-specific field for a generic DataSource in SAP ERP? Note: There are 3 correct answers to this question.

Question67: For a BW query, you want to have the first month of the curret quarter as a default value for an input-ready BW variable for the characteristic OCALMONTH. Which processing tyoe do you use?

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

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

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

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

Question72: You are involved in an SAP BW/4HANA project focusing on General Ledger reporting and want to use the SAP ERP Standard DataSource 0FI_GL_ 14 (New GL Items). Which transaction can be used to activate this DataSource? (2)

Question73: 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 for rapid prototyping?

Question74: What is the maximum number of characteristics that can be used for a multi-dimensional exception aggegation in a BW query?

Question75: With SAP BW/4HANA 2.0, SAP introduced a new capability called Write Interface for DataStore objects (Advanced). Which SAP solutions can leverage this interface to push data into the inboud table of DataStore objects (Advanced)? Note: There are 3 correct answers to this question.

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

Question77: What are some of the prerequesites for using SAP S/4HANA ABAP CDS views for extraction into SAP BW/4HANA in an ODP context? Note: There are 2 correct answers to this question.

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

Question79: What can you achieve with rule groups in an SAP BW transformation?
There are 2 correct answers to this question.

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

Question81: SAP provides three data warehousing solutions to provide customers more flexibility. How is SAP Data Warehouse Cloud positioned?

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

Question83: For which requirements do you suggest an SAP HANA modeling focus rather that an SAP BW/4HANA modeling focus?? Note: There are 2 correct answers to this question.

Question84: Which external hierarchy properties can be changed the query definition? (3)