SAP HANA: Certification Questions 231 through 240

Questions: 231
Which privilege controls User Admin & Create Schema roles?
A. Analytic privilege
B. Package privilege
C. System privilege
D. SQL privilege

Answer: C

Question: 232
Without Analytic Privilege, no data can be viewed from
A. Attribute Views
B. Analytic Views
C. Calculation Views
D. All of the above

Answer: D

Question: 233
Analytic Privileges belong to?
A. _SYS_BI
B. _SYS_REPO
C. _SYS_BIC
D. _SYS_VIEWS

Answer: B

Question: 234
Private attributes from the Attribute views are used to join to the Key attributes?
A. True
B. False

Answer: B

Question: 235
Following types of joins are possible in Attribute view?
Note:  There are multiple correct answers to the question
A. Referential join
B. Description join
C. Inner join
D. Outer join

Answer: A, C, D

Question: 236
Persistence layer in the SAP HANA DB has the following components:
A. Data volumes & Log Volumes
B. Page management & Logger
C. Row store & Column store

Answer: B

Question: 237
Which section controls the data processing in the HANA DB?
A. Transaction Manager
B. Authorization Manager
C. Metadata Manager
D. None

Answer: A

Question: 238
Which tool is used to create Universe for reporting in dashboard?
A. Semantic layer tool
B. Information design tool
C. Universe layer tool
D. None

Answer: B

Question: 239
OPD for data replication API is used in which replication?
A. Log based real time data replication services
B. Data services 4.0
C. Sybase real time data replication
D. Done

Answer: B

Question: 240
RFC connection is required for connection from Replication server to HANA Database
A. True
B. False

Answer: B