SAP HANA: Certification Questions 431 through 440

QUESTION: 431

You want to design a model in SAP HANA. Which of the following modeling constructs do you use to create an analytic view?
Note: There are multiple correct answers to the question

A. Join types

B. Attribute views 

C. User privileges

D. Tables 
E. Analytic views 

Answer: A, B, D

QUESTION: 432

Which of the following are functions of the DB trigger within SAP Landscape Transformation (SLT)?
Note: There are multiple correct answers to the question

A. Ensure that replicated changes are kept within the logging tables

B. Record relevant changes in logging tables

C. Include only relevant tables for DB recording

D. De-cluster table classes into a transparent format

Answer: B, C

QUESTION: 433

You want to test the quality of SAP HANA data by using a set of results from the source system. How can you retrieve the required data from SAP HANA?
Note: There are multiple correct answers to the question

A. Use SAP Landscape Transformation (SLT)

B. Use the data preview in SAP HANA studio

C. Use an SAP BusinessObjects client tool (such as Explorer or Web Intelligence)

D. Use the database schema _SYS_REPO
E. Write and execute an appropriate SQL statement

Answer: B, C, E

QUESTION: 434

What are benefits of using a business layer on top of SAP HANA?
Note: There are multiple correct answers to the question

A. An extra layer of granular security 

B. Improved database calculation speed 

C. Fast throughput via BICS connectivity 

D. Users can use business names instead of technical names 

Answer: A, D

QUESTION: 435

You want to report on data from SAP HANA using MS Excel. How can you achieve this?

A. Select an analytic view using the Data Connection wizard

B. Create a ODBC connection between SAP HANA and MS Excel

C. Select an attribute view using the Data Connection wizard

D. Create an ODBO connection between SAP HANA and MS Excel

Answer: A, D

QUESTION: 436

You are building a calculation view and want to select data from an analytic view. How can you achieve better performance for this requirement?

A. Use CE functions

B. Use SQL statements

C. Use L programming

D. Use table indexing

Answer: A

QUESTION: 437

Which connectivity options can you use to create a SAP BusinessObjects universe on SAP HANA?
Note: There are multiple correct answers to the question

A. OLAP connection using MDX

B. Relational connection using BICS

C. Relational connection using ODBC

D. Relational connection using MDX

Answer: C, E

QUESTION: 438

Which statement best describes an analytic view as a multidimensional view?

A. Analytic views are composed of one data foundation and one or more attribute views

B. Analytic views are composed of at least one attribute view joined with more than one data foundation

C. Analytic views are composed of multiple joined data foundations

D. Analytic views are composed of at least one attribute view

Answer: A

QUESTION: 439

Which SAP BusinessObjects reporting tool should you use to answer ad-hoc questions and interact with shared information?

A. Crystal Reports

B. Dashboards 

C. Explorer 

D. WebIntelligence 

Answer: D

QUESTION: 440

Which of the following entities a role can be granted to?

A. An object

B. Another role

C. A user

D. A privilege

Answer: B, C