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.