SAP C_HANATEC_1 Certified Technology Associate Practice Exam Set 4

Which of the following can you use to update SAP HANA (SPS06)?


Options are :

  • SAP HANA on-site configuration tool
  • SAP HANA lifecycle manager (Correct)
  • Software update manager (SUM) for SAP HANA
  • SAP HANA update wizard

Answer : SAP HANA lifecycle manager

Which of the following must be installed during the installation of SAP Landscape Transformation (SLT)? (Choose two)


Options are :

  • Java stack for the SLT Server
  • SAP NetWeaver 7.02 or higher (Correct)
  • SAP HANADB libraries to the source system
  • DMIS add-on to the SAP source system (Correct)

Answer : SAP NetWeaver 7.02 or higher DMIS add-on to the SAP source system

Where do you specify the instance number during the installation of SAP HANA?


Options are :

  • In global.ini
  • In the installer execution file
  • In the installer configuration file (Correct)
  • In a dialog box prompt

Answer : In the installer configuration file

Which of the following is influenced by the audit level?


Options are :

  • The amount of data transferred to SAP Solution Manager
  • The information that is printed with the audit log entry (Correct)
  • The messages that are sent to the security administrator
  • The order of the audit log entries in the audit log

Answer : The information that is printed with the audit log entry

A company is planning to upgrade from an SAP HANA platform license to an SAP HANA enterprise license.Which additional component will be provided?


Options are :

  • Data replication (Correct)
  • XS application development
  • Database for SAP NetWeaver BW
  • SAP Sybase ASE

Answer : Data replication

Which of the following views allows an administrator to identify all the authorizations assigned to a user?


Options are :

  • GRANTED_PRIVILEGES
  • GRANTED_ROLES
  • EFFECTIVE_PRIVILEGES (Correct)
  • USERS

Answer : EFFECTIVE_PRIVILEGES

When you try to create a delivery unit from the SAP HANA studio you receive the following error message. 'Cannot create Delivery Unit as content vendor is not defined for this system'.How do you troubleshoot this issue?


Options are :

  • Grant REPO.MAINTAIN_NATIVE_PACKAGES privilege
  • Maintain the vendor ID
  • Grant REPO.MAINTAIN_DELIVERY_UNITS privilege
  • Maintain the content_vendor parameter (Correct)

Answer : Maintain the content_vendor parameter

Which of the following are advantages of using the SAP CO-PA accelerator? (Choose two)


Options are :

  • Eliminates the need for customization
  • Reduces reporting time (Correct)
  • Transforms data during the load step
  • Provides business configuration (Correct)

Answer : Reduces reporting time Provides business configuration

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? (Choose three)


Options are :

  • Assign the analytic privilege to the users (Correct)
  • Assign a package privilege to the users
  • Create an analytic privilege (Correct)
  • Select an attribute and define restricted values for it (Correct)

Answer : Assign the analytic privilege to the users Create an analytic privilege Select an attribute and define restricted values for it

Which of the following authentication methods does SAP HANA support for http(s) access? (Choose two)


Options are :

  • Header-based authentication
  • SAP logon tickets (Correct)
  • X.509 client certificates (Correct)
  • LDAP authentication

Answer : SAP logon tickets X.509 client certificates

What does the save point process in SAP HANA do?


Options are :

  • It synchronizes changed data to the disaster recovery system.
  • It saves changed data to disk when transactions are committed
  • It saves changed data to disk at regular intervals (Correct)
  • It frees up memory by saving non-active data to disk.

Answer : It saves changed data to disk at regular intervals

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?


Options are :

  • Restart the master job using transaction LTR in the SLT system
  • Select "Stop Replication" and "Replicate" in the Data Provisioning dialog (Correct)
  • Run the hdbnsutil program on the command line
  • Select "Suspend" and "Resume" in the Data Provisioning dialog

Answer : Select "Stop Replication" and "Replicate" in the Data Provisioning dialog

You are using continuous system replication between SAP HANA systems in two separate data centers.What are the advantages of this scenario? (Choose two)


Options are :

  • Database changes are continuously updated to the secondary site. (Correct)
  • Memory and CPU are used on the secondary site for shadow processes.
  • The take-over happens in less than 3 minutes.
  • The take-over only requires a roll forward since the last synchronization point. (Correct)

Answer : Database changes are continuously updated to the secondary site. The take-over only requires a roll forward since the last synchronization point.

You have to create an SAP HANA architecture that meets the following requirements: - Data provisioning is performed in batch mode - Data transformation is performed during the load step, - Reporting is run using analytic data models. Which of the following scenarios would you implement?


Options are :

  • An operational data mart
  • An SAP HANA accelerator
  • An agile data mart (Correct)
  • SAP HANA as application platform

Answer : An agile data mart

You need to combine unstructured data from an Apache Hadoop database with data in your SAP HANA system. What do you use to achieve this?


Options are :

  • SAP Landscape Transformation
  • Virtual tables (Correct)
  • Full-text search indexes
  • SAP Sybase IQ

Answer : Virtual tables

A user is locked due to too many failed logon attempts. Which SQL command can solve this problem?


Options are :

  • ALTER USER DROP CONNECT ATTEMPTS
  • ALTER USER ACCOUNT UNLOCK
  • ALTER USER FORCE PASSWORD CHANGE AFTER ATTEMPTS
  • ALTER USER RESET CONNECT ATTEMPTS (Correct)

Answer : ALTER USER RESET CONNECT ATTEMPTS

What do you have to consider when you design a backup plan? (Choose two)


Options are :

  • The backup execution must be monitored. (Correct)
  • The database backup must be stored at a different location than the database server. (Correct)
  • The newest data must be backed up most often.
  • The column table data needs to be compressed before a backup.

Answer : The backup execution must be monitored. The database backup must be stored at a different location than the database server.

Which of the following prerequisites must be met before you can install the SAP HANA studio on a Linux operating system? (Choose two)


Options are :

  • The Java runtime is accessible via the PATH or JAVA_HOME variable. (Correct)
  • The installation directory has at least 10 GB of free space.
  • You are logged on as the adm user.
  • You are logged on as the root user. (Correct)

Answer : The Java runtime is accessible via the PATH or JAVA_HOME variable. You are logged on as the root user.

Which parameters do you change to configure the trace file rotation? (Choose two)


Options are :

  • maxfilesize (Correct)
  • maxfiles (Correct)
  • tracefile
  • trace

Answer : maxfilesize maxfiles

You deleted billions of records from several tables in the SAP HANA database. However, the file system for the data volumes did not gain any free space. What is the reason?


Options are :

  • You did not execute a full backup and restore to reduce the size of the data volumes.
  • SAP HANA did not trigger a delta merge yet
  • SAP HANA keeps the space for later reuse. (Correct)
  • You did not execute the ALTER SYSTEM RECLAIM LOG.

Answer : SAP HANA keeps the space for later reuse.

Which of the following situations can trigger a delta merge?


Options are :

  • The number of records in the main storage exceeds a limit.
  • A pre-defined time of day has arrived.
  • An SQL statement must read merged data
  • The memory consumption of the delta storage exceeds a limit. (Correct)

Answer : The memory consumption of the delta storage exceeds a limit.

When you transport objects between SAP HANA systems using the Change and Transport System (CTS), you want to create and release the transport requests manually. Which transport strategy should you choose?


Options are :

  • WBO_GET_REQ_STRATEGY = Smart WBO_REL_REQ_STRATEGY = Manual
  • WBO_GET_REQ_STRATEGY = Create WBO_REL_REQ_STRATEGY = Auto
  • WBO_GET_REQ_STRATEGY = Tagged WBO_REL_REQ_STRATEGY = Manual (Correct)
  • WBO_GET_REQ_STRATEGY = Smart WBO_REL_REQ_STRATEGY = Auto

Answer : WBO_GET_REQ_STRATEGY = Tagged WBO_REL_REQ_STRATEGY = Manual

You have to implement disaster recovery for an SAP HANA production system. You also want to use the secondary SAP HANA appliance for development and testing. The data centers are more than 100km (60 miles) apart; the network capacity between them is restricted. Which disaster recovery option would you implement?


Options are :

  • Synchronous system replication with continuous memory loading
  • Synchronous storage replication with shadow processes
  • Asynchronous system replication with continuous memory loading
  • Asynchronous system replication with shadow processes (Correct)

Answer : Asynchronous system replication with shadow processes

Which of the following situations result in a system lockdown? (Choose two)


Options are :

  • The license type was changed from platform to enterprise
  • The installed license key is an unenforced license key and the current memory consumption exceeds the licensed amount plus the tolerance.
  • The license keys installed in the database have been deleted. (Correct)
  • The system ID and/or hardware key of the database have been changed after a system copy or renaming. (Correct)

Answer : The license keys installed in the database have been deleted. The system ID and/or hardware key of the database have been changed after a system copy or renaming.

You created an information model in the SAP HANA studio and activated it successfully. When you execute the data preview you get an error message indicating missing privileges.Which of the following could solve the problem?


Options are :

  • GRANT SELECT ON SCHEMA TO _SYS_BIC
  • GRANT SELECT ON SCHEMA TO _SYS_REPO WITH GRANT OPTION (Correct)
  • GRANT SELECT ON SCHEMA TO _SYS_BI WITH GRANT OPTION
  • GRANT CREATE ANY ON SCHEMA TO _SYS_REPO

Answer : GRANT SELECT ON SCHEMA TO _SYS_REPO WITH GRANT OPTION

Which of the following steps allow you to create a test system (system A) based on a productive SAP HANA standalone system (system B)? (Choose two)


Options are :

  • Export the data from system B to a file share and import the data to system A.
  • Copy a snapshot from system B to system A.
  • Copy the data and log volume files from system B to system A (Correct)
  • Restore a complete database backup from system B to system A. (Correct)

Answer : Copy the data and log volume files from system B to system A Restore a complete database backup from system B to system A.

In the SAP HANA studio, where can you check the throughput performance of SAP HANA backups?


Options are :

  • System Information Database Information
  • Backup Editor Backup Catalog Backup Details (Correct)
  • Administration Console Diagnosis files Backup.log
  • Administration Console Performance Job Progress

Answer : Backup Editor Backup Catalog Backup Details

A backup catalog became unusable.What can you do to recover existing backups?


Options are :

  • In SAP HANA studio Backup Editor Display all backups select REFRESH
  • Use a third party backup tool to recover the backups.
  • Create a new data backup.
  • Recreate the backup catalog based on the available backup files with the tool hdbbackupdiag. (Correct)

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

Which view allows you to find the name and the size of backup files?


Options are :

  • M_SERVICE_STATISTICS
  • M_SYSTEM_OVERVIEW
  • M_BACKUP_CATALOG_FILES (Correct)
  • M_BACKUP_CATALOG

Answer : M_BACKUP_CATALOG_FILES

In the SAP HANA studio, in which tab can you find information about the performance of queries?


Options are :

  • Diagnosis Files (Correct)
  • Alerts
  • System Information
  • Trace Configuration

Answer : Diagnosis Files

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions