When do you recommend using an external hierarchy? Note: There are 3 correct answers to this question.

When do you recommend using an external hierarchy? Note: There are 3 correct answers to this question.A . The hierarchical structure will be time-dependent.B . The structure will contain formulas.C . The structure will depend on the order of the row characteristics.D . The structure exists in the source system.E...

July 7, 2021 No Comments READ MORE +

For which business requirements do you suggest an SAP BW/4HANA modeling focus rather than an SAP HANA modeling focus? Note: There are 2 correct answers to this question.

For which business requirements do you suggest an SAP BW/4HANA modeling focus rather than an SAP HANA modeling focus? Note: There are 2 correct answers to this question.A . Report on a harmonized set of master data.B . Load snapshots or deltas on a periodic basis.C . Use existing HANA...

July 7, 2021 No Comments READ MORE +

Why do you define a custom table as a row store table? Note: There are 2 correct answers to this question.

Why do you define a custom table as a row store table? Note: There are 2 correct answers to this question.A . The table will be integrated into a native SAP HANA calculation view.B . Aggregation and fast search is required for query execution.C . When the table is accessed,...

July 7, 2021 No Comments READ MORE +

How does sap hana smart data access (SDA) differ from sap hana smart data integration (SDI)?

you create a new sap hana remote connection . How does sap hana smart data access (SDA) differ from sap hana smart data integration (SDI)? (2 answer)A . SDI is recommended for data source with limited changesin data structure SDA contains features to act as a full blown ETL tool"B...

July 7, 2021 No Comments READ MORE +

Which of the following use cases is classified as operational reporting?

Which of the following use cases is classified as operational reporting?A . Year-to-date comparison reports containing prior and actual year numbersB . Evaluation of trends over several yearsC . Reporting requirements with monthly data refreshesD . Near-real-time access to original transactional valuesView AnswerAnswer: D

July 7, 2021 No Comments READ MORE +

for the data model design concept?

Storage requirements for the data model design concept?View AnswerAnswer: B

July 6, 2021 No Comments READ MORE +

What is the reference InfoObject in an exception aggregation?

You need to determine the number of customers in each country that have revenue in 2018 . What is the reference InfoObject in an exception aggregation?A . CounterB . CustomerC . CountryD . YearView AnswerAnswer: B

July 5, 2021 No Comments READ MORE +

Which currency reference can be assigned to the measure?

You want to use the SAP HANA concept of semantic types as part of the currency conversion mechanism. You decide to use semantic type Amount with Currency Code within your SAP HANA calculation view . Which currency reference can be assigned to the measure? Note: There are 3 correct answers...

July 5, 2021 No Comments READ MORE +

What must you ensure to use the data preview functionality?

You want to validate your SAP HANA data model . What must you ensure to use the data preview functionality?A . The _SYS_BIC user is created in the system and the runtime information is written to_SYS STATISTICC . You are connected as SYSTEM user and all object privileges are assigned...

July 5, 2021 No Comments READ MORE +

which advantages can you leveragewhile importing data into a new sap hana table using a flat file? (2 answer)

which advantages can you leveragewhile importing data into a new sap hana table using a flat file? (2 answer)A . adjustement for column, type, lenght, and name is possibleB . easiness of loadingC . trasformation capabilitiesD . availability of delta logicView AnswerAnswer: A,C

July 5, 2021 No Comments READ MORE +