EMT Practice Test

1. Question Content...


Question List

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

Question2: Which node types are only available for graphical modeling of SAP HANA HDI Calculation Views(XS Advanced), but not for SAP HANA Calculation Views(XS Classic)? Note: There are 2 correct answers to this question.

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

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

Question5: "For InfoObject ADDRESS, the High Cardinality flag has been set. However, ADDRESS has an attribute CITY without the high Cardinality flag." What is the effect on SID values in this scenario?

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

Question7: 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 hacve to analyze a potential extractor issue? Note: There are 2 correct answers to this question.

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

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

Question10: InfoObject CITY is defined as a display attribute for InfoObject CUSTOMER, and InfoObject COUNTRY is defined as a display attribute for InfoObject CITY. In a master data report you want to display the COUNTRY of a CUSTOMER. Which options do you have to realize the scenario? Note: There are 3 correct answer to this question."

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

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

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

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: You are following a top-down method for your SAP BW/4HANA modeling project. What would be your first task?

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

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

Question18: You create a generic DataSource in SAP ERP. "How can you enable your generic DataSource to be used as an ODP_SAP DataSource in SAP BW/4HANA in casa it is not available by default?"

Question19: "What are benefits of separating master data from transactional data in SAP BW/4HANA? Note: There are 3 correct answer to this question."

Question20: What are some of the variable types n a BW query that can use the processing tupe SAP HANA Exit. Note: There are 2 correct answers to this question.

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

Question22: "Which SAP BW/4HANA objects support the feature of generating an external SAP HANA View?" Note: There are 2 correct answers to this question.

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

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

Question25: "You have already loaded data from a non-sap system into SAP Data Wharehouse Cloud. You want to federate this data with data from an InfoCube of your SAP BW powered by SAP HANA system" What do you need to use to combine data?

Question26: What is required before you can integrate an HDI Calculation View (data category Dimension) into another HDI Calculation View (data category Cube with Star Join) of the same HDI container?"

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

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

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

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

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

Question32: "What are benefits of separating master data from transactional data in SAP BW/4HANA? Note: There are 3 correct answer to this question."

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

Question34: You want build a web-based dashboard with interactive visualizations using Javascript. Which SAP tool can you use to create this?

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

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