nerdexam
SAP

C_HANAIMP142 · Question #296

C_HANAIMP142 Question #296: Real Exam Question with Answer & Explanation

The correct answer is B. GRANT SELECT on PRODUCTS to _SYS_REPO WITH GRANT OPTION. See the full explanation below for the reasoning.

Question

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?

Options

  • AGRANT SELECT on SCHEMA XYZ to _SYS_REPO
  • BGRANT SELECT on PRODUCTS to _SYS_REPO WITH GRANT OPTION
  • CGRANT SELECT on SCHEMA XYZ to _SYS_BIC WITH GRANT OPTION
  • DGRANT SELECT on PRODUCTS to _SYS_BIC

Community Discussion

No community discussion yet for this question.

Full C_HANAIMP142 Practice