SAP C_HANAIMP151 Online Practice Questions and Exam Preparation

SAP C_HANAIMP151 Online Questions & Answers

• Question 111:

  With which of the following do you build the vocabulary of a decision table?

  A. Actions
  B. Attributes
  C. Conditions
  D. Measures
  B. Attributes

• Question 112:

  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 113:

  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 114:

  An SAP BusinessObjects Web Intelligence report throws an SQL error during query execution. Which of the following could you check to resolve the error?

  A. The business layer
  B. The business view
  C. The Web Intelligence report variables
  D. The SAP HANA information model
  A. The business layer
  D. The SAP HANA information model

• Question 115:

  When you create a report in SAP BusinessObjects you notice that some columns of your SAP HANA information model are not available in the report. How can you make the columns available?

  A. Add the columns in SAP Landscape Transformation replication.
  B. Add the columns to the query panel of the report.
  C. Add the columns to the source table in the catalog node in SAP HANA studio.
  D. Add the columns to the business layer.
  B. Add the columns to the query panel of the report.
  D. Add the columns to the business layer.

• Question 116:

  You create an analytic view and want to restrict access to departments with specific values using analytic privileges. Which tasks do you have to perform to accomplish this?

  A. Assign restricted values to the attribute view.
  B. Assign values to be restricted. Choose at least one information model to assign restrictions.
  C. Assign the analytic privilege to a user or role.
  D. Assign values to be restricted to a content table.
  E. Choose an attribute to define restricted values for it.
  B. Assign values to be restricted. Choose at least one information model to assign restrictions.
  C. Assign the analytic privilege to a user or role.
  E. Choose an attribute to define restricted values for it.

• Question 117:

  Which of the following steps is required for configuring SAP Landscape Transformation (SLT)?

  A. Define the number of background work processes in SLT.
  B. Define an RFC connection from SLT to SAP HANA.
  C. Define a DB connection from SLT to the source system.
  D. Define the number of jobs to be used for data replication.
  D. Define the number of jobs to be used for data replication.

• Question 118:

  Which of the following can you set up to enable the extraction of data from SAP Business Warehouse (BW) into SAP HANA?

  A. SAP System Landscape Directory (SLD)
  B. SAP BusinessObjects Data Services
  C. SAP Landscape Transformation (SLT)
  D. Open hub
  E. SAP HANA Direct Extractor Connection (DXC)
  B. SAP BusinessObjects Data Services
  D. Open hub
  E. SAP HANA Direct Extractor Connection (DXC)

• Question 119:

  In an analytic view, you need two different logical joins from the data foundation to an attribute view. The analytic view already contains the attribute view but you have to use the attribute view again. To which of the following do you connect the second join?

  A. To a shared attribute view
  B. To a derived attribute view
  C. To a new instance of the attribute view
  D. To a copy of the attribute view
  B. To a derived attribute view
  D. To a copy of the attribute view

• Question 120:

  Which SAP BusinessObjects tools require an SAP BusinessObjects semantic layer (universe) to access data in SAP HANA?

  A. Crystal Reports 2011
  B. Crystal Reports for Enterprise
  C. Dashboards
  D. Analysis Office v1.1
  E. WebIntelligence
  B. Crystal Reports for Enterprise
  C. Dashboards
  E. WebIntelligence