Part 1

Question. 1 What are benefits of separating master data from transactional data in SAP BW/4HANA? Note: There are 2 correct answers to this question. Provide language-dependent texts. Avoid generation of SID values. Ensure referential integrity on your transactional data. Distinguish between changeable and non-changeable data.

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. Union. Intersect. Rank. Graph.

Which development object needs to be built to generate an HDI Container?. SQL script procedure. Space. HDB module. Package.

You use SAP HANA to integrate an HDI Calculation View (data category Dimension) into another HDI Calculation View (data category Cube with Star Join). What do you need to do before you can integrate the HDI Calculation View (data category Dimension)?. Build the design time file of the HDI Calculation View (data category Dimension) to generate a run time object. Integrate the design time file of the HDI Calculation View (data category Dimension) into a CompositeProvider. Integrate the design time file of the HDI Calculation View (data category Cube with Star Join) into a CompositeProvider. Build the run time object of the HDI Calculation View (data category Cube with Star Join) to generate a design time file.

You create an SAP HANA HDI Calculation View. What are some of the reasons to choose the data category Cube with Star Join instead of data category Dimension? Note: There are 3 correct answers to this question. Persist transactional data. Combine master data and transactional data. Provide default time characteristics. Create restricted columns. Aggregate measures as a sum.

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?. SAP Crystal Reports for Enterprise. SAP Analysis for Microsoft Office. SAP BusinessObjects Web Intelligence. SAP Lumira, designer edition.

With SAP BW/4HANA, the new HANA-optimized business content is designed according to the LSA++ framework. Which technical namespace is assigned to identify the new SAP ERP-related business content?. /0SAP/. /SFA/. /IMO/. /BW4/.

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. The ABAP CDS views must be released via program RODPS_OS_EXPOSE for BW extraction. An Operational Data Provisioning Framework must be configured in SAP BW/4HANA. The ABAP CDS views must be defined with the appropriate data extraction annotations. An ODP source system with context ODP_CDS must be created in SAP BW/4HANA.

What is the purpose of an architecture overview model?. To identify the user groups and required authorizations. To identify the required data sources. To determine the sequence of projects. To automatically generate the LSA++ architecture.

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?. In the SAP BW Open ODS view. In the SAP BW InfoSource. In the SAP BW DataStore object (advanced). In the SAP BW CompositeProvider.

Which features are related to the start process in a process chain? Note: There are 2 correct answers to this question. Only one start process is allowed for each process chain. It can be a successor of another process. It is the only process that can be scheduled without a predecessor. It can be re-used in other process chains.

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?. Only one result row with the sales revenue sum of the top 10 customers. One result row with the sales revenue sum of the top 10 customers and a second result row with the sales revenue sum of the other 90 customers. Only one result row with the sales revenue sum of all 100 customers. Only one result row with the sales revenue sum of all 100 customers.

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. There must be no BW analysis authorizations defined that use any of the cost centers. There must be no transaction data referring to the cost centers. There must be no hierarchy for the cost centers. There must be no BW query that uses cost center as a free characteristic.

In which ODP context is the operational delta queue (ODQ) managed by the target system?. ODP_BW. ODP_HANA. ODP_SAP. ODP_CDS.

What is the maximum number of characteristics that can be used for a multi-dimensional exception aggregation in a BW query?. 10. 7. 3. 5.

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?. Customer Exit. Manual Input with default value. Manual Input with offset value. Replacement Path.

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?. The BW query starts and only the authorized data is displayed. The BW query starts and shows an error message. The BW query does not start running. The BW query starts and the unauthorized values are 0.

Which external hierarchy properties can be changed in the query definition? Note: There are 3 correct answers to this question. Time dependency. Expand to level. Position of child nodes. Allow temporal hierarchy join. Sort direction.

When loading master data for a material, you want to look at the new values before they are released for reporting. What could you do using modeling features? Note: There are 2 correct answers to this question. When you define the data transfer process,select the “Load records with new key only” setting. When you define the attributes of material,select the “Time Dependent” setting. When you define the material characteristic,select the “Enhanced Master data update” setting. When you define the data transfer process, choose the “Set manually” setting for “Overall status of request”.

Which interface do you use to create a BW InfoObject with access type "SAP HANA view"?. SAP HANA modeler perspective in SAP HANA studio. Embedded SAP GUI in SAP HANA studio. SAP Web IDE for SAP HANA. BW modeling perspective in SAP HANA studio.

What can you leverage using the live data connections of SAP Analytics Cloud with SAP BW/4HANA? Note: There are 2 correct answers to this question. Process chain streaming functionality. BW data models for planning scenarios. BW data models for analysis. Existing authorization concepts.

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. Stored procedures. Calculation views. AMDPs (ABAP Managed Database Procedures). BAPIs (Business Application Programming Interface).

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?. Using this characteristic as a navigational attribute will impact response time. The High Cardinality property needs to be defined in the Composite Provider. The local SID values are created automatically during reporting, which will impact the response time. Using a hierarchy of this characteristic for navigation will impact response time.

Why should you run an SAP HANA delta merge? Note: There are 2 correct answers to this question. To decrease memory consumption. To combine the query cache from different executions. To improve the read performance of InfoProviders. To move the most recent data from disk to memory.

For which requirements do you suggest an SAP HANA modeling focus rather than an SAP BW/4HANA modeling focus? Note: There are 2 correct answers to this question. Load snapshots or deltas from different sources on a periodic basis. Leverage SQL in-house knowledge. Enhance existing SAP HANA content models. Report on a harmonized set of master data.

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 settings before you can successfully build the HDB module?. Enter an organization. Assign a space. Reset the project type. Define a package.

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. Map InfoObjects to fields in the target table. Adjust the suggested data type of the target table fields. Define sorting properties for a target table field. Switch the table type between row store and column store. Change the order of the fields in the target table.

You would like to highlight the deviation from predefined threshold values for key figure actual revenue. Which BW feature do you use?. Structure. Calculated key figures. Conditions. Exceptions.

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. Open ODS view of type Facts. Calculation View of type Dimension. Open ODS view of type Master Data. InfoObject of type Characteristic.

With which query considerations can you optimize the query performance? Note: There are 3 correct answers to this question. Use exclude functions in the restricted key figures. Use mandatory characteristic value variables. Use characteristic filters that overlap. Use fewer drill-down characteristics in the initial view. Use include functions in the restricted key figures.

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?. The language column in the right table. The join cardinality between both tables. The logon language in the left table. The language column in the left table.

Which of the following are possible source types for an Open ODS view? Note: There are 3 correct answers to this question. Database table or view. Open hub destination. CompositeProvider. Transformations. DataStore object (advanced).

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 inbound table of DataStore objects (advanced)? Note: There are 3 correct answers to this question. SAP Data Services. SAP Landscape Transformation Replication Server. SAP Process Integration. SAP Business Technology Platform. SAP Data Warehouse Cloud.

What is the request handling default setting for error handling in a data transfer process (DTP) in SAP BW/4HANA?. Request is set to failed, error stack is written, and valid records are updated. Request is canceled, first incorrect record is tracked, and target is not updated. Request is canceled, records are not tracked, and target is not updated. Request is set to success, error stack is written, and valid records are updated.

Which source types are available to create a generic DataSource in SAP ERP? Note: There are 3 correct answers to this question. SAP query. ABAP function module. HDI Calculation View. ABAP class method. Database view.

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. Information. Components. Analysis. Design Rules.

Which layers offer the virtualization approach for the layered scalable architecture (LSA++) of SAP BW/4HANA? Note: There are 2 correct answers to this question. Data acquisition layer. Open hub layer. Open operational data store layer. Virtual data mart layer.

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?. Compound the characteristic for Controlling Area with the characteristic "COSTOBJ". Define Controlling Area as a navigation attribute for the characteristic "COSTOBJ". Define characteristic "COSTOBJ" as a navigation attribute for Controlling Area. Compound characteristic "COSTOBJ" with the characteristic for Controlling Area.

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

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. Request ID. Time stamp. Record mode. Calendar day. Numeric pointer.