EMT Practice Test

1. Question Content...


Question List

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

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

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

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

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

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

Question7: You create a transformation from a DataSource to a DataMart Data Store object (advanced) All key figures are updated as Sum. Which Delta methods indicate that the DataSource provides consistent information for this target? Note: There are 2 correct answers to this question.

Question8: Which recommendations should you follow to optimize BW query performance? Note: There are 3 correct answers to this question

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

Question10: The Database Explorer in the Web IDE for SAP HANA proveides a data file improt wizard to create a table in SAP HANA from a flat file. What are possible actions adter the system suggests the target structure?? Note: There are 3 correct answers to this question.

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

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

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

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

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

Question16: What can you leverage using the live data connectyions of SAP Analytics Cloud with SAP BW/4HANA? Note: There are 2 correct answers to this question.

Question17: You want to build an SAP HANA HDI 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 data category to DIMENSION, what do you have to do?

Question18: With SAP BW/4HANA, the new HANA-optimized business content is designed according to the LSA++ framework. Which tecnical namespace is assigned to identify the new SAP ERP-related business content?

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

Question20: Which disadvantages should you keep in mind when you set the High Cardinality flag for a characteristic? Note: There are 2 correct answers to this question.

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

Question22: You define a remote subscription of type UPSERT in an SAP HANA Smart Data Integration (SDI) real-time udate scenario. Which fields are added to the DataSource automatically? Note: There are 3 correct answers to this question.

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

Question24: You open an SAP Analysis for Microsoft Office workbook. On which Design Panel tabs can you verify the filter values? Note: There are 2 correct answers to this question.

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

Question26: You use InfoObject B as a display attribute for InfoObject A. Which object properties prevent you from changing InfoObject B into a navigational attribute for InfoObject A? Note: There are 3 correct nswers to this question."

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

Question28: "You created an Open ODS View on an SAP HANA database table to virtually consume 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 are created when using the ""Generate Data Flow"" function in the Open ODS View editor? Note: There are 3 correct answers to this question."

Question29: You use a measure with semantic type "Amount with Currency Code" in your SAP HANA HDI calculation view. Which kind of currency reference can be assigned to the measure? Note: There are 2 correct answers to this question.

Question30: What foundation is necessary to use SAP S/4HANA embedded analytics?

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

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

Question33: In a BW query with cells, you need to overwrite the initial definition of a cell. With which cell tupes can this be achieved?? Note: There are 2 correct answers to this question.

Question34: What does a Composite Provider allow you to do in SAP BW/4HANA? Note: There are 3 correct Answers to this question.

Question35: Which data deletion options are offered for a standard DataStore object (advanced)? Note: There are 3 correct answers to this question.

Question36: Which SAP solutions can leverage the Write Interface for DataStore objects (advanced) to push data into the inbound table of DataStore objects (Advanced)?
There are 2 correct answers to this question.

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