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."
A. Combine CUSTOMER, CITY and COUNTRY in a Open ODS View using a sequence of associations.
B. Generate external views for CUSTOMER, CITY and COUNTRY, and join them in another calculation view.
C. Combine CUSTOMER, CITY and COUNTRY in a Composite Provider using a sequence of left outer join operators.
D. Include CUSTOMER to rows in the BW Query on CUSTOMER and activate the Universal Display Hierarchy setting.
E. Add COUNTRY as a transitive attribute for CUSTOMER in InfoObject definition.
What are the key benefits of using the SAP Landscape Transformation Replication Server for data provisioning into SAP HANA? Note: There are 3 correct answers to this question.
A. Real-time and scheduled data replication
B. Field type mapping
C. Virtualization capabilities
D. All databases are supported
E. Transformations using ABAP
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.
A. Change the order of the fields in the target table
B. Switch the table type between row store and column store
C. Define sorting properties for a target table field
D. Adjust the suggested data type of the target table fileds
E. Map InfoObjetcs to fields in the target tavle
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.
A. You cannot use navigation attributes for this characteristic
B. You cannot load more than 2 billion master data records for this characteristic
C. SID numbers are created at runtime which might negatively affetct the reporting performance
D. You cannot use this characteristic as a navigation attribute for another characteristic.
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.
A. A fixed currency from table TCURC
B. Another column of the same SAP HANA view
C. A column from another SAP HANA view
D. A variable in the same SAP HANA view
Which join types can you use in a CompositeProvider? Note: There are 3 correct answers to this question.
A. Full outer join
B. Referential join
C. Hierarchy join
D. Text join
E. Inner join
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.
A. Analysis
B. Components
C. Information
D. Design Rules
You have created a custom characteristic with the technical name "COSTOBJ" Depending on the controlling area, you need to have different atribute values assigned. How do you desing the model?
A. Compound characteristic "COSTOBJ" with the characteristic for Controlling Area
B. Compound the characteristic for Controlling Area with the characteristic "COSTOBJ"
C. Define Controlling Areas as a navigation attribute for the characteristic "COSTOBJ"
D. Define characteristic "COSTOBJ" as a navigation attribute for Controlling Area
For which requirements do you suggest an SAP HANA modeling focus rather that an SAP BW/4HANA modeling focus? Note: There are 2 correct answers to this question.
A. Enhance existing SAP HANA content models
B. Report on a harmonized set of master data
C. Load snapshots or deltas from different sources on a periodic basis
D. Leverage SQL in-house knowledge
Which recommendations should you follow to optimize BW query performance? Note: There are 3 correct answers to this question
A. Use fewer drill-down characteristics in the initial view
B. Use characteristic filters that overlap
C. Use exclude functions in the restricted key figures
D. Use mandatory characteristic value variables
E. Use include functions in the restricted key figures.
What is the purpose of an architecture overview model?
A. To identify the user groups and required authorizations
B. To automatically generate the LSA++ architecture
C. To determine the sequence of projects
D. To identify the required data sources.
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.
A. BAPIs (Business Application Programming Inetrface)
B. Calculation views
C. AMDPs (ABAP Manged Database Procedures)
D. Stored procedures
Which external hierarchy properties can be changed in the query definition? Note: There are 3 correct answers to this question.
A. Position of child nodes
B. Expand to level
C. Time dependency
D. Sort direction
E. Allow temporal hierarchy join
You have an existing field-based data flow that follows the LSA++ concept. To meet a new urgent business requirement for a field you want to leverage a hierarchy of an existing characteristic without changing the transformation. How can you achieve this? Note: There are 2 correct answers to this question.
A. Associate the field with the characteristic in the CompositeProvider
B. Add the characteristic to the DataStore object (advanced)
C. Associate the field with the characteristic In the Open ODS View
D. Assign hierarchy properties to the field in the SW Query
Which SAP BW/4HANA objects support the feature of generating an external SAP HANA View? Note: There are 2 correct answers to this question.
A. Open ODS view
B. Semantic group object
C. Composite Provider
D. BW query .