SAP C_HANAIMP131 exam Free Dumps Download (21-30)

QUESTION 21
In a graphical calculation view you specify the default client to be dynamic.
How is the client value determined when the view is used?

A.    By checking the session client of the user accessing the view
B.    By reading the client of the tables in the view
C.    By applying the filtering conditions on the client field
D.    By executing a procedure in the user’s own schema

Answer: A

QUESTION 22
Which of the following are characteristics of SAP NetWeaver Business Warehouse (SAP BW) when migrating it to run on SAP HANA? (Choose three)

A.    The sizing of your current SAP BW application servers remains valid.
B.    It allows co-deployment of the SAP BW application server on the SAP HANA database hardware.
C.    It allows re-use of your available SAP BW application servers.
D.    It eliminates the need to upgrade to the latest SAP BW application version.
E.    The system usage is the same as an equivalent SAP BW on non-SAP databases.

Answer: ACE

QUESTION 23
You have two analytic views. One contains actual data and the other one contains plan data. You want to combine the two result sets and keep actual and plan data on separate records.
In the SAP HANA studio, which of the following can you use to achieve this?

A.    JOIN in a calculation view
B.    JOIN in an analytic view
C.    UNION in a calculation view
D.    PROJECTION in a calculation view

Answer: C

QUESTION 24
In a calculation view you define a calculated column and set the Calculate Before Aggregation flag.
Which of the following activities is mandatory to activate the view?

A.    Set the column type to Attribute
B.    Add a new aggregation node
C.    Mark the column as hidden
D.    Select the aggregation type

Answer: D

QUESTION 25
Which of the following tools can you use to load data into SAP HANA from SAP DataSource extractors? (Choose two)

A.    SAP Data Services
B.    SAP Sybase Replication Server
C.    SAP Landscape Transformation Server
D.    SAP Direct Extractor Connection

Answer: AD

QUESTION 26
Two attribute views in the same analytic view contain the same column name (ID from attribute view Customer and ID from attribute view Product). In the output, the system automatically renamed one column to ID_1.
Which of the following can you do to indicate that ID_1 originated from attribute view Product?

A.    Update the alias in the properties of ID_1.
B.    Change the label of ID_1.
C.    Create a restricted column with a different name based on ID_1.
D.    Create a derived attribute view with an alias for ID_1.

Answer: A

QUESTION 27
When you try to delete an attribute view you receive the error message “One or more objects are dependent upon this object”.
Which of the following functions can you use to find out which objects depend on this view? (Choose two)

A.    History function
B.    Auto Documentation function
C.    Display XML function
D.    Where-Used function

Answer: BD

QUESTION 28
Your data models use hierarchies.
In which front end tool can you access these hierarchies? (Choose two)

A.    SAP BusinessObjects Dashboards
B.    SAP BusinessObjects Crystal Reports 2011
C.    SAP BusinessObjects Analysis, edition for OLAP
D.    SAP BusinessObjects Analysis, edition for Microsoft Office

Answer: CD

QUESTION 29
Which of the following is a best practice in calculation views?

A.    Apply a static filter on a projection node.
B.    Combine analytic views with a join node.
C.    Change an attribute to a measure.
D.    Push calculations down to the attribute views.

Answer: A

QUESTION 30
You want to use a UNION to combine two information objects in a calculation view.
Which steps do you have to perform? (Choose two)

A.    Define a constant column in the target.
B.    Sort the columns in the output structure.
C.    Connect the information objects to the UNION node.
D.    Define the mapping of columns of the information objects.

Answer: CD

If you want to pass the SAP C_HANAIMP131 exam sucessfully, recommend to read latest C_HANAIMP131 full version.

http://www.lead2pass.com/c-hanaimp131.htmll

Free 2014 SAP C_HANAIMP131 Exam Download With PDF & VCE (1-10)

QUESTION 1
How can you import information models into SAP HANA using the Quick Launch view?

A.    Select the Redeploy button
B.    Select Data Provisioning -> Load
C.    Select Import -> SAP HANA Content -> Import Data From Local File
D.    Select Import -> SAP HANA Content -> Delivery Unit

Answer: D

QUESTION 2
Which of the following describes an SAP HANA analytic view?

A.    It is a set of tables joined together in a star schema.
B.    It is a copy of data after transformation.
C.    It is a reusable object in attribute views.
D.    It is a materialized set of data.

Answer: A

QUESTION 3
Which of the following steps do you have to execute to import models from one SAP HANA system (system1) to another SAP HANA system (system2)? (Choose three)

A.    Create a delivery unit on system1
B.    Import the models into system2
C.    Create a schema on system2
D.    Create a delivery unit on system2
E.    Export the models from system1

Answer: ABE

QUESTION 4
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 5
You want to aggregate the grand total sales amount into one currency.
In which of the following cases would you perform the calculation before aggregation? (Choose two)

A.    When a line item table contains sales values of two different currencies.
B.    When an aggregate table by country contains sales values in one currency.
C.    When a line item table contains sales values in one currency.
D.    When an aggregate table by country contains sales values in three different currencies.

Answer: AD

QUESTION 6
What type of calculation would you create to ensure the fastest calculation performance?

A.    A report variable in an SAP BusinessObjects reporting client
B.    A calculated column in an SAP HANA information model
C.    An input parameter in an SAP HANA information model
D.    An calculated measure in an SAP BusinessObjects universe

Answer: B

QUESTION 7
Which of the following remote data sources can you access with SAP HANA smart data access? (Choose three)

A.    SAP NetWeaver Business Warehouse
B.    Microsoft SQL Server
C.    Apache Hadoop
D.    Teradata Database
E.    SAP Sybase Adaptive Service Enterprise

Answer: CDE

QUESTION 8
When you use SAP Landscape Transformation (SLT) replication, which of the following can you set up in the advanced replication settings? (Choose two)

A.    Change a character field length of a table.
B.    Change the target table for specific records of a table.
C.    Assign a specific mass transfer ID to a table.
D.    Add a field to a table.

Answer: AD

QUESTION 9
In an analytic view, you need two different logical joins from the data foundation to an attribute view. The analytic view already contains the attribute view but you have to use the attribute view again.
To which of the following do you connect the second join? (Choose two)

A.    To a shared attribute view
B.    To a derived attribute view
C.    To a new instance of the attribute view
D.    To a copy of the attribute view

Answer: BD

QUESTION 10
Which of the following are restrictions of the SAP HANA flat file upload? (Choose two)

A.    A table must have the same column order as the flat file when you append data.
B.    The upload does not allow to change the column names of new tables.
C.    A new table must have a 1:1 mapping between the flat file columns and the table columns.
D.    The upload prevents data type changes when appending data.

Answer: CD

f you want to pass the SAP C_HANAIMP131 exam sucessfully, recommend to read latest C_HANAIMP131 full version.

http://www.lead2pass.com/c-hanaimp131.htmll