SAP C_HANATEC142 Online Practice Questions and Exam Preparation

SAP C_HANATEC142 Online Questions & Answers

• Question 51:

  In the SAP HANA studio, in which tab can you find information about the performance of queries? Please choose the correct answer.

  A. Alerts
  B. Diagnosis Files
  C. System Information
  D. Trace Configuration
  B. Diagnosis Files

• Question 52:

  In an analytic view, you want to restrict the access for users according to their geographical reporting region.

  What do you have to do to achieve this?

  There are 3 correct answers to this question.

  Choose:

  A. Create an analytic privilege
  B. Select an attribute and define restricted values for it
  C. Assign a package privilege to the users
  D. Create a filter on an attribute
  E. Assign the analytic privilege to the users
  A. Create an analytic privilege
  B. Select an attribute and define restricted values for it
  E. Assign the analytic privilege to the users

• Question 53:

  Which component of SAP HANA Database is used when you query an SAP HANA information model to populate a pivot table in Microsoft Excel? Please choose the correct answer.

  A. The Log Volumes
  B. The Calculation Engine
  C. The Transaction Manager
  D. The SQL Interface
  B. The Calculation Engine

• Question 54:

  Of the databases that can be used for Data Services 4.0, which of the following is bundled with Information Platform Services (mini-BOE)?

  Please choose the correct answer.

  Choose one:

  A. SAP MaxDB
  B. MySQL
  C. SYBASE Adaptive Server Enterprise
  D. MS SQL Server Express
  D. MS SQL Server Express

• Question 55:

  What is the maximum number of master name servers that you can define in a distributed landscape?

  Please choose the correct answer.

  Choose one:

  A. 2
  B. 3
  C. 8
  D. 1
  B. 3

• Question 56:

  A user is locked due to too many failed logon attempts.

  Which SQL command can solve this problem?

  Please choose the correct answer.

  Choose one:

  A. ALTER USER FORCE PASSWORD CHANGE AFTER ATTEMPTS
  B. ALTER USER RESET CONNECT ATTEMPTS
  C. ALTER USER DROP CONNECT ATTEMPTS
  D. ALTER USER ACCOUNT UNLOCK
  B. ALTER USER RESET CONNECT ATTEMPTS

• Question 57:

  What is the purpose of the save point process in SAP HANA?

  Please choose the correct answer.

  Choose one:

  A. Save changed data and logs to persistent storage on a regular basis.
  B. Free up memory by saving less frequently used data to persistent storage.
  C. Save changed data to persistent storage when a transaction is committed.
  D. Save logs to persistent storage when a transaction is committed.
  A. Save changed data and logs to persistent storage on a regular basis.

• Question 58:

  Which of the following requires a dedicated network interface to SAP HANA? Please choose the correct answer.

  A. SAP HANA studio
  B. SAP LT
  C. Backup destination
  D. SAP BusinessObjects Business Intelligence platform
  B. SAP LT

• Question 59:

  Which technologies use trigger-based replication? There are 2 correct answers to this question.

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

• Question 60:

  You are replicating data in real-time from a source system to SAP HANA using System Landscape Transformation (SLT). The source system had to be restored using a point-in- time recovery to an earlier point in time. The systems are now

  out of sync.

  How can you synchronize the systems again?

  Please choose the correct answer.

  A. Select "Suspend" and "Resume" in the Data Provisioning dialog
  B. Run the hdbnsutil program on the command line
  C. Restart the master job using transaction LTR in the SLT system
  D. Select "Stop Replication" and "Replicate" in the Data Provisioning dialog
  D. Select "Stop Replication" and "Replicate" in the Data Provisioning dialog