SAP C_HANAIMP142 Online Practice Questions and Exam Preparation

SAP C_HANAIMP142 Online Questions & Answers

• Question 141:

  You have 2 SAP HANA systems. You are working in 1 of these systems.

  Which of the following do you use to read data from and write data to the other, remote SAP HANA system? (Choose two)

  A. SAP HANA smart data access
  B. Remote providers
  C. Virtual column
  D. Virtual table
  A. SAP HANA smart data access
  D. Virtual table

• Question 142:

  Where does SAP recommend you create calculated measures?

  A. In a column view
  B. In a business layer
  C. In an attribute view
  D. In an analytic view
  D. In an analytic view

• Question 143:

  Which feature is supported by the backup and recovery process within the standard delivery of SAP HANA?

  A. Incremental backup
  B. Information model recovery
  C. Point-in-time recovery
  D. Automatic backup of archiving log files scheduled within SAP HANA
  C. Point-in-time recovery

• Question 144:

  You want to create a sales analysis by combining your customer master data with your transactional sales data. How do you model your data to ensure best performance?

  A. Model the transactional data in the data foundation of an analytic view. Model the master data in the projection node of a calculation view. Combine them in the union node of the calculation view.
  B. Model the transactional data in the data foundation of an analytic view. Model the master data in the data foundation of an attribute view. Join them in the logical join of the analytic view.
  C. Model the transactional data in the projection node of a calculation view. Model the master data in the data foundation of an attribute view. Combine them in the join node of the calculation view.
  D. Model the transactional data in the projection node of a calculation view. Model the master data in the data foundation of an attribute view. Combine them in the union node of the calculation view.
  B. Model the transactional data in the data foundation of an analytic view. Model the master data in the data foundation of an attribute view. Join them in the logical join of the analytic view.

• Question 145:

  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 146:

  Which SAP HANA privileges are used for administration tasks, such as creating schemas?

  A. Analytic privileges
  B. Application privileges
  C. Package privileges
  D. System privileges
  D. System privileges

• Question 147:

  You want to load a large amount of source data (more than one billion rows) into SAP HANA for read-intensive information models.

  Which table type is recommended for this scenario?

  A. Global temporary table
  B. Decision table
  C. Row table
  D. Column table
  D. Column table

• Question 148:

  You create an analytic view and want to restrict access to departments with specific values using analytic privileges. Which tasks do you have to perform to accomplish this? (Choose three)

  A. Assign restricted values to the attribute view.
  B. Assign values to be restricted. Choose at least one information model to assign restrictions.
  C. Assign the analytic privilege to a user or role.
  D. Assign values to be restricted to a content table.
  E. Choose an attribute to define restricted values for it.
  B. Assign values to be restricted. Choose at least one information model to assign restrictions.
  C. Assign the analytic privilege to a user or role.
  E. Choose an attribute to define restricted values for it.

• Question 149:

  An analytic view has two columns, SHIP_TO_COUNTRY and SHIP_FROM_COUNTRY, that contain ISO country codes. You must replace these codes with the English country names by joining to the same country attribute view twice. What must you create to achieve this?

  A. A derived attribute view
  B. A shared attribute view
  C. Two data foundations
  D. An attribute view using the Copy From method.
  A. A derived attribute view

• Question 150:

  Which of the following can you check to investigate the query time in SAP HANA? (Choose three)

  A. The SQL plan cache
  B. The Central Management Console
  C. The expensive statements trace
  D. The statistics server warning for long running statements
  E. The System information tab of the Administration console
  A. The SQL plan cache
  C. The expensive statements trace
  D. The statistics server warning for long running statements