SAP C_HANATEC_14 Online Practice Questions and Exam Preparation

SAP C_HANATEC_14 Online Questions & Answers

• Question 101:

  For which communication channel do you need to set up encryption manually? Please choose the correct answer. Response:

  A. Between SAP HANA systems in system replication scenarios
  B. Between hosts in an SAP HANA scale-out system
  C. Between the SAP HANA server and clients
  D. Between databases in an SAP HANA multitenant database container system
  C. Between the SAP HANA server and clients

• Question 102:

  What are the prerequisites for querying the system view EFFECTIVE_PRIVILEGES to get data about other users and roles granted privileges?

  There are 2 correct answers to this question.

  Response:

  A. CATALOG READ
  B. DATA ADMIN
  C. MONITOR ADMIN
  D. USER ADMIN
  A. CATALOG READ
  B. DATA ADMIN

• Question 103:

  Where is SDI used?

  There are 2 correct answers to this question.

  Response:

  A. Data cleansing
  B. Data transformation
  C. Data streaming
  D. For data loading
  B. Data transformation
  D. For data loading

• Question 104:

  What are advantages of column store tables? There are 3 correct answers to this question. Response:

  A. Data footprint is automatically reduced through compression
  B. Only the columns required are actually loaded to memory
  C. Columns can be partitioned
  D. They are optimized for high-volume read / write transactional processing
  A. Data footprint is automatically reduced through compression
  B. Only the columns required are actually loaded to memory
  C. Columns can be partitioned

• Question 105:

  You implement a multi-host SAP HANA system with auto-failover capabilities. What are the requirements for the disk storage?

  There are 2 correct answers to this question.

  Response:

  A. The slave node is set to backup standby.
  B. The failed worker host gets fenced during failover.
  C. The standby host has file access.
  D. The master node is fully clustered.
  B. The failed worker host gets fenced during failover.
  C. The standby host has file access.

• Question 106:

  A technical user is required when you register an SAP HANA system as a resource in SAP HANA cockpit 2.0. Which system or object privilege do you assign to the technical user account on the target system?

  Please choose the correct answer.

  Response:

  A. SELECT on _SYS_TASK
  B. SELECT on _SYS_REPO
  C. CATALOG READ
  D. USER ADMIN
  C. CATALOG READ

• Question 107:

  Which are tuning methods for the database migration, using DMO of SUM?

  There are 3 correct answers to this question.

  Response:

  A. Adapt the number of parallel R3load processes
  B. Using the Near Zero Downtime Maintenance capabilities of SUM (NZDM)
  C. Using the table migration duration files from a previous run
  D. Performing a benchmark using the benchmarking options of SUM
  A. Adapt the number of parallel R3load processes
  C. Using the table migration duration files from a previous run
  D. Performing a benchmark using the benchmarking options of SUM

• Question 108:

  You must design a high-availability SAP HANA database system with 8 hosts (6 worker and 2 standby) that also uses multitenant database containers.

  Which rules apply?

  There are 2 correct answers to this question.

  Response:

  A. The system database must run on the standby host.
  B. The system database instance must run on all hosts (worker and standby).
  C. The tenant databases must be able to be scaled out to all hosts (worker and standby).
  D. The tenant databases must run on the worker hosts.
  B. The system database instance must run on all hosts (worker and standby).
  D. The tenant databases must run on the worker hosts.

• Question 109:

  Which of the following configuration files are created if customer-specific changes are made after or during installation of SAP HANA database?

  There are 3 correct answers to this question.

  Response:

  A. sapprofile.ini
  B. hanaconfig.ini
  C. daemon.ini
  D. nameserver.ini
  A. sapprofile.ini
  C. daemon.ini
  D. nameserver.ini

• Question 110:

  The SAP HANA Repository is structured using packages. A package can do which of the following?

  There are 3 correct answers to this question.

  Response:

  A. Directly be transported to another SAP HANA system
  B. Nested to another package creating a hierarchy
  C. Contain directly repository objects
  D. Be empty or contain only other packages
  B. Nested to another package creating a hierarchy
  C. Contain directly repository objects
  D. Be empty or contain only other packages