C-HANAIMP141 試験問題を無料オンラインアクセス

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 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.
• B.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.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.
• D.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.

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 analysis authorization using the cost center and employee master data.
• C.Create an analytic privilege using the cost center and the salary measure.
• D.Create an object privilege on the cost center and employee master data schema.

Which of the following criteria indicate that you should store data in row tables?
Note: There are 2 correct answers to this question.

• A.The information models search the table based on the values of a few columns.
• B.The tables require frequent write access.
• C.The tables have a large number of columns
• D.The information models frequently need to access all columns.

How can you analyze a performance issue in the execution of an SQL statement using the SQL Console?
Note: There are 2 correct answers to this question.

• A.Use the Explain Plan command from the right-click menu in the SQL Console.
• B.Use the Prepare Statement command from the right-click menu in the SQL Console.
• C.Query the table "SYS"."CACHE_P_QUERIES_"' after the execution of the SQL statement.
• D.Use EXPLAIN PLAN in the SQL statement and query the EXPLAIN_PLAN_TABLE.

Which of the following would you create to ensure the fastest calculation performance?

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