SAP HANA: Certification Questions 371 through 380

QUESTION: 371

Your customer requires real-time replication. Where do you select the tables to be replicated to SAP HANA?

A. In transaction LTR in SAP Landscape Transformation (SLT) 

B. In the Import dialog of the Quick Launch of SAP HANA studio

C. In transaction SAP ERP Tables and Indexes Monitor (DB02)

D. In the Data Provisioning dialog of SAP HANA studio

Answer: D

QUESTION: 372

Which of the following can you use as a source for a graphical calculation view?
Note: There are multiple correct answers to the question

A. Calculation view

B. SQL view

C. Table

D. Decision table
E. Procedure 

Answer: A, C, D

QUESTION: 373

Which of the following can you check to investigate the query time in SAP HANA?
Note: There are multiple correct answers to the question

A. The SQL plan cache

B. The Central Management Console

C. The expensive statements trace

D. The statistics server warning for long running statements
E. The System information tab of the Administration console

Answer: A, C, D

QUESTION: 374

You create a role with the following command: CREATE ROLE "InfoUser". When you try to assign this role to user PETER with the following command:
GRANT InfoUser to PETER you receive an error message "Invalid user privilege: INFOUSER". 
What must you do to avoid this problem?
Note: There are multiple correct answers to the question

A. Recreate the role with the command CREATE ROLE InfoUser

B. Recreate user PETER with GRANT OPTION

C. Grant the role the WITH ADMIN OPTION

D. Recreate the role with the command CREATE ROLE INFOUSER
E. Grant the role with the command GRANT "InfoUser" to PETER

Answer: A, D,E

QUESTION: 375

Which of the following does an SAP BusinessObjects universe use to communicate with SAP HANA?

A. ABAP 

B. SQL

C. MDX

D. BICS

Answer: B

QUESTION: 376

Which of the following must you do in order to use SAP BusinessObjects Explorer on SAP HANA data?
Note: There are multiple correct answers to the question

A. Create a delivery unit

B. Create a business layer

C. Create an information model

D. Create an information space

Answer: C, D

QUESTION: 377

Where is the physical data stored, on which a calculation view is based?

A. In the _SYS_BI schema

B. In a schema

C. In the _SYS_BIC schema

D. In a package

Answer: B

QUESTION: 378

Which of the following automatically aggregates data?
Note: There are multiple correct answers to the question

A. Analytic view

B. Calculation view

C. Column table

D. Attribute view

Answer: A, B

QUESTION: 379

Which privilege type do you have to assign to a role, when you want to provide row-level access to data?

A. ANALYTIC 

B. PACKAGE

C. SYSTEM

D. SQL

Answer: A

QUESTION: 380

Using SAP BusinessObjects Data Services, in which of the following can you perform data transformations?
Note: There are multiple correct answers to the question

A. Query 

B. DataStore

C. XML File

D. Script

Answer: A, D