SAP C_HANAIMP142 Online Practice Questions and Exam Preparation

SAP C_HANAIMP142 Online Questions & Answers

• Question 111:

  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
  B. Create a filter on the table

• Question 112:

  Which of the following must you avoid to ensure your calculation view uses only the calculation engine? (Choose three)

  A. Combining SQL and CE Functions
  B. Reading from tables in the column store
  C. Reading from tables using SELECT statements
  D. Joins using SQL
  E. DO WHILE loops
  A. Combining SQL and CE Functions
  C. Reading from tables using SELECT statements
  D. Joins using SQL

• Question 113:

  How can you define conditions and actions in a decision table? (Choose three)

  A. Use ABAP routines
  B. Use conditional expressions
  C. Use CE functions
  D. Use date operations
  E. Use mathematical operations
  B. Use conditional expressions
  D. Use date operations
  E. Use mathematical operations

• Question 114:

  Which of the following are functions of the controller in the SAP Landscape Transformation (SLT) server? (Choose two)

  A. Create repositories in the source system.
  B. Write data to the SAP HANA system using the DB connection.
  C. Map database structures between SAP HANA and the source system.
  D. Schedule replication processes.
  C. Map database structures between SAP HANA and the source system.
  D. Schedule replication processes.

• Question 115:

  When must you create a calculation view in SAP HANA?

  A. When you need to create a star schema
  B. When key figures span across tables
  C. When you need calculations before aggregations
  D. When you need analytic operations like aggregation
  B. When key figures span across tables

• Question 116:

  Your data models use hierarchies.

  In which of the following front end tools can you access these hierarchies? (Choose three)

  A. SAP Lumira
  B. SAP BusinessObjects Analysis, edition for Microsoft Office
  C. SAP BusinessObjects Dashboards
  D. SAP Crystal Reports 2011
  E. SAP BusinessObjects Analysis, edition for OLAP
  A. SAP Lumira
  B. SAP BusinessObjects Analysis, edition for Microsoft Office
  E. SAP BusinessObjects Analysis, edition for OLAP

• Question 117:

  Which of the following are characteristics of an operational data mart based on SAP HANA? (Choose two)

  A. It is based on analytic denormalized data models
  B. It uses real-time replication of time-critical data
  C. It runs directly on top of the operational data
  D. It persists transformed data
  B. It uses real-time replication of time-critical data
  C. It runs directly on top of the operational data

• Question 118:

  What is the advantage of reporting directly from column tables?

  A. It provides multi-language support
  B. It eliminates the need for additional modeling
  C. It shifts complex calculations and logic to SAP HANA
  D. It supports analytical privileges
  B. It eliminates the need for additional modeling

• Question 119:

  You want to create a custom attribute in addition to your data model. How can you achieve this?

  A. Create the attribute as a calculated attribute within the analytic view.
  B. Create the attribute and add it to the appropriate system table manually.
  C. Create the attribute as a calculated measure within the attribute view.
  D. Create the attribute as a restricted attribute within the calculation view.
  A. Create the attribute as a calculated attribute within the analytic view.

• Question 120:

  Which of the following properties of a derived attribute view can you modify?

  A. Description
  B. Description mapping
  C. Calculated attributes
  D. Filters
  A. Description