SAP C_HANAIMP142 Online Practice Questions and Exam Preparation

SAP C_HANAIMP142 Online Questions & Answers

• Question 121:

  In a reporting scenario you use an Opening Date attribute in the data foundation that contains information about your stores. You want to determine the number of years each store has been in business. How do you achieve this?

  A. Use calculated measures.
  B. Use time attributes.
  C. Use calculated attributes.
  D. Use private attributes.
  C. Use calculated attributes.

• Question 122:

  In which tool can you create information spaces for reporting?

  A. in the SAP HANA modeler perspective
  B. in the SAP HANA SQL editor
  C. in SAP BusinessObjects Explorer
  D. in the Information Design Tool
  C. in SAP BusinessObjects Explorer

• Question 123:

  Which of the following are functions of the DB trigger within SAP Landscape Transformation (SLT)? (Choose two)

  A. Ensure that replicated changes are kept within the logging tables.
  B. Record relevant changes in logging tables.
  C. Include only relevant tables for DB recording.
  D. Decluster table classes into a transparent format.
  B. Record relevant changes in logging tables.
  C. Include only relevant tables for DB recording.

• Question 124:

  You create a role with the following command: CREATE ROLE "InfoUser"

  When you try to assign this role to user PETER with the following command:

  GRANT InfoUser to PETER you receive an error message "Invalid user privilege:

  INFOUSER".

  What must you do to avoid this problem? (Choose three)

  A. Recreate the role with the command CREATE ROLE InfoUser.
  B. Recreate user PETER with GRANT OPTION.
  C. Grant the role the WITH ADMIN OPTION.
  D. Recreate the role with the command CREATE ROLE INFOUSER.
  E. Grant the role with the command GRANT "InfoUser" to PETER.
  A. Recreate the role with the command CREATE ROLE InfoUser.
  D. Recreate the role with the command CREATE ROLE INFOUSER.
  E. Grant the role with the command GRANT "InfoUser" to PETER.

• Question 125:

  What does the following SQL statement do? SELECT SCORE() as SCORE, PRODUCT_NAME, * FROM PRODUCT_ITEMS WHERE CONTAINS(*,'Paper', FUZZY(0.8)) ORDER BY PRODUCT_NAME

  A. It performs a fuzzy search on all columns in the PRODUCT_NAME table for the term 'Paper'.
  B. It performs a fuzzy search count on the number of columns in the PRODUCT_NAME table that contain the term 'Paper'.
  C. It performs a fuzzy search on the PRODUCT_NAME column in the PRODUCT_ITEMS table for the term 'Paper'.
  D. It performs a fuzzy search of all columns in the PRODUCT_ITEMS table for the term 'Paper'.
  D. It performs a fuzzy search of all columns in the PRODUCT_ITEMS table for the term 'Paper'.

• Question 126:

  You have created an analytic view and an analytic privilege that filters on 3 attributes:

  Sales region = "West"

  Sales channel = "Online", "Retail"

  Product category = "Electronics".

  After granting the analytic privilege to a user, what data can the user see?

  

  A. B. C. D.
  B

• Question 127:

  A calculation view that joins one fact table with dimension tables performs slowly. Which of the following can you do to improve performance?

  A. Turn the calculation view into an analytic view.
  B. Turn the calculation view into a simple calculation view.
  C. Load the calculation view into memory.
  D. Load the calculation view into the _SYS_BI schema.
  A. Turn the calculation view into an analytic view.

• Question 128:

  In an aggregation node of a calculation view, which is the default aggregation type for an aggregated measure?

  A. COUNT
  B. MAX
  C. SUM
  D. MIN
  C. SUM

• Question 129:

  Prior to modeling in SAP HANA, you want to validate referential integrity between two very large tables in the SAP HANA database. Which SAP HANA tool would you use?

  A. Data preview
  B. View contents
  C. View log
  D. SQL console
  D. SQL console

• Question 130:

  Which of the following are characteristics of a referential join? (Choose two)

  A. It requires referential integrity between right and left tables.
  B. If a field is selected from the right table, it acts similar to a left outer join.
  C. It assumes referential integrity between right and left tables.
  D. If a field is selected from the right table, it acts similar to an inner join.
  C. It assumes referential integrity between right and left tables.
  D. If a field is selected from the right table, it acts similar to an inner join.