High-performance Analytic Appliance (HANA) TEC Practice Exam

These questions are part of the practice quiz. Start practicing

• In SAP HANA, what is the effect of setting the retention policy for logs?
• How can you shorten the delta merge runtime of a table in SAP HANA?
• When does the SAP HANA system perform a regular log backup after switching to normal log mode?
• Which method is NOT involved in securing SAP HANA features?
• Which programming languages can you use for application development on SAP HANA extended application services?
• What information can the design-time version of a security role include?
• What specific information is essential about the tenant database before recovery?
• Which tool is commonly used for managing users in SAP HANA?
• Which rules should you consider when creating a table distribution plan for SAP Business Suite on SAP HANA?
• Which prerequisites must be met before recovering a tenant database in SAP HANA?
• What information can you analyze using the Troubleshoot Unresponsive System application?
• What configuration is needed to ensure that Web-based applications send HTTPS requests to specific databases in SAP HANA?
• Which feature of SAP HANA allows for automated workload management?
• When are email notifications sent based on the configured alert thresholds?
• Which prerequisites of the primary system and the secondary system are mandatory before activating SAP HANA system replication with secondary time travel?
• Which migration features are supported when using the Database Migration Option (DMO) feature of SAP Software Update Manager (SUM)?
• For effective resource management in SAP HANA, what should be done for each tenant in a multi-tenant system?
• How can you optimize downtime for a production system during the Database Migration Option (DMO) procedure?
• In what scenario would a system perform a delta merge?
• How can you minimize the database migration option (DMO) downtime?
• Why are repository roles preferred over catalog roles?
• What must you do to configure data backup on a scale-out SAP HANA system?
• What must be true of a database to rename it in the SAP HANA cockpit?
• Which SAP HANA trace should be activated to analyze performance issues where third-party software cannot be installed?
• Where are the R3load processes located when performing the Database Migration Option (DMO) procedure using in-place migration?
• What is a necessary condition for the tenant database when renaming it in SAP HANA cockpit?
• What privilege is required to perform database-specific backups on all tenant databases in an MDC system?
• Which parameters do you adjust to manage the event log when SQL statements are rejected by the Workload Admission Control application?
• How should you preprocess a workload before a replay in SAP HANA?
• Which of the following is a correct step for preparing a tenant database for operations in SAP HANA?
• Which removal statuses allow you to remove a host from an SAP HANA scale-out landscape?
• What is an appropriate action to take regarding table migration during the DMO procedure?
• What is the first node limit for planning an SAP S/4HANA scale-out system?
• What information can be collected by running the fullSystemlnfoDump.py script when the SQL connection is available?
• What tools can you use to monitor the SAP HANA database if direct SQL connections are restricted?
• What condition leads to a log backup when the log segment is full?
• To analyze high CPU load in the Thread Monitor, which parameters might need to be changed?
• Which process can increase efficiency during SAP HANA database migration?
• Which tasks can be performed using the resident SAP HANA database lifecycle manager (HDBLCM)?
• In the case of a hardware failure affecting the persistence area, what tasks must be performed to recover the SAP HANA database?
• Why is it important for the SAP HANA database system and SAP NetWeaver AS ABAP system to have different System IDs (SIDs)?
• You are installing several SAP HANA systems with a standard setup. How can you automate this activity?
• What is one of the key responsibilities of the SAP landscape management tool?
• Where are the parameters for the password policy of an SAP HANA tenant database stored?
• Which partitioning option distributes rows equally for load balancing in the SAP HANA database?
• During the DMO procedure, which feature assists in troubleshooting?
• During the delta merge process, to which memory areas is data inserted?
• Which feature provides the capability of creating automatic backups in SAP HANA?
• If three services in a single-host system are running, what is the effective allocation limit of service 3 given a total memory allocation?
• Which types of patches are included in the SAP HANA 2.0 revision strategy?
• Which tool is used to backup the root encryption keys in SAP HANA?
• When can you load and unload individual tables and table columns manually in an SAP HANA tenant database?
• When recovery fails during log replay of the SAP HANA database, what is the quickest solution to recover?
• Which function does the SAP HANA system installation rely on for scaling out?
• What is the first step to take when a user reports missing privileges while executing a query?
• Which prerequisites are necessary for using the SAP HANA database lifecycle manager (HDBLCM) Web user interface?
• What is the default role of the DBACOCKPIT user in the SAP HANA database?
• Which tool is used during the Database Migration Option (DMO) procedure to monitor table splitting?
• Which preparation tasks are necessary before starting the Database Migration Option (DMO) procedure?
• Which tools can be used to delete diagnosis files in SAP HANA?
• Which component of SAP HANA Indexserver facilitates client connections to the database?
• Which types of backups can be used to copy an SAP HANA tenant?
• What is the purpose of the load_monitor_granularity parameter in SAP HANA?
• What happens when you rename a tenant in an SAP HANA database?
• After what type of backup can you resume the incomplete recovery of an SAP HANA tenant database?
• What is the result of rolling back transactions after starting the SAP HANA database?
• What is essential to create in the target database system when preparing for the SAP HANA capture and replay tool?
• What should you set the GLOBAL_ALLOCATION_LIMIT parameter to in a 1.5 TB SAP HANA scale-out system with four 1TB nodes?
• When should you set up the table distribution during an SAP HANA migration to a scale-out landscape?
• Which schema provides performance data and system alert details in SAP HANA MiniChecks?
• Which file systems are supported for the SAP HANA database system?
• How is the system replication mode set in SAP HANA?
• What type of data is primarily affected by delta merges?
• What value for the Autostart parameter controls the automatic start of an SAP HANA system?
• What system privilege is required to manage blacklisted parameters in SAP HANA cockpit?
• How are savepoints triggered in an SAP HANA environment?
• Which two certificates are required for trusted secure communication between the client and the SAP HANA database?
• How can you perform a complete backup of an SAP HANA database system?
• What happens to the data footprint when using column store tables in SAP HANA?
• What type of server is specifically mentioned as a requirement for SAP HANA cockpit 2.0?
• In a Single-Host system with 100GB physical memory, what would the global allocation limit be set to?
• What is the role of the name server in an SAP HANA Multiple Database Container system?
• What R3load mode is used during an inplace SUM database migration option procedure?
• What is required to convert an SAP HANA 1.0 single database system to an SAP HANA 2.0 multitenant database system?
• Which replication modes keep the primary system waiting until a timeout is exceeded when the secondary system is not available?
• What is necessary for using SAP HANA cockpit 2.0 effectively?
• What is the default secure user store for storing the password of the SAP user in an SAP Netweaver-based application on an SAP HANA database?
• Which alert configuration properties can be set in SAP HANA cockpit?
• Where do you create the technical user needed for integrating an existing SAP HANA2.0 SPS03 database into the SAP HANA cockpit?
• What feature allows SAP HANA to support a 3-tier scenario using Secure User Store?
• What data can be reviewed through the _SYS_STATISTICS schema in SAP HANA?
• What is the purpose of monitoring data in the SYSTEMDB?
• Which encryption services can you activate in SAP HANA?
• What is included with the Predictive Analysis Library (PAL)?
• What prerequisite is necessary when a technical user needs to execute queries across tenant databases?
• What is the minimum RAM requirement on a dedicated server for productive use of SAP HANA cockpit 2.0?
• What is necessary for configuring higher database isolation between tenant databases in a Multiple Database Container system?
• Which SQL privilege can be granted to another user in SAP HANA?
• Which of the following describes a characteristic of an SAP HANA Multiple Database Container (MDC) System?
• Which of the following is true about system replication in SAP HANA?
• What action should you take when the data area in an SAP HANA database is running out of space?
• What should you check before starting the process to rename a tenant database?
• What status indicates a temporary connection loss of the secondary system in SAP HANA system replication?
• What is necessary for configuring database encryption in SAP HANA?
• What system privilege is required to redistribute tables across hosts in a scale-out SAP HANA system?
• Which parameters should be set to protect an SAP HANA database system against uncontrolled queries that consume excessive memory?
• Which tools can you use to monitor the response time of individual SQL queries?
• What advanced DMO options can be adjusted to speed up migration to SAP HANA?
• What is the default target database provided by the SUM databases migration option?
• Which parameters must be changed to analyze the memory usage of running SQL statements?
• Which of the following changes made during a database migration cannot be reset when using the database migration option fallback scenario?
• Which tasks can you perform using the SAP HANA database lifecycle manager (HDBLCM) on installation media?
• Which operating systems can be used to set up an SAP HANA 2.0 system on an Intel-based hardware platform?
• When creating a new user by copying from an existing user, which predelivered role is automatically granted to the new user?
• In which of the following scenarios is SAP expert sizing necessary?
• What is a prerequisite for installing the SAP Landscape Management tool?
• What user management tasks can be performed by a Lightweight Directory Access Protocol (LDAP) server?
• What item is key for ensuring the correct operation of SAP Landscape Management?
• What authentication method can be configured for single sign-on in a middleware/server scenario?
• What additional action must be taken after creating a new tenant in SAP HANA system replication?
• What scale-out roles can be assigned to hosts in the nameserver.ini file?
• What SAP HANA cockpit functions can you use to investigate an unresponsive database?
• What privileges are assigned automatically during the registration of a technical user in SAP HANA cockpit?
• Which database objects can you manipulate if you have the ALL PRIVILEGES activity?
• In which scenarios can you resume an incomplete recovery of your SAP HANA tenant database?
• Which activity is part of recovering a tenant database backup from SAP HANA system 1 into SAP HANA system 2?
• Which properties can be adjusted in SAP HANA Admission Control?
• What is the prerequisite for registering a new resource in SAP HANA cockpit 2.0?
• Which information is provided by the backup catalog in SAP HANA?
• Which two components are necessary to perform a migration using the SUM database migration option?
• How can you monitor the connection status of a secondary system in SAP HANA system replication?
• What is a key purpose of savepoints in SAP HANA?
• In the context of SAP HANA, what does the term 'landscape' refer to?
• To which point in time can you recover a database if the only intact data is from a log storage, with a full backup from 9 hours ago and an incremental backup from 4 hours ago?
• Which operation is executed before a table is repartitioned?
• In an SAP HANA MDC, how many System IDs (SID) does a multiple database container have?
• How are hosts assigned to the shared storage in an SAP HANA scale-out system?
• Which user credentials are required during the initial run of the configuration phase for the Database Migration Option to an SAP HANA 2.0 database tenant?
• What type of algorithms does the Predictive Analysis Library (PAL) contain?
• In an SAP HANA database system running in log mode "normal", when does the system automatically execute a regular log backup?
• What is the role of the hdblcm tool in SAP HANA?
• Which application is used to reset memory statistics before analyzing a tenant database?
• What causes could lead to a hung SAP HANA database where blocking transactions cannot be identified?
• For a query to execute across tenant databases in an SAP HANA multitenant database container, which prerequisites are needed?
• Which tools can you use to start and stop an SAP HANA database?
• Which SAP HANA database system usage types are automatically assigned to tiles in the SAP HANA cockpit?
• Which merge methods are triggered by the SAP HANA system processes?
• Which information is stored in the SYSTEMDB of an SAP HANA multitenant database container system?
• What is a prerequisite for adding hosts to an SAP HANA scale-out system?
• What is the main function of the backup.log file in SAP HANA?
• Which component of SAP HANA is responsible for data recovery during a failure?
• Which tools can be utilized to start and stop tenants in an SAP HANA database?
• In the context of SAP HANA, which statement best describes the use of continuous log shipping?
• Which connection types are allowed with system replication using the Active/Active option?
• Which option of the Manage Table Distribution tool do you use to evaluate if a partitioned table needs to be repartitioned?
• What information can be found in the SUM UI?
• Which monitoring tools are recommended for SAP HANA database management?
• How do you resolve privileges issues faced by a user in an SAP HANA environment?
• Which of the following tools can be utilized for User Administration?
• Which technology is used by the SAP DBA Cockpit to store performance indicators?
• What is a primary benefit of partitioning columns in SAP HANA column store tables?
• Which of the following SAP recommendations should be followed for optimal table partitioning in SAP Business Suite powered by SAP HANA?
• Which privilege is required for a role to assign privileges to other users in SAP HANA?
• Which backup and recovery scenario is allowed in multitenant database containers?
• Which system privileges are required for administrating tenant databases when being connected to the system database?
• What are the mandatory prerequisites before activating SAP HANA system replication with read-enabled mode?
• Who is responsible for owning an SAP HANA Deployment Infrastructure (HDI) role?
• Which privilege level is typically necessary for managing multiple databases in SAP HANA?
• What is a common reason for receiving the Disk Full (Alert 30) alert in SAP HANA systems?
• Which script can you trigger from SAP HANA cockpit to collect diagnosis information?
• Which features can be used to manage the peak load of a SAP HANA database?
• Which of the following tasks requires the BACKUP ADMIN authorization?
• Which method is used to trigger a savepoint in an SAP HANA database?
• Which system privilege is required to view roles granted to other users in SAP HANA?
• What is a characteristic of the synchronous in-memory system replication mode in SAP HANA?
• What is the purpose of the Secure User Store (hdbuserstore)?
• In which replication mode is the primary system blocked until the secondary system is available?
• Which performance monitoring tool is utilized within SAP HANA to provide detailed performance statistics?
• Which prerequisite is required to rename a tenant database in the SAP HANA cockpit?
• Which connections must be explicitly enabled for a Restricted User in SAP HANA?
• Which of the following is NOT a characteristic of the SAP HANA Multiple Database Container (MDC) system?
• Where can you find information about when the productive SAP HANA system was updated and to which version?
• What is necessary before installing SAP HANA Cockpit 2.0 as a monitoring tool?
• Which table provides a customizing interface for dynamic management of partitions and locations?
• Which SAP HANA feature ensures that committed data is NOT lost if there is a power failure?
• Which SAP HANA features are secured by certificates in the SAP HANA certificate store?
• Before replaying a captured workload using the SAP HANA capture and replay tool, which preparation steps are necessary?
• Which method can improve the performance of delta merges in SAP HANA?
• Which two requirements are mandatory when installing an SAP HANA database and SAP NetWeaver AS ABAP 7.5 on a productive system?
• What is required to avoid compatibility issues after upgrading an SAP HANA system?
• Which capability allows real-time data loading and replication from ABAP and non-ABAP source systems to an SAP HANA environment?
• How can you ensure that a consistent database status is saved using data snapshots?
• What is a characteristic feature of the Delta Data Shipping operation mode in SAP HANA system replication?
• Which users are able to start and stop a distributed SAP HANA Database System?
• Which default users will be created during the installation of the SAP HANA database system?
• Which operations are performed by SAP Landscape Management?
• What is one of the advantages of using column store tables in SAP HANA?
• What is the correct sequence for the restart of the SAP HANA database system?
• Which of the following is a preparation step for the database migration option in Software Update Manager?
• Which products are used for SAP HANA administration?
• What does the term ‘worker’ refer to in the context of SAP HANA scale-out architecture?
• What feature is enhanced in an SAP HANA MDC to increase database isolation?
• After starting the SAP HANA database, what action does the system take to ensure it is in a consistent mode?
• What is the benefit of setting alert threshold values in SAP HANA cockpit?
• What two features of the storage engine in the SAP HANA index server enable data consistency and maintain durable changes?
• What command-line tool is typically used to run SAP HANA SQL commands?
• Which parameter should be edited to deactivate the reload feature in SAP HANA?
• Which file diagnostics can be used to monitor the status of database recovery in SAP HANA?
• Which of the following is NOT a correct method for monitoring memory usage in SAP HANA?
• What type of server is necessary for running SAP HANA Cockpit as a central monitoring tool?
• Which system privileges should be assigned to a technical user account when registering an SAP HANA system?
• Which checks are performed when using the Hardware Configuration Check Tool (HWCCT)?
• Which actions are recorded when auditing is active in an SAP HANA system?
• What type of database activities are recorded in the database trace of the SAP HANA database?
• What happens if the reorganization process is required for a host in a scale-out landscape?