Which of the following objects can you use when you build an analytic view?
Note: There are 3 correct answers to this question.
A. Hierarchies
B. Variables
C. Projections
D. Attribute Views
E. Analytic Views
正解:A,B,D
質問 2:
You want to run a report on data with multiple currencies. You want to allow end users to select the target currency at runtime.
Which options does SAP recommend for defining the currency conversion?
Note: There are 2 correct answers to this question.
A. A CE_CONVERSION function in a calculation view
B. Measures enabled for conversion in an analytic view
C. Currency conversion during data load
D. A calculated column in an analytic view
正解:A,B
質問 3:
Which CE function do you use to implement the following SQL statement?
SELECT DATE,SHOP_ID,PRODUCT_ID, QUANTITY * COST AS "PRICE" FROM SALES_DATA;
A. CE_CALC_VIEW
B. CE_AGGREGATION
C. CE_CONVERSION
D. CE_CALC
正解:D
質問 4:
Which of the following can be grouped inside a single schema in an SAP HANA database?
A. Information models
B. Users
C. Database tables
D. Packages
正解:C
質問 5:
You have been asked to create an SAP HANA attribute view using the tables Employee (left table) and Department (right table), shown in the attached diagram. Your view should contain the columns NAME and D_Name for all employees.
Which of the following join types do you use?
A. Inner join
B. Referential join
C. Text join
D. Left outer join
正解:D
質問 6:
An analytic view has a long runtime.
Which of the following can be a root cause for the bad performance?
Note: There are 2 correct answers to this question.
A. The Calculation Before Aggregation flag is set.
B. The analytic view uses generated columns.
C. The Execute In option is set to SQL Engine.
D. The analytic view uses calculated columns.
正解:A,D
鹫巣** -
なぜだかすごくわかりやすかった。C_HANAIMP141試験にも合格いたしました!SAPさん、今後もお世話になります。