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.
