SAP C_HANAIMP151 Online Practice Questions and Exam Preparation

SAP C_HANAIMP151 Online Questions & Answers

• Question 91:

  You have an SAP HANA productive system with sensitive data.How can you restrict modeling users from viewing this data?

  A. Remove ALTER SYSTEM in the system privileges for the modeling users.
  B. Use randomized data for the development of data models.
  C. Allow modeling only on the SAP HANA development system and export/import the models to the productive system.
  D. Remove SAP_DATA_ADMIN in the SQL privileges for the modeling users.
  B. Use randomized data for the development of data models.
  C. Allow modeling only on the SAP HANA development system and export/import the models to the productive system.

• Question 92:

  In which engines is an analytic view executed that contains a calculated column?

  A. Calculation engine
  B. Row store engine
  C. OLAP engine
  D. Join engine
  A. Calculation engine
  C. OLAP engine

• Question 93:

  Prior to modeling in SAP HANA, you want to validate referential integrity between two very large tables in the SAP HANA database. Which SAP HANA tool would you use?

  A. Data preview
  B. View contents
  C. View log
  D. SQL console
  D. SQL console

• Question 94:

  Which technologies use trigger-based replication?

  A. ABAP extractors
  B. Test Data Migration Server (TDMS)
  C. Standard SQL database replication
  D. Near Zero Downtime
  B. Test Data Migration Server (TDMS)
  D. Near Zero Downtime

• Question 95:

  You are experiencing performance problems with SAP BusinessObjects reports based on SAP HANA data. Which of the following can you do to increase performance?

  A. Add only relevant data to the report queries.
  B. Avoid aggregation and work on raw data.
  C. Merge all relevant data into a consolidated report.
  D. Use drill-down or linked reports.
  A. Add only relevant data to the report queries.
  D. Use drill-down or linked reports.

• Question 96:

  Which connectivity combination between MS Excel and SAP HANA provides multidimensional reporting capabilities?

  A. ODBO connector via SQL requests to analytic or calculation views
  B. ODBC connector via MDX requests to analytic or calculation views
  C. ODBO connector via MDX requests to analytic or calculation views
  D. ODBO connector via MDX requests to column tables
  C. ODBO connector via MDX requests to analytic or calculation views

• Question 97:

  What do you have to define in an attribute view to reduce the initial amount of data selected from the data foundation tables?

  A. A static filter value on any column in the data foundation tables
  B. A column marked as "Hidden" in the output structure
  C. A restricted column in the output structure
  D. A dynamic filter value on a measure in the attribute view
  A. A static filter value on any column in the data foundation tables

• Question 98:

  How can you create a computed column in an information model?

  A. Create a calculated attribute within a calculation view.
  B. Create a counter in an analytic view.
  C. Create a restricted measure in a calculation view.
  D. Create a restricted measure in an analytic view.
  A. Create a calculated attribute within a calculation view.
  D. Create a restricted measure in an analytic view.

• Question 99:

  When you use SLT replication, which of the following determines the name of the SAP HANA schema where replicated data is stored?

  A. The name of the secondary database connection
  B. The name of the replication configuration
  C. The name of the source system schema
  D. The name of the RFC connection
  B. The name of the replication configuration

• Question 100:

  You have imported models from the development system. What is the recommended way toactivate 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.
  C. Use the Cascade Activate function.