SAP C_HANAIMP142 Online Practice Questions and Exam Preparation

SAP C_HANAIMP142 Online Questions & Answers

• Question 151:

  Which of the following steps do you have to execute to import models from one SAP HANA system (system1) to another SAP HANA system (system2)? (Choose three)

  A. Export the models from system1.
  B. Create a delivery unit on system1.
  C. Create a delivery unit on system2.
  D. Import the models into system2.
  E. Create a schema on system2.
  A. Export the models from system1.
  B. Create a delivery unit on system1.
  D. Import the models into system2.

• Question 152:

  Which of the following nodes can you use when you create a calculation view with the SAP HANA studio graphical interface? (Choose two)

  A. Data Foundation
  B. Aggregation
  C. Join
  D. Analytic Privilege
  B. Aggregation
  C. Join

• Question 153:

  Which of the following is a best practice in calculation views?

  A. Change an attribute to a measure.
  B. Apply a static filter on a projection node.
  C. Push calculations down to the attribute views.
  D. Combine analytic views with a join node.
  B. Apply a static filter on a projection node.

• Question 154:

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

  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

• Question 155:

  Which of the following are mandatory to create a decision table? (Choose two)

  A. A condition
  B. An action
  C. A CE function
  D. A parameter
  A. A condition
  B. An action

• Question 156:

  You created a model on a table XYZ.PRODUCTS. You successfully activated the model. When you run the data preview you receive an error message "Insufficient privilege. Not authorized". Which of the following 4 statements do you execute to resolve the error before you reactivate the model?

  A. GRANT SELECT on SCHEMA XYZ to _SYS_REPO
  B. GRANT SELECT on PRODUCTS to _SYS_REPO WITH GRANT OPTION
  C. GRANT SELECT on SCHEMA XYZ to _SYS_BIC WITH GRANT OPTION
  D. GRANT SELECT on PRODUCTS to _SYS_BIC
  B. GRANT SELECT on PRODUCTS to _SYS_REPO WITH GRANT OPTION

• Question 157:

  Which new connection type is available as of SAP BusinessObjects Data Services 4.0?

  A. Operational Data Provider
  B. BAPI function calls
  C. IDOCs
  D. Read table via ABAP data flows
  A. Operational Data Provider

• Question 158:

  You receive an activation error in a scripted calculation view that uses the following function:

  CE_PROJECTION(:table1, ["AMOUNT"], '"PROD" = A')

  What could be a reason for this error?

  A. The filter condition is not set within square brackets.
  B. The projection list contains a field that is not specified in the filter condition.
  C. The filter condition must be specified inside the projection list.
  D. The filter condition contains a field that is not part of the projection list.
  D. The filter condition contains a field that is not part of the projection list.

• Question 159:

  How can you assess the quality of the loaded data in SAP HANA? (Choose two)

  A. Configure the SAP Landscape Transformation tool to implement the data quality process.
  B. Compare data from reports in SAP BusinessObjects against the SAP HANA _SYS_STATISTICS table.
  C. Perform master data quality checks in SAP ERP prior to replication in SAP HANA.
  D. Compare reports in SAP BusinessObjects against source data for specific selections.
  C. Perform master data quality checks in SAP ERP prior to replication in SAP HANA.
  D. Compare reports in SAP BusinessObjects against source data for specific selections.

• Question 160:

  A customer wants to reproduce the following SQL statement in SAP HANA:

  SELECT P.PROD_NAME, P.PROD_ID, PT.PROD_DESC

  FROM PRODUCTS P,

  PROD_TEXTS PT

  WHERE P.PROD_ID=PT.PROD_ID;

  Which of the following SQLScript constructs is equivalent to this SQL statement and yields the best performance?

  A. ot_products= CE_COLUMN_TABLE(PRODUCTS); ot_prodtexts= CE_COLUMN_TABLE(PROD_TEXTS); ot_all=CE_JOIN(:ot_products, :ot_prodtexts, [PROD_ID]); output=CE_PROJECTION(:ot_all, [PROD_NAME, PROD_ID, PROD_DESC]);
  B. SELECT P.PROD_NAME, P.PROD_ID, NULL as PROD_DESC FROM PRODUCTS P UNION SELECT NULL as PROD_NAME, PT.PROD_ID, PT.PROD_TEXTS FROM PROD_TEXTS PT;
  C. SELECT P.PROD_NAME, P.PROD_ID, PT.PROD_DESC FROM PRODUCTS P JOIN PROD_TEXTS PT ON P.PROD_ID=PT.PROD_ID;
  D. ot_products= CE_COLUMN_TABLE(PRODUCTS); ot_prodtexts= CE_COLUMN_TABLE(PROD_TEXTS); ot_all=CE_UNION_ALL(:ot_products, :ot_prodtexts); output=CE_PROJECTION(:ot_all, [PROD_NAME, PROD_ID, PROD_DESC]);
  A. ot_products= CE_COLUMN_TABLE(PRODUCTS); ot_prodtexts= CE_COLUMN_TABLE(PROD_TEXTS); ot_all=CE_JOIN(:ot_products, :ot_prodtexts, [PROD_ID]); output=CE_PROJECTION(:ot_all, [PROD_NAME, PROD_ID, PROD_DESC]);