SAP C_HANATEC_1 Certified Technology Associate Practice Exam Set 1

Which of the following can you use to configure the connection between the source system and SAP HANA in the SAP LT system? (Choose two)


Options are :

  • SAP HANA studio -> Administration Console -> Add System
  • Web Dynpro application IUUC_REPLICATION_CONFIG (Correct)
  • Transaction LTR (Correct)
  • SAP NetWeaver Administrator -> Configuration -> Destination

Answer : Web Dynpro application IUUC_REPLICATION_CONFIG Transaction LTR

Which of the following connections require the highest network bandwidth?


Options are :

  • SAP HANA and SAP NetWeaver Portal
  • SAP HANA and SAP HANA studio
  • SAP HANA and SAP BW (Correct)
  • SAP HANA and SBO BI

Answer : SAP HANA and SAP BW

Which user must have SELECT privilege with the grant option on the data schema?


Options are :

  • ADM
  • _SYS_BIC
  • _SYS_REPO (Correct)
  • SYSTEM

Answer : _SYS_REPO

What is the correct communication data flow between diagnostics in SAP Solution Manager and SAP HANA in the monitor scenario?


Options are :

  • Solution Manager HostAgent SAP HANA
  • Solution Manager HostAgent SMDAgent SAP HANA
  • Solution Manager SMDAgent HostAgent SAP HANA (Correct)
  • Solution Manager SMDAgent SAP HANA

Answer : Solution Manager SMDAgent HostAgent SAP HANA

Which actions to you need to perform to configure SAP HANA single sign-on?


Options are :

  • Generate and import PSE key
  • Generate and import X.509 certificate
  • Generate and import Kerberos keytab (Correct)
  • Generate and import SSH rsa key

Answer : Generate and import Kerberos keytab

Which of the following are benefits of using accelerators with SAP HANA? (Choose two)


Options are :

  • They provide prebuilt customer-specific solutions.
  • They provide prebuilt business content. (Correct)
  • They reduce the time required for implementation. (Correct)
  • They eliminate the need for customization.

Answer : They provide prebuilt business content. They reduce the time required for implementation.

Which delivered role is mandatory for a system administrator in SAP HANA?


Options are :

  • IC MODELER
  • CONTENT_ADMIN (Correct)
  • SAP_ALL
  • SYS_ADMIN

Answer : CONTENT_ADMIN

Which of the following sequences of steps is used to implement SAP HANA with SAP ERP?


Options are :

  • SAP HANA system setup Modeling Data Provisioning Consumption
  • SAP HANA system setup Data Provisioning Consumption Modeling
  • Data Provisioning SAP HANA system setup Modeling Consumption
  • SAP HANA system setup Data Provisioning Modeling Consumption (Correct)

Answer : SAP HANA system setup Data Provisioning Modeling Consumption

You need to retrieve data from SAP HANA that is restricted to a certain region and specific users.How can you implement this security strategy?


Options are :

  • By assigning package privileges to the necessary users
  • By assigning system privileges to the necessary users
  • By assigning analytic privileges to the necessary users (Correct)
  • By assigning SQL privileges to the necessary user

Answer : By assigning analytic privileges to the necessary users

SAP Support needs to access a customer's SAP HANA studio remotely. Which entry must the client maintain in SAP Service Marketplace?


Options are :

  • Preprocessor server
  • Statistics server
  • Master index server (Correct)
  • Name server

Answer : Master index server

What information is presented when you check the license key?


Options are :

  • SAP HANA build number
  • SAP HANA licensed memory amount (Correct)
  • SAP HANA support package number
  • SAP HANA edition type

Answer : SAP HANA licensed memory amount

The SAP LT trigger-based approach uses a log table to record all relevant changes. Where is this log table stored?


Options are :

  • In the source system (Correct)
  • In SAP Solution Manager
  • In SAP HANA
  • In SAP LT

Answer : In the source system

A company wants to restrict data access to a specific year for certain users. Which privilege type must you define in SAP HANA to achieve this requirement?


Options are :

  • Analytic privileges (Correct)
  • System privileges
  • SQL privileges
  • Package privileges

Answer : Analytic privileges

What is the connection type for communication between the SAP LT Replication Server and the non-SAP source system?


Options are :

  • Web service
  • QRFC
  • TRFC
  • Database (Correct)

Answer : Database

Which of the following are required to enable SAP HANA high availability? (Choose two)


Options are :

  • High-performance computing clustering for Linux
  • SAP HANA distributed systems (Correct)
  • SUSE Linux Enterprise High Availability Extension
  • Redundant storage and network (Correct)

Answer : SAP HANA distributed systems Redundant storage and network

Which operating system commands show the SAP HANA processes? (Choose two)


Options are :

  • HDB proc (Correct)
  • HDB admin
  • HDB info (Correct)
  • HDB version

Answer : HDB proc HDB info

Where do you check log and trace files in SAP HANA studio?


Options are :

  • Modeler Diagnosis Files tab
  • Administration Editor System Information tab
  • Administration Editor Diagnosis Files tab (Correct)
  • Administration Editor Performance tab Diagnosis Files tab

Answer : Administration Editor Diagnosis Files tab

What is the recommended approach by SAP when loading tables into SAP HANA from SAP ERP via Data Services?


Options are :

  • Use the Replication Server
  • Use the ABAP application tier (Correct)
  • Use the data staging server
  • Use open hub

Answer : Use the ABAP application tier

Which of the following requires a dedicated network interface to SAP HANA?


Options are :

  • SAP BusinessObjects Business Intelligence platform
  • SAP LT (Correct)
  • Backup destination
  • SAP HANA studio

Answer : SAP LT

A customer complains about poor performance when they query a column table with 5 billion records. You suspect that this table is partially loaded into memory. Where can you to check the load status of this table? (Choose two)


Options are :

  • On the Runtime Information tab of the table definition (Correct)
  • In the M_CS_TABLES view (Correct)
  • In the M_TABLE_PERSISTENCE_LOCATIONS view
  • In the M_TABLES view

Answer : On the Runtime Information tab of the table definition In the M_CS_TABLES view

Which tools can you use to monitor the query time from SAP HANA?


Options are :

  • Event Viewer
  • Performance tab of the System Monitor
  • Central Management Console
  • SQL Trace (Correct)

Answer : SQL Trace

What happens when you add a standby host to an existing SAP HANA system? (Choose two)


Options are :

  • The standby host takes over one of the active index servers.
  • The standby host registers with the index server.
  • The standby host registers with the master name server (Correct)
  • The standby host starts an index server and waits (Correct)

Answer : The standby host registers with the master name server The standby host starts an index server and waits

Which of the following must you configure to enable monitoring of SAP HANA in DBA Cockpit?


Options are :

  • The CCMS connection in DBA cockpit
  • A database connection in the table DBCON
  • A database connection in DBA Cockpit (Correct)
  • The CCMS agent in SAP HANA

Answer : A database connection in DBA Cockpit

Which of the following are recovery types in SAP HANA database? (Choose two)


Options are :

  • Recovery until cancel
  • Full recovery (Correct)
  • Recovery with incremental backup
  • Point in time recovery (Correct)

Answer : Full recovery Point in time recovery

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


Options are :

  • Save changed data and logs to persistent storage on a regular basis. (Correct)
  • Save logs to persistent storage when a transaction is committed
  • Save changed data to persistent storage when a transaction is committed.
  • Free up memory by saving less frequently used data to persistent storage.

Answer : Save changed data and logs to persistent storage on a regular basis.

High-performance computing clustering for Linux


Options are :

  • hdbinst -a studio - -copy_repository=
  • hdbinst -a studio - -repository=
  • hdbinst -a studio - -repository=
  • hdbinst -a studio - -copy_repository= (Correct)

Answer : hdbinst -a studio - -copy_repository=

Which of the following Kerberos implementations is supported for single sign-on in SAP HANA? (Choose two)


Options are :

  • MIT's Kerberos Network Authentication Protocol (Correct)
  • "Advanced Encryption Standard (AES) Encryption for Kerberos 5" on HP-UX
  • Windows Active Directory Domain Kerberos implementation (Correct)
  • Red Hat Linux version 4 and later Kerberos implementation

Answer : MIT's Kerberos Network Authentication Protocol Windows Active Directory Domain Kerberos implementation

Which technologies use trigger-based replication? (Choose two)


Options are :

  • Near Zero Downtime (Correct)
  • Test Data Migration Server (TDMS) (Correct)
  • TREX engine
  • ABAP extractors

Answer : Near Zero Downtime Test Data Migration Server (TDMS)

Which of the following is most relevant for CPU sizing of a SAP HANA appliance?


Options are :

  • The number of concurrent users logged onto SAP HANA
  • The SAP HANA hardware platform
  • The number of users actively running analytics in SAP HANA (Correct)
  • The amount of disk storage

Answer : The number of users actively running analytics in SAP HANA

Which of the following must be running to view SAP HANA Diagnosis Files if the SAP HANA database is offline?


Options are :

  • r3trans
  • SMD Agent
  • disp+work
  • sapstartsrv (Correct)

Answer : sapstartsrv

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions