SAP C_HANAIMP_17 Online Practice Questions and Exam Preparation

SAP C_HANAIMP_17 Online Questions & Answers

• Question 51:

  Why might you use the Keep Flag property in an aggregation node?

  A. To cache the results of the aggregation node for drill-down
  B. To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query
  C. To include columns that are NOT requested by a query but are essential for the correct result
  D. To retain the correct aggregation behavior in stacked views.
  C. To include columns that are NOT requested by a query but are essential for the correct result

• Question 52:

  Why does query performance decrease when the data volume of the delta storage is large?

  Note: There are 2 correct answers to this question.

  A. The data is unstructured.
  B. The data is uncompressed.
  C. The data is stored in the warm tier.
  D. The data is NOT sorted.
  B. The data is uncompressed.
  D. The data is NOT sorted.

• Question 53:

  Which type of join supports a temporal condition in a calculation view?

  A. Left outer join
  B. Text join
  C. Referential join
  D. Inner join
  D. Inner join

• Question 54:

  When using the CONTAINS predicate, what are the restrictions you must keep in mind? Note: There are 2 correct answers to this question.

  A. Non-physical columns, such as calculated columns, are not search-relevant.
  B. The NOT (-) operator can only be specified directly after the OR operator.
  C. Wild cards * and ? are supported for text columns but not string columns.
  D. If several tables are joined, all columns mentioned in the CONTAINS predicate must come from only one of the tables.
  A. Non-physical columns, such as calculated columns, are not search-relevant.
  C. Wild cards * and ? are supported for text columns but not string columns.

• Question 55:

  Your calculation view consumes one data source which includes the following columns :

  SALES_ORDER_ID, PRODUCT_ID, QUANTITY and PRICE.

  In the output, you want to see summarized data by PRODUCT_ID and a calculated column, PRODUCT_TOTAL, with the formula QUANTITY ?PRICE.

  In which type of node do you define the calculation to display the correct result?

  A. Union
  B. Join
  C. Projection
  D. Aggregation
  C. Projection

  ---

  Explanation/Reference:

• Question 56:

  In SAP Web IDE, you rename a dimension calculation view that is used by a cube calculation view. Afterward, you perform the following build operations:

  *Build the dimension calculation view as a single object.

  *Build the entire SAP HANA database module. What is the outcome of the build operations?

  A. The first build fails. The second build fails.
  B. The first build is successful. The second build is successful.
  C. The first build fails. The second build is successful.
  D. The first build is successful. The second build fails.
  B. The first build is successful. The second build is successful.

• Question 57:

  In a calculation view, what is the purpose of a variable?

  A. To break up complex SQL into smaller steps
  B. To pass values between procedures and calculation views
  C. To provide a run-time attribute filter based on a user input
  D. To provide a dynamic value in a calculated column
  A. To break up complex SQL into smaller steps
  C. To provide a run-time attribute filter based on a user input

• Question 58:

  Which of the following techniques can you use to improve the performance of calculation views?

  Note: There are 2 correct answers to this question.

  A. Limit the number of stacked calculation views
  B. Avoid aggregating data early in the dataflow
  C. Implement union pruning
  D. Partition large tables
  A. Limit the number of stacked calculation views
  D. Partition large tables

• Question 59:

  Which of the following allows data replication?

  A. SAP HANA smart data access
  B. SAP HANA streaming analytics
  C. SAP HANA smart data integration
  D. SAP HANA smart data quality
  C. SAP HANA smart data integration

• Question 60:

  What can you use SAP HANA smart data access for?

  Note: There are 2 correct answers to this question.

  A. To push down queries to data sources
  B. To expose data from remote tables
  C. To load and harmonize data from disparate sources
  D. To replicate remote data sources
  A. To push down queries to data sources
  B. To expose data from remote tables