option

HANATEC Learning Assessment

INFO STADISTICS RECORDS
TAKE THE TEST
Title of test:
HANATEC Learning Assessment

Description:
Learning Assessment C_HANATEC_16 with remembered questions from exam

Author:
dogas[at]gmx.de
(Other tests from this author)

Creation Date:
18/09/2020

Category:
Computers

Number of questions: 401
Share the Test:
Facebook
Twitter
Whatsapp
TAKE THE TEST
Last comments
dogas ( uploaded 1 month )
Questions and answers are maintained with the best of knowledge and conscience. If there are still errors, please contact me so that I can correct them. Thank you.
Answer
Content:
Which steps can be combined in a DMO procedure, targeting an AS ABAP 7.50-based SAP system? Note: There are 2 correct answers to this question. Performing an SAP software update Migrating to a target database, e.g. SAP HANA Performing a Unicode conversion Performing a database upgrade of the source database.
What are the advantages of the DMO procedure? Note: There are 3 correct answers to this question. DMO combines several steps into one procedure. DMO allows a lower target release on SAP HANA database. DMO allows an easy reset during the procedure. DMO is an inplace procedure by default, keeping the application server host.
Your source SAP system is running on Windows with an SAP MaxDB database. You want to use the DMO procedure to migrate to SAP HANA database, using the inplace migration. Which up to date SAP kernel is needed for the DMO procedure? Note: There are 2 correct answers to this question. Linux, SAP MaxDB Windows, SAP MaxDB Linux, SAP HANA Windows, SAP HANA.
The configuration of SAP Host Agent to start SUM is mandatory, because the SAP Host Agent is needed to connect the SUM UI to SAPup. Determine whether this statement is true or false. True False.
Which information is provided via the SUM UI? Note: There are 3 correct answers to this question. A progress bar for the overall procedure The active roadmap step The memory consumption of SUM The content of log files via the log viewer.
SUM relies on an up to date version of SPAM/SAINT in the source release. Determine whether this statement is true or false. True False.
You are applying SAP Support Packages during an SUM DMO run to SAP HANA. Which options are possible to select in the main dialog Tool Configuration? Note: There are 3 correct answers to this question. Single System Standard Advanced Expert Mode.
As a result of Roadmap Step 3 - Checks, it can be necessary to extend the freespace in the source database. Determine whether this statement is true or false. True False.
During a standard DMO run, the migration of the repository is performed during uptime, the migration of the application data is performed during downtime. Determine whether this statement is true or false. True False.
During uptime migration, which information can you receive in the Charts Control Center, via the SUM Utilities of the SUM UI? Note: There are 3 correct answers to this question. The configured maximum number of parallel R3load processes The actual number of running R3load processes The memory consumption of the target database The process buckets being processed.
What do you have to ensure during the downtime phases of SUM? Note: There are 3 correct answers to this question. The source database must be stopped End users can not log on to the SAP system Batch jobs from daily business can not start Interfaces from other SAP systems can not log on to the SAP system.
When a standard DMO run is completed, you can still reset the procedure. Determine whether this statement is true or false. True False.
A reset of the DMO procedure requires a database restore/recovery. Determine whether this statement is true or false. True False.
Which are tuning methods for the database migration, using DMO of SUM? Note: There are 3 correct answers to this question. Adapt the number of parallel R3load processes Using the Near Zero Downtime Maintenance capabilities of SUM (NZDM) Using the table migration duration files from a previous run Performing a benchmark using the benchmarking options of SUM.
Which of the following are part of the Software Logistics (SL) Toolset? Note: There are 3 correct answers to this question. Software Update Manager (SUM) Transport Management System (TMS) Software Provisioning Manager (SWPM) Support Package Manager (SPAM).
For a migration to SAP HANA database, it is generally recommended to use DMO of SUM. Determine whether this statement is true or false. True False.
What software innovations did SAP deliver with SAP HANA? Note: There are 2 correct answers to this question. Column and delta store Compression and decompression Partitioning Insert only on column store.
What is the minimum space requirement for the Data Volume? Note: There are 2 correct answers to this question. 1.2 * RAM (TDI) Min. 1 * RAM Min. 0.5 * RAM 3 * RAM (Appliance).
If you choose to build a multi-host system during the installation, the shared file systems for data and log files are configured and mounted on all hosts, including the primary host, automatically. Determine whether this statement is true or false. True False.
By using the Database Migration Option (DMO) of the Software Update Manager (SUM), you are able to simplify migration steps by combining the system update and database migration into one tool, and reduce business downtime. Determine whether this statement is true or false. True False.
Which SAP products are built on SAP HANA? Note: There are 3 correct answers to this question. SAP S/4HANA SAP C/4HANA SAP BW/HANA SAP R3/4HANA.
SAP HANA tailored data center integration is an open and flexible approach for the integration of SAP HANA in the data center. Tailored data center integration can reduce hardware and operations cost by reusing existing hardware components and processes. Determine whether this statement is true or false. True False.
SAP HANA cockpit can only be installed separately on dedicated hardware. Determine whether this statement is true or false. True False.
What is contained in SAP HANA Cockpit Support Packages? Note: There are 2 correct answers to this question. Bug fixes Support Package Stacks Feature Packs New features.
Which tools can you use to update SAP HANA cockpit? Note: There are 2 correct answers to this question. hdblcm hdblcmgui SUM SWPM.
From an architectural standpoint, which of the following components belong to the SAP HANA index server? Note: There are 2 correct answers to this question. External interfaces Preprocessor Relational engines SAP Web Dispatcher.
Which of the following events occur while the merge operation is running? Note: There are 2 correct answers to this question. Uncommitted changes in the first delta storage are rolled back. The content of the complete main storage is persisted to disk. The content of the first main storage and the committed entries in the first delta storage are merged into the new second main storage. All write operations go to the second delta storage.
The resident HDBLCM located on the SAP HANA installation media performs administrative tasks like installing and updating an SAP HANA database and its core components. Determine whether this statement is true or false. True False.
Which of the following administration tools provide the ability for central landscape management? Note: There are 2 correct answers to this question. SAP DBA Cockpit SAP HANA HDBSQL SAP HANA studio SAP Landscape Management.
Which of the following database resources can be monitored in the DBA Cockpit Current Status Overview monitor? Note: There are 3 correct answers to this question. The time at which the database was started Disk consumption from the SAP HANA database Connection statistics about open connections Memory and CPU consumption from the SAP HANA database.
SAP Landscape Management is a powerful automated solution designed to simplify, centralize, and orchestrate the management and operations of the entire application landscape powered by SAP HANA. With the enterprise edition of SAP Landscape Management, you can perform various operations on SAP HANA instances, such as start, stop, monitor, or system replication operations. Determine whether this statement is true or false. True False.
Which of the following elements are contained in the SAP HANA studio System Navigator? Note: There are 3 correct answers to this question. Backup Content Configuration Security.
Which users are able to start and stop a distributed SAP HANA database system? Note: There are 2 correct answers to this question. SYSTEM <sid>adm root sapadm.
When a registered SAP HANA resource is offline, the version number 0.00.000.00.0 (UNKNOWN) is displayed to indicate an improper shutdown. Determine whether this statement is true or false. True False.
You can only generate the full system information dump file using the SAP HANA cockpit. Determine whether this statement is true or false. True False.
In which circumstances do you create a column store table? Note: There are 3 correct answers to this question. When the calculations are based on a small number of columns When accessing complete records When aggregations or fast search are required When the table has a large number of columns.
Which of the following tasks require the BACKUP ADMIN authorization? Note: There are 2 correct answers to this question. Backing up the database without a user interface Recovering the database without a user interface Physically deleting data and log backups and obsolete versions of the backup catalog from the backup location Administration tasks executed on a tenant database through the system database.
Which of the following elements are valid rules for the location of backup files? Note: There are 3 correct answers to this question. The volume ID is automatically added to a specified file name. The backup files should never be in the same directory and on the same file system as the data. The backup ID is unique for each persistence only. The backup folder will be created automatically when the backup process is started.
Your SAP HANA database is running in log mode Normal and automatic log backups are enabled. With this configuration, in which situations are the log segments backed up automatically? Note: There are 3 correct answers to this question. The log segment is full. The database is started. The log segment is closed after exceeding the configured time threshold. The database is stopped.
To diagnose backup errors, you can use the backup.log and backint.log files. Determine whether this statement is true or false. True False.
Which of the following recovery types is not supported for delta backups? Choose the correct answer. Recover the database to its most recent state. Recover the database to a specific point in time. Recover the database to a specific data backup.
The creation of storage snapshots has a big impact on the system, and recovery from storage snapshots takes longer. Determine whether this statement is true or false. True False.
Which of the following elements are required for implementing a database copy? Note: There are 2 correct answers to this question. The target database must have the same or higher version than the source database. The host number of the source and the target system are identical. Source and target databases can have different number and types of services. A data backup (file-based backups or backups using a third-party backup tool) or storage snapshot of the source system is available.
In which of the following SAP HANA scenarios is it recommended to encrypt communication between the client software and SAP HANA? Note: There are 2 correct answers to this question. SAP HANA as a data mart for reporting and analytics. SAP HANA as a classic three-tier architecture as the primary database (for example, SAP Business Warehouse, SAP Business Suite installation). SAP HANA as a platform for providing database and application services to native SAP HANA-based applications.
You cannot force all clients who communicate with the SAP HANA database through the SQL interface to use a secured connection. Determine whether this statement is true or false. True False.
What are the prerequisites for configuring audit logging? Note: There are 2 correct answers to this question. AUDIT ADMIN system privilege INIFILE ADMIN system privilege AUDIT OPERATOR system privilege INIFILE OPERATOR system privilege.
Which of the following actions can be audited by SAP HANA? Note: There are 2 correct answers to this question. Changes to system configuration Upgrade of an SAP HANA database instance Create or drop user, and create or drop role.
Which of the following tools can be used for user administration? Note: There are 3 correct answers to this question. SAP HANA cockpit hdbsql Resident hdblcm SAP Identity Management.
Which of the following privileges allow read access to data in SAP HANA information models depending on certain values or combination of values? Choose the correct answer. System privileges Object privileges Analytic privileges Package privileges.
Which of the following statements is true for the SAP HANA preinstalled role (SAP_INTERNAL_HANA_SUPPORT) for support cases? Choose the correct answer. It can be granted to the SYSTEM user. It can be granted to another role. It can only be granted further system privileges. It can only be granted further object privileges.
The password policy parameters for the system database of a multiple-container system are maintained in the indexserver.ini file. Determine whether this statement is true or false. True False.
What are the prerequisites for querying the EFFECTIVE_PRIVILEGES system view to get data about privileges granted to other users and roles? Note: There are 2 correct answers to this question. CATALOG READ DATA ADMIN MONITOR ADMIN USER ADMIN.
Only backups are offered in the SAP HANA database for disaster recovery. Determine whether this statement is true or false. True False.
With SAP HANA storage replication, you can use the servers on the secondary system for non-production SAP HANA systems values or combination of values? Choose the correct answer. True False.
When using the Continuous Log Replay operation mode (logreplay), the shipped redo log is continuously replayed on the secondary site and read-only access on the secondary site is allowed. Determine whether this statement is true or false. True False.
Which of the following are prerequisites for System Replication with QA and Development System on the secondary site? Note: There are 2 correct answers to this question. Preload of tables must be switched off on the secondary. The instance numbers for the replicated system and the Development/QA system are identical. Development/QA systems need to be shut down in case of a takeover. Additional independent disk volume is needed for Development/QA systems.
The system replication status Initializing indicates that the initial data transfer is in progress. Determine whether this statement is true or false. True False.
You create a new tenant database in a configured SAP HANA system replication. Which prerequisite must be fulfilled for the new tenant database to participate in the replication? Choose the correct answer. It must be stopped. It must be backed up. A fallback snapshot must be created The restart mode must be set to No auto-restart.
Which tool can you use to trigger a takeover from the current primary to the secondary system? Note: There are 2 correct answers to this question. hdblcm hdbsql SAP HANA cockpit hdbnsutil.
System replication with a read-enabled secondary site is based on the delta data shipping operation mode. Determine whether this statement is true or false. True False.
After an invisible takeover, the client keeps the connections to the primary system and the sessions are restored to the secondary system. Determine whether this statement is true or false. True False.
Enabling SAP HANA system replication with secondary time travel has no impact on the sizing and performance of the secondary system. Determine whether this statement is true or false. True False.
You can use system replication to upgrade your SAP HANA systems because the secondary system can run with a higher software version than the primary system. Determine whether this statement is true or false. True False.
To which use cases does multitarget system replication bring advantages? Note: There are 3 correct answers to this question. Update scenarios Reaching higher availability Necessity to perform backups Rearrangements of system replication multitier chains.
Moving tenant databases can be used for a tenant database-specific upgrade. Determine whether this statement is true or false. True False.
The HDBAdmin tool is the primary monitoring tool for SAP HANA, and is fully supported by SAP support. Determine whether this statement is true or false. True False.
Which SAP HANA tool can be used to automatically check the availability of the SAP HANA database? Choose the correct answer. HDBAdmin HANAsitter HANAcleaner HDBscheduler.
What kind of query language statements can be used in the SAP HANA Database Explorer? Choose the correct answers. SQL MDX XML TCL.
In a system-down scenario, SQL can be used to access the system to further analyze the problem. Determine whether this statement is true or false. True False.
Which analysis steps can be performed when the SAP HANA database cannot be reached using SQL? Choose the correct answers. Check the /var/log/messages for SAP HANA error messages. Use the deadlock detector functionality of hdbcons. Use the Heath Monitor of SAP HANA Cockpit 2.0. Check the hardware with the SAP HANA Hardware Configuration Check Tool.
The Troubleshoot Unresponsive System application collects its data through the fullSystemInfoDump.py python script. Determine whether this statement is true or false. True False.
Which monitoring KPIs are provided in the Manage Services application? Note: There are 2 correct answers to this question. CPU usage Service status Disk usage Lock status.
Because SAP HANA is running in-memory, a slow system situation is always caused by a problem at OS level. Determine whether this statement is true or false. True False.
Which KPIs are shown in the Performance Monitor started from the Memory Usage tile in SAP HANA Cockpit 2.0? Note: There are 2 correct answers to this question. Total resident memory Physical memory size Used resident memory Database free memory.
The statistics service is a central element of the internal monitoring infrastructure of SAP HANA. It collects statistical and performance information using SQL. Determine whether this statement is true or false. True False.
Which SAP HANA information sources inform you about high CPU consumption on your SAP HANA database? Note: There are 3 correct answers to this question. The host CPU usage Alert number 5 The CPU graph on the CPU usage tile The Alerts tile in the Overview screen The Overall Database Status tile.
In SAP HANA, performance issues are nothing to worry about unless the CPU becomes a bottleneck. Determine whether this statement is true or false. True False.
Which tools can you use to monitor the Average Execution Time of individual SQL queries? Note: There are 2 correct answers to this question. Monitor Statements - Overview Monitor Statements - Active Statements Monitor Statements - Expensive Statements SQL plan cache.
The Top SQL Statements tile displays the number of blocked transactions currently on hold in the database. Determine whether this statement is true or false. True False.
Which operations in the SAP HANA database result in disk I/O on the Redo Log Volume? Note: There are 2 correct answers to this question. Database restart Column table reload Scale-out host fail-over Database data backup.
A disk-full event causes the SAP HANA database to stop and the problem must be resolved before database operations can continue. Determine whether this statement is true or false. True False.
Which protocol is used by the statistics service to collects statistical and performance information? Choose the correct answer. JSON MDX SNMP SQL.
When configuring SAP HANA alerts, you can only enter one email recipient per alert. Determine whether this statement is true or false. True False.
CPU-binding is a resource pooling technique at the SAP HANA kernel level, and it can be configured within the SAP HANA database. Determine whether this statement is true or false. True False.
What are the workload characteristics of SAP HANA requests? Note: There are 2 correct answers to this question. The target of a request The type of a query The business importance The Disk Level Objectives.
What changes may influence a system’s performance and stability? Note: There are 2 correct answers to this question. Index changes Log Mode changes Table distribution changes Memory allocation limit.
The SAP HANA Capture and Replay tool allows you to capture real system workload in a productive environment, and preprocess and replay the captured workload on a different target system. Determine whether this statement is true or false. True False.
(SAMPLE QUESTIONS: C_HANATEC141) Which of the following can you use to analyze an expensive SQL statement? Note: There are 2 correct answers to this question. Open the Plan Visualizer. Open the Plan Explanation. Open the hdbcons tool. Open the SQL Plan Cache.
(SAMPLE QUESTIONS: C_HANATEC141) Which of the following update scenarios can be selected for execution in the SAP HANA lifecycle manager? Note: There are 2 correct answers to this question. Perform automated updates of SAP HANA and SAP HANA components. Apply support package stacks. Update the SAP HANA studio on local machines. Update SAP HANA replication technology components.
(SAMPLE QUESTIONS: C_HANATEC141) Which of the following are pre-delivered template roles? Note: There are 2 correct answers to this question. MONITORING IMPORT SAP_INTERNAL_HANA_SUPPORT MODELING.
(SAMPLE QUESTIONS: C_HANATEC141) A user cannot query an information model because of missing authorizations. What is the fastest way to find out which authorization is missing? Please choose the correct answer. Query the system view EFFECTIVE_PRIVILEGES. Investigate the authorization trace. Use the authorization dependency viewer. Check the assigned roles in the user editor.
(SAMPLE QUESTIONS: C_HANATEC141) Which of the following actions are required in the SAP HANA studio to use the Enhanced Change and Transport System (CTS+)? Note: There are 2 correct answers to this question. Create a delivery unit that contains all of the runtime objects. Create the HTTP connection named CTSDEPLOY. Configure the connection to the CTS in the preferences. Use an authorized user to attach SAP HANA content to transport requests.
(SAMPLE QUESTIONS: C_HANATEC141) Where in the SAP HANA studio can you change the path of the backup folder? Note: There are 2 correct answers to this question. Backup catalog executor.ini global.ini Backup editor.
(SAMPLE QUESTIONS: C_HANATEC141) Which of the following can performed in the SAP HANA lifecycle manager? Note: There are 3 correct answers to this question. Uninstall an SAP HANA system. Rename an SAP HANA system. Add an additional SAP HANA system. Copy an SAP HANA system. Change the SAP HANA license type.
(SAMPLE QUESTIONS: C_HANATEC141) What is the maximum number of master name servers that you can define in a distributed landscape? Please choose the correct answer. 1 2 8 3.
(SAMPLE QUESTIONS: C_HANATEC151) Which authorization error do you troubleshoot using the Authorization Dependency Viewer? Please choose the correct answer. SQL processing error (256) Invalid user privilege (334) Invalidated procedure (430) Transaction error (128).
(SAMPLE QUESTIONS: C_HANATEC151) You want to update a productive SAP HANA system to the next support package stack (SPS). What are the prerequisites? Note: There are 3 correct answers to this question. You applied the new license key for the new SPS. You performed a backup of the system. You know the <sid>adm password. You planned a business downtime for the system. You prepared the data and log area in the file system.
(SAMPLE QUESTIONS: C_HANATEC151) You have SAP HANA and ABAP content that is exclusively used by ABAP for SAP HANA. You want to transport this content together. Which of the following options can you use for this transport? Note: There are 2 correct answers to this question. SAP HANA Application Lifecycle Manager (SAP HALM) SAP HANA Transport Container (SAP HTC) Enhanced Change and Transport System (CTS+) Export and Import of the Delivery Unit (DU).
(SAMPLE QUESTIONS: C_HANATEC151) Which tasks can you perform using the resident SAP HANA lifecycle management tool? Note: There are 3 correct answers to this question. Uninstall SAP HANA components. Add additional hosts to the SAP HANA system. Copy an SAP HANA system. Change the license of the SAP HANA system. Rename the SAP HANA system.
(SAMPLE QUESTIONS: C_HANATEC_10) What can you do on the Configure Alerts tile in the SAP HANA cockpit? Note: There are 2 correct answers to this question. Run the checks regardless of their status. Schedule the execution of the checks. Set a threshold value which triggers the check run. Cancel a running check from the list.
(SAMPLE QUESTIONS: C_HANATEC_10) You plan to install an SAP HANA database in an SAP HANA Tailored Datacenter Integration (TDI) scenario. Which SAP HANA installation tools are required? Note: There are 2 correct answers to this question. hdbinst hdbsetup hdblcmgui hdblcm.
(SAMPLE QUESTIONS: C_HANATEC_10) You execute an authorization trace in the SAP HANA studio. Where can you review the outcome? Please choose the correct answer. In the result screen of the trace configuration. In the indexserver trace diagnosis file. In the authorization dependency viewer. In the monitoring view M_SERVICE_TRACES.
(SAMPLE QUESTIONS: C_HANATEC_11) Your customer is performing a full data backup every week and a delta backup daily. You need to implement the shortest recovery method for an SAP HANA database. Which recovery order is the fastest? Please choose the correct answer. 1. Full data backup 2. Log backup 3. Incremental backup 1. Full data backup 2. Incremental backup 3. Log backup 1. Full data backup 2. Differential backup 3. Log backup 1. Full data backup 2. Log backup 3. Differential backup.
(SAMPLE QUESTIONS: C_HANATEC_11) You are setting up a disaster recovery system using system replication. You want the transaction processing of the primary system to be suspended if the network to the secondary system fails. What log replication mode must you use? Please choose the correct answer. async syncmem sync full sync.
(SAMPLE QUESTIONS: C_HANATEC_11) Which role do you need to have assigned to configure the kernel profiler? Please choose the correct answer. MONITORING SAP_INTERNAL_HANA_SUPPORT sap.hana.xs.lm.roles::Administrator sap.hana.admin.roles::Monitoring.
(SAMPLE QUESTIONS: C_HANATEC_11) What is the correct hierarchy of the SAP HANA component model? Please choose the correct answer. Product > Package > Delivery Unit > Object Package > Product > Delivery Unit > Object Delivery Unit > Product > Package > Object Product > Delivery Unit > Package > Object.
(SAMPLE QUESTIONS: C_HANATEC_11) You are planning a batch installation for a scale-out system. Which settings do you need to make in the configuration file? Note: There are 2 correct answers to this question. The instances on all hosts must use an identical instance number. The user ID of the <sid>adm user must be identical on all hosts. The max_mem parameter must be specified for the sum of all hosts The hostname specified must be identical on all hosts.
(SAMPLE QUESTIONS: C_HANATEC_11) What privileges can you manage with the SAP HANA Live authorization assistant? Note: There are 2 correct answers to this question. Analytical Application System Object.
(SAMPLE QUESTIONS: C_HANATEC_11) You have to load data in real time from external systems into SAP HANA. Which Data Provisioning tools can you use? Note: There are 3 correct answers to this question. SAP LT Replication Server (SLT) Smart Data Access (SDA) SAP Replication Server (SRS) SAP Data Services (SDS) Smart Data Integration (SDI).
(SAMPLE QUESTIONS: C_HANATEC_11) You are using SAP Solution Manager to troubleshoot your SAP HANA database. What can you analyze? Note: There are 3 correct answers to this question. Memory usage Linux system logs Locked users Alert status Services availability.
(SAMPLE QUESTIONS: C_HANATEC_11) Which of the following tools can you use to create and manage SAP HANA database users? Note: There are 2 correct answers to this question. SAP Solution Manager SAP Identity Management SAP Web IDE Microsoft Active Directory.
(SAMPLE QUESTIONS: C_HANATEC_12) On which tile can you monitor the operation mode of the SAP HANA cockpit? Please choose the correct answer. System Replication Database Status General Information Latest Alerts.
(SAMPLE QUESTIONS: C_HANATEC_12) What happens when you start the SAP HANA database? Note: There are 2 correct answers to this question. For the ROW tables, the secondary indexes are created during load. For the COLUMN tables, the primary indexes are created during load. The ROW store is completely loaded into the memory. The COLUMN store is completely loaded into the memory.
(SAMPLE QUESTIONS: C_HANATEC_13) You created data and log backups on the file system. Due to a hardware failure, you use the Recover Database app in SAP HANA cockpit 2.0 to recover the crashed SAP HANA database. From which location does the Recover Database app read the recovery information by default? Please choose the correct answer. $(DIR_INSTANCE)/../global/hdb/custom/config $(DIR_INSTANCE)/backup/log $(DIR_INSTANCE)/<hostname>/trace $(DIR_INSTANCE)/backup/data.
(SAMPLE QUESTIONS: C_HANATEC_13) What can you do to shorten the startup time of an SAP HANA system after a reboot? Please choose the correct answer. Set the preload column value in the Tables system table to FULL. Flag all columnar tables for preload. Set the savepoint interval to a lower value. Partition the row store across nodes.
(SAMPLE QUESTIONS: C_HANATEC_13) Which of the following traces is active after the SAP HANA installation is completed? Please choose the correct answer. SQL Plan Performance Database.
(SAMPLE QUESTIONS: C_HANATEC_13) Which prerequisites must be met to set up high availability for a distributed SAP HANA system? Note: There are 2 correct answers to this question. The column tables were assigned to an index server manually. The name server is started on all nodes. The synchronized backup savepoint is set. The shared storage is connected to every host.
(SAMPLE QUESTIONS: C_HANATEC_13) Which security settings can you monitor in SAP HANA cockpit 2.0? Note: There are 2 correct answers to this question. Data Storage Security Password Policy Manage Database Backups Manage Users.
(SAMPLE QUESTIONS: C_HANATEC_13) You are monitoring the application server of an SAP S/4 HANA system. You need to investigate on the SAP HANA database, but someone locked your personal SAP HANA user. Which tools can you use to execute an SQL query? Note: There are 2 correct answers to this question. SQL Command Editor of the DBA Cockpit on the application server SAP HANA studio on the SAP HANA server HDBSQL command line tool on the SAP HANA server SAP HANA cockpit 2.0 on a central server.
(SAMPLE QUESTIONS: C_HANATEC_13) Which tasks must you perform to convert a single database to a multitenant database system? Note: There are 2 correct answers to this question. Set the password for the system database user. Trigger the conversion in the SAP HANA cockpit 2.0. Generate the system database before the conversion. Create an operating system user for the converted tenant database.
(SAMPLE QUESTIONS: C_HANATEC_13) You implement a multi-host SAP HANA system with auto-failover capabilities. What are the requirements for the disk storage? Note: There are 2 correct answers to this question. The slave node is set to backup standby. The failed worker host gets fenced during failover. The standby host has file access. The master node is fully clustered .
(SAMPLE QUESTIONS: C_HANATEC_14) What is a prerequisite for a system replication when the development (DEV) system and the quality (QA) system are installed on the secondary site? Please choose the correct answer. The preload of tables must be switched off. The global allocation limit must be identical. The SIDs and instance numbers must be identical. The DEV and QA systems must be online during system takeover.
(SAMPLE QUESTIONS: C_HANATEC_14) You install SAP HANA for productive usage, but the installation stops because the hardware check failed. How do you resolve this issue? Please choose the correct answer. Run the HanaHwCheck.py script before resuming the installation. Use the hdbinst command to install the SAP HANA database directly. Use SAP HANA database lifecycle manager (HDBLCM) to edit the configuration. Use a hardware configuration listed in the Product Availability Matrix.
(SAMPLE QUESTIONS: C_HANATEC_14) Which combination of source and target systems is allowed when you perform a database copy in a scale-out scenario? Please choose the correct answer. The source system can have 4 hosts. The target system can have 2 hosts. The source system can have 2 hosts. The target system can have 4 hosts. The source system can have 4 index servers. The target system can have 2 index servers. The source system can have 2 index servers. The target system can have 4 index servers.
(SAMPLE QUESTIONS: C_HANATEC_14) Which connection is used when you view or edit alerts in the Configure Alerts app using SAP HANA cockpit 2.0? Please choose the correct answer. The SQL connection with a technical user The https connection with the system user The https connection with the <sid>adm user The SQL connection with a named user.
(SAMPLE QUESTIONS: C_HANATEC_16) Assume your current partitioning plan of SAP HANA is NOT optimal. Which option of the Manage Table Distribution tool do you use to evaluate if a partitioned table needs to be repartitioned? Please choose the correct answer. Check the number of partitions Balance table distribution Redistribute tables after adding host(s) Check the correct location of tables and partitions.
(SAMPLE QUESTIONS: C_HANATEC_16) SAP HANA system replication is configured and active between two SAP HANA systems. After which action must you perform manual steps to synchronize the systems? Please choose the correct answer. A restart of the primary system A restart of the secondary system An upgrade of the secondary system An upgrade of the primary system.
(SAMPLE QUESTIONS: C_HANATEC_16) SQL statements are rejected by the Workload Admission Control application, and you need to investigate the reason. Which parameters do you adjust to manage the event log? Note: There are 2 correct answers to this question. queue_wait_time_threshold record_limit queue_timeout max_queue_size.
(SAMPLE QUESTIONS: C_HANATEC_16) You install an SAP HANA database and SAP NetWeaver AS ABAP 7.5 on one productive system. Which of the following installation requirements are mandatory? Note: There are 2 correct answers to this question. The disk resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same. The instance number for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same. The memory resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be added. The System ID (SID) for the SAP NetWeaver AS ABAP system and the SAP HANA database must be different.
(SAMPLE QUESTIONS: C_HANATEC_16) You plan to migrate a non-SAP database to SAP HANA using the database migration option (DMO) of the Software Update Manager. Which processes can you adjust in the advanced mode to speed up the migration? Note: There are 2 correct answers to this question. TP SQL SAPup R3trans.
(SAMPLE QUESTIONS: C_HANATEC_16) Which tools do you use to delete diagnosis files? Note: There are 2 correct answers to this question. SAP HANA cleaner SAP HANA Web-based Development Workbench SAP HANA cockpit SAP HANA database explorer.
(SAMPLE QUESTIONS: C_HANATEC_16) You create a new user by copying an existing user. Which predelivered role of the existing user is automatically granted to the new user? Please choose the correct answer. Runtime Modeling Repository Monitoring.
(SAMPLE QUESTIONS: C_HANATEC_16) The data storage of your productive SAP HANA instance crashed, and you need to recover the database. The log storage is still intact. You have a full data backup that is 9 hours old and an incremental backup that is 4 hours old. To which point in time can you recover to minimize the data loss? Please choose the correct answer. The latest log backup The last full data backup The latest incremental backup The last commited transaction.
(SAMPLE QUESTIONS: C_HANATEC_16) What do you need to size before you install SAP HANA in a tailored data center integration (TDI) scenario? Note: There are 3 correct answers to this question. Input/output operations per second (IOPS) Network throughput Persistent storage SAP Application Performance Standard (SAPS) Main memory.
Where does the acronym SHINE stand for? Choose the correct answers. SAP HANA INdex Engine SAP Hybris INteractive Enterprise SAP HANA INteractive Education SAP Hybrid IN-memory Engine.
When connected to the SAP HANA database, which HDBSQL command displays general information about the database? Choose the correct answer. \di \s \c \a.
(SAMPLE QUESTIONS: C_HANATEC_16) Where is the name server running in a multitenant database container system? SYSTEMDB Each tenant Standby node Master node.
(SAMPLE QUESTIONS: C_HANATEC_14) Which connection type can a standard restricted user use to connect to the SAP HANA database? ODBC HTTP(S) TCP/IP JDBC.
(SAMPLE QUESTIONS: C_HANATEC_14) Which fault recovery features can you implement to make your SAP HANA 2.0 production system more resilient against local hardware errors and software faults? Note: There are 2 correct answers to this question. Host auto-failover Service auto-restart Auto log backups Storage replication.
(Remembered Questions C_HANATEC_16) On which storages are read on delta merge? Note: There are 3 correct answers to this question. Main 1 Delta 1 Main 2 Delta 2.
(Remembered Questions C_HANATEC_16) Which analytical technology is DBA Cockpit use for evaluation of HANA Database? Business Intelligence (BI) system Diagnostics Agent Host Agent RFC Connection.
(Remembered Questions C_HANATEC_16) Which resource groups are delivered by default with Hana Cockpit 2.0 Note: There are 3 correct answers to this question. Development Test Production Sandbox Custom.
(Remembered Questions C_HANATEC_16) What requirements must be met if the hdblcmweb is to be used? Note: There are 2 correct answers to this question. Host agent port 1129 is reachable HANA revision 90 or higher Diagnostics Agent is installed The root user's password is known.
(Remembered Questions C_HANATEC_16) Which operating system is required to install HANA Cockpit on an IBM Power LPAR? Note: There are 2 correct answers to this question. SLES 12 RHEL 7.2 SLES 11 SP 4 SLES 15.
(Remembered Questions C_HANATEC_16) What defines a restricted user? Note: There are 2 correct answers to this question. Restricted users initially have no privileges This user type is intended for users who use HANA via a client application User has CATALOG READ privilege The user can establish connections via JDBC/ODBC.
(Remembered Questions C_HANATEC_16) What are the limitations of a restricted user compared to a standard user? Note: There are 3 correct answers to this question. You cannot create objects in the database, not even in your own schema You cannot view data because you are not authorized to do so and cannot have the standard PUBLIC role You can only connect via HTTP (S) You can create objects in your own schema You can connect via ADONet.
(Remembered Questions C_HANATEC_16) Which backup types can be continued in the event of a failed recovery by simply restarting? Note: There are 3 correct answers to this question. Differential Log Recovery Full Data Backup Data Snapshot Storage Snapshot Incremental.
(Remembered Questions C_HANATEC_16) Which OS is approved for using HANA 1.0 on IBM Power Systems? Please choose the correct answer. SLES 11 SP4 SLES 12 RHEL 6.5 RHEL 7.2.
(Remembered Questions C_HANATEC_16) Which OS is approved for using HANA 2.0 on IBM Power Systems? Note: There are 3 correct answers to this question. SLES 12 SLES 15 RHEL 7.3 and newer RHEL 7.2 SLES 11 SP4.
(Remembered Questions C_HANATEC_16) What are the requirements and preparations for an upgrade from HANA 1.0 to HANA 2.0? Note: There are 2 correct answers to this question. HANA 1.0 SPS 10 or higher Before migrating to HANA 2.0, it is recommended to upgrade HANA 1.0 to SPS 12 in order to use Capture & Replay SYSTEM user must be created manually SYSTEMDB must be created manually.
(Remembered Questions C_HANATEC_16) What needs to be done to enable cross-tenant database access? Note: There are 3 correct answers to this question. Switch on cross-tenant access Cross-tenant communication channel must be whitelisted A remote identity must be added in the target DB A remote user is required who has exactly the same name as the user in the source DB Cross-tenant DB Access is active by DEFAULT.
After confirming Lock now, which actions are still possible? Choose the correct answer. Developing via ABAP workbench (SE80) Applying SAP notes via SAP Note Assistant (SNOTE) Creating and changing application data (e.g. VA01) and user master records (SU01) Releasing and importing transport requests via the Transport Manager (SE09) and Transport Management System (STMS).
Which of the following web sites are SAP HANA documentation web sites? Choose the correct answer. https://help.sap.com/viewer/product/SAP_HANA_PLATFORM https://support.sap.com/swdc https://www.sap.com/community/topics/hana.html.
Which SAP HANA Lifecycle Management Tools can be used to change configuration settings? Choose the correct answer. hdblcm hdbinst Resident hdblcm hdbsetup.
During a SAP HANA installation, which operating system user account is assigned to the trusted local secure store (LSS)? Choose the correct answer. <sid>adm sapadm SYSTEM <sid>crypt.
What is the correct order when registering resources and creating resource groups and SAP HANA cockpit users with the cockpit manager? Choose the correct answer. Resources, Resource Groups, Cockpit Users Resource Groups, Resources, Cockpit Users Cockpit Users, Resources, Resource Groups There is no fixed order to follow.
Which of the following SAP HANA license key types locks down the system when the current memory consumption of SAP HANA exceeds the licensed amount of memory? Choose the correct answer. Temporary license key Unenforced license key Enforced license key.
Which inter-service communication properties binds the processes to entered address only and to all local host interfaces? Choose the correct answer. Global Internal Local.
In the context of the SAP HANA maintenance strategy, new features and functions on the SAP HANA platform are shipped in what kind of bundle? Choose the correct answer. SAP HANA standard revisions SAP HANA maintenance revisions Support package stack (SPS) Support packages (SP).
In which SAP HANA server process does the statistic service of a tenant database run? Choose the correct answer. Name server Daemon Compile server Index server.
Which of the following system views provides violation information about unsupported values for configuration parameters in your SAP HANA database system? Choose the correct answers. CONFIGURATION_PARAMETER_PROPERTIES M_LANDSCAPE_HOST_CONFIGURATION M_CONFIGURATION_PARAMETER_VALUES M_BACKUP_CONFIGURATION.
Which of the following traces has the default configuration status “Active”? Choose the correct answer. Performance trace Database trace SQL trace Plan trace.
Which tool can you use to set up SAP HANA system replication in one step? Choose the correct answer. SAP HANA Studio SAP HANA Web IDE SAP HANA cockpit hdbnsutil.
(Remembered Questions C_HANATEC_16) What authorization is required for the Dynamic Tiering Option? EXTENDED STORAGE ADMIN privilege EXTENDED DATA ADMIN privilege DATA ADMIN privilege USER ADMIN privilege.
(Remembered Questions C_HANATEC_16) What role does only exist at runtime? Catalog Role Design-Time Role Repository Role.
(Remembered Questions C_HANATEC_16) What role cannot be transported between systems? Catalog Role Design-Time Role Repository Role.
(Remembered Questions C_HANATEC_16) Which statement applies to catalog roles? Note: There are 2 correct answers to this question. No versioning The database user who created it owns the role Versioning is possible A technical database user owns the role.
(Remembered Questions C_HANATEC_16) How are catalog roles assigned? They are assigned and removed directly from a database user using SQL GRANT and SQL REVOKE They are automatically assigned via transport management They are only assigned by assigning other HDI roles.
(Remembered Questions C_HANATEC_16) What happens to the assigned catalog roles when the "GRANTING USER" is deleted? The assigned authorizations are withdrawn The assigned permissions are not withdrawn The assigned authorizations are automatically included in higher-level roles and are retained.
(Remembered Questions C_HANATEC_16) What is possible or not possible during the creation of catalog roles? The role can be mapped to an LDAP group The assignment of privileges cannot be made directly Inheritance of roles can be activated.
(Remembered Questions C_HANATEC_16) Which statement about HDI containers are true? Note: There are 3 correct answers to this question. An HDI container can be viewed like a database schema Several HDI containers can exist in a HANA database All objects of the HDI container belong to a container-specific technical owner There may only be one HDI container per HANA database All objects of the The container-specific techincal user container belong to the _SYS_REPO user.
(Remembered Questions C_HANATEC_16) What are the requirements to create Design-Time Repository Roles? Note: There are 3 correct answers to this question. Authorization object sap.hana.xs.ide.roles :: EditorDeveloper role must be assigned A shared project with a suitable package for storing the role must exist Package privileges on the required package must be granted A transport authorization must be assigned No authorizations necessary, since the _SYS_REPO user has all authorizations.
(Remembered Questions C_HANATEC_16) What are characteristics of hana mdc? Note: There are 4 correct answers to this question. It is only identified via a single system ID (SID) The name server only runs in the SYSTEMDB and contains landscape information about the system as a whole The name server offers index server functionalities for the SYSTEMDB The SYSTEMDB name server does NOT contain any topology information (such as table locations and table partitions) The name server of the SYSTEMDB contains topology information (such as table locations and table partitions) The name server does NOT offer index server functionalities for the SYSTEMDB.
(Remembered Questions C_HANATEC_16) Which services only run on the SYSTEMDB and serve all Tenant databases? Note: There are 2 correct answers to this question. Compile Server Preprocessor Server Indexserver Webdispatcher Nameserver.
(Remembered Questions C_HANATEC_16) What activities have to be carried out to set the database isolation level "high"? Note: There are 3 correct answers to this question. Create a tenant OS user <tn1_user> with the primary group sapsys Create the group <sid_shm> and add the <tn1_user> Create the group tn1_group and add the <tn1_user> Creation of the group dba Create the group sapsys Inclusion of the <tn1_user> in the oper group.
(Remembered Questions C_HANATEC_16) What needs to be done to get the database in a consistent state for data snapshot? Create database internal snapshot Delta Merge Logbackup Data Snapshot.
(Remembered Questions C_HANATEC_16) What are the options for a Tenant database copy? Note: There are 3 correct answers to this question. Backup & Recovery Data snapshot at max. 1 tenant DB Copy tenant with system replication hdblcm Storage Snapshot.
(Remembered Questions C_HANATEC_16) What security tiles are there in the HANA Cockpit? Note: There are 3 correct answers to this question. User & Role Management Authentication Auditing HANA Firewall Network security.
(Remembered Questions C_HANATEC_16) What can a user be assigned directly via the cockpit? Note: There are 3 correct answers to this question. roles groups privileges passwords Security Questions.
(Remembered Questions C_HANATEC_16) Which certificates can NOT be stored in the in-database certificate store, but in PSE files? Note: There are 2 correct answers to this question. System PKI (internal communication) HTTP client access via web dispatcher SAML X.509 SAP Logon and Assertion.
(Remembered Questions C_HANATEC_16) Which channels can HANA encrypt? Note: There are 4 correct answers to this question. Between container databases Between hosts at scale-out Between HANA databases and Additional Server Components Between HANA systems with system replication System PKI HTTP connections of the web dispatcher.
(Remembered Questions C_HANATEC_16) What can you do with the ALL PRIVILEGES privilege? All operations on tables, views or table types All operations in one schema All operations in the database.
(Remembered Questions C_HANATEC_16) What does the HWCCT check? Note: There are 3 correct answers to this question. Validation of the hardware setup (CORE / MEM ratio, ..) Validation of the OS setting (Linux kernel, supported Linux Distribution) Data throughput and latencies between HANA and storage Configuration of the backup settings Password guidelines on HANA and OS level.
(Remembered Questions C_HANATEC_16) What does the HWCCT check? Note: There are 2 correct answers to this question. Check the LPAR settings under IBM Power Server Min. Bandwidth between HANA hosts at scale-out (intra-node) Configuration of the VMWare VM Configuration of the storage system.
(Remembered Questions C_HANATEC_16) What accesses are there to the shared storage with scale-out? Note: There are 2 correct answers to this question. Master name server has access to its own volume Master name server has access to all volumes Slave host has access to all volumes Standby host has access to all volumes.
(Remembered Questions C_HANATEC_16) Which file systems are shared in scale-out scenarios? Note: There are 3 correct answers to this question. /hana/data/<sid> /hana/log/<sid> /hana/shared /usr/sap/<sid> /sapmnt/<sid>.
(Remembered Questions C_HANATEC_16) When do you need SAP Expert Sizing? Note: There are 3 correct answers to this question. Consolidation of several ERP systems into a single ERP on SAP HANA Carve-out of ERP functionalities of a source system in ERP on SAP HANA Migration of a high-volume legacy system to SAP HANA Customers who want to use SAP software Customers who want to migrate existing NetWeaver-based systems to SAP HANA.
(Remembered Questions C_HANATEC_16) How does a technical co-deployment work? Note: There are 3 correct answers to this question. a HANA DB with one schema one AS ABAP app server Only available for SRM and SCM as an ERP add-on Several AS ABAP app servers A HANA DB with several schemas Available for all combinations of systems.
(Remembered Questions C_HANATEC_16) When is the shadow repository copied to the HANA DB at a SUM DMO? In the uptime phase In the downtime phase Right at the beginning of the SUM process At the end of the SUM process.
(Remembered Questions C_HANATEC_16) Which additional components can be deployed via SAP HANA HALM? Note: There are 3 correct answers to this question. SAP HANA SHINE SAP HANA Live Customer Developments Third Party Applications SAP AS ABAP Coding SAP AS Java Coding.
(Remembered Questions C_HANATEC_16) Which binary is controlled by the "Troubleshoot unresponsive system" app? hdbcons hanasitter HDBAdmin sapcontrol.
(Remembered Questions C_HANATEC_16) What does the binary "hdbcons" check? Note: There are 4 correct answers to this question. DB Connections Transactions Blocked Transactions Threads Expensive SQL Statements SQL Plan Cache.
(Remembered Questions C_HANATEC_16) When should the "Troubleshoot unresponsive system" app be started? When SQL connections are no longer possible If the CPU utilization is too high If sapcontrol delivers no results.
(Remembered Questions C_HANATEC_16) Which statement applies to System Replication with Delta Data Shipping? Delta data shipping takes place in addition to the continuous log shipping Delta data shipping takes place in addition to the continuous log shipping with Active/Active.
(Remembered Questions C_HANATEC_16) What privileges are required to view the roles assigned to other users? Note: There are 2 correct answers to this question. USER ADMIN DATA ADMIN CATALOG READ ROLE ADMIN.
(Remembered Questions C_HANATEC_16) What is the maximum CPU / RAM allocation for a Scale-Up S / 4 HANA system? 6TB / 8 Sockets 6 TB / 10 Sockets 8 TB / 8 Sockets 8 TB / 10 Sockets.
(Remembered Questions C_HANATEC_16) Which connections do you need to enable explicitly for a Restricted User? Note: There are 2 correct answers to this question. JDBC ODBC ADO.NET OLEDB.
(Remembered Questions C_HANATEC_16) Determine Log Volume Size, that it is based on best practice and experiences with productive SAP HANA installations. Note: There are 4 correct answers to this question. 128 GB system ≥ Size log volume = 64 GB 256 GB system ≥ Size log volume = 256 GB 512 GB system ≥ Size log volume = 256 GB 2 TB system ≥ Size log volume min = 1 T 4 TB system ≥ Size log volume min = 2 T 1 TB system ≥ Size log volume min = 512 GB 1 TB system ≥ Size log volume min = 1 T 3 TB system ≥ Size log volume min = 512 GB.
(Remembered Questions C_HANATEC_16) Which are the standard shared file systems for the data files and log files are configured, so that they are present and mounted on all hosts, including the primary host prerequisite for creating a multi-host system? Note: There are 3 correct answers to this question. /hana/shared /hana/data/<sid> /hana/log/<sid> /hana/shared/<sid> /usr/sap/<sid> /usr/sap/<SID>/HDB<instance> /usr/sap/hdbclient.
Witch system privilege can only be granted to users of the system database? DATABASE ADMIN INIFILE ADMIN USER ADMIN ROLE ADMIN DATA ADMIN.
Which replication modes are supported for system replication with a read-enabled secondary site? Choose the correct answer. SYNC Full SYNC SYNCMEM ASYNC All.
Which operating systems are supported when installing SAP HANA cockpit on IBM Power hardware? Choose the correct answer. Red Hat Enterprise Linux (RHEL) SUSE Linux Enterprise Server (SLES) Ubuntu Server (UBSE) Slackware Linux (SLLI).
Which components of an in-memory appliance do you need to consider for sizing? Choose the correct answer. Storage Memory CPU.
(Remembered Questions C_HANATEC_16) Which option do you choose to protect your SAP HANA scale-out system using host auto-failover? Please choose the correct Answer. System replication Automatic savepoint Storage replication Standby node.
(Remembered Questions C_HANATEC_16) During the delta merge process, to which memory areas is data inserted? Note: There are 2 correct answers to this question. Delta 2 Main 1 Main 2 Delta 1.
(Remembered Questions C_HANATEC_16) What do you need to size before you install SAP HANA in a tailored data center integration (TDI) scenario? Note: There are 3 correct answers to this question. SAP Application Performance Standard (SAPS) Network throughput Input/output operations per second (IOPS) Main memory Persistent storage.
(Remembered Questions C_HANATEC_16) Which connection types are allowed when you use system replication with the Active/Active option? Note: There are 2 correct answers to this question. Automatic round-robin statement routing Implicit hint-based statement routing Explicit read only on the secondary system Explicit read and write on the secondary system.
(Remembered Questions C_HANATEC_16) How do you ensure that web-based applications send https requests to specific db in an SAP HANA multiple-container system? Note: There are 2 correct answers to this question. Check the hostname mappings to internal https ports Check that all requests with physical hostname are forwarded to tenant databases Configure an sap web dispatcher for every tenant database Configure an alias hostname for every tenant db.
(Remembered Questions C_HANATEC_16) Which value for the Autostart parameter do you use to control the automatic start of an SAP HANA system? Please choose the correct answer. On Off 0 1.
(Remembered Questions C_HANATEC_16) The administration console is pre-delivered by SAP. You can access the administration console in one of the following ways. Note: There are 3 correct answers to this question. Choose the Administration button in the upper right corner Double-click the system in the Navigator view Choose the Administration button in the upper left corner Double-click the system monitor in the Navigator view Double-click the system in the system monitor.
(Remembered Questions C_HANATEC_16) You migrate a database using the database migration option. Which tools are available to monitor the migration? Note: There are 2 correct answers to this question. Table Depooling monitor Process Bucket monitor Table Splitting monitor Log Tail Viewer monitor.
(Remembered Questions C_HANATEC_16) You switched the SAP HANA database to normal log mode. When does the system perform a regular log backup? Note: There are 2 correct answers to this question. After the configured time threshold has been exceeded When the log segment is full When a savepoint occurs When the log buffer is full.
(Remembered Questions C_HANATEC_16) What is the the recommended disk space for /hana/shared/<SID> for single-node SAP HANA systems Please choose the correct Answer: Size [installation(single-node)] = MIN (2 x RAM; 1 TB) Size [installation(single-node)] = MIN (2 x RAM; 2 TB) Size [installation(single-node)] = MAX (2 x RAM; 1 TB) Size [installation(single-node)] = MIN (1 x RAM; 1 TB).
(Remembered Questions C_HANATEC_16) Why would you implement the SAP HANA Data Warehousing Foundation? Please choose the correct Answer: To implement a SQL-driven approach to data warehousing To enable reporting on SAP HANA data using the full suite of SAP BusinessObjectse To improve the loading and reporting performance of SAP Business Warehouse To add OLAP data warehousing capabilities to SAP HANA.
(Remembered Questions C_HANATEC_16) Which of the following tools can be used for User Administration? Note: There are 3 correct Answers to this question. SAP HANA Cockpit Resident hdblcm SAP NetWeaver Identity Management hdbsql.
(Remembered Questions C_HANATEC_16) Which administration tool can you use to start and stop the SAP HANA database system? Please choose the correct answer. SAP HANA HDBSQL SAP Landscape Management DBA Cockpit SAP Solution Manager.
(Remembered Questions C_HANATEC_16) Which migration features are supported when using the Database Migration Option (DMO) feature of SAP Software Update Manager (SUM)? Note: There are 2 correct answers to this question. The source and target database system are of the same type The source system is Application Server (AS) Java-based The target database is SAP Adaptive Server Enterprise (ASE). The Primary Application Server can be moved to a target system Landscape.
(Remembered Questions C_HANATEC_16) Why do you create a time dimension calculation view? Please choose the correct answer. To enhance a calculation view with a drilldown on a time hierarchy To support temporal joins in a cube calculation view with star schema To enable time dependency on parent-child hierarchies To provide date-based help values for a DIRECT type input parameter.
(Remembered Questions C_HANATEC_16) What do you need in a Multitenant Database Container (MDC) system to run queries across tenant databases? Note: There are 2 correct answers to this question. The user in the source system must be associated with a user in the target database The user in the source system must have sufficient privileges in the target database The cross-tenant database communication must be explicitly activate The bidirectional communication channel must be whiteliste.
(Remembered Questions C_HANATEC_16) Which preparation steps do you need to perform before replaying a captured workload using the SAP HANA capture and replay tool? Note: There are 3 correct answers to this question. Preprocess the captured workload on the source system. Create a replayer user account on the target operating system. Create a replayer user account in the target database system. Restore the source system tenant backup to the target tenant. Store the logon credentials of the replayer user in the secure store.
(Remembered Questions C_HANATEC_16) Which preparation tasks do you need to perform before starting the copy and move process for a tenant database? Note: There are 3 correct answers to this question. Create credentials for authenticated access to the target system. Configure a secure connection from target system to source system Create credentials for authenticated access to the source system. Back up the source tenant database. Create a tenant on the target system identical to the source system.
(Remembered Questions C_HANATEC_16) Which prerequisites of the primary system and the secondary system are mandatory before you can activate the SAP HANA system replication with secondary time travel? Note: There are 2 correct answers to this question. The CPU architecture must be identical. Both systems are located in the same data center. An explicit read-only connect on between both systems must be available Both must have the same SAP HANA version.
(Remembered Questions C_HANATEC_16) During the Installation, the following users are created automatically. Which of them is the SAP Host Agent administrator? sapadm user adm user SYSTEM user.
(Remembered Questions C_HANATEC_16) Which of the following actions are possible when managing roles? Note: There are 3 correct answers to this question. A role can contain multiple other roles. A role can be nested to multiple other roles. A role can contain either other roles or privileges but not both together A role can contain other roles and privileges at the same time.
(Remembered Questions C_HANATEC_16) Which of the following actions are audited by default in SAP HANA? There are 2 correct Answer:s to this question. Changes to system configuration Installation of SAP HANA license Deletion of audit entries from the audit trail Creation, modification or deletion of audit policies .
(Remembered Questions C_HANATEC_16) Which of the following are characteristics of SAP HANA Smart Data Streaming? Please choose the correct answer: It uses databases queries. It acts based on combinations of events. It provides reports and analysis on the received data. It is a standalone product for use with any target system.
(Remembered Questions C_HANATEC_16) Which tools shows the differences of tables and indexes between your abap dictionary and your SAP HANA Database? Please choose the correct answer: DBAcockpit SAP HANA cockpit HDBSQL HDBLCM.
(Remembered Questions C_HANATEC_16) What can you check with the SAP HANA Hardware Configuration Check Tool (HWCCT)? Note: There are 2 correct answers to this question. Missing OS patches Memory configuration Network configuration Kernel settings.
(Remembered Questions C_HANATEC_16) You are monitoring the application server of an SAP S/4 HANA system. You need to investigate on the SAP HANA database, but someone locked your personal SAP HANA user. Which tools can you use to execute an SQL query? Note: There are 2 correct answers to this question. HDBSQL command line tool on the SAP HANA server SAP HANA cockpit 2.0 on a central server SQL Command Editor of the DBA Cockpit on the application server SAP HANA studio on the SAP HANA server .
(Remembered Questions C_HANATEC_16) Which replication modes keep the primary system waiting until a timeout is exceeded when the secondary system is not available? Note: There are 2 correct answers to this question. SYNC FULL SYNC ASYNC SYNCMEM.
(Remembered Questions C_HANATEC_16) SAP HANA, in the context of user management, allows you to do which of the following? Note: There are 3 correct answers to this question. Create a restricted user Lock and unlock users Assign a user to a user group Create and delete users.
(Remembered Questions C_HANATEC_16) You need to integrate an existing SAP HANA 2.0 SPS02 database system into SAP HANA cockpit monitor infrastructure where do you create the technical user created for the resource registration Please choose the correct answer: in the SYSTEMDB in the first tenant in the SYSTEMDB and the all tenant in the SYSTEMDB and the first tenant.
(Remembered Questions C_HANATEC_16) You plan to setup a sap hana 2.0 system on intel-based platforms. Which of the following Operating system can you use? Note: There are 2 correct answers for this questions Radhat enterprise linux for sap hana (RHEL for SAP HANA) 6.5 Suse linux enterprise server (SLES for sap application 11 sp1) Suse linux enterprise server (SLES for sap application 12 sp1) Radhat enterprise linux for sap hana (RHEL for SAP HANA) 7.2.
(Remembered Questions C_HANATEC_16) Your customer wants to know when the productive SAP HANA system was updated and to which version. Where do you find this information? There are 2 correct answers to this question In the catalog view of the SAP HANA Web-based Development Workbench In the SAP HANA database explorer for SAP HANA cockpit 2.0 In the administration editor of the SAP HANA studio In the General Information app of SAP HANA cockpit 2.0.
(Remembered Questions C_HANATEC_16) Which tool do you use during the Database Migration Option (DMO) procedure to monitor table splitting? Please choose the correct answer. The Log viewer The Observer Monitor The Process Bucket monitor The R3LDCTL.
(Remembered Questions C_HANATEC_16) You administer a single-host system with 100gb physical memory. The global allocation limit and the individual service allocation are set to 90%. Three services are running. Service 1 has 25GB of memory allocated and service 2 has 40gb allocated. What is the effective allocation of service 3? Please choose the correct answer: 90GB 100 GB 35GB 25GB.
(Remembered Questions C_HANATEC_16) What is included with the Predictive Analysis Library (PAL)? NOTE: There are 2 correct answers to this question. Data preparation functions Text mining functions Flowgraphs Predictive algorithms.
(Remembered Questions C_HANATEC_16) Which information is provided by the backup catalog Please choose the correct answer: Backup ID Backup configuration Backup destination Progress of a backup.
(Remembered Questions C_HANATEC_16) You can establish SAP Solution Manager connectivity and configure a Remote Service Connection (via SAP Router) as part of the initial setup. Since Solution Manager 7.1 SP04, the SAP HANA databases can be integrated into SAP Solution Manager. What are these components can be integrated into SAP HANA database? Note: There are 3 correct answers to this question. The transaction DBACockpit SAP HANA Database Performance Warehouse Diagnostics agent Alerting Infrastructure.
(Remembered Questions C_HANATEC_16) Which diagnostic file can you use to monitor the status of database recovery? Please choose the correct answer. Backinit.log Sapstartsrv.log Available.log Backup.log.
(Remembered Questions C_HANATEC_16) Which processor combinations are allowed for the primary system and secondary system in an Active/Active system replication setup? Note: There are 2 correct Answer:s to this question. Primary IBM Power Secondary IBM Power Primary IBM Power Secondary Intel-based Primary Intel-based Secondary Intel-based Primary Intel-Based Secondary IBM Power.
(Remembered Questions C_HANATEC_16) Your application runs with a technical user in a database of an SAP HANA multitenant database container. You want to execute a query across tenant databases. Which of the following prerequisites are required? Note: There are 2 correct answers to this question. User sharing Communication channel whitelist User mapping Bi-directional communication channels.
(Remembered Questions C_HANATEC_16) Reloading column tables in this way restores the database to a fully operational state more quickly. However, it does create performance overhead, and may not be necessary in nonproductive systems, how can you deactivate the reload feature? Please choose the correct answer. Edit the indexserver.ini file by setting the reload_tables parameter in the sql section to true Edit the indexserver.ini file by setting the reload_tables parameter in the sql section to false Edit the indexserver.xml file by setting the reload_tables parameter in the sql section to false Edit the indexserver.xml file by setting the reload_tables parameter in the sql section to false.
(Remembered Questions C_HANATEC_16) Which statement is wrong regarding Operational Data Marts? Please choose the correct answer. No transformation during load step (only selection of relevant data if applicable) Views calculate results for reports in real time on the actual operational data Real-time replication of time critical data (SLT/SRS) Typically contains no time critical data and therefore utilize traditional ETL.
(Remembered Questions C_HANATEC_16) What are advantages of column store tables? Note: There are 3 correct answers to this question. Data footprint is automatically reduced through compression Only the columns required are actually loaded to memory Columns can be partitioned They are optimized for high-volume read / write transactional processing.
(Remembered Questions C_HANATEC_16) The application data of the SAP NetWeaver-based applications are stored in the schema SAP<Schema-ID> of the SAP HANA system, Which of the following statement is biased to perform if you change the SAP<Schema-ID> password of a NetWeaver based system? Note: There are 2 correct answers to this question. No need to update the ABAP SSFS of the Domain\SAPService<SAPSID> (Windows) You must update the relevant DEFAULT connection entries in the hdbuserstore Update the ABAP SSFS of the <sapsid>adm (Linux) Use the old password when establishing the connection.
(Remembered Questions C_HANATEC_16) Which authorization assignments are possible when you set up an authorization concept in the SAP HANA database? Note: There are 2 correct Answer:s to this question. A role can be granted to a catalog object. A privilege can be granted to a user. A role can be granted to a role. A user can be granted to a role.
(Remembered Questions C_HANATEC_16) Which scale-out roles can you assign to the hosts in the nameserver.ini file? Note: There are 2 correct answers to this question. WORKER MASTER 1 STANDBY SLAVE.
(Remembered Questions C_HANATEC_16) A user is complaining about missing privileges when executing a query. How do you configure the indexserver trace to obtain the missing privileges? Please choose the correct answer: Select trace level Debug for the authenticationcodec component. Select trace level Error for the auditing component. Select trace level Info for the authorization component. Select trace level Warning for the authentication component.
(Remembered Questions C_HANATEC_16) What is XS? Please choose the correct answer: A data cleansing engine An optional engine to handle excessive data loads A native, lightweight application server A user interface.
(Remembered Questions C_HANATEC_16) Where can you check the trace and log files when your SAP HANA database is NOT available? Note: There are 2 correct answers to this question In the Diagnosis Files app of the SAP HANA cockpit for offline administration In the Trace app of the SAP HANA Web-based Development Workbench In the /usr/sap/<SID>/HDB<instance number>/<host>/trace path on the operating system In the Troubleshoot Unresponsive System app of SAP HANA cockpit 2.0.
(Remembered Questions C_HANATEC_16) When you use the database migration option reset procedure as a fallback scenario, which of the changes made during the migration are NOT reset? Note: There are 3 correct answers to this question. The DBACOCKPIT user on the SAP HANA database The SAP ABAP kernel on the application server The deleted SAP BusinessObjects Business Intelligence data on the non-SAP database The updated BRTOOLS on the non-SAP database The shadow schema on the non-SAP database.
(Remembered Questions C_HANATEC_16) Why might you want to reference a user-provided service in a project? Please choose the correct answer. To access data from another container To access data from your project container To access data from a classic database schema.
(Remembered Questions C_HANATEC_16) The design-time version of a security role can contain which of the following information? Note: There are 2 correct answers to this question. The users assigned by default to this role The role name The users assigned to the role The privileges assigned to the role.
(Remembered Questions C_HANATEC_16) What are the merge methods that are triggered by the SAP HANA system processes? There are 2 correct Answer:s to this question. Critical Auto Hard Smart.
(Remembered Questions C_HANATEC_16) What is the correct sequence of the following four steps in the restart of the SAP HANA database system? Please choose the correct answer. 1. Aborted transactions are rolled back. 2. Open transactions are recovere 3. Row tables are loaded into memory. 4. Column tables are loaded 1. Row tables are loaded into memory. 2. Open transactions are recovere 3. Aborted transactions are rolled back. 4. Column tables are loaded 1. Row tables are loaded into memory. 2. Column tables are loaded 3. Open transactions are recovere 4. Aborted transactions are rolled back. 1. Aborted transactions are rolled back. 2. Row tables are loaded into memory. 3. Open transactions are recovere 4. Column tables are loaded.
(Remembered Questions C_HANATEC_16) Which steps can be combined in a DMO procedure, targeting an AS ABAP 7.50 based SAP system? Note: There are 2 correct answers to this question. Performing a database upgrade of the source database Performing an SAP software update Performing a Unicode conversion Migrating to a target database, g. SAP HANA.
(Remembered Questions C_HANATEC_16) When can you load and unload individual tables and table columns manually in an SAP HANA tenant database? Note: There are 2 correct answers to this question. When you need to actively free up memory. When you need to extend the scale-out memory. When you need to optimize the standby node memory. When you need to measure total memory.
(Remembered Questions C_HANATEC_16) What do you do to prepare the database migration option of a Software Update Manager procedure? Note: There are 3 correct answers to this question Extract the SAP HANA database installation archive. Move the SPAM update archive into the download folder. Move the R3trans update archive into the download folder. Extract the SAP HANA client installation archive. Move the stack.xml update file into the download folder.
(Remembered Questions C_HANATEC_16) Which prerequisites apply when you perform an SAP HANA database copy of a single tenant system? Note: There are 2 correct answers to this question. The version of the target database is the same as or higher than the source database The restore point in time (PIT) of the target database is the same as or earlier than the source database The number of nodes on the target database is the same as or lower than the source database The number and type of services on the target database can be different from the source database.
(Remembered Questions C_HANATEC_16) Once you start the SAP HANA cockpit 2.0, From the Aggregated Health Monitor, navigate to the SAP HANA system overview page. This page displays the detailed status of the selected SAP HANA system. Which of the following options are listed? Note: There are 3 correct answers to this question. Performance Management Security Monitoring and Administration Memory Management Resource Management.
(Remembered Questions C_HANATEC_16) Which of the following SAP HANA capability allows you to load and replicate data in real time from ABAP source systems and non-ABAP source systems to an SAP HANA environment? Please choose the correct answer. SAP HANA remote data sync SAP HANA dynamic tearing SAP HANA landscape transformation replication server SAP HANA smart data streaming.
(Remembered Questions C_HANATEC_16) Which information can you collect by running the fullSystemInfoDump.py script when the SQL connection is available? Please choose the correct answer: A selection of rows of schema SAP<SID> A selection of .trc files A selection of rows of schema _SYS_XS A selection of .log files.
(Remembered Questions C_HANATEC_16) Which components of SAP HANA Indexserver allow clients to connect and communicate with the SAP HANA database? Please choose the correct answer: Request Processing and Execution Control Relational Engines Storage Engine and Disk Storage External Interfaces.
(Remembered Questions C_HANATEC_16) At the end of the SAP HANA Cockpit 2.0 installations, how can you obtain the URL of the SAP HANA cockpit and the SAP HANA cockpit manager? Please choose the correct answer. Installation config screen COCKPIT_ADMIN user logs Installation log file Installation logs screen.
(Remembered Questions C_HANATEC_16) Which of the following system privileges can you assign to an SAP HANA database user? There are 3 correct answers to this question. CREATE SCHEMA EXPORT DEVELOPMENT CREATE ANY EXECUTE.
(Remembered Questions C_HANATEC_16) Which role do you need in order to assign users to groups in SAP HANA cockpit? Please choose the correct answer. Cockpit User Cockpit Resource Administrator Cockpit User Administrator Cockpit Administrator.
(Remembered Questions C_HANATEC_16) Which of the following tasks can you perform using the resident SAP HANA database lifecycle manager (HDBLCM)? Note: There are 3 correct answers. Remove host roles Uninstall the individual components Rename the SAP HANA database system Transport application changes Rename the SAP HANA Database hostname.
(Remembered Questions C_HANATEC_16) Your SAP HANA database is locked down. Which action can you still perform? Please choose the correct answer. Configure system properties Check database license Check overall database status Check session memory.
(Remembered Questions C_HANATEC_16) You migrate an SAP HANA system using SUM database migration option. Which activities do you perform to activate the viewer mode for SAP support? Note: There are 2 correct answers. Provide the sum observer URL to SAP support Provide the SUM URL to SAP support Create the OS user <sid>obs on the application server Create the database user <sid>obs on the application server.
(Remembered Questions C_HANATEC_16) Which actions are always recorded when auditing is active? Note: There are 2 correct answers. Create or drop user Modification of an audit policy Disable auditing Grant or revoke user .
(Remembered Questions C_HANATEC_16) What is a characteristic of the synchronous in-memory system replication mode in SAP HANA? Please choose the correct answer. The primary system does NOT wait for confirmation of the secondary system The primary system suspends transactions processing until the connection to the secondary system is established The primary system waits until the secondary system confirms receiving the log The primary system waits until the secondary system confirms the log was persisted.
(Remembered Questions C_HANATEC_16) Which tools can you use to start and stop an SAP HANA database? Note: There are 3 correct answers. Sapcontrol DBA cockpit HDB command SAP HANA application life cycle management (HDBLCM) SAP HANA cockpit .
(Remembered Questions C_HANATEC_16) Which script can you trigger from SAP HANA cockpit to collect diagnosis information? Please choose the correct answer. hanadumpviewer.py fullSystemInfoDump.py hanachecker.py HanaHwCheck.py.
(Remembered Questions C_HANATEC_16) You needt to integrate an existing SAP HANA 2.0 SPS03 database system into the SAP HANA cockpit monitor infrastructure. Where do you create the technical user needed for the resource registration? Please choose the correct answer. In the SYSTEMDB and the first tenant In the SYSTEMDB and all tenants In the first tenant In the SYSTEMDB.
(Remembered Questions C_HANATEC_16) How can you minimize the database migration option (DMO) downtime? Please choose the correct answer. Adjust the number of R3load processes during benchmarking and the DMO procedure Use the benchmarking tool for a productive database migration with the DMO procedure Run the benchmarking tool parallel to the DMO to automatically adjust the number of R3load processes Provide the measured table migration duration for table sequencing during benchmarking .
(Remembered Questions C_HANATEC_16) Which tools can you use to start and stop tenants in an SAP HANA database? Note: There are 2 correct answers. SAP HANA cockpit 2.0 - Manage Databases sapcontrol SAP HANA Studio - System view hdbsql.
(Remembered Questions C_HANATEC_16) Due to a hardware failure of your persistence area, your SAP HANA database needs to be restored. Which tasks do you perform to recover the complete system? Note: There are 2 correct answers. Start the recovery from the system database SAP HANA cockpit 2.0 Recover the system database before recovering all tenant databases Start the recovery from the tenant database using SAP HANA cockpit 2.0 Recover all the databases using Initialize Log Area option.
(Remembered Questions C_HANATEC_16) Which action do you perform when the data area in an SAP HANA database is running out of space? Please choose the correct answer. Create a new database volume Create a new tenant database Extend the file system size in the operating system level Extend the size of the database volume.
(Remembered Questions C_HANATEC_16) Which programming languages are supported when you develop an application on SAP HANA extended application Note: There are 2 correct answers. Lisp.js C++ Node.js ABAP.
(Remembered Questions C_HANATEC_16) What must you do to convert an SAP HANA 1.0 single database system to an SAP HANA 2.0 multitenant database system? Please choose the correct answer. Upgrade the SAP HANA database system Export/import application and customer data Create the system database manually Execute the SUM database migration option with system move.
(Remembered Questions C_HANATEC_16) Which removal statuses allow you to remove a host from an SAP HANA scale-out landscape Note: There are 2 correct answers. Reorg finished Reorg pending Reorg not required Reorg active.
(Remembered Questions C_HANATEC_16) Which operations are performed by SAP Landscape Management? Note: There are 2 correct answers. It simplifies the management of SAP hybrid landscapes and standardizes SAP operations It replicates the storage in SAP landscape It de-centralizes landscape operations and provides local landscape view It automizes repetitive, time-intensive administration tasks.
(Remembered Questions C_HANATEC_16) Which tool shows the difference of tables and indexes between your ABAP dictionary and your SAP HANA database? Please choose the correct answer. SAP HANA cockpit DBA Cockpit hdbsql hdblem.
(Remembered Questions C_HANATEC_16) Why does SAP HANA have a persistence storage layer that is disk-based? Note: There are 2 correct answers. To ensure maximum performance To allow a restart if the power fails To persist in-memory data To enable database scale-up .
(Remembered Questions C_HANATEC_16) You need to analyze the high CPU load of running thread in more detail in the Thread Monitor. Which parameters do you need to change? Note: There are 2 correct answers. cpu_time_measurement_mode enable_tracking threshold_cpu_time load_monitor_granularity.
(Remembered Questions C_HANATEC_16) A technical user is required when you register an SAP HANA system as a resource in SAP HANA cockpit 2.0. Which system privileges do you assign to the technical user account on the target system? Please choose the correct answer. CATALOG READ USER ADMIN DATA ADMIN MONITOR ADMIN.
(Remembered Questions C_HANATEC_16) Which information is recorded in the database trace of the SAP HANA database? Please choose the correct answer. Performance indicators on a query level Executed SQL statements on database level Database activities with the trace level ERROR Query execution plans on an application level.
(Remembered Questions C_HANATEC_16) Which kinds of patches are available in the SAP HANA 2.0 revision strategy? Note: There are 2 correct answers. Datacenter Service Point Feature Package Stack Support Package Support Package Stack.
(Remembered Questions C_HANATEC_16) Which encryption services can you activate in SAP HANA? Note: There are 3 correct answers. Log Backup Pages in-memory Storage snapshot Data.
(Remembered Questions C_HANATEC_16) How can you shorten the delta merge runtime of a table? Note: There are 2 correct answers. Perform memory-only delta merges Fully load the delta store into memory Partition the table Merge per column.
(Remembered Questions C_HANATEC_16) The network security policies of your project restrict direct SQL connections to the SAP HANA databases. Which tools can you use to monitor the SAP HANA database? Note: There are 2 correct answers. SAP HANA Data Management Suite SAP HANA Cockpit SAP Solution Manager SAP Landscape Management.
(Remembered Questions C_HANATEC_16) You setup email notification for a specific alert threshold by using Alerts Configuration. When are the email notification sent? Note: There are 2 correct answers. When the alert checker is turned off When the alert checker identifies a resolved issue When the alert checker identifies an issue When the alert checker identifies a recurring issue.
(Remembered Questions C_HANATEC_16) What happens when you rename a tenant in an SAP HANA database Note: There are 2 correct answers. The backups are renamed The logs are renamed The database is renamed The directories are renamed.
(Remembered Questions C_HANATEC_16) You define the parameters for the password policy of an SAP HANA tenant database. Where are these parameters stored? Please choose the correct answer. multidb.ini global.ini indexserver.ini nameserver.ini.
(Remembered Questions C_HANATEC_16) After you start the SAP HANA database, what does the system do to ensure that it is in a consistent mode? Please choose the correct answer. It reloads a savepoint with the restored consistent state of the database It rolls back write transactions that were open when the database was stopped It rolls back changes of committed transactions that were NOT written to the data area It determines and rolls forward aborted transactions.
(Remembered Questions C_HANATEC_16) Which SQL privileges can you grant to another user? Please choose the correct answer. ATTACH DEBUGGER CATALOG READ DATA ADMIN CREATE SCHEMA.
(Remembered Questions C_HANATEC_16) Which information is stored in the SYSTEMDB of an SAP HANA multitenant database container system? Note: There are 2 correct answers. Monitoring data in the SYSTEMDB and all tenant databases Topology data on the location of tables and table partitions Users and authorizations of the SYSTEMDB and all tenant databases Landscape topology data on the system as a whole.
(Remembered Questions C_HANATEC_16) You installed an SAP Netweaver-based application on an SAP HANA database. What is the default secure user store to store the password of the SAP<schema-id> user? Please choose the correct answer. Secure store in file system (SSFS) xuser hdbuserstore ABAP secure store file system (SSFS).
(Remembered Questions C_HANATEC_16) Which certificates do you require for a trusted secure communication between the client and the SAP HANA database? Note: There are 2 correct answers. User certificate Server certificate Root certificate X.509 certificate.
(Remembered Questions C_HANATEC_16) You register a new resource in SAP HANA cockpit 2.0. What prerequisite does the resource require? Please choose the correct answer. A user with DATA ADMIN privileges and SELECT on _SYS_TELEMETRY schema The target database on SAP HANA 2.0 SPS00 or higher A multitenant configuration with SYSTEMDB A user with CATALOG READ privileges and SELECT on _SYS_STATISTICS schema .
(Remembered Questions C_HANATEC_16) What must you do to configure the data backup on a scale-out SAP HANA system? Note: There are 2 correct answers. Ensure the availability of shared backup storage Change the backup configuration for each node Verify that data and log backup destinations are valid throughout the system Specify the individual backup destination on each node.
(Remembered Questions C_HANATEC_16) You install a productive multi-host system with failover capabilities. Which storage condition prerequisites must be ensured? Note: There are 2 correct answers. The failed worker host has access to write files The standby host has NO file access The standby host has file access The failed worker host no longer has access to write to files.
(Remembered Questions C_HANATEC_16) In which replication mode is the primary system blocked until the secondary system is available? Please choose the correct answer. full sync sync async syncmem.
(Remembered Questions C_HANATEC_16) Which R3load mode is used during an inplace SUM database migration option procedure? Please choose the correct answer. Socket Pipe File Network.
(Remembered Questions C_HANATEC_16) Which information can you analyze using the Troubleshoot Unresponsive System application? Please choose the correct answer. System availability CPU utilization Thread status Alerts count.
(Remembered Questions C_HANATEC_16) You are installing several SAP HANA systems with a standard setup. How can you automate this activity? Please choose the correct answer. Copy the complete install folders to all hosts Export and import the standard configurations from SAP HANA cockpit Copy the ini files to all systems Generate a configuration template using hdblcm.
(Remembered Questions C_HANATEC_16) How can you ensure that the critical database system properties CANNOT be changed by tenant database administrators? Please choose the correct answer. Set up cross-database access control Assign internal communication ports Edit the configuration change blacklist Set database isolation levels to high.
(Remembered Questions C_HANATEC_16) You need to recover a tenant database backup from SAP HANA system 1 into SAP HANA system 2. Which activities do you perform to restore the tenant? Note: There are 2 correct answers. Start the recovered tenant database Create the tenant in the target database Copy the transaction logs to the target database Recover the tenant with the Initialize Log Area option.
(Remembered Questions C_HANATEC_16) Which target database does the SUM databases migration option provide by default? Note: There are 2 correct answers. SAP IQ SAP HANA SAP MaxDB SAP ASE.
(Remembered Questions C_HANATEC_16) Which tool do you use to backup the root encryption keys? Please choose the correct answer. rsecssfx dbacockpit hdbnsutil hdbuserstore.
(Remembered Questions C_HANATEC_16) What is a prerequisite before you can install SAP HANA Cockpit 2.0 as a central monitoring tool for productive SAP HANA databases? Please choose the correct answer. A dedicated server with at least 16 GB RAM with SUSE Linux Enterprise Server (SLES) or Red Hat Enterprise Linux (RHEL) A central SAP HANA database 2.0 with SAP HANA extended application services, advanced model (XS Advanced) installed SAP Netweaver 7.5x on SAP HANA 2.0 with ABAP Core Data Services (CDS) and SAP Fiori installed A central SAP HANA database 2.0 SPS02 multitenant database system with at least 16 GB of RAM.
(Remembered Questions C_HANATEC_16) Which SAP HANA feature ensure that committed data is NOT lost if there is a power failure? Note: There are 2 correct answers. Automatic savepoints Delta merge Persisted redo logs Memory allocation limit.
(Remembered Questions C_HANATEC_16) What are some advantages of a system replication with operation mode logreplay compared to delta_datashipping Note: There are 2 correct answers. CPU load is reduced Memory consumption is lower Takeover time is shorter Network traffic is reduced.
(Remembered Questions C_HANATEC_16) You plan to set up an SAP HANA 2.0 system on intel-based hardware platform. Which of the following operating systems can you use? Note: There are 2 correct answers. SUSE Linux Enterprise Server (SLES) for SAP Applications 12 SP1 Red Hat Enterprise Linux for SAP HANA (RHEL for SAP HANA) 7.2 SUSE Linux Enterprise Server (SLES) for SAP Applications 11 SP1 Red Hat Enterprise Linux for SAP HANA (RHEL for SAP HANA) 6.5.
(Remembered Questions C_HANATEC_16) One of your systems show the internal Disk Full (Alert 30) alert. What is the root cause of this alert? Please choose the correct answer. Writing to the /hana/data/<sid> volume is NOT possible Runing out of free space on the /hana/shared volume Reading from the /hana/log/<sid> volume is NOT possible Exceeding system quota on the /usr/sap volume.
(Remembered Questions C_HANATEC_16) The recovery of your productive SAP HANA database fails during log replay. What is the fastest solution to complete the recovery Please choose the correct answer. Resume the recovery from beginning Resume the interrupted recovery Replay the delta backups and log backups Restart the database and resume the interrupted recovery.
(Remembered Questions C_HANATEC_16) Which tools can you use to monitor the response time of individual SQL queries? Note: There are 2 correct answers. Statement Monitor SQL plan cache SQL Trace Thread Monitor.
(Remembered Questions C_HANATEC_16) Which trace do you use to create a graphical representation of an individual SQL Statement? Please choose the correct answer. SQL trace Plan trace Expensive statements trace Performance trace.
(Remembered Questions C_HANATEC_16) Which partitioning option distributes rows equally for load balancing in the SAP HANA database? Please choose the correct answer. Hash Range-Range Range RoundRobin.
(Remembered Questions C_HANATEC_16) You perform an SAP HANA migration to a scale-out landscape. When do you setup the table distribution? Please choose the correct answer. After table creation Before table creation After the migration Before the migration.
(Remembered Questions C_HANATEC_16) How do you trigger a savepoint in an SAP HANA database? Please choose the correct answer. Perform a soft shutdown Commit a transaction Start a log backup Execute a delta merge.
(Remembered Questions C_HANATEC_16) For which scenarios is it mandatory to define the authorizations at HANA Level? There are 2 correct answers to this question. SAP S/4HANA SAP HANA Live for SAP Business Suite Business Suite on HANA Web-based native applications based on XS.
(Remembered Questions C_HANATEC_16) Witch SAP HANA features can you use to manage the database work load? Note: There are 2 correct answers to this question. Thread throttling Capture and replay Admission control Workload classes.
(Remembered Questions C_HANATEC_16) Who ownes a SAP HANA Development Infrastruction (HDI) role? Please choose the correct answer. The container specified technical user The user who created the role The _SYS_REPO technical user The SYSTEM user of the tenant database.
(Remembered Questions C_HANATEC_16) Which can you directly assign to a user with the Manage Users app in SAP HANA Cockpit Note: There are 2 correct answers to this question. Roles Privileges Role collections Scopes.
(Remembered Questions C_HANATEC_16) Which privileges are assigned automaticly when you crates a technical user during the register ressource procedure in SAP HANA Cockpit? Note: There are 2 correct answers to this question. SELECT on the _SYS_TELEMETRY schema SELECT on the _SYS_STATISTICS schema CATALOG READ RESOURCE ADMIN.
(Remembered Questions C_HANATEC_16) The recovery of your productive SAP HANA tenant database fails. In which cases can you resume the database recovery? Note: There are 2 correct answers to this question. Aborted recovery of a delta data backup Aborted recovery of a complete data backup Aborted recovery of a log backup Aborted recovery of the configuration files.
(Remembered Questions C_HANATEC_16) Which properties can you configure in SAP HANA Admission Control? Note: There are 3 correct answers to this question. Maximum request queue size Memory limit for queing requests Maximum parallel IO requests SQL statement request memory limit CPU threshold for rejecting requests.
(Remembered Questions C_HANATEC_16) Which is the relationship between the user group operator and the user group? Note: There are 2 correct answers to this question. Multiple user group operators per user group Multiple user groups per user group operator Only one user group operator per user group Only one user group per user group operator.
(Remembered Questions C_HANATEC_16) How are hosts assigned to the shared storage in the SAP HANA scale out scenario? Note: There are 2 correct answers to this question. The slave servers are assigned to their own data volumes The master name server is assigned to the master data volume The standby server is assigned to the master data volume The master server is assigned to all data volumes.
(Remembered Questions C_HANATEC_16) How can you perform a complete back up of the SAP HANA database system? Please choose the correct answer. Back up the system database and all tenant databases individually Back up the system database and all tenant databases in one step Back up the complete database system Back up the complete storage system.
(Remembered Questions C_HANATEC_16) Which parameters are mandatory when using the hdblcm tool in batch mode? Note: There are 2 correct answers to this question. Data and Log Path Password of the user sapadm SAP HANA System ID (SID) Installation Path.
(Remembered Questions C_HANATEC_16) Which SAP HANA cockpit application can you use to investigate a system offline situation? Please choose the correct answer. CPU usage monitor Full system information dump Troubleshoot unresponsive system Out-of-memory event monitor.
(Remembered Questions C_HANATEC_16) Which alert configuration properties can you configure in SAP HANA cockpit? Note: There are 3 correct answers to this question. E-mail alert notification Alert checker category Alert threshold values Schedule activation Schedule period.
(Remembered Questions C_HANATEC_16) Which types of backups can you use to copy an SAP HANA tenant? Note: There are 2 correct answers to this question. Delta database backup Fallback snapshot Data snapshot Full database backup.
(Remembered Questions C_HANATEC_16) Logical error occurred in one tenant of your SAP HANA database. What action do you perform to make the tenant consistent Please choose the correct answer: Recover the system database first and then recover the affected tenant. Recover the system database. The affected tenant is recovered automatically. Recover the affected tenant first and then recover the system database. Recover the affected tenant. The system database is NOT recovered.
(Remembered Questions C_HANATEC_16) Which file systems are supported for the SAP HANA database system? Note: There are 2 correct answers to this question. EXT3 MPFS GPFS XFS.
(Remembered Questions C_HANATEC_16) Which informations are provided by the Manage Full System Information Dump tile in SAP HANA Cockpit? Note: There are 2 correct answers to this question. Diagnostics informations Runtime environment End-to-end Trace SAP HANA mini checks.
(Remembered Questions C_HANATEC_16) What do you mind in a Multitenant Database Container (MDC) system to use queries cross-tenant communication? Note: There are 2 correct answers to this question. The bidirectional communication channel must be whitelisted The user in the source system must have sufficient privileges in the target database The cross-tenant database communication must be explicitly activated The user in the source system must be associated with a user in the target database.
(Remembered Questions C_HANATEC_16) Which rules should you consider when creating a table distribution plan for SAP Business Suite on SAP HANA to get the best possible results? Note: There are 2 correct answers to this question. Keep the number of partitioned tables low Keep the number of key colums low Keep all partitions on different hosts Keep the number of partitions per table high.
(Remembered Questions C_HANATEC_16) Which prerequisites must be fulfilled when recovering a tenant database? Note: There are 2 correct answers to this question. Before the recovery starts, the tenant database must be stopped The whole system shut down, including all tenant databases You need the logon credentials of the system database user You need the logon credentials of the <sid>adm user.
(Remembered Questions C_HANATEC_16) Which prerequisites are mandatory for using the SAP HANA database Lifecycle manager (HDBLCM) Web user interface? Note: There are 2 correct answers to this question. Communication port 1129 is open SAP HANA database system in any version Installed SAP Host Agent on the SAP HANA host SAP HANA Client software locally installed.
(Remembered Questions C_HANATEC_16) What is a characteristic of the Detla Data Shipping operation mode in SAP HANA system replication? Please choose the correct answer: Delta data shipping takes place in addition to continuous log replay Delta data shipping takes place in addition to continuous log shipping Delta data shipping takes place with continuous read-only access to the secondary system Delta data shipping takes place every 5 minutes.
(Remembered Questions C_HANATEC_16) What is the first node limit for planning an SAP HANA scale-out system? Note: There are 2 correct answers to this question. >= 12 CPU >= 8 CPU >= 6 TB >= 8 TB.
(Remembered Questions C_HANATEC_16) Which backup and recovery scenario is allowed in multi-tenant database system? Please choose the correct answer: After the recovery of a tenant database, the system database needs a backup A backup of a tenant database can be recovered to the system database The system database should be recovered first in order to recover the tenant database A tenant database can initiate its own backup, but the system database restarts for recovery.
(Remembered Questions C_HANATEC_16) Which products do you use for SAP HANA administration? Note: There are 2 correct answers to this question. SAP Web IDE for SAP HANA SAP Master Data Governance SAP HANA cockpit SAP Solution Manager.
(Remembered Questions C_HANATEC_16) Which properties are mandatory for productifly using SAP HANA cockpit 2.0? Note: There are 2 correct answers to this question. 10 GBits network bandwidth An IBM Power System with operation system SUSE Linux Enterprise Server (SLES) An Intel-based system with operating system Microsoft Windows 16 GB RAM on an dedicated server.
(Remembered Questions C_HANATEC_16) What is the additional disk space that's required during delta merge operation? Please choose the correct answer: 3.0 1.2 4.0 1.6.
(Remembered Questions C_HANATEC_16) What do you have to consider when you perform a Tailroad Data Center Integration (TDI) installation for SAP HANA database system? Note: There are 2 correct answers to this question. Obtaining the hardware certification from sap for the hardware you are going to use Obtaining C_HANATEC_XX Certification Having the data and the log volumes on different disks Having 10Gbit/s for storage zone achd 1GBit/s for internet zone for outgoing communication.
(Remembered Questions C_HANATEC_16) Which preparation tasks do you need to perform before starting the Database Migration Option (DMO) process? Note: There are 2 correct answers to this question. Check if the latest SPAM/SAINT update is applied Extract the SAP HANA database software installation package Move the latest R3trans update archive into the download folder Update the SAP Host Agent to the latest version.
(Remembered Questions C_HANATEC_16) Which SAP HANA features are secured by certificates stored in the SAP HANA certificate store? Note: There are 2 correct answers to this question. SAP HANA tenant database replication HTTPS client access using the SAP HANA Web Dispatcher Client server communication over JDBC Internal communication channels with the system PKI.
(Remembered Questions C_HANATEC_16) Which preparations must you configre to add hosts to an SAP HANA scale-out system? Note: There are 2 correct answers to this question. The SAP HANA system should be on a shared files system The additional host is placed in a different data center The SAP HANA database server is shut down The host has access to the installation directories.
(Remembered Questions C_HANATEC_16) What is a prerequisite when you install the SAP Landscape Manager tool? Please choose the correct answer: SAP Netweaver Application Server Java SAP Fiori Launchpad SAP Netweaver Application Server ABAP SAP HANA XS Advanced.
(Remembered Questions C_HANATEC_16) What can you use the Secure User Store (hdbuserstore) for? Note: There are 2 correct answers to this question. To configure an SAP HANA Auto Restart Fault Recovery Snapshot To store connection information on the SAP HANA XS Advanced engine To configure failover support in an 3-tier scenario To store connection information on the SAP HANA database client.
(Remembered Questions C_HANATEC_16) What are the supported operating systems for SAP HANA on IBM Power Systems? Note: There are 2 correct answers to this question. For SAP HANA 1.0 SUSE Linux Enterprise Server (SLES) 11 SP4 For SAP HANA 2.0 SUSE Linux Enterprise Server (SLES) 12 und 15 For SAP HANA 2.0 SUSE Red Hat Enterprise Linux (RHEL) 7.2 For SAP HANA 1.0 SUSE Red Hat Enterprise Linux (RHEL) 6.10.
(Remembered Questions C_HANATEC_16) Which SAP HANA database service can you stop from the system database? Note: There are 2 correct answers to this question. Preprocessor Compile Server Index server XS Engine.
(Remembered Questions C_HANATEC_16) How are savepoints happened? Note: There are 2 correct answers to this question. By performing a database backup By performing a delta merge By issuing a transactional commit By a database soft shutdown.
(Remembered Questions C_HANATEC_16) Which checks are executed when you use the Hardware Configuration Check Tool (HWCCTOOL)? Note: There are 3 correct answers to this question. Validation of the operating system configuration settings for the Linux Kernel Measurement of the data throughput between CPU and RAM Measurement of the data throughput between the Linux Kernel and CPU Measurement of the data throughput between SAP HANA nodes and storage Validation of the LPAR configuration settings on IBM Power server.
(Remembered Questions C_HANATEC_16) Which replication modes keep the primary system waiting until a transaction is confirmed when the secondary system takes time? Note: There are 2 correct answers to this question. ASYNC FULL SYNC SYNC SYNCMEM.
(Remembered Questions C_HANATEC_16) How can you optimize the Database Migration Option (DMO) procedure procedure downtime for a production system? Note: There are 2 correct answers to this question. Provide the measured table migration duration data for optimized table partitioning during benchmarking Use the Test Cycle option to find the optimal counts of R3load processes in a test run Using the benchmarking option to find the optimal throughput during the DMO procedure Set the optimal number of R3load processes during benchmarking and the DMO procedure.
(Remembered Questions C_HANATEC_16) Which database objects can you manage if you have the _SYS_STATISTICS privilege? Note: There are 2 correct answers to this question. Tables Sequences Procedures Views.
(Remembered Questions C_HANATEC_16) Which is the correct sequence of the loading from storage in the memory of the SAP HANA database system? Please choose the correct answer: 1. Row tables are loaded into memory 2. Column tables are loaded 3. Open transactions are recovered 4. Aborted transactions are rolled back 1. Row tables are loaded into memory 2. Open transactions are recovered 3. Aborted transactions are rolled back 4. Column tables are loaded 1. Aborted transactions are rolled back 2. Open transactions are recovered 3. Row tables are loaded into memory 4. Column tables are loaded 1. Aborted transactions are rolled back 2. Row tables are loaded into memory 3. Open transactions are recovered 4. Column tables are loaded.
(Remembered Questions C_HANATEC_16) You are checking and monitoring SAP HANA database system replication. Which status indicates a temporary connection loss of the secondary system? Please choose the correct answer: Unknown Error Initializing Syncing.
(Remembered Questions C_HANATEC_16) Where are the R3load processes located when performing the Database Migration Option (DMO) procedure using the in-place migration? Please choose the correct answer: On the Primary Application Server (PAS) host On the remote target database host On the Additional Application Server (AAS) host On the source and target host.
(Remembered Questions C_HANATEC_16) Which database objects can you manipulate if you have the ALL Privileges activity? Note: There are 2 correct answers to this question. Procedures Views Tables Sequences.
(Remembered Questions C_HANATEC_16) Your customer has purchased a 1.5 TB SAP HANA license. To which value do you set the GLOBAL_ALLOCATION_LIMIT parameter when you have four 1TB nodes in an SAP HANA scale-out systemwith three worker and one standby nodes? Please choose the correct answer: 1.5 TB 1.0 TB 512 GB 375 GB.
(Remembered Questions C_HANATEC_16) Which tool do you use to investigate an SAP HANA system that is started but can't be reached using SQL? Note: There are 2 correct answers to this question. HANASitter hdbcons Sapcontrol HDBAdmin.
(Remembered Questions C_HANATEC_16) What are the two features of the storage engine in the SAP HANA index server that enable data consistency and maintain durable changes? Please choose the correct answer: Metadata Manager and Transaction Manager Column Store and Row Store Page Management and logger Session Management and log volumes.
(Remembered Questions C_HANATEC_16) Which system schema provides performance data and system alerts details to review in SAP HANA MiniChecks? Please choose the correct answer: _SYS_SQL_ANALYZER _SYS_TELEMETRY _SYS_STATISTICS _SYS_WORKLOAD_REPLAY.
(Remembered Questions C_HANATEC_16) Which user credentials are required during the initial run of the configuration phase when performing the Database Migration Option (DMO) procedure to an SAP HANA 2.0 database tenant? Note: There are 3 correct answers to this question. The DDIC user in client 000 of the ABAP system The SAPstar user in client 000 of the ABAP system The DBACOCKPIT user of the tenant database The SYSTEM user of the system database The S-user for the SAP Support Portal connection.
(Remembered Questions C_HANATEC_16) What is the correct minimum requirement for log volume and /hana/shared/ file system for an SAP HANA database system? Please choose the correct answer: For 512 GB system, Log volume = 512 GB, /hana/shared/ = 256 GB For 1 TB system, Log volume = 1 TB, /hana/shared/ = 1 TB For 256 GB system, Log volume = 128 GB, /hana/shared/ = 256 GB For 2 TB system, Log volume = 1 TB, /hana/shared/ = 1 TB.
(Remembered Questions C_HANATEC_16) Which parameters do you need to change before you can analyse the memory usage of running SQL statements? Note: There are 2 correct answers to this question. enable_tracking memory_tracking statement_memory_limit use_in_memory_tracing.
(Remembered Questions C_HANATEC_16) Who owns an SAP HANA Deployment Infrastructure (HDI) role? Please choose the correct answer: The SYSTEM user of the tenant database The _SYS_REPO techical user The user who created the role The container-specific techincal user.
(Remembered Questions C_HANATEC_16) Which prerequisites must you consider to add hosts to an SAP HANA scale-out system? (2 answers) Note: There are 2 correct answers to this question. The SAP HANA system installation should be on a shared files system The hosts has access to the installation directories The SAP HANA database is shut down The additional hosts is placed in a different data center.
(Remembered Questions C_HANATEC_16) Which charateristics describe an SAP HANA Multiple database Container (MDC) System? Note: There are 3 correct answers to this question. Each tenant database runs its own compile server and the preprocessor server The Database Isolation increases the isolation between tenant databases on the operating system A Multiple Database Container system is identified by a Single System ID (SID) The name server owns information about the location of tables and table partitions in database The name server provides index server functionality for the system database.
(Remembered Questions C_HANATEC_16) Which parameters do you set to protect an SAP HANA database system against uncontrolled queries that consume excessive memory? Note: There are 2 correct answers to this question. total_statement_memory_limit memory_tracking statement_memory_limit reject_memory_threshold.
(Remembered Questions C_HANATEC_16) How can you ensure that a consistent database status is saved using data snapshots? Please choose the correct answer: Create an internal database snapshot Trigger a savepoint Execute the hdbbackupdiag tool Create a fallback snapshot.
(Remembered Questions C_HANATEC_16) Which prerequisites must you consider to rename a tenant database in the SAP HANA cockpit? Note: There are 2 correct answers to this question. The tenant database is stopped The tenant database must be unloaded from memory The on-disk tenant directory should be a mount point The database that is not in move operation.
(Remembered Questions C_HANATEC_16) How are savepoints triggered? Note: There are 2 correct answers to this question. By performing a delta merge By a database soft shutdown By issuing a transactional commit By performing a database backup.
(Remembered Questions C_HANATEC_16) In a Multiple Database Container (MDC) system, which privilege do you need to perform database-specific backups on all tenant databases? Please choose the correct answer: BACKUP OPERATOR DATABASE ADMIN TENANT ADMIN BACKUP ADMIN.
(Remembered Questions C_HANATEC_16) Which SAP HANA database system usage types are automatically assigned to tiles in the SAP HANA Cockpit? Note: There are 3 correct answers to this question. Production Development Test Custom Sandbox.
(Remembered Questions C_HANATEC_16) Which user management tasks can be performed by a Lightweight Directory Acess Protocol (LDAP) server? Note: There are 2 correct answers to this question. User creation Password policy configuration Role assignment User mapping.
(Remembered Questions C_HANATEC_16) Which system privilege must you have to manage blacklisted parameters in SAP HANA cockpit? Please choose the correct answer: RESOURCE ADMIN INIFILE ADMIN WORKLOAD ADMIN DATABASE ADMIN.
(Remembered Questions C_HANATEC_16) Which checks are executed when you run the Hardware Configuration Check Tool (HWCCTL)? Note: There are 3 correct answers to this question. Measurement of data throughput between the Linux kernel and the CPU Measurement of data throughput between SAP HANA nodes and storage Measurement of the data throughput between CPU and DRAM Validation of the LPAR configuration settings on IBM Power servers Validation of the operating systems configurations settings for the Linux kernel.
(Remembered Questions C_HANATEC_16) Which activities do you have to carry out to configure your Multiple Database Container (MDC) System to a higher database isolation between tenant databases on the operating system (OS) level? Note: There are 3 correct answers to this question. Add dedicated tenant OS users to the <sid> shm group. Remove the <sid> adm OS user from the sapsys group. Add dedicated tenant OS users to the sapsys group. Create dedicated tenant OS user for each tenant. Lock the adm OS user.
(Remembered Questions C_HANATEC_16) Which default users will be created during the installation of the SAP HANA database? Note: There are 2 correct answers to this question. sapadm ldapadm sap <sid> <sid>crypt.
(Remembered Questions C_HANATEC_16) Which filesystem locations are suggested to install an SAP HANA multi-host system? Note: There are 2 correct answers to this question. /hana/<hostname> /hana/shared /hana/log/<sid> /hana/<sid>.
(Remembered Questions C_HANATEC_16) What additional action do you need to perform after you created a new tenant in an SAP HANA system Please choose the correct answer: Copy tenant database Restart secondary system Back up tenant database Start tenant database.
(Remembered Questions C_HANATEC_16) Which prerequisites are necessary for productively using SAP HANA Cockpit 2.0? Note: There are 2 correct answers to this question. An Intel-based system with operating system Microsoft Windows 16 GB RAM on dedicated server 10 Gbit/s network bandwidth An IBM Power System with operating system SUSE Linux Enterprise Server (SLES).
(Remembered Questions C_HANATEC_16) How can the system database administrator disable tenant database functionalities? Please choose the correct answer: Using the resident hdbclm tool Using the Manage Blacklisted Parameter app Using the Manage Restricted Features app Using the hdbuserstore tool.
(Remembered Questions C_HANATEC_16) Which SAP HANA trace must you activate to analyze performance issues with systems where third-party software cannot be installed? Please choose the correct answer: Kernel profiler End-to-End SQL User-Specific.
(Remembered Questions C_HANATEC_16) Which system privilege must you have to redistribute tables across the hosts in your scale-out system? Please choose the correct answer: WORKLOAD ADMIN DATA ADMIN RESOURCE ADMIN OPTIMIZER ADMIN.
(Remembered Questions C_HANATEC_16) Which system privileges are required for administrating tenant databases when being connected to the system database? Note: There are 2 correct answers to this question. DATA ADMIN MONITOR ADMIN BACKUP ADMIN DATABASE ADMIN.
(Remembered Questions C_HANATEC_16) Which SAP HANA features can you use to manage the database peak load? Note: There are 2 correct answers to this question. Workload classes Thread throttling Admission control Capture and replay.
(Remembered Questions C_HANATEC_16) In an SAP HANA database system running in log mode "normal”, in which situation does the system automatically execute a regular log backup? Note: there are 2 correct answers to this question When the time threshold is exceeded When a commit occurs When the log segment is full When the log buffer is full.
(Remembered Questions C_HANATEC_16) Which system schema provides performance data adn system alert detail to review in SAP HANA Mini checks? Please choose the correct answer: _SYS_STATISTICS _SYS_TELEMETRY _SYS_SQL_ANALYZER _SYS_WORKLOAD_REPLAY.
(Remembered Questions C_HANATEC_16) Which tables provides a customizing interface that can be used for the dynamic management of partitions and locations? Please choose the correct answer: EFFECTIVE_TABLE_PLACEMENT TABLE_GROUP UPDATE_LANDSCAPE_CONFIGURATION TABLE_PLACEMENT.
(Remembered Questions C_HANATEC_16) Which tasks can you perform using the SAP HANA database lifecycle manager (HDBLCM) on installation media? Note: There are 2 correct answers to this question. Update SAP HANA and its components Extract components Rename the SAP HANA database system Uninstall SAP HANA database components.
(Remembered Questions C_HANATEC_16) A developer at your customer starts a badly designed query. How do you stop this query? Please choose the correct answer: Use the Expensive Statements Trace app to stop the statement Use the Threads app to cancel the thread Use the Monitor Statements app to interrupt the statement Use the Sessions app to end the session.
(Remembered Questions C_HANATEC_16) A SAP HANA system is a database management system (DBMS); that is, it is a server component that manages a database model. Which of the following is the wrong statement regarding DBMS functions? Please choose the correct answer: Provides secure access to data using only <sid>adm authorization Maintains relationships between data Delivers high performance for processing data requests Recovers data automatically to the most recent consistent status after a system failure.
Report abuse Terms of use
HOME
CREATE TEST
INFO
STADISTICS
RECORDS
Author's Tests