Security Questions.docx

Security 1. What is the lowest level of granularity you can use in an analytic privilege? A. An attribute B. A view C. An attribute value D. A column Answer: C 2. You would like to authorize a user to see data in an analytic view only for company code 1000 and fiscal year 2000 or for company code 1005 and fiscal year 2005. Which of the following achieves this requirement? A. One analytic privilege. the combination of company code = 1000 and fiscal year = 2000, and the combination of company code = 1005 and fiscal year = 2005 B. • One analytic privilege: company code = 1000, fiscal year = 2000 • One analytic privilege: company code = 1005, fiscal year = 2005 C. One analytic privilege: company codes = 1000 and 1005, and fiscal years = 2000 and 2005 D. • One analytic privilege: company codes = 1000 and 1005 • One analytic privilege: fiscal years = 2000 and 2005 Answer: B 3. You want to run a report on data with multiple currencies. You want to allow end users to select the target currency at run time. Which option does SAP recommend for defining the currency conversion? A. A calculated column in an analytic view B. Currency conversion during data load C. Measures enabled for conversion in an analytic view D. ACE_CONVERSION function in a calculation view Answer: C 4. A new user has implemented an SAP HANA data model. which technical user requires select rights on the new user's schema? A. _SYS_REPO B. _SYS_BIC C. _SYS_BI D. _SYS_SECURITY Answer: A 5. You would like to authorize a user to select and delete data from a specific column table. The user should also be able to grant this authorization to other users. Which privilege do you need to implement?

A. Analytic privilege B. System privilege C. Package privilege D. Object privilege Answer: D