On a weekly basis, you need to extract and transform data from multiple sources such as SAP ERP Microsoft Excel and Apache Hadoop and load the data into SAP HANA.
Which tools can you use?
There are 2 correct answers to this question.
Response:
You are a data analyst working with medical records that contain confidential patient information. Why do you use the anonymization node in a calculation view?
Note: There are 2 correct answers to this question.
When creating a system connection in SAP HANA Studio, which of these is essential information?
There are 3 correct answers to this question.
Response:
One SQL analytic privilege authorizes you to view data for Europe and the USA in the sales calculation view, and another one authorizes you to view data for Asia and the USA in the income calculation view.
The income view uses the sales view as a data source.
Both calculation views check SQL analytic privileges.
What data can you visualize when consuming the income calculation view?
Please choose the correct answer.
Response:
Your calculation view includes the following SALES_ORDER_ID and ITEM as attributes, and QUANTITY and PRICE as measures. You create a calculated column, ITEM_TOTAL, with the formula QUANTITY*PRICE.
In which node do you define the calculation to display the correct aggregated result?
Please choose the correct answer.
Response:
