[2016-New] Free Lead2pass SAP C_HANAIMP151 Exam Questions Download (131-140)

2016 August SAP Official New Released C_HANAIMP151 Q&As in Lead2pass.com!

100% Free Download! 100% Pass Guaranteed!

Since I recently passed the the SAP C_HANAIMP151 exam, it’s time for me to share the Lead2pass exam dumps I used when preparing for this exam.

Following questions and answers are all new published by SAP Official Exam Center: http://www.lead2pass.com/c-hanaimp151.html

QUESTION 131
You want to restrict access to SAP HANA information models based on user groups.
The models are accessed through an SAP BusinessObjects report.
In which of the following can you implement these restrictions?

A.    The schema mapping
B.    The restricted measures
C.    The analytic privileges
D.    The universe

Answer: CD

QUESTION 132
You need to run a Web Intelligence report that requires data from SAP HANA filtered for a specific year based on ad hoc user input.
For best performance, how would you achieve this?

A.    Use a pre-defined prompt based on a self-join in the business layer.
B.    Use input from a Web Intelligence report passed to a variable in an information model.
C.    Use a dynamic transformation rule during data provisioning.
D.    Use a prompt in the query of the Web Intelligence report.

Answer: B

QUESTION 133
You want to retrieve data from SAP HANA and restrict access to certain data columns for specific user groups. Where can you implement this?

A.    In the analytic privileges
B.    In the data foundation
C.    In the business layer
D.    In the SQL privileges

Answer: C

QUESTION 134
In which View, client queries can be less optimized and could significantly be slower compare to other models

A.    Analytic
B.    Attribute
C.    Calculation (SQL)
D.    Calculation (CE Functions)

Answer: C

QUESTION 135
How can you improve the performance of an information model?

A.    Use generated columns.
B.    Use analytic views wherever possible.
C.    Use indexes on all measures.
D.    Use attribute views wherever possible.
E.    Use constraint filters.

Answer: ABE

QUESTION 136
You want to design a model in SAP HANA. Which of the following modeling constructs do you use to create an analytic view?

A.    Join types
B.    Attribute views
C.    User privileges
D.    Tables
E.    Analytic views

Answer: ABD

QUESTION 137
For which SAP HANA data types is a FULLTEXT index created automatically during table creation?

A.    TEXT
B.    SHORTTEXT
C.    VARCHAR
D.    NCLOB

Answer: AB

QUESTION 138
You want to broadcast reports that use data from SAP HANA. Which SAP BusinessObjects tool do you use?

A.    Analysis, edition for OLAP
B.    Dashboards
C.    Crystal Reports
D.    Explorer

Answer: C

QUESTION 139
Which CE function do you use to implement an inner join between two tables on a list of join attributes?

A.    CE_COLUMN_TABLE
B.    CE_JOIN_VIEW
C.    CE_OLAP_VIEW
D.    CE_JOIN

Answer: D

QUESTION 140
You want to add a column to a calculation view that displays the year-to-date revenue of the current fiscal year.
How can you achieve this?

A.    Use a calculated attribute.
B.    Use a calculated measure.
C.    Use a variable.
D.    Use a CE function.

Answer: BD

I hope Lead2pass exam questions from the SAP C_HANAIMP151 exam helps you pass the exam and earn your SAP certification! Happy Studying!

2016 SAP C_HANAIMP151 exam dumps (All 308 Q&As) from Lead2pass:

http://www.lead2pass.com/c-hanaimp151.html [100% Exam Pass Guaranteed]