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 131-140

September 25, 2015

Ensurepass

 

QUESTION 131

During loading of data into SAP HANA you want to filter the source data. Where can you apply the filters?

 

A.

In a query transformation in SAP BusinessObjects Data Services

B.

In a row generation transformation in SAP BusinessObjects Data Services

C.

In a SQL WHERE clause in SAP Landscape Transformation (SLT)

D.

In an ABAP code rule in SAP Landscape Transformation (SLT)

 

Answer: AD

 

 

QUESTION 132

You have a Web Intelligence report that requires data from SAP HANA filtered for a specific year. Where do you apply the filter for optimal performance?

 

A.

In the universe

B.

In the Web Intelligence report

C.

In the analytic view

D.

In the calculation view using an attribute value variable

 

Answer: C

 

 

QUESTION 133

Which view in SAP HANA studio do you use to add additional users?

 

 

 

 

 

A.

Properties View

B.

Quick launch View

C.

Console View

D.

Navigator View

 

Answer: D

 

 

QUESTION 134

Which of the following is used to make hierarchies available to reporting tools?

 

A.

CE Functions

B.

MDX

C.

SQLScript

D.

SQL

 

Answer: B

 

 

QUESTION 135

You want to create a custom attribute in addition to your data model. How can you achieve this?

 

A.

Create the attribute as a calculated attribute within the analytic view.

B.

Create the attribute and add it to the appropriate system table manually.

C.

Create the attribute as a calculated measure within the attribute view.

D.

Create the attribute as a restricted attribute within the calculation view.

 

Answer: A

 

 

QUESTION 136

What must you do to enable currency conversions with a fixed currency in an analytic view?

 

A.

Set the Enable for Conversion option

B.

Create a measure with the measure type Simple

 

 

 

 

C.

Base the target currency on a currency column

D.

Create the target currency using an input parameter

 

Answer: A

 

 

QUESTION 137

You want to create a sales analysis by combining your customer master data with your transactional sales data.

 

How do you model your data to ensure best performance?

 

A.

– Model the transactional data in the data foundation of an analytic view  Model the master data in the data foundation of an attribute view  Join both in the logical join of analytic view

B.

– Model the transactional data in the projection node of an calculation view  Model the master data in the data foundation of an attribute view  Combine both in the union node of the calculation view

C.

– Model the transactional data in the data foundation of an analytic view  Model the master data in the projection node of a calculation view  Combine both in the union node of the calculation view

D.

– Model the transactional data in the projection node of an calculation view  Model the master data in the datafoundation of an attribute view  Combine both in the join node of the calculation view

 

Answer: A

 

 

QUESTION 138

Which tasks do you have to perform if you want to use SAP BW with SAP HANA as the underlying database?

 

A.

Install SAP Business Warehouse Accelerator (BWA).

B.

Perform a database migration from your current DB to SAP HANA DB.

C.

Execute the report RS_BW_POST_MIGRATION.

D.

Upgrade to at least SAP NetWeaver Business Warehouse 7.30 SP5.

E.

Recreate SAP BW indexes after SAP HANA database migration.

 

Answer: BCD

 

 

 

QUESTION 139

Which connectivity combination between MS Excel and SAP HANA provides multidimensional reporting capabilities?

 

A.

ODBO connector via SQL requests to analytic or calculation views

B.

ODBC connector via MDX requests to analytic or calculation views

C.

ODBO connector via MDX requests to analytic or calculation views

D.

ODBO connector via MDX requests to column tables

 

Answer: C

 

 

QUESTION 140

You have an SAP HANA productive system with sensitive data.How can you restrict modeling users from viewing this data?

 

A.

Remove ALTER SYSTEM in the system privileges for the modeling users.

B.

Use randomized data for the development of data models.

C.

Allow modeling only on the SAP HANA development system and export/import the models to the productive system.

D.

Remove SAP_DATA_ADMIN in the SQL privileges for the modeling users.

 

Answer: BC

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 …