QUESTION 11
You have a table of transactional data with different transaction types. You want to create an analytic view for only one of the transaction types.
How can you ensure that only rows with the required transaction type are displayed in the analytic view?
A. Create an input parameter
B. Create a filter on the table
C. Create a calculated column
D. Create a restricted column
Answer: B
QUESTION 12
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 a dynamic analytic privilege using the cost center and employee master data
B. Create an analytic privilege using the cost center and the salary measure
C. Create an object privilege on the cost center and employee master data schema
D. Create an analysis authorization using the cost center and employee master data
Answer: A
QUESTION 13
Which SAP HANA privileges are used for administration tasks such as creating schemas?
A. System privileges
B. Package privileges
C. Analytic privileges
D. Application privileges
Answer: A
QUESTION 14
You have created an input parameter in an information model. In which of the following can you use the input parameter?
A. The definition of an information space that reads from the information model
B. The creation of a BEx query reading from the information model
C. The creation of an SAP BusinessObjects Web Intelligence report directly on the information model
D. The definition of objects in an SAP BusinessObjects universe
Answer: D
QUESTION 15
A new user has implemented an SAP HANA data model.
Which technical user requires select rights on the new user’s schema?
A. _SYS_REPO
B. _SYS_BIC
C. _SYS_BI
D. _SYS_SECURITY
Answer: A
QUESTION 16
What do you have to define in an attribute view to reduce the initial amount of data selected from the data foundation tables?
A. A static filter value on any column in the data foundation tables
B. A column marked as “Hidden” in the output structure
C. A restricted column in the output structure
D. A dynamic filter value on a measure in the attribute view
Answer: A
QUESTION 17
In a left outer join, the left table has one record and the right table has three records. What is the maximum number of records that you expect in the join result?
A. 0
B. 1
C. 3
D. 4
Answer: C
QUESTION 18
What are the consequences of executing the stop activity on the Data Provisioning view in the SAP HANA studio for a table that is currently replicated?
A. Triggers and logging tables are deleted.
B. The table is dropped from the SAP HANA database.
C. Triggers and logging tables are kept.
D. The replication of the table is temporarily stopped.
Answer: A
QUESTION 19
You modified an active analytic view in the SAP HANA studio and saved it without activating it.
What is the consequence?
A. The inactive view is not available.
B. The inactive view is in “Read Only” mode.
C. The active view is not available.
D. The active view is in “Read Only” mode.
Answer: D
QUESTION 20
Table SALES_TABLE contains the columns COUNTRY and SALES. unction 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 = SELECT COUNTRY, CALL :calc_tax(SALES) AS TAX FROM :SALES_TABLE;
B. v_tax = SELECT COUNTRY, calc_tax(SALES) AS TAX FROM SALES_TABLE;
C. :v_tax = CE_PROJECTION(SALES_TABLE, [“COUNTRY”,”CALL :calc_tax(SALES)”]);
D. v_tax = CE_PROJECTION(SALES_TABLE, [“COUNTRY”,”calc_tax(SALES)”]);
Answer: B
If you want to pass the SAP C_HANAIMP131 exam sucessfully, recommend to read latest C_HANAIMP131 full version.