SAP SAP Application Associate C_HANAIMP_1 Questions & Answers

• Question 1:

  Which SAP HANA model is recommended for reporting purposes where read operations on mass data are required?

  A. Analytic view

  B. Calculation view using SQL

  C. Calculation view using SQL Script

  D. Attribute view

  Correct Answer: A

• Question 2:

  Which SAP BusinessObjects reporting tool should you use to answer ad-hoc questions and interact with shared information?

  A. Crystal Reports

  B. Dashboards

  C. Explorer

  D. WebIntelligence

  Correct Answer: D

• Question 3:

  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.

  Correct Answer: CD

• Question 4:

  You have imported models from the development system. What is the recommended way to activate dependent models in SAP HANA?

  A. Use the Activate with History function.

  B. Use the Where-Used List function.

  C. Use the Cascade Activate function.

  D. Activate each view manually.

  Correct Answer: C

• Question 5:

  When you activate an analytic view, a column view is created. In which schema is this column view stored?

  A. _SYS_BIC

  B. _SYS_BI

  C. _SYS_REPO

  D. _SYS

  Correct Answer: A

• Question 6:

  What can be used as a source for the data foundation of an analytic view? (Choose two)

  A. A table that contains surrogate IDs referring to primary keys in the attribute views

  B. A table that contains foreign keys referring to primary keys in the attribute views

  C. A table that contains business facts or measures

  D. A table that contains only descriptive attributes

  Correct Answer: BC

• Question 7:

  If you want to create or drop tables in a schema, which privilege type do you need?

  A. SYSTEM

  B. ANALYTIC

  C. PACKAGE

  D. SQL

  Correct Answer: D

• Question 8:

  You want to broadcast reports that use data from SAP HANA.Which SAP BusinessObjects tool do you use?

  A. Analysis, edition for OLAP

  B. Dashboards

  C. Crystal Reports

  D. Explorer

  Correct Answer: C

• Question 9:

  Which security settings can you apply in analytic privileges? (Choose two)

  A. Grant access to analytic views.

  B. Restrict access within an analytic view using measure values.

  C. Restrict access within an analytic view using attribute values.

  D. Restrict access to hierarchies.

  Correct Answer: AC

• Question 10:

  You need to retrieve data from SAP HANA that is restricted to a certain region and specific users. How can you implement this security strategy?

  A. By assigning SQL privileges to the necessary users

  B. By assigning Analytic privileges to the necessary users

  C. By assigning System privileges to the necessary users

  D. By assigning Package privileges to the necessary users

  Correct Answer: B