SAP C_HANAIMP142 - SAP Certified Application Associate - SAP HANA (Edition 2014) Exam
Page: 2 / 55
Total 271 questions
Question #6 (Topic: )
You created a model on a table XYZ.PRODUCTS. You successfully activated the model.
When you run the data preview you receive an error message "Insufficient privilege. Not
authorized".
Which of the following 4 statements do you execute to resolve the error before you
reactivate the model?
When you run the data preview you receive an error message "Insufficient privilege. Not
authorized".
Which of the following 4 statements do you execute to resolve the error before you
reactivate the model?
A. GRANT SELECT on SCHEMA XYZ to _SYS_REPO
B. GRANT SELECT on PRODUCTS to _SYS_REPO WITH GRANT OPTION
C. GRANT SELECT on SCHEMA XYZ to _SYS_BIC WITH GRANT OPTION
D. GRANT SELECT on PRODUCTS to _SYS_BIC
Answer: B
Question #7 (Topic: )
Refer to the exhibit.
[SAP-C-HANAIMP142-5.0/SAP-C_HANAIMP142-4_2.png]
You have been asked to create an SAP HANA attribute view using the tables Employee
(left table) and Department (right table), shown in the attached diagram. Your view should
contain the columns NAME and D_Name for all employees.
Which of the following join types do you use?
[SAP-C-HANAIMP142-5.0/SAP-C_HANAIMP142-4_2.png]
You have been asked to create an SAP HANA attribute view using the tables Employee
(left table) and Department (right table), shown in the attached diagram. Your view should
contain the columns NAME and D_Name for all employees.
Which of the following join types do you use?
A. Referential join
B. Left outer join
C. Text join
D. Inner join
Answer: B
Question #8 (Topic: )
You are building a calculation view and want to select data from an analytic view. How can
you achieve better performance for this requirement?
you achieve better performance for this requirement?
A. Use CE functions
B. Use SQL statements
C. Use L programming
D. Use table indexing
Answer: A
Question #9 (Topic: )
You want to implement an SAP HANA data model based on tables in a new schema that
you just created.
Which technical user requires select rights on your new schema?
you just created.
Which technical user requires select rights on your new schema?
A. _SYS_BI
B. _SYS_SECURITY
C. _SYS_BIC
D. _SYS_REPO
Answer: D
Question #10 (Topic: )
Which of the following can be grouped inside a single schema in an SAP HANA database?
A. Information models
B. Packages
C. Users
D. Database tables
Answer: D
