SAP C_HANAIMP151 Online Practice Questions and Exam Preparation

SAP C_HANAIMP151 Online Questions & Answers

• Question 81:

  When you activate a procedure, in which schema is the procedure stored?

  A. SYSTEM
  B. _SYS_BIC
  C. SYS_REPL
  D. _SYS_BI
  B. _SYS_BIC

• Question 82:

  Which of the following must you avoid to ensure your calculation view uses only the calculation engine?

  A. Combining SQL and CE Functions
  B. Reading from tables in the column store
  C. Reading from tables using SELECT statements
  D. Joins using SQL
  E. DO WHILE loops
  A. Combining SQL and CE Functions
  C. Reading from tables using SELECT statements
  D. Joins using SQL

• Question 83:

  What are characteristics of a constraint filter?

  A. It is defined during the design time on a table.
  B. It is applied on a table before the query execution.
  C. It is applied on the result set of an SQL query.
  D. It is defined during the runtime in the SQL query.
  A. It is defined during the design time on a table.
  B. It is applied on a table before the query execution.

• Question 84:

  When loading data into SAP HANA, which of the following tasks can you perform using SAP Data Services?

  A. Upload data via the SAP HANA studio
  B. Data filtering
  C. Real-time replication
  D. Data transformations
  B. Data filtering
  D. Data transformations

• Question 85:

  In SAP ERP there are more than 50,000 application tables. How do you determine the relevant SAP ERP tables to replicate in SAP HANA and their dependencies?

  A. Use SAP ERP Data Modeler (transaction SD11).
  B. Use SAP ERP ABAP Dictionary Maintenance (transaction SE11).
  C. Use the SAP ERP Tables and Indexes Monitor(transaction DB02).
  D. Use SAP ERP Data Browser (transaction SE16).
  A. Use SAP ERP Data Modeler (transaction SD11).

• Question 86:

  What are advantages of implementing SAP HANA using an SAP rapid-deployment solution over a traditional implementation project?

  A. Fixed-scope implementation
  B. No need for consultants
  C. Lower risk
  D. Pre-configured content
  E. Customized content
  A. Fixed-scope implementation
  C. Lower risk
  D. Pre-configured content

• Question 87:

  Which of the following are direct outputs of an analytic view?

  A. Hierarchies
  B. Private attributes
  C. Restricted attributes
  D. Measures
  E. Attribute views
  B. Private attributes
  D. Measures
  E. Attribute views

• Question 88:

  Your data models use hierarchies.

  In which front end tool can you access these hierarchies?

  A. SAP BusinessObjects Dashboards
  B. SAP BusinessObjects Crystal Reports 2011
  C. SAP BusinessObjects Analysis, edition for OLAP
  D. SAP BusinessObjects Analysis, edition for Microsoft Office
  C. SAP BusinessObjects Analysis, edition for OLAP
  D. SAP BusinessObjects Analysis, edition for Microsoft Office

• Question 89:

  Which of the following are restrictions of the SAP HANA flat file upload?

  A. A table must have the same column order as the flat file when you append data.
  B. The upload does not allow to change the column names of new tables.
  C. A new table must have a 1:1 mapping between the flat file columns and the table columns.
  D. The upload prevents data type changes when appending data.
  C. A new table must have a 1:1 mapping between the flat file columns and the table columns.
  D. The upload prevents data type changes when appending data.

• Question 90:

  What is the behavior of a Text Table Join where language column SPRAS is available?

  A. Left Outer Join
  B. Right Outer Join
  C. Inner Join
  D. Referential Join
  A. Left Outer Join