Online Access Free C-HANAIMP-1 Exam Questions

You have an SAP HANA productive system with sensitive data.How can you restrict modeling users from viewing this data? (Choose two)

• A.Use randomized data for the development of data models.
• B.Remove SAP_DATA_ADMIN in the SQL privileges for the modeling users.
• C.Allow modeling only on the SAP HANA development system and export/import the models to the productive system.
• D.Remove ALTER SYSTEM in the system privileges for the modeling users.

Where does SAP recommend you create calculated measures?

• A.In an attribute view
• B.In a business layer
• C.In a column view
• D.In an analytic view

Which of the following must you avoid to ensure your calculation view uses only the calculation engine? (Choose three)

• A.Reading from tables using SELECT statements
• B.Combining SQL and CE Functions
• C.Reading from tables in the column store
• D.Joins using SQL
• E.DO WHILE loops

Which reporting tool can you use to display native parent-child hierarchies from SAP HANA?

• A.Microsoft Excel
• B.SAP BusinessObjects Analysis, edition for OLAP
• C.SAP BusinessObjects WebIntelligence
• D.SAP BusinessObjects Analysis, edition for Microsoft Office

You want to report on data from SAP HANA using MS Excel. How can you achieve this? (Choose two)

• A.Select an attribute view using the Data Connection wizard.
• B.Create an ODBO connection between SAP HANA and MS Excel.
• C.Select an analytic view using the Data Connection wizard.
• D.Create a ODBC connection between SAP HANA and MS Excel.