When loading data into SAP HANA, which of the following tasks can you perform using SAP Data Services?
Note: There are 2 correct answers to this question.
A. Data filtering
B. Real-time replication
C. Data transformations
D. Upload data via the SAP HANA studio
正解:A,C
質問 2:
A corporation with over 15.000 cost centers would like to ensure that only the person responsible for the cost center may view salary information for individuals assigned to their cost center.
How can the corporation achieve this in SAP HANA?
A. Create an analytic privilege using the cost center and the salary measure.
B. Create an object privilege on the cost center and employee master data schema.
C. Create an analysis authorization using the cost center and employee master data.
D. Create a dynamic analytic privilege using the cost center and employee master data.
正解:D
質問 3:
Which of the following are restrictions of the SAP HANA flat file upload?
Note: There are 2 correct answers to this question.
A. A new table always has a 1:1 mapping between the flat file columns and the table columns.
B. The upload does not allow changes to the column names of new tables.
C. A table must have the same column order as the flat file when you append data.
D. The upload prevents data type changes when appending data.
正解:A,D
質問 4:
You have 2 SAP HANA systems. You are working in 1 of these systems.
Which of the following do you use to read data from and write data to the other, remote SAP HANA system?
Note: There are 2 correct answers to this question.
A. Virtual column
B. SAP HANA smart data access
C. Virtual table
D. Remote providers
正解:B,C
質問 5:
Which information model can you use with measures from multiple fact tables?
A. Analytic privilege
B. Attribute view
C. Analytic view
D. Calculation view
正解:D
質問 6:
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 projection node of a calculation view.
Model the master data in the data foundation of an attribute view.
Combine them in the union node of the calculation view.
B. Model the transactional data in the projection node of a calculation view.
Model the master data in the data foundation of an attribute view.
Combine them in the join node of the calculation view.
C. 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 them in the logical join of the analytic view.
D. 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 them in the union node of the calculation view.
正解:C
質問 7:
You work with an information model on SAP HANA that contains sales data for all regions.
Which of the following modeling techniques can you use to define re-usable columns per region?
A. Input parameters
B. Constraint filters
C. Analytic privileges
D. Restricted columns
正解:D
質問 8:
Table SALES_TABLE contains the columns COUNTRY and SALES. Function calc_tax calculates sales tax based on input parameter SALES.
Using a scripted calculation view, how can you call the calc_tax function?
A. :v_tax = CE_PROJECTION(SALES_TABLE, ["COUNTRY","CALL :calc_tax(SALES)"]);
B. v_tax = SELECT COUNTRY, calc_tax(SALES) AS TAX FROM SALES_TABLE;
C. v_tax = CE_PROJECTION(SALES_TABLE, ["COUNTRY","calc_tax(SALES)"]);
D. :v_tax = SELECT COUNTRY, CALL :calc_tax(SALES) AS TAX FROM :SALES_TABLE;
正解:B
1038 お客様のコメント
クリック」






Gushiken -
理解しやすく簡単に書いてあって、本当にこのPass4Testの問題集ひとつのみで大丈夫でした。無事に受かりました。