SAP C_HANATEC_1 Certified Technology Associate Practice Exam Set 3

What must you do in SAP LT to establish a connection between a non-SAP source system database and SAP HANA? (Choose three)


Options are :

  • Define the SAP LT RFC connection to SAP HANA.
  • Create the source database connection in table DBCON. (Correct)
  • Add a source database connection in the DBA Cockpit. (Correct)
  • Define the SAP LT database connection to SAP HANA. (Correct)

Answer : Create the source database connection in table DBCON. Add a source database connection in the DBA Cockpit. Define the SAP LT database connection to SAP HANA.

If you want to create or drop tables in a schema, which privilege type do you need?


Options are :

  • Analytic
  • System
  • SQL (Correct)
  • Package

Answer : SQL

You have to size an SAP HANA system for SAP NetWeaver BW. The SAP NetWeaver BW system is currently running on a non-SAP RDBMS.Which of the following factors influences the size of the SAP HANA system?


Options are :

  • The number of indexes
  • The partitioning of tables
  • The size of aggregates
  • The number of tables in the row store (Correct)

Answer : The number of tables in the row store

Which view in SAP HANA studio do you use to add additional users?


Options are :

  • Navigator view (Correct)
  • Quick Launch view
  • Console view
  • Properties view

Answer : Navigator view

You have an SAP HANA productive system with sensitive data. How can you restrict modeling users from viewing this data? (Choose two)


Options are :

  • Allow modeling only on the SAP HANA development system and export/import the models to the productive system. (Correct)
  • Use randomized data for the development of data models. (Correct)
  • Remove ALTER SYSTEM in the system privileges for the modeling users.
  • Remove SAP_DATA_ADMIN in the SQL privileges for the modeling users.

Answer : Allow modeling only on the SAP HANA development system and export/import the models to the productive system. Use randomized data for the development of data models.

Which Linux kernel parameters need to be adapted during SAP HANA installation depending on the SAP HANA system size?


Options are :

  • net.ipv4.tcp_slow_start_after_idle and kernel.shmmni (Correct)
  • fs.file-max and net.core.wmem_max
  • net.core_rmem_max and kernel.sysrq
  • kernel.shmall and fs.file-max

Answer : net.ipv4.tcp_slow_start_after_idle and kernel.shmmni

Which of the following are parts of SAP HANA sizing? (Choose three)


Options are :

  • CPU sizing (Correct)
  • Disk sizing (Correct)
  • Network bandwidth sizing
  • Memory sizing (Correct)

Answer : CPU sizing Disk sizing Memory sizing

Which of the following commands stops the SAP HANA database?


Options are :

  • stop HDB
  • HDB stop (Correct)
  • HDB -stop
  • stopsap hdb

Answer : HDB stop

How can you delete old data and log backups from both the backup catalog and physically from the server?


Options are :

  • Delete all files under $(DIR_INSTANCE)/backup/data and $(DIR_INSTANCE)/backup/log
  • Run "DELETE from m_backup_catalog_files where backup_id = " in the SQL editor
  • Go to Backup Editor -> Backup Catalog -> Delete Older Backups -> Catalog and backup location (Correct)
  • Delete all files under $(DIR_GLOBAL)/hdb/log

Answer : Go to Backup Editor -> Backup Catalog -> Delete Older Backups -> Catalog and backup location

Which view displays the current SAP HANA Support Package level?


Options are :

  • M_HOST_INFORMATION
  • M_VERSION_MEMORY
  • M_LANDSCAPE_HOST_CONFIGURATION
  • M_DATABASE (Correct)

Answer : M_DATABASE

Which of the following would you use to upgrade an SAP HANA system and keep the downtime to a minimum?


Options are :

  • System replication (Correct)
  • Partitioning
  • Storage replication
  • High availability

Answer : System replication

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


Options are :

  • Local users with administrator privileges (Correct)
  • Local users without administrator privileges
  • Domain users with administrator privileges (Correct)
  • ADM users without administrator privileges

Answer : Local users with administrator privileges Domain users with administrator privileges

Which of the following can you use to replicate data from SAP BW to SAP HANA?


Options are :

  • Open hub with Data Services 4.0 (Correct)
  • A database connection to Data Services 4.0
  • Open hub with SAP LT
  • An RFC connection to SAP LT

Answer : Open hub with Data Services 4.0

Which of the following are functions of the controller on the SAP Landscape Transformation (SLT) server? (Choose two)


Options are :

  • Map database structures between SAP HANA and the source system. (Correct)
  • Write data to the SAP HANA system using the DB connection.
  • Schedule replication processes. (Correct)
  • Create repositories in the source system.

Answer : Map database structures between SAP HANA and the source system. Schedule replication processes.

Which tasks do you have to perform if you want to use SAP BW with SAP HANA as the underlying database?


Options are :

  • Do a homogeneous system copy from your current DB to SAP HANA DB.
  • Do a heterogeneous system copy from your current DB to SAP HANA DB. (Correct)
  • Recreate SAP BW indexes after SAP HANA database migration.
  • Ensure that you have at least SAP NetWeaver Business Warehouse 7.02 installed.

Answer : Do a heterogeneous system copy from your current DB to SAP HANA DB.

How can you make space available inside the log volume in a productive SAP HANA system?


Options are :

  • Compress the log backups at file system level.
  • Set the log mode to Overwrite.
  • Perform log backups. (Correct)
  • Delete log backups at the operating system level.

Answer : Perform log backups.

What are the recommended ways to perform a database backup? (Choose two)


Options are :

  • Use the./hdbsetup command
  • Use SAP HANA Studio (Correct)
  • Use the BRBACKUP command
  • Use SQL commands (Correct)

Answer : Use SAP HANA Studio Use SQL commands

Which of the following traces is active by default in SAP HANA?


Options are :

  • Expensive statements trace
  • Performance trace
  • Database trace (Correct)
  • SQL trace

Answer : Database trace

In which file do you configure the maximum size of the delta storage memory?


Options are :

  • Executer.ini
  • Preprocessor.ini
  • Global.ini
  • Indexserver.ini (Correct)

Answer : Indexserver.ini

What can you use to transform data from SAP Business Warehouse (BW) into SAP HANA?


Options are :

  • SAP BusinessObjects Data Services (Correct)
  • SAP Landscape Transformation (SLT)
  • SAP BW extractors
  • SAP Legacy System Migration Workbench (LSMW)

Answer : SAP BusinessObjects Data Services

You want to make sure that all data accesses to a specific view will be logged in the audit trail. As part of an update of the database schema, the view is dropped and recreated under the same name. What is the consequence for auditing?


Options are :

  • Auditing continues to work for the view. (Correct)
  • Auditing needs to be set up again for the recreated view.
  • The audit log-object references must be reinitialized.
  • The audit policy needs to be reactivated.

Answer : Auditing continues to work for the view.

Which of the following configuration files contains the backup locations of log and data files?


Options are :

  • Global.ini (Correct)
  • Indexserver.ini
  • localclient.ini
  • Attributes.ini

Answer : Global.ini

Which of the following is an SQL privilege?


Options are :

  • DEVELOPMENT
  • EXPORT
  • SAVEPOINT ADMIN
  • DROP (Correct)

Answer : DROP

Which command is recommended by SAP to install an SAP HANA database via a graphical user interface (GUI)?


Options are :

  • ./hdbinst
  • ./hdbsetup (Correct)
  • ./sapinst
  • ./hdbinst – install

Answer : ./hdbsetup

After you install an SAP HANA database, you want to ensure that it is automatically started when the host is rebooted.Which of the following parameter settings allows you to do this?


Options are :

  • Autostart to "1" in the profile file /usr/sap//SYS/profile/_HDB_ (Correct)
  • Autostart to "Yes" in the profile file /usr/sap//SYS/profile/DEFAULT.PFL
  • Autostart to "TRUE" in the profile file /usr/sap//SYS/profile/DEFAULT.PFL
  • Autostart to "Enable" in the profile file /usr/sap//SYS/profile/_HDB_

Answer : Autostart to "1" in the profile file /usr/sap//SYS/profile/_HDB_

Which of the following steps is required for configuring SAP Landscape Transformation (SLT)?


Options are :

  • Define the number of jobs to be used for data replication. (Correct)
  • Define the number of background work processes in SLT.
  • Define a DB connection from SLT to the source system.
  • Define an RFC connection from SLT to SAP HANA.

Answer : Define the number of jobs to be used for data replication.

Which of the following are characteristics of SAP NetWeaver Business Warehouse (SAP NetWeaver BW) when it is migrated to run on the SAP HANA database? (Choose two)


Options are :

  • The SAP NetWeaver BW application server can be installed on the SAP HANA hardware.
  • All SAP NetWeaver BW 7.x application versions can be used.
  • The sizing of the current SAP NetWeaver BW application server remains valid. (Correct)
  • The current SAP NetWeaver BW application server hardware can be re-used. (Correct)

Answer : The sizing of the current SAP NetWeaver BW application server remains valid. The current SAP NetWeaver BW application server hardware can be re-used.

Which of the following connection types does Direct Extractor Connection (DXC) use to transfer data to SAP HANA?


Options are :

  • Secondary database connection
  • http connection (Correct)
  • BICS connection
  • RFC connection

Answer : http connection

You want to create a role that grants read-only access to the content of the system and monitoring views and to statistics services.Which of the following privileges should the role contain? (Choose two)


Options are :

  • ALTER for SQL schema _SYS_STATISTICS
  • SELECT for SQL schema _SYS_STATISTICS (Correct)
  • DATA ADMIN (Correct)
  • SERVICE ADMIN

Answer : SELECT for SQL schema _SYS_STATISTICS DATA ADMIN

What must you do to configure SAP HANA high availability?


Options are :

  • Run command./hdbinst --SID= --password= --autostart=off.
  • Run command./hdbaddhost --SID= --password= --role=standby. (Correct)
  • Right click the Navigator panel and choose Add System…
  • Call stored procedure SYS.UPDATE_LANDSCAPE_CONFIGURATION.

Answer : Run command./hdbaddhost --SID= --password= --role=standby.

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions