SAP C_HANAIMP_17 Online Practice Questions and Exam Preparation

SAP C_HANAIMP_17 Online Questions & Answers

• Question 1:

  What must you create to access a Predictive Analysis Library (PAL) procedure from inside your HDI container?

  A. Database connection
  B. Wrapper
  C. Function
  D. Synonym
  C. Function

• Question 2:

  You want to join 2 tables in a calculation view. Why do you use a non-equijoin?

  A. The number of joined columns is different in both tables.
  B. Join columns do not have the same datatype.
  C. The join condition is not represented by matching values.
  D. The cardinality is impossible to determine.
  C. The join condition is not represented by matching values.

• Question 3:

  When you create a full text index, why do you specify FAST_PREPROCESS OFF?

  A. To avoid the generation of the term document matrix
  B. To prevent the creation of a fuzzy search index
  C. To generate text analysis results in multiple languages
  D. To enable a full linguistic search
  D. To enable a full linguistic search

• Question 4:

  How can you optimize performance when writing SQL for use with calculation views?

  Note: There are 2 correct answers to this question.

  A. Use declarative language instead of cursors
  B. Use calculation engine (CE) functions instead of plain SQL
  C. Control the flow logic using IF-THEN-ELSE conditions
  D. Increase parallelization by using variables to break up statements
  A. Use declarative language instead of cursors
  D. Increase parallelization by using variables to break up statements

• Question 5:

  A calculation view consumes the data sources shown in the graphic. You want to identify which companies SQLd products in January 2018 AND February 2018. What is the optimal way to do this?

  

  A. Use a full outer join.
  B. Use a union node.
  C. Use an left outer join.
  D. Use an intersect node
  D. Use an intersect node

• Question 6:

  What can you extract using the standard text analysis configuration: Voice of the Customer? Note: There are 2 correct answers to this question.

  A. Recommendations
  B. Sentiments
  C. Suggestions
  D. Requests
  B. Sentiments
  D. Requests

• Question 7:

  You combine two customer master data tables with a union node in a calculation view. Both master data tables include the same customer name. The same customer can exist in both tables. How do you ensure that each customer appears only once in the results?

  A. Add a minus node above the union node.
  B. Add an intersect node above the union node.
  C. Include an aggregation node above the union node.
  D. In the union node, map both source customer name columns to one target column.
  C. Include an aggregation node above the union node.

• Question 8:

  Why do you create calculation views of data category DIMENSION with type TIME?

  A. To provide the time intervals required by time-dependent parent-child hierarchies.
  B. To store historical version of attributes.
  C. To add a temporal condition to a join to find matching records from two tables based on a date.
  D. To provide additional time-related navigation possibilities
  D. To provide additional time-related navigation possibilities

• Question 9:

  You have imported a new calculation view in a folder that contains a .hdinamespace file. This calculation view consumes one data source which is a table. When trying to build the calculation view, there is a namespace-related issue and the build fails.

  What could be the reason? Note: There are 2 correct answers.

  A. The imported calculation view and its data source have different namespaces.
  B. The name space used within the calculation view to reference the table is different from the actual namespace in the identifier of this table.
  C. The .hdinamespace file specifies a different name space property than the one in the identifier of the calculation view.
  D. The hdinamespace specifies "sub-folder": "append'', so calculation views can only be created in sub-folders.
  A. The imported calculation view and its data source have different namespaces.
  B. The name space used within the calculation view to reference the table is different from the actual namespace in the identifier of this table.

  ---

  Explanation/Reference:

• Question 10:

  Why do you use a hierarchy function node in a calculation view?

  A. To display value help using hierarchies
  B. To enable hierarchical navigation in reporting tools
  C. To generate additional Meta data that can be used for analysis of a hierarchy structure
  D. To assist the developer by visualizing hierarchies
  C. To generate additional Meta data that can be used for analysis of a hierarchy structure