Latest Certified Success Dumps Download

CISCO, MICROSOFT, COMPTIA, HP, IBM, ORACLE, VMWARE
C_HANAIMP151 Examination questions (September)

Achieve New Updated (September) SAP C_HANAIMP151 Examination Questions 11-20

September 25, 2015

Ensurepass

 

QUESTION 11

Which of the following are characteristics of an operational data mart based on SAP HANA?

 

A.

It is based on analytic denormalized data models

B.

It uses real-time replication of time-critical data

C.

It runs directly on top of the operational data

D.

It persists transformed data

 

Answer: BC

 

 

QUESTION 12

Which of the following can you use as a source for a graphical calculation view?

 

A.

Calculation view

B.

SQL view

C.

Decision table

D.

Table

E.

Procedure

 

Answer: ACD

 

 

QUESTION 13

You have a replicated an SAP ERP transaction table that contains a language field and a text table containing descriptions in various languages. You create an attribute view by

 

 

 

 

joining these two tables using a text join.

 

As which of the following join types does the text join act in this context?

 

A.

Referential join

B.

Inner join

C.

Left outer join

D.

Right outer join

 

Answer: C

 

 

QUESTION 14

Which security settings can you apply in analytic privileges?

 

A.

Grant access to analytic views.

B.

Restrict access within an analytic view using measure values.

C.

Restrict access within an analytic view using attribute values.

D.

Restrict access to hierarchies.

 

Answer: AC

 

 

QUESTION 15

In a fuzzy search, when would you perform a freestyle search?

 

A.

When you want to search with a low fuzziness threshold

B.

When you want to search in only one column

C.

When you want to search in multiple columns

D.

When you want to search with a high fuzziness threshold

 

Answer: C

 

 

QUESTION 16

You want to repeatedly load data from a flat file into SAP HANA with SAP Data Services. The target table is not available in SAP HANA and must be recreated with every scheduled

 

 

 

 

data load. The structure of the target table is identical to the structure of the source table.

 

Which of the following steps must you perform?

 

A.

Create a table in the SAP HANA studio.

B.

Map the source structure to the template table.

C.

Import metadata of the target table from the SAP HANA datastore.

D.

Drop a template table into the data flow.

E.

Enter the table name and schema name.

 

Answer: BDE

 

 

QUESTION 17

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 18

In SAP HANA, which join type yields the same results as a referential join when fields from both tables are selected?

 

A.

Left outer join

B.

Full outer join

C.

Inner join

D.

Temporal join

 

Answer: C

 

 

 

QUESTION 19

What is the advantage of reporting directly from column tables?

 

A.

It provides multi-language support

B.

It eliminates the need for additional modeling

C.

It shifts complex calculations and logic to SAP HANA

D.

It supports analytical privileges

 

Answer: B

 

 

QUESTION 20

Two attribute views in the same analytic view contain the same column name: the ID from the Customer attribute view and the ID from the Product attribute view. In the output, the system automatically renamed one column to ID_1. You want to indicate that ID_1 originated from the Product attribute view by renaming it to ID_PRODUCT.

 

Where in the attribute properties of ID_1 can you change this?

 

A.

In the alias label

B.

In the label

C.

In the alias name

D.

In the name

 

Answer: AC

Free VCE & PDF File for SAP C_HANAIMP151 Real Exam

Instant Access to Free VCE Files: CompTIA | VMware | SAP …
Instant Access to Free PDF Files: CompTIA | VMware | SAP …