SAP HANA: Certification Questions 421 through 430

QUESTION: 421
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?
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. RANT SELECT on PRODUCTS to _SYS_BIC

Answer: B


QUESTION: 422
You want to add a calculated column to an SAP BusinessObjects Web Intelligence report. 
In which application do you create the calculation to achieve best report performance?
A. Central Management Console
B. Information Design Tool 
C. Web Intelligence
D. SAP HANA Studio

Answer: D

QUESTION: 423
What outputs can you create in an attribute view?
Note: There are multiple correct answers to the question
A. Key Attributes
B. Calculated Attributes
C. Restricted Measures
D. Calculated Measures
E. Private Attributes

Answer: A, B

QUESTION: 424
Which reporting tool can you use to display native parent-child hierarchies from SAP HANA?
A. Microsoft Excel
B. SAP BusinessObjects WebIntelligence 
C. SAP BusinessObjects Analysis, edition for OLAP
D. SAP BusinessObjects Analysis, edition for Microsoft Office

Answer: A

QUESTION: 425
Which of the following privileges do you need to activate views?
A. SELECT option on the _SYS_BIC schema 
B. SELECT option on the _SYS schema 
C. SELECT option on the _SYS_BI schema 
D. SELECT option on the _SYS_REPO schema

Answer: D

QUESTION: 426
Which SAP BusinessObjects tools require an SAP BusinessObjects semantic layer (universe) to access data in SAP HANA?
Note: There are multiple correct answers to the question
A. Crystal Reports 2011
B. Crystal Reports for Enterprise
C. Dashboards 
D. Analysis Office v1.1
E. WebIntelligence 

Answer: B, C, E

QUESTION: 427
For what purpose do you use SQL Script in SAP HANA?
Note: There are multiple correct answers to the question
A. To transfer a large amount of data between engines
B. To achieve very high performance on SELECT statements
C. To combine two analytic views 
D. To create database procedures 
E. To shift complex calculations and logic to the client side 

Answer: C, D

QUESTION: 428
Which of the following are benefits of using accelerators with SAP HANA?
Note: There are multiple correct answers to the question
A. They provide pre-built business content
B. They provide pre-built customer-specific solutions
C. They reduce the time required for implementation
D. They eliminate the need for customization

Answer: A, C

QUESTION: 429
How can you evaluate the speed of a calculation within the database?
Note: There are multiple correct answers to the question
A. Use the Data Preview function in the SAP HANA studio
B. Execute a Web Intelligence report and check the duration of the previous refresh
C. Execute an information space using SAP BusinessObjects Explorer
D. Write and execute an appropriate SQL statement

Answer: A, D

QUESTION: 430
You are running an SAP BusinessObjects WebIntelligence report that fetches data from SAP HANA. Which components will be used inside SAP HANA for providing data to this report?
A. Persistence Layer
B. MDX 
C. Session Management
D. Authorization Manager

Answer: C, D








No comments:

Post a Comment