SAP HANA: Certification Questions 271 through 280

QUESTION: 271

You have created an MS Excel report on SAP HANA data. On which of the following could you store the Excel file and make it available for other users?
A. Shared network drive
B. SAP BusinessObjects Information Design Tool
C. SAP HANA database
D. SAP HANA studio Content node

Answer: A

QUESTION: 272

Which SAP tool would you use for data cleansing before data is loaded into SAP HANA?
A. SAP BusinessObjects Information Steward
B. SAP BusinessObjects Data Services
C. SAP Landscape Transformation
D. SAP NetWeaver Master Data Management

Answer: B

QUESTION: 273

Which transaction is used for releasing extractors specified by the customers in SLT?
A. RODPS_OS_OPEN
B. RODPS_OS_CLOSE
C. RODPS_OS_EXPOSE
D. RODPS_OS

Answer: C

QUESTION: 274

Which feature is supported by the backup and recovery process within the standard delivery of SAP HANA?
A. Incremental backup
B. Information model recovery
C. Point-in-time recovery
D. Automatic backup of archiving log files scheduled within SAP HANA

Answer: C

QUESTION: 275

How can you improve the performance of a scripted calculation view?
A. Read data from column tables using nested SELECT statements
B. Convert SQL code to equivalent CE functions
C. Combine analytic views using a CE_JOIN function
D. Combine data from the row store and column store

Answer: B

QUESTION: 276

What outputs can you create in an attribute view?

Note:  There are multiple correct answers to the question

A. Key Attributes 

B. Calculated Attribute

C. Restricted Measures

D. Calculated Measures 

E. Private Attributes 

Answer: A, B

QUESTION: 277

Which data provisioning method can you use to load data from SAP business content Data Sources into SAP HANA?

Note:  There are multiple correct answers to the question

A. SAP Landscape Transformation (SLT)

B. SAP Landscape Directory (SLD)

C. SAP Direct Extractor Connection (DXC)

D. SAP BusinessObjects Data Services

Answer: C, D

QUESTION: 278

If you want to create or drop tables in a schema, which privilege type do you need? 

A. SYSTEM

B. ANALYTIC

C. PACKAGE

D. SQL

Answer: D

QUESTION: 279

When you activate a procedure, in which schema is the procedure stored? 
A. SYSTEM
B. _SYS_BIC
C. SYS_REPL
D.  _SYS_BI

Answer: B

QUESTION: 280

In which tool can you create information spaces for reporting?
A. SAP HANA modeler perspective 
B. SAP HANA SQL editor 
C. SAP BusinessObjects Explorer
D. Information Design Tool 

Answer: C