SAP SAP Certifications C_HANATEC142 Questions & Answers

• Question 111:

  Which connectivity options can you use to create an SAP BusinessObjects universe on SAP HANA?

  There are 2 correct answers to this question.

  Choose:

  A. Relational connection using BICS

  B. Relational connection using JDBC

  C. Relational connection using MDX

  D. Relational connection using ODBC

  Correct Answer: B

• Question 112:

  Which of the following files should be considered in your SAP HANA backup strategy?

  There are 3 correct answers to this question.

  Choose:

  A. Export and import files

  B. Data and log files

  C. Dump files

  D. Kernel files

  E. Configuration files

  Correct Answer: BDE

• Question 113:

  A user cannot query an information model because of missing authorizations.

  How can the user find out which authorization is missing?

  Please choose the correct answer.

  A. Check the assigned roles in the user editor.

  B. Query the system view EFFECTIVE_PRIVILEGES.

  C. Use the authorization dependency viewer.

  D. Investigate the authorization trace.

  Correct Answer: C

• Question 114:

  An administrator should be enabled to cancel long running commands and end sessions.

  Which privilege must the user be granted?

  Please choose the correct answer.

  A. SESSION ADMIN

  B. USER ADMIN

  C. RESOURCE ADMIN

  D. MONITOR ADMIN

  Correct Answer: A

• Question 115:

  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?

  There are 3 correct answers to this question.

  Choose:

  A. Assign values to be restricted. Choose at least one information model to assign restrictions.

  B. Assign restricted values to the attribute view.

  C. Choose an attribute and define restricted values for it.

  D. Assign the analytic privilege to a user or role.

  E. Assign values to be restricted to a content table.

  Correct Answer: ACD

• Question 116:

  You are investigating a problem with the SAP HANA database.

  You opened a customer message with SAP support. SAP support asks you to provide diagnostic

  information from the SAP HANA instance.

  How can you gather this information?

  There are 2 correct answers to this question.

  A. Run the HDB info command on the SAP HANA server as adm

  B. Run the fullSystemInfoDump.py script on the SAP HANA server as adm

  C. Execute Diagnosis Files -> Diagnosis Information -> Collect function in the SAP HANA studio

  D. Select and download all files under Diagnosis Files in the SAP HANA studio

  Correct Answer: BC

• Question 117:

  Which of the following can you use to analyze an expensive SQL statement?

  There are 2 correct answers to this question.

  Choose:

  A. Open the Plan Explanation.

  B. Open the Plan Visualizer.

  C. Open the hdbcons tool.

  D. Open the SQL Plan Cache.

  Correct Answer: AB

• Question 118:

  A backup catalog became unusable.

  What can you do to recover existing backups?

  Please choose the correct answer.

  Choose one:

  A. Create a new data backup.

  B. In SAP HANA studio Backup Editor Display all backups select REFRESH

  C. Recreate the backup catalog based on the available backup files with the tool hdbbackupdiag.

  D. Use a third party backup tool to recover the backups.

  Correct Answer: C

• Question 119:

  You set up a data transfer architecture that replicates data to SAP HANA from an SAP source system

  using SAP Landscape Transformation (SLT).

  Which of the following SLT configuration parameter changes can improve the replication performance?

  There are 3 correct answers to this question.

  A. Set data class of tablespace

  B. Change initial load mode

  C. Select Allow Multiple Usage in Connection to Source System

  D. Increase the number of calculation jobs

  E. Increase the number of data transfer jobs

  Correct Answer: BDE

• Question 120:

  Which of the following users allow you to install SAP HANA studio on a Windows client platform?

  There are 2 correct answers to this question.

  Choose:

  A. Domain users with administrator privileges

  B. ADM users without administrator privileges

  C. Local users with administrator privileges

  D. Local users without administrator privileges

  Correct Answer: AC