EMT Practice Test

1. Question Content...

---

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

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

Question3: You plan to regularly transfer changes from an SAP ERP custom table to SAP BW/4HANA.
An additional custom development may NOT be implemented in the source system. Which Operational Data Provisioning (ODP) source system type do you recommend?

Question4: You need to load data from a generic DataSource using Operational Data Provisioning (ODP). In which sequence do you perform the activities?

Question5: What are key capabilities of SAP Agile Data Preparation Note: There are 3 correct answers to this question.

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

Question7: For which table type does SAP HANA compress data?
Please choose the correct answer.

Question8: You want to add a Source System of type Big Data in SAP BW/4HANA.
Which adapters can you use to reference the remote source system? Note: There are 2 correct Answers to this question.

Question9: Which external hierarchy properties can be changed in the query definition? Note: There are 3 correct Answers to this question.

Question10: What are the key benefits of using the SAP Landscape Transformation Replication Server for data provisioning into SAP HANA? Note: There are 2 correct Answers to this question.

Question11: Which object is a target of an SAP BW transformation?

Question12: Where can you automatically generate a process chain?

Question13: 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.

Question14: In which sequence does SAP recommen

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

Question16: Which condition must you ensure if you want to replicate data based on a view with SAP Landscape Transformation Replication Server?

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

Question18: Which SAP HANA objects are automatically generated if you set the External SAP HANA Calculation View flag for an SAP BW/4HANA object?
Note: There are 2 correct answers to this question.

Question19: Which property settings can you assign for a characteristic? Note: There are 3 correct answers to this question.

Question20: You created a generic DataSource in SAP ERP using a function module. Which manual activity could you perform to enable your generic DataSource to use as an ODP_SAP DataSource in SAP BW/4HANA?

Question21: 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.

Question22: What are the prerequisites for deleting master data (for example, cost centers) in SAP BW/4HANA?
Note: There are 2 correct Answers to this question.

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

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

Question25: Which SAP BW/4HANA features support the code-to-data principle? Note: There are 3 correct answers to this question.

Question26: You need to combine master data (right table) and transactional data (left table) using a referential join. How will this referential join behave?

Question27: Which of the Augmented Analytics Smart Features in SAP Analytics Cloud generates fully populated, multi-tabbed stories?

Question28: You want to use the SAP HANA concept of semantic types as part of the currency conversion mechanism. You decide to use semantic type Amount with Currency Code within your SAP HANA calculation view. Which currency reference can be assigned to the measure? Note: There are 3 correct answers to this question.

Question29: Which modeling function is possible in modeling with an SAP HANA Calculation View that is not possible in modeling with a CompositeProvider?

Question30: Which tasks are part of the Business Blueprint and Data Model Definition phase in an SAP BW/4HANA project? Note: There are 3 correct Answers to this question.

Question31: You want to build Web-based dashboards with interactive visualizations. Which SAP tool would you use?

Question32: You created an Open ODS view based on a database table in SAP HANA to 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 objects will be created when using the Generate Dataflow function via the Open ODS view? Note: There are 3 correct Answers to this question.

Question33: Which SAP BW/4HANA objects can keep persistent data? Note: There are 2 correct answers to this question.

Question34: Which layers are part of the layered scalable architecture for SAP BW/4HANA (LSA++)? Note: There are 2 correct answers to this question.

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

Question36: Which SAP BW/4HANA objects can be used as sources of a data transfer process (DTP) ? Note: There are
3 correct Answers to this question.

Question37: For which activity do you use the key figure matrix?

Question38: Which of the following are possible delta-specific fields for a generic DataSource in SAP ERP? Note:
There are 3 correct Answers to this question.

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

Question40: You need to restrict a sales report to the products that make up 50% of the total revenue. Which BW query feature do you use?

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

Question42: What are the reasons for implementing CompositeProviders? Note: There are 2 correct Answers to this question.

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

Question44: Which objects can you combine using a CompositeProvider? Note: There are 2 correct answers to this question.

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

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

Question47: Which functionality does the SAP Landscape Transformation Replication Server support?
Please choose the correct answer.

Question48: How do you model plant-specific attributes for the characteristic material?

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

Question50: Which of the following use cases is classified as operational reporting?

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

Question52: You need to consume remote HADOOP data in your SAP HANA Native App. Which components can you use? Note: There are 3 correct answers to this question.

Question53: For which of the following revenue reporting requirements do you create restricted key figures?

Question54: Which settings can you define in a data transfer process (DTP) if you load data into a DataStore object (advanced)?
Note: There are 3 correct answers to this question.

Question55: How do you enable streaming mode for a process chain?

Question56: Which SAP Landscape Transformation Replication Server cockpit operation removes all data from the trigger table?

Question57: 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 InfoObject to be associated?