C_HANATEC_13 SAP Certified Technology Associate – SAP HANA 2.0 Certification Made Easy!!

Certification Questions

C_HANATEC_13 SAP HANA 2.0

1. Which prerequisites must be met to set up high availability for a distributed SAP HANA system? There are 2 correct answers to this question. Response: a) The column tables were assigned to an index i ndex server manually. b) The name server is started on all nodes. c) The synchronized backup savepoint is set. d) The shared storage is connected to every host. Answer: B,D 2. In SAP HANA HA NA Architecture which of the following component can easily enhance the functionality of Multiple-Container System Please choose the correct answer. Response: a) OS & Hardware b) Storage c) Tenant Database d) System Database Answer: C 3. What is the SAP HANA Application Function Library (AFL)? There are 2 correct answers to this question. Response: a) Repository of ready-made business functions b) Repository of connections that can be used by business functions c) Repository of ready-made predictive algorithms d) Repository of ready-to-run applications that are powered by SAP HANA Answer: A,C

reserved 1 Copyright© 2018, ZaranTech LLC. All rights reserved



4. 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 the reload feature? Please choose the correct answer. Response: a) Edit the indexserver.ini file by setting the reload_tables parameter in the sql section to true b) Edit the indexserver.xml file by setting the reload_tables parameter in the sql section to false c) Edit the indexserver.ini file by setting the reload_tables parameter in the sql section to false d) Edit the indexserver.xml file by setting the reload_tables parameter in the sql section to false Answer: C 5. After the SHINE demo application is installed, the developers and modelers can explore the features on the SAP HANA system. Which of the following statement is wrong regarding SHINE features? Please choose the correct answer. Response: a) Fuzzy search is a fast and fault-tolerant search feature b) The OData standard collects multiple individual HTTP requests into one batched HTTP request c) The SINA API is a server-side JavaScript API for developing browser-based search UIs d) Spatial data describes the position, shape, and orientation of objects in a defined space Answer: C




4. 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 the reload feature? Please choose the correct answer. Response: a) Edit the indexserver.ini file by setting the reload_tables parameter in the sql section to true b) Edit the indexserver.xml file by setting the reload_tables parameter in the sql section to false c) Edit the indexserver.ini file by setting the reload_tables parameter in the sql section to false d) Edit the indexserver.xml file by setting the reload_tables parameter in the sql section to false Answer: C 5. After the SHINE demo application is installed, the developers and modelers can explore the features on the SAP HANA system. Which of the following statement is wrong regarding SHINE features? Please choose the correct answer. Response: a) Fuzzy search is a fast and fault-tolerant search feature b) The OData standard collects multiple individual HTTP requests into one batched HTTP request c) The SINA API is a server-side JavaScript API for developing browser-based search UIs d) Spatial data describes the position, shape, and orientation of objects in a defined space Answer: C




6. Which of the following foll owing events occur while the merge operation is running? There are 2 correct answers to this question. Response: a) Uncommitted changes in the first delta storage are rolled back. b) The content of the complete main storage is persisted to disk. c) The content of the first main storage and the committed entries in the first delta storage are merged into the new second main storage. d) All write operations go to the second delta storage. Answer: C,D 7. When creating a system connection in SAP HANA Studio, which of these is i s essential information? There are 3 correct answers to this question. Response: a) A valid user and password b) Host c) URL d) Instance Answer: A,B,D 8. 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? There are 2 correct answers to this question. Response: a) SQL Command Editor of the DBA Cockpit on the application server b) SAP HANA studio on the SAP HANA server c) HDBSQL command line tool on the SAP HANA server d) SAP HANA cockpit 2.0 on a central server Answer: A,D




9. What is a role of the SAP HANA Cockpit? Choose the correct answer. Response: a) To provide KPIs to help focus on business performance b) To provide key system performance information for one of more HANA instances c) To provide an application developer collaboration hub Answer: B 10. Which of the following traces is active after the SAP HANA installation is completed? Please choose the correct answer. Response: a) SQL b) Plan c) Performance d) Database Answer: D 11. What are the two storage components used to restore the database in case of power failure? There are 2 correct answers to this question. Response: a) Log area b) Data volume c) Memory d) Delta store Answer: A,B

4 Copyright© 2018, ZaranTech LLC. All rights reserved



12. What are the native tools for SAP HANA Database administrators? There are 2 correct answers to this question. Response: a) SAP HANA Cockpit b) SAP Solution Manager c) SAP Landscape Management d) SAP HANA Studio Answer: A,D 13. From an architectural standpoint, which of the following components belong to the SAP HANA Indexserver? There are 2 correct answers to this question. Response: a) External Interfaces b) Preprocessor c) Relational Engines d) SAP Web Dispatcher Answer: A,C 14. Your customer sets up an SAP HANA system as tailored datacenter integration (TDI) deployment. What are the enterprise network requirements? There are 2 correct answers to this question. Response: a) 8 GbE storage area b) 4 GbE fiber channel c) 15 GbE internode d) 10 GbE backup Answer: C,D




15. Which of the following recovery types is not supported for delta backups? Choose the correct answer. Response: a) Recover the database to its most recent state. b) Recover the database to a specific point in time. c) Recover the database to a specific data backup. Answer: C 16. Your SAP HANA database is running in log mode “normal” and automatic log backups “enabled”. With this configuration, In which situations are the log segments backed up automatically? There are 3 correct answers to this question. Response: a) The log segment is full. b) The database is started. c) The log segment is closed after exceeding the configured time threshold. d) The database is stopped. Answer: A,B,C 17. Which security settings can you monitor in SAP HANA cockpit 2.0? There are 2 correct answers to this question. Response: a) Data Storage Security b) Password Policy c) Manage Database Backups d) Manage Users Answer: A,B




18. What is the minimum space requirement for the Data Volume? There are 2 correct answers to this question. Response: a) 1.2 * RAM (TDI) b) Min. 1 * RAM c) Min. 0.5 * RAM d) 3 * RAM (Appliance) Answer: A,D 19. You implement a multi-host SAP HANA system with auto-failover capabilities. What are the requirements for the disk storage? There are 2 correct answers to this question. Response: a) The slave node is set to backup standby. b) The failed worker host gets fenced during failover. c) The standby host has file access. d) The master node is fully clustered. Answer: B,C 20. Which of the following statements are true about SAP HANA Live? There are 2 correct answers to this question. Response: a) SAP HANA Live for SAP Business Suite comes with a comprehensive set of predefined models from across the SAP Business Suite. b) SAP HANA Live for SAP Business Suite is an accelerator.




c) SAP HANA Live for SAP Business Suite focuses on Enterprise Data Warehouse cases. and not on live operational reporting. d) SAP HANA Live for SAP Business Suite comprises of an Analytical Model. e) SAP HANA Live for SAP Business Suite is a Rapid Deployment Solution. Answer: A,D 21. 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? There are 3 correct answers to this question. Response: a) Performance Warehouse b) SAP HANA Database c) Alerting Infrastructure d) The transaction DBACockpit e) Diagnostics agent Answer: A,C,D 22. In which of the following SAP HANA scenarios is it recommended to encrypt communication between the client software and SAP HANA? There are 2 correct answers to this question. Response: a) SAP HANA as a data mart for reporting and analytics. b) SAP HANA as a classic three-tier architecture as the primary database (for example) SAP NetWeaver Business Warehouse, SAP Business Suite Installation). c) SAP HANA as a platform for providing database and application services to native SAP HANAbased applications. Answer: A,C




23. In the General Licensing Process you can install and reinstall a new permanent license. If the current permanent license expires, a temporary license is installed automatically, what is the validity of this temporary license following a permanent license? Please choose the correct answer. Response: a) 30 days b) 28 days c) 32 days d) 90 days Answer: B 24. What software innovations did SAP deliver with SAP HANA? There are 2 correct answers to this question. Response: a) Row and Delta store. b) Compression and Decompression. c) Partitioning. d) Insert only on Column store. Answer: A,C 25. Which information is provided via the SUM UI? There are 3 correct answers to this question. Response: a) A progress bar for the overall procedure b) The active roadmap step c) The memory consumption of SUM d) The content of log files via the log viewer Answer: A,B,D




26. Out of complete SAP HANA platform, which from the following components are not part of SAP HANA Database? There are 3 correct answers to this question. Response: a) HWCCT b) Database Services c) Smart Data Access d) INA file loader e) EPM Services Answer: C,D,E 27. Which of the following statements is true for the SAP HANA preinstalled role (SAP_INTERNAL_HANA_SUPPORT) for support cases? Choose the correct answer. Response: a) It can be granted to the SYSTEM user. b) It can be granted to another role. c) It can only be granted further system privileges. d) It can only be granted further object privileges. Answer: C




28. Which steps can be combined in a DMO procedure, targeting an AS ABAP 7.50 based SAP system? There are 2 correct answers to this question. Response: a) Performing an SAP software update b) Migrating to a target database, e.g. SAP HANA c) Performing a Unicode conversion d) Performing a database upgrade of the source database Answer: A,B 29. You are applying SAP Support Packages during an SUM DMO run to SAP HAN a) Which options are possible to select in the main dialog Tool Configuration? There are 3 correct answers to this question. Response: a) Single System b) Standard c) Advanced d) Expert Mode Answer: B,C,D 30. Which of the following statements are true regarding Multitenant Database Containers (MDC)? There are 2 correct answers to this question. Response: a) One system database and multiple tenant databases b) Single installation of database system software c) Distinction between tasks performed at system level and those performed at database level d) Integration with database operation procedures Answer: A,C




31. During uptime migration, which information can you receive in the Charts Control Center, via the Utilities of the SUM UI? There are 3 correct answers to this question. Response: a) The configured maximum number of parallel R3load processes b) The actual number of running R3load processes c) The memory consumption of the target database d) The process buckets being processed Answer: A,B,D 32. What are advantages of column store tables? There are 3 correct answers to this question. Response: a) Data footprint is automatically reduced through compression b) Only the columns required are actually loaded to memory c) Columns can be partitioned d) They are optimized for high-volume read / write transactional processing Answer: A,B,C 33. Where is SDI used? There are 2 correct answers to this question. Response: a) Data cleansing b) Data transformation c) Data streaming d) For data loading Answer: B,D




34. SAP HANA, in the context of user management, allows you to do which of the following? There are 3 correct answers to this question. Response: a) Create and delete users b) Lock and unlock users c) Assign a user to a user group d) Create a restricted user Answer: A,B,D 35.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. Response: a) Temporary license keys b) Unenforced license keys c) Enforced license keys Answer: C 36. When connected to the SAP HANA database, which hdbsql command displays general information about the database? Choose the correct answer. Response: a) \di b) \s c) \c d) \a Answer: B




37. 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. Response: a) Maintains relationships between data b) Recovers data automatically to the most recent consistent status after a system failure c) Provides secure access to data using only adm authorization d) Delivers high performance for processing data requests Answer: C 38. Which files are created after unpacking the SAP HANA Cockpit .SAR File? There are 2 correct answers to this question. Response: a) Configuration File b) Signature File c) hdblcm.sh File Answer: B,C 39. Which of the following traces has the default configuration status of “Active”? Choose the correct answer. Response: a) Performance trace b) Database trace c) SQL trace d) Kernel profiler Answer: B




40. In the Monitoring Expensive Statements trace, which additional trace option needs to be set to “false” to write the trace data directly to file. Choose the correct answer. Response: a) Threshold memory b) Use in-memory tracing c) Trace flush interval d) In-memory tracing records Answer: B 41. How to open Web user interface for HDBLCM from SAP HANA Studio from the context menu? Please choose the correct answer. Response: a) HDBLCM Management→Platform Lifecycle Management→SAP HANA Platform Lifecycle

Management b) HDBLCM Management→Platform Lifecycle Management→S AP HANA Platform Lifecycle

Management c) Lifecycle Management→Platform Lifecycle Management→SAP HANA Platform Lifecycle

Management d) Lifecycle Management→Platform Lifecycle Management→Open HDBLCM

Answer: C




42. 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? There are 2 correct answers to this question. Response: a) Linux, SAP MaxDB b) Windows, SAP MaxDB c) Linux, SAP HANA d) Windows, SAP HANA Answer: B,D 43. What are the three main steps of Sizing an SAP HANA tailored data center integration setup? There are 3 correct answers to this question. Response: a) RAM sizing for static and dynamic data b) Disk sizing for the persistence storage c) CPU sizing for the queries and calculations d) CPU sizing for the smart data access e) RAM sizing for HWCCT Answer: A,B,C




44. Which are tuning methods for the database migration, using DMO of SUM? There are 3 correct answers to this question. Response: a) Adapt the number of parallel R3load processes b) Using the Near Zero Downtime Maintenance capabilities of SUM (NZDM) c) Using the table migration duration files from a previous run d) Performing a benchmark using the benchmarking options of SUM Answer: A,C,D 45. Which of the following Inter-Service Communication properties binds the processes to entered address only and to all local host interfaces? Choose the correct answer. Response: a) Global b) Internal c) Local Answer: B 46. After confirming Lock now, which actions are still possible? Choose the correct answer. Response: a) Developing via ABAP workbench (SE80) b) Applying SAP notes via Note Assistant (SNOTE) c) Creating and changing application data (e.g. VA01) and user master records SU01) d) Releasing and importing transport requests via the Transport Manager (SE09) and Transport Management System (STMS) Answer: C




47. Which of the following actions can be audited by SAP HANA? There are 2 correct answers to this question. Response: a) Changes to system configuration. b) Upgrade of an SAP HANA database instance. c) Create or drop user, and create or drop role. Answer: A,C 48. What can you do to shorten the startup time of an SAP HANA system after a reboot? Please choose the correct answer. Response: a) Set the preload column value in the Tables system table to FULL. b) Flag all columnar tables for preload. c) Set the savepoint interval to a lower value d) Partition the row store across nodes. Answer: C 49. 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? There are 3 correct answers to this question. Response: a) Monitoring and Administration b) Performance Management c) Resource Management d) Security e) Memory Management Answer: A,B,D




50. In an SAP NetWeaver AS for ABAP system, the hdbuserstore program is located in which directory? Please choose the correct answer. Response: a) /usr//sap/hdbclient b) /sap/usr//hdbuser c) /usr/sap//hdbclient d) /usr/sap//hdbuser Answer: C 51. What is the order specified for registering resources and creating resource groups and cockpit users with the Cockpit Manager? Choose the correct answer. Response: a) Resources, Resource Groups, Cockpit Users b) Resource Groups, Resources, Cockpit Users c) Cockpit Users, Resources, Resource Groups d) There is no order to follow Answer: D 52. Which of the following display authorizations for DBA Cockpit is not enabled for SAP_BC_S_DBCON_USER? Please choose the correct answer. Response: a) S_DBCON b) ACTVT=03 c) S_RZL_ADM d) ACTVT=01 Answer: D




53. Which of the following elements are contained by the SAP HANA Studio System Navigator? There are 3 correct answers to this question. Response: a) Backup b) Content c) Configuration d) Security Answer: A,B,D 54. Which of the following configuration files are created if customer-specific changes are made after or during installation of SAP HANA database? There are 3 correct answers to this question. Response: a) sapprofile.ini b) hanaconfig.ini c) daemon.ini d) nameserver.ini Answer: A,C,D 55. In the General Licensing Process which of the following statements are true regarding Temporary license keys? There are 2 correct answers to this question. Response: a) Temporary license keys are manually installed by the SAP HANA system b) Temporary license keys are automatically installed by the SAP HANA system c) After 90 days, the temporary license expires and the system is locked down d) After 28 days, the temporary license expires and the system is locked down Answer:B,C




56. Which of the following are part of the Software Logistics (SL) Toolset? There are 3 correct answers to this question. Response: a) Software Update Manager (SUM) b) Transport Management System (TMS) c) Software Provisioning Manager (SWPM) d) Support Package Manager (SPAM) Answer: A,C,D 57. Which tasks must you perform to convert a single database to a multitenant database system? There are 2 correct answers to this question. Response: a) Set the password for the system database user. b) Trigger the conversion in the SAP HANA cockpit 2.0. c) Generate the system database before the conversion. d) Create an operating system user for the converted tenant database. Answer: A,B 58. Which statement is wrong regarding Operational Data Marts? Please choose the correct answer. Response: a) Views calculate results for reports in real time on the actual operational data b) No transformation during load step (only selection of relevant data if applicable) c) Real-time replication of time critical data (SLT/SRS) d) Typically contains no time critical data and therefore utilize traditional ETL Answer: D




59. Which command can re-encrypt the system PKI SSFS with a new key? Please choose the correct answer. Response: a) RSEC_SSFS_DATAPATH=/usr/sap//SYS/security/global/rsecssfs/data RSEC_SSFS_KEYPATH=/usr/sap//SYS/security/global/rsecssfs/key rsecssfx changekey $(rsecssfx generatekey –getPlainValueToConsole b) RSEC_SSFS_DATAPATH=/usr/sap//SYS/global/security/rsecssfs/data RSEC_SSFS_KEYPATH=/usr/sap//SYS/global/security/rsecssfs/key rsecssfx changekey $(rsecssfx generatekey –getPlainValueToConsole c) RSEC_SSFS_DATAPATH=/usr/sap//SYS/global/hdb/security/ssfs RSEC_SSFS_KEYPATH= rsecssfx changekey $(rsecssfx generatekey -getPlainValueToConsole) d) RSEC_SSFS_DATAPATH=/usr/sap//SYS/security/hdb/global/ssfs RSEC_SSFS_KEYPATH= rsecssfx changekey $(rsecssfx generatekey -getPlainValueToConsole) Answer: B 60. During Installation 3 users are created automatically, which of the following statement is wrong regarding default users description? Please choose the correct answer. Response: a) The password of the adm user is set during installation with the password parameter b) SYSTEM is the SAP Host Agent administrator




c) SYSTEM is the database superuser d) The password of the SYSTEM user is set during installation with the system_user_password parameter Answer: B 61. SAP HANA uses SSFS to protect the root encryption keys. These root keys protect all encryption keys used in the SAP HANA database from unauthorized access. What other two main functions of the root encryption keys? There are 2 correct answers to this question. Response: a) The root key used for the internal data encryption service of the database b) The root key used for data volume encryption c) The root key used for users log encryption d) The root key used for transactions volume encryption Answer: A,B 62. Which statement is correct regarding Agile Data Marts? Please choose the correct answer. Response: a) Data has been transformed, in favor of the business problem at hand b) Views calculate results for reports in real time on the actual operational data c) No transformation during load step d) Real-time replication of time critical data (SLT/SRS) Answer: A




63. What are the prerequisites for using the Web user interface for HDBLCM? There are 2 correct answers to this question. Response: a) The SAP HANA database is revision 90 or higher b) The communication port 1329 is open c) Internet Explorer - Version 8 or higher d) The communication port 1129 is open Answer: A,D 64. Which of the following users are able to start and stop a distributed SAP HANA Database System There are 2 correct answers to this question. Response: a) SYSTEM user b) ADM user c) ROOT user Answer: B,C 65. Which of the following statement is not true regarding SAP HANA Server Components? Please choose the correct answer. Response: a) The index server contains the actual data stores and the engines for processing the data b) Index server is access by SAP HANA Cockpit with SQL queries c) Web based tools can access the index server with simple HTTP request d) XS Engine process the client application with HTTP request Answer: C




66. What is a multistore table? Choose the correct answer. Response: a) A table that can hold data in row and column orientation b) A table that can distribute its partitions across memory and extended storage tiers c) A table that can be shared across multiple instances of HANA Answer: B 67. Which of the following SAP products in the security portfolio can be integrated with SAP HANA using a native connector or integration? There are 2 correct answers to this question. Response: a) SAP NetWeaver Identity Management b) SAP GRC Access Control c) SAP GRC Process Control d) Microsoft Active Directory Answer: A,B 68. What are the advantages of the DMO procedure? There are 3 correct answers to this question. Response: a) DMO combines several steps into one procedure. b) DMO allows a lower target release on SAP HANA database. c) DMO allows an easy reset during the procedure. d) DMO is an inplace procedure by default, keeping the application server host. Answer: A,C,D




69. Which of the following actions triggers the replication of SAP BW authorizations in SAP HANA? There are 3 correct answers to this question. Response: a) System restart b) InfoProvider activation c) Execution of "Replicate BW user authorizations to HANA database" process chain d) Execution of report "RS2HANA_AUTH_RUN" Answer: B,C,D 70. 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. Response: a) System Privileges b) Object Privileges c) Analytic Privileges d) Package Privileges Answer: C 71. Which of the following elements are required for implementing a database copy? There are 2 correct answers to this question. Response: a) The target database must have a the same or higher version than the source database. b) You don’t have to be concerned about disk space and memory of the target database. c) Source and target databases can have different number and types of services. d) A data backup (file-based backups or backups using a third-party backup tool) or a storage snapshot of the source system is available. Answer: A,D




72. Which of the following tasks requires the BACKUP ADMIN authorization? There are 2 correct answers to this question. Response: a) Backing up the database without a user interface. b) Recovering the database without a user interface c) Physically deleting data and log backups and obsolete versions of the backup catalog from the backup location. d) Administration tasks executed on a tenant database through the system database. Answer: A,C 73. How many tiers do you usually find in an SAP HANA application? There are 2 correct answers to this question. Response: a) 1 b) 2 c) 3 d) 4 Answer:B,C 74. Which of the following SAP HANA Lifecycle Management Tools can be used for configuration works? Choose the correct answer. Response: a) hdblcm b) hdblcmgui c) Resident hdblcm d) hdblcmweb Answer: C




75. When was the first release of SAP HANA Cockpit? Choose the correct answer. Response: a) SAP HANA 1.0 SPS09 b) SAP HANA 1.0 SPS11 c) SAP HANA 1.0 SPS12 d) SAP HANA 2.0 Answer: A 76. In which circumstances do you create a column store table? There are 3 correct answers to this question. Response: a) When the calculations are based on a small number of columns b) When accessing complete records c) When aggregations or fast search is required d) When the table has a large number of columns Answer: A,C,D 77. Which package of SAP HANA cloud platform provides a vast set of platform services for the most common pattern in software engineering, such as persistence, connectivity, identity and document management? Please choose the correct answer. Response: a) SAP HANA Infrastructure Services b) SAP HANA DBServices c) SAP HANA AppServices d) SAP HANA Enterprise Cloud Answer: C




78. In the context of the SAP HANA maintenance strategy, which of the following terms is connected to bundle new features and functions to the SAP HANA Platform? Choose the correct answer. Response: a) SAP HANA standard revisions b) SAP HANA maintenance revisions c) Support package stack (SPS) d) Support packages (SP) Answer: C 79. To maintain good read performance in a constantly changing database, which two components are used? There are 2 correct answers to this question. Response: a) Column store b) Memory store c) Delta storage d) Main storage Answer: C,D 80. Which of the following elements are valid rules for the location of the backup files? There are 3 correct answers to this question. Response: a) The Volume ID is automatically added to a specified file name. b) The backup files should never be in the same directory and on the same file system as the data) c) The backup ID is unique for each persistence only. d) The backup folder will be created automatically when the backup process is started. Answer: A,B,C




81. What are the prerequisites for querying the system view EFFECTIVE_PRIVILEGES to get data about other users and roles granted privileges? There are 2 correct answers to this question. Response: a) CATALOG READ b) DATA ADMIN c) MONITOR ADMIN d) USER ADMIN Answer: A,B 82. Which components of SAP HANA Indexserver allow clients to connect and communicate with the SAP HANA database? Please choose the correct answer. Response: a) Request Processing and Execution Control b) External Interfaces c) Relational Engines d) Storage Engine and Disk Storage Answer: B 83. Why do we still need a persistent layer? There are 2 correct answers to this question. Response: a) To store data that has been unloaded from memory b) To hold the delta store for newly arrived records c) To enable full database recovery if we have a power failure d) To store data that is frequently used Answer: A,C




84. You can change the SSFS master keys using the command line tool RSECSSFX, where it is available? Please choose the correct answer. Response: a) /sap/usr//HDB/exe b) /usr/sap/HDB//exe c) /sap/usr/HDB//exe d) /usr/sap//HDB/exe Answer: D 85. 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. Response: a) SAP HANA smart data streaming b) SAP HANA dynamic tearing c) SAP HANA remote data sync d) SAP HANA landscape transformation replication server Answer: D 86. In Dynamic data memory requirements Additional memory is required for objects that are created dynamically when new data is loaded or queries are executed) Which of the following two recommendation? There are 2 correct answers to this question. Response: a) Reserving as much memory for dynamic objects as for static ones b) Calculating the total RAM, the static RAM is divided by two c) Reserving double memory for dynamic objects as for static ones d) Calculating the total RAM, the static RAM is multiplied by two Answer: A,D




87. Which components for an In-Memory Appliance do you need to consider for sizing? Choose the correct answer. Response: a) Storage b) Memory c) CPU Answer: B 88. What are prerequisites for changing the SSFS Master Keys? There are 2 correct answers to this question. Response: a) You have the server root privilege INIFILE ADMIN b) You have the system privilege INIFILE ADMIN c) You have the credentials of the Operating system user adm that was created when the system was installed. d) You have the credentials of the SYSTEM user Answer: B,C 89. USER A grants a privilege to USER B, and USER B grants the same to USER C afterwards. What happens if you drop USER B from the HANA database? Choose the correct answer. Response: a) The privilege is revoked from both USER A and USER C. b) The privilege is revoked from USER C, but not USER a) c) The privilege remains assigned to both USER A and USER C. d) The privilege is revoked from USER A, but not USER C. Answer: B




90. 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. Response: a) $(DIR_INSTANCE)/../global/hdb/custom/config b) $(DIR_INSTANCE)/backup/log c) $(DIR_INSTANCE)//trace d) $(DIR_INSTANCE)/backup/data Answer: B 91. What do you have to ensure during the downtime phases of SUM? There are 3 correct answers to this question. Response: a) The source database must be stopped b) End users can not log on to the SAP system c) Batch jobs from daily business can not start d) Interfaces from other SAP systems can not log on to the SAP system Answer: B,C,D 92. Which of the following elements are SAP HANA system components There are 2 correct answers to this question. Response: a) SAP HANA Database b) SAP HANA Dynamic Tiering c) SAP HANA Advanced Data Processing d) SAP HANA Remote Data Sync Answer: A,C




93. Which of the following authentication methods are available in SAP HANA? Please select all the correct answers that apply. Response: a) Login with user and password b) Use of SAML identity provider assertion tickets c) Reuse the Kerberos ticket issued by the Active Directory d) Use the SAP Logon ticket issued by another SAP ABAP system Answer: A,B,C,D 94. Which of the following tools can be used for User Administration? There are 3 correct answers to this question. Response: a) SAP HANA Cockpit b) hdbsql c) Resident hdblcm d) SAP NetWeaver Identity Management Answer: A,B,D 95. 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. Response: a) Installation config screen b) Installation log file c) Installation logs screen d) COCKPIT_ADMIN user logs Answer: C




96. Which of the following SAP HANA Scenario enable the acceleration of standard ABAP reports? Please choose the correct answer. Response: a) Operational Data Marts b) SAP HANA Accelerators c) Agile Data Marts d) SAP BW/4HANA Answer: B 97. What is scale-out? There are 2 correct answers to this question. Response: a) Use of standby servers in the event of hardware failure. b) Use of remote servers to store archived data that is rarely used. c) Use of commodity servers that are used in high volume steaming applications. d) Use of multiple servers to spread processing and improve performance. Answer: A,D 98. You need to enable single sign-on for SAP HANA with Microsoft Active Directory. Which authentication method allows you to use the Active Directory groups? Please choose the correct answer. Response: a) X.509 client certificates b) Security Assertion Markup Language (SAML) c) SAP Logon and assertion tickets d) Kerberos Answer: D




99. For scale-out SAP HANA systems, the recommended disk space for hana/shared/ depends on the number of worker nodes. A disk space of 1x RAM of one worker is recommended for every four worker nodes of a given scaleout system. Please choose the correct answer. Response: a) Size [installation(scale-out)] = 1 x RAM_of_worker per 3 worker nodes b) Size [installation(scale-out)] = 1 x RAM_of_worker per 8 worker nodes c) Size [installation(scale-out)] = 1 x RAM_of_worker per 4 worker nodes d) Size [installation(scale-out)] = 1 x RAM_of_worker per 2 worker nodes Answer: C 100. What is XS? Choose the correct answer. Response: a) A native, lightweight application server b) An optional engine to handle excessive data loads c) A data cleansing engine d) A user interface Answer: A




101. The Add System Archive Link is a new feature that allows users to connect to multiple SAP HANA systems. From which method one user can manage the list of all systems in a centrally-accessible archive (with read only link to other user)? Please choose the correct answer. Response: a) File → Export → Landscape → SAP HANA b) File → archive → SAP HANA → Landscape c) File → Export → SAP HANA → Landscape d) File → archive → SAP HANA → Export

Answer: C 102. In single-host SAP HANA systems, you can use plain attached storage devices, such as Small Computers System Interface hard drives, solid-state drives (SSDs), or storage area networks (SANs). However, to build a multi-host system with failover capabilities, the storage must ensure which of the following conditions? There are 2 correct answers to this question. Response: a) The standby host has file access b) SYSTEM users replaced by standby host c) The failed worker host no longer has access to write to files d) The standby host has access to write to files Answer: A,C




103. The application data of the SAP NetWeaver-based applications are stored in the schema SAP of the SAP HANA system, Which of the following statement is biased to perform if you change the SAP password of a NetWeaver based system? There are 2 correct answers to this question. Response: a) You must update the relevant DEFAULT connection entries in the hdbuserstore b) Update the ABAP SSFS of the adm (Linux) c) No need to update the ABAP SSFS of the Domain\SAPService (Windows) d) Use the old password when establishing the connection Answer: A,B 104. To ensures that the database can be restored to the most recent committed state after a restart which of the following Indexserver components make sure such consistency and maintain durable changes? Please choose the correct answer. Response: a) Storage Engine b) Relational Engines c) Disk Storage d) Request Processing Answer: A




105. Which of the following Technical Deployment Option has single application runs in a single schema, and in a single SAP HANA database as part of an SAP HANA system? Please choose the correct answer. Response: a) Single Application on One System (SCOS) b) Multiple Components on one Database (MCOD) c) SAP HANA with Virtualization d) Technical Co-Deployment Answer: A 106. Which of the following actions are audited by default in SAP HANA? There are 2 correct answers to this question. Response: a) Changes to system configuration b) Deletion of audit entries from the audit trail c) Installation of SAP HANA license d) Changes to system configuration e) Creation, modification or deletion of audit policies Answer: B,E 107. What are the prerequisites for configuring audit logging? There are 2 correct answers to this question. Response: a) AUDIT ADMIN system privilege b) INIFILE ADMIN system privilege c) AUDIT OPERATOR system privilege d) INIFILE OPERATOR system privilege Answer: A,B




108. The SAP HANA Repository is structured using packages. A package can do which of the following? There are 3 correct answers to this question. Response: a) Directly be transported to another SAP HANA system b) Nested to another package creating a hierarchy c) Contain directly repository objects d) Be empty or contain only other packages Answer: B,C,D 109. Which of the following statements are true regarding In-Memory computing security? There are 2 correct answers to this question. Response: a) Data and undo log information (part of data) are automatically saved to disk at regular savepoints b) The log is also saved to disk continuously and synchronously after each COMMIT of a database transaction c) The redo log captures last 5 minutes changes by database transactions d) After a power failure the system returns to its last consistent state by replaying the undo log since the last savepoint Answer: A, B




110. During the Installation, the following users are created automatically. Which of them is the SAP Host Agent administrator? Choose the correct answer. Response: a) adm user b) sapadm user c) SYSTEM user Answer: B 111. 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? There are 2 correct answers to this question. Response: a) SQL Command Editor of the DBA Cockpit on the application server b) SAP HANA studio on the SAP HANA server c) HDBSQL command line tool on the SAP HANA server d) SAP HANA cockpit 2.0 on a central server Answer: A,D 112. Which of the following database resources can be monitored at the DBA Cockpit Current Status Overview monitor? There are 3 correct answers to this question. Response: a) The time at which the database was started. b) Disk consumption from the SAP HANA database. c) Connection statistics about open connections. d) Memory and CPU consumption from the SAP HANA database. Answer: A,B,D




113. For which scenarios is it mandatory to define the authorizations at HANA Level? There are 2 correct answers to this question. Response: a) SAP HANA Live for SAP Business Suite b) Business Suite on HANA c) SAP S/4HANA d) Web-based native app 114. Which of the following actions are possible when managing roles? There are 3 correct answers to this question. Response: a) A role can be nested to multiple other roles. b) A role can contain multiple other roles. c) A role can contain other roles and privileges at the same time. d) A role can contain either other roles or privileges but not both together Answer: A,B,C 115. The design-time version of a security role can contain which of the following information? There are 2 correct answers to this question. Response: a) The users assigned to the role b) The role name c) The privileges assigned to the role d) The users assigned by default to this role Answer: B,C




116. In Web IDE for SAP HANA, what can I create in a HDB module? There are 2 correct answers to this question. Response: a) Calculation View b) Analytic Privilege c) HTML file d) Flowgraph Answer: A,B,D 117. The administration console is pre-delivered by SAP. You can access the administration console in one of the following ways. There are 3 correct answers to this question. Response: a) Choose the Administration button in the upper left corner b) Choose the Administration button in the upper right corner c) Double-click the system in the system monitor d) Double-click the system monitor in the Navigator view e) Double-click the system in the Navigator view Answer: B,C,E 118. In SAP HANA Studio, what would you find in a Package? There are 2 correct answers to this question. Response: a) Calculation Views b) Analytic Privileges c) Procedures d) Tables Answer: A,B,C




119. Due to a hardware failure, you are using a different host to recover a crashed SAP HANA database) Which of the following configuration files must you use for the recovery? There are 2 correct answers to this question. Response: a) sapprofile.ini b) xsengine.ini c) nameserver.ini d) Indexserver.ini Answer: C,D 120. Your SAP HANA system CANNOT be reached by SQL. You need to check all connections, transactions, and blocked transactions to understand the root cause. Which system service do you use to collect the information? Response: a) daemon b) sapstartsrv c) preprocessor d) nameserver Answer: B 121. Where can you check the trace and log files when your SAP HANA database is NOT available? There are 2 correct answers to this question Response: a) In the Trace app of the SAP HANA Web-based Development Workbench b) In the Troubleshoot Unresponsive System app of SAP HANA cockpit 2.0 c) In the Diagnosis Files app of the SAP HANA cockpit for offline administration d) In the /usr/sap//HDB//trace path on the operating system Answer: C,D




122. When you use the database migration option reset procedure as a fallback scenario, which of the changes made during the migration are NOT reset? There are 3 correct answers to this question. Response: a) The deleted SAP BusinessObjects Business Intelligence data on the non-SAP database b) The SAP ABAP kernel on the application server c) The DBACOCKPIT user on the SAP HANA database d) The shadow schema on the non-SAP database e) The updated BRTOOLS on the non-SAP database Answer: A,B,C 123. logical error occurred in one tenant of your SAP HANA database) What action do you perform to make the tenant consistent again? Please choose the correct answer. Response: a) Recover the system database) The affected tenant is recovered automatically. b) Recover the system database first and then recover the affected tenant. c) Recover the affected tenant. The system database is NOT recovered. d) Recover the affected tenant first and then recover the system database. Answer: B




124. Your customer asks you to set up alert monitoring in SAP HANA cockpit 2.0. Which alert properties can you configure? There are 2 correct answers to this question. Response: a) Threshold values b) Check interval c) Schedule activation d) Proposed solution Answer: A,B 125. You plan to implement SAP HANA multitenant database containers using a scale-out scenario with high availability. What rules can be applied when you implement such an SAP NANA system? Note: There are 2 correct answers to this question. Response: a) Single tenant databases can be failed over to the standby host. b) Tenant databases can be automatically distributed across all the available hosts. c) An instance of the system database can run on all the nodes, including the standby host. d) An instance of the system database can run on all the nodes, except the standby host. Answer: A, C




126. 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. Response: a) SAP NetWeaver 7.5x on SAP HANA 2.0 with ABAP Core Data Services (CDS) and SAP Fiori installed b) A central SAP HANA database 2.0 with SAP HANA extended application services, advanced model (XS Advanced) installed c) SAP Solution Manager 7.2 on SAP HANA 2.0 with SAP HANA extended application services, advanced model (XS Advanced) d) A dedicated server with at least 16GB of RAM with SUSE Linux Enterprise Server (SLES) or Red Hat Enterprise Linux (RHEL) Answer: D 127. Which command do you use to bring a distributed SAP HANA database system to a fully operational state? Please choose the correct answer. Response: a) HDB start b) startsap c) sapcontrol -nr -function Start d) sapcontrol -nr -function StartSystem Answer: D




128. You need to secure client-server communication using transport layer security. Which objects must you set up on the server side? There are 2 correct answers to this question. Response: a) User certificate b) Private key c) Root certificate d) Server certificate Answer: C,D 129. You are installing 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. Response: a) Use a hardware configuration listed in the Product Availability Matrix. b) Add an additional scale-out node to your hardware configuration. c) Run the HanaHwCheck.py script before resuming the installation. d) Disable the hardware check before starting the installation. Answer: C 130. You suspect an authorization issue while executing SAP HANA reports that contain calculation views. How do you configure the authorization trace? There are 2 correct answers to this question. Response: a) Select INFO from the System Trace Level for the Indexserver component and then select AUTHORIZATION.




b) Specify the name of the table/view. c) Select INFO from the System Trace Level for the Preprocessor component and then select AUTHORIZATION. d) Specify the user as the database user. Answer: A,D 131. Which database administration tasks can you perform in SAP HANA cockpit 2.0? There are 3 correct answers to this question. Response: a) Troubleshoot an unresponsive system. b) Create a storage snapshot for an SAP HANA database. c) Execute the SAP HANA Hardware Configuration Check Tool. d) Monitor the system replication operation mode. e) Restart the SAP HANA database services. Answer: A,D,E 132. You plan to migrate a non-SAP database to SAP HANA using the database migration option (DMO) of the Software Update Manager. Which advanced DMO options can you adjust to speed up the migration? There are 2 correct answers to this question. Response: a) R3trans processes b) TP processes c) SQL processes d) SAPup processes Answer: A,C




133. Which operation mode can you use to configure SAP HANA system replication? Please choose the correct answer. Response: a) Delta data file shipping b) Continuous log replay c) Log file shipping d) Log mirroring Answer: B 134. What tenant information can you monitor in the Overall Tenant Statuses app of SAP HANA cockpit 2.0? Please choose the correct answer. Response: a) Security status b) Used memory c) Isolation status d) Instance number Answer: B 135. How is a savepoint triggered in SAP HANA? Please choose the correct answer. Response: a) By performing a soft shutdown b) By committing a transaction c) By starting a log backup d) By executing a delta merge Answer: A




136. 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. Response: a) Select trace level Error for the auditing component. b) Select trace level Warning for the authentication component. c) Select trace level Info for the authorization component. d) Select trace level Debug for the authenticationcodec component. Answer: C 137. Which tool do you use to create a new tenant when you install SAP HANA multitenant database containers? Please choose the correct answer. Response: a) Manage Databases app of SAP HANA cockpit 2.0 b) Administration Console of the SAP HANA studio c) HDBSQL command line and the CREATE SCHEMA statement d) System Configuration tab of the DBA Cockpit Answer: A 138. 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 Response: a) - The source system can have 4 hosts. - The target system can have 2 hosts.




b) - The source system can have 2 hosts - The target system can have 4 hosts c) - The source system can have 4 index servers - The target system can have 2 index servers d) - The source system can have 2 index servers. - The target system can have 4 index servers. Answer: A 139. You need to set up an SAP HANA system where several companies share the same SAP HANA instance) You have to provide each company a dedicated share of the instance for its data, configuration and user management. Which deployment scenario do you use? Please choose the correct answer. Response: a) Multitenant database containers (MDC) b) Technical co-deployment (TCD) c) Multiple Components on One Database (MCOD) d) Multiple Components on One System (MCOS) Answer: A 140. Which SAP HANA features ensure that committed data is NOT lost if there is a power failure? There are 2 correct answers to this question. Response: a) Automatic savepoints b) Persisted redo logs c) Delta merge d) Undo logs Answer: A,B




141. You migrate a database using the database migration option. Which tools are available to monitor the migration? There are 2 correct answers to this question. Response: a) Process Bucket monitor b) Log Tail Viewer monitor c) Table Depooling monitor d) Table Splitting monitor Answer: A,B 142. Which security infrastructures can you integrate with SAP HANA? There are 2 correct answers to this question. Response: a) Linux syslog b) Radius server c) Identity management d) Intrusion detection Answer: A,C 143. Where do you investigate a failed uninstall of an SAP HANA scale-out system? Please choose the correct answer. Response: a) /hana/shared/log b) /hana/log/ c) /var/tmp/hdblcm.log d) /usr/sap//hostctrl/work Answer: C




144. A technical user is required when you register an SAP HANA system as a resource in SAP HANA cockpit 2.0. Which system or object privilege do you assign to the technical user account on the target system? Please choose the correct answer. Response: a) SELECT on _SYS_TASK b) SELECT on _SYS_REPO c) CATALOG READ d) USER ADMIN Answer: C 145. Which connection types are allowed when you use system replication with the Active/Active option? There are 2 correct answers to this question. Response: a) Implicit hint-based statement routing b) Explicit read only on the secondary system c) Explicit read and write on the secondary system d) Automatic round-robin statement routing Answer: A,B




146. You are using USER01 and modelling a calculation view that combines existing calculation views with tables belonging to SCHEMA02. You want to activate the new calculation view, but you get a User is NOT Authorized error. What is the cause of the error? Please choose the correct answer. Response: a) User _SYS_REPO is missing object privileges for SCHEMA02. b) The calculation view was created in the sap package. c) USER01 is missing object privileges for SCHEMA02. d) The calculation view was created in the system-local package. Answer: D 147. You need to install multiple identically configured SAP HANA systems in batch mode) Which installation parameter is mandatory when you use a configuration file? Please choose the correct answer. Response: a) sid b) system_usage c) components d) number Answer: A




148. You install an SAP HANA system with multitenant database containers and monitor the SYSTEMDB from SAP HANA cockpit 2.0. Which services are part of the Manage Services app? There are 3 correct answers to this question Response: a) xsengine b) compileserver c) indexserver d) nameserver e) preprocessor Answer: B,D,E 149. Which prerequisites apply when you perform an SAP HANA database copy of a single tenant system? There are 2 correct answers to this question. Response: a) The number and type of services on the target database can be different from the source database. b) The restore point in time (PIT) of the target database is the same as or earlier than the source database. c) The number of nodes on the target database is the same as or lower than the source database. d) The version of the target database is the same as or higher than the source database. Answer: C,D




150. SAP HANA security services include which of the following? There are 4 correct answers to this question. Response: a) Audit logging b) Authentication c) Encryption d) Antivirus Protection e) Authorization Answer: A,B,C,E 151. Your customer has security restrictions that prohibit direct SQL connections from your PC to the productive SAP HANA system. Which tools can you use to monitor the system alerts of the SAP HANA database from your PC? There are 2 correct answers to this question. Response: a) SAP HANA studio b) HDBSQL command line tool c) SAP NANA cockpit 2.0 d) DBA Cockpit Answer: A,D




152. Your business users are complaining about longer-than-usual query runtimes and you want to get an overview of long-running l ong-running queries. Where do you activate the expensive statements trace? There are 2 correct answers to this question. Response: a) SAP HANA studio diagnosis mode b) SAP HANA cockpit 2.0 c) SAP HANA database explorer for SAP HANA cockpit d) SAP HANA Web-based Development Workbench Answer: A,B 153. You perform backups using a third-party backup tool (BACKINT SDK for SAP HANA). Which service supports configuration of several parallel streams? Please choose the correct answer. Response: a) preprocessor b) xsengine c) indexserver d) name server Answer: C




154. You must design a high-availability SAP HANA database system with 8 hosts (6 worker and 2 standby) that also uses multitenant database containers. Which rules apply? There are 2 correct answers to this question. Response: a) The system database must run on the standby host. b) The system database instance must run on all hosts (worker and standby). c) The tenant databases must be able to be scaled out to all hosts (worker and standby). d) The tenant databases must run on the worker hosts. Answer: B,D 155. Which authorization assignments are possible when you set up an authorization concept in the SAP HANA database? There are 2 correct answers to this question. Response: a) A role can be granted to a role. b) A role can be granted to a catalog object. c) A privilege can be granted to a user. d) A user can be granted to a role. Answer: A,C 156. You need to test an ABAP report, which uses SAP HANA H ANA objects, in the quality assurance (QA) system. Which tool do you use to import all objects to the QA system? Please choose the correct answer. Response: a) SAP HANA Application Lifecycle Manager b) SAP HANA Quality Gate Maintenance c) SAP HANA Change C hange Request Management d) SAP HANA Transport Containers Answer: A




157. You register a new resource in SAP HANA cockpit 2.0. What prerequisite does the resource require? Please choose the correct answer. Response: a) A multitenant configuration with SystemDB b) A usage type of production, test, or development c) The target database on SAP HANA 2.0 SPS00 or higher d) A technical user with limited authorizations Answer: D 158. You need to analyze resource usage and forecast the requirements for your SAP HANA database) Which app do you start in SAP HANA cockpit 2.0? Please choose the correct answer. Response: a) Monitor Expensive Statements b) Troubleshoot Unresponsive System c) Manage Workload Classes d) Disk Usage Answer: D 159. What are some of the characteristics of the design-time role? There are 3 correct answers to this question. Response: a) The role is granted through the execution of stored procedures. b) The role is revoked if the grantee user is deleted.




c) The role is created by technical user _SYS_REPO. d) The role can be transported between systems. e) The role is granted and revoked directly by the database user. Answer: A,C,D 160. Which backup scenarios are allowed in multitenant database containers? There are 2 correct answers to this question. Response: a) A backup of a tenant database can be recovered to an SAP HANA single-container system. b) A tenant database can initiate its own backup unless this is prohibited by the system configuration. c) A tenant database can initiate its own backup and the backup of the other tenant databases. d) The system database can initiate its own backup and the backup of tenant databases. Answer: B,D 161. What tool must you use to add an additional host to an SAP HANA scale-out system? Please choose the correct answer. Response: a) hdbnsutil b) hdbinst c) hdblcm d) hdbparam Answer: C




162. Who can access the runtime object generated from a repository object immediately after the activation?Please choose the correct answer. Response: a) The user who started the activation b) The SYSTEM user c) The _SYS_REPO user d) The user who created the repository object Answer: D 163. According to SAP Best Practices, what should you do with the SYSTEM user? Please choose the correct answer. Response: a) Delete the user. b) Exempt the user from locking. c) Revoke granted roles. d) Deactivate the user. Answer: B 164. 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. Response: a) async b) full sync c) syncmem d) sync Answer: B




165. Why does SAP HANA have a persistence storage layer that is disk-based? There are 2 correct answers to this question. Response: a) To generate indexes for the column store b) To allow row store operations c) To persist in-memory data d) To enable data recovery if the power fails Answer: C,D 166. You receive a new system from your hardware partner with SAP HANA 2.0 multitenant databasecontainers preinstalled) What is a prerequisite to guarantee secure encryption of the data volumes? Please choose the correct answer. Response: a) Change the generated SSFS master key for the whole database instance. b) Change the generated password of the SYSTEM user. c) Update the connection information stored in the hdbuserstore. d) Regenerate the encryption root keys for the internal application encryption. Answer: C 167. Which R3load mode is used during a database migration option procedure? Please choose the correct answer. Response: a) Pipe b) File c) Network d) Socket Answer: A




168. Which option do you choose to protect your SAP HANA scale-out system using host autofailover? Please choose the correct answer. Response: a) System replication b) Standby node c) Storage replication d) Automatic savepoint Answer: B 169. How can you minimize the database migration option (DMO) downtime? Please choose the correct answer. Response: a) Adjust the number of R3load processes during benchmarking and the DMO procedure. b) Use the benchmarking tool for a productive database migration with the DMO procedure. c) Provide the measured table migration duration for table sequencing during benchmarking. d) Run the benchmarking tool parallel to the DMO to automatically adjust the number of R3load processes. Answer: A 170. What do you do to prepare the database migration option of a Software Update Manager procedure? There are 3 correct answers to this question Response: a) Extract the SAP HANA database installation archive. b) Move the SPAM update archive into the download folder. c) Extract the SAP HANA client installation archive.




d) Move the stack.xml up Response: a) Recover database b) Troubleshoot unresponsive system c) Launch cockpit for offline administration d) Monitor performance Answer: B,C 173. You are applying SAP Support Packages during an SUM DMO run to SAP HAN a) Which options are possible to select in the main dialog Tool Configuration? There are 3 correct answers to this question. Response: a) Single System b) Standard c) Advanced d) Expert Mode Answer: B,C,D 174. You need to reset the database migration option (DMO) procedure due to a hardware failure) What are the prerequisites if you want to use the DMO reset procedure? There are 2 correct answers to this question Response: a) The source database needs to be available. b) The SUM folder needs to exist. c) The before-downtime backup needs to be available. d) The cleanup procedure needs to be performed. Answer: A,B




175. Which best practices do you apply when you optimize the table distribution in a scale-out SAP HANA database? There are 2 correct answers to this question. Response: a) Cross-node joins must be avoided. b) Table partitions can be distributed over all nodes. c) The row store can be distributed over all nodes. d) The columns of a table can be distributed over all nodes. Answer: B,C 176. You are implementing system replication for an SAP HANA system. How is the secondary SAP HANA database synchronized with the primary SAP HANA database? There are 2 correct answers to this question. Response: a) Each service on the secondary database establishes a connection with the primary database. b) The primary database persists the log information to the log volumes of the primary database and the secondary database. c) Every commit is written to a shared subdirectory between the primary database and secondary database. d) An initial snapshot and the redo log information are transferred from the primary database to the secondary database. Answer: A,D




177. What is the the recommended disk space for /hana/shared/ for single-node SAP HANA systems Please choose the correct answer. Response: a) Size [installation(single-node)] = MIN (2 x RAM; 2 TB) b) Size [installation(single-node)] = MIN (1 x RAM; 1 TB) c) Size [installation(single-node)] = MIN (2 x RAM; 1 TB) d) Size [installation(single-node)] = MAX (2 x RAM; 1 TB) Answer: B 178. Which information can you collect by running the fullSystemInfoDump.py script when the SQL connection is available? Please choose the correct answer. Response: a) A selection of .log files b) A selection of rows of schema SAP c) A selection of rows of schema _SYS_XS d) A selection of .trc files Answer: D 179. You created a restricted user in the DB1 database) Which commands must you use to convert the restricted SAP HANA user to a standard SAP HANA user? There are 3 correct answers to this question. Response: a) ALTER USER ACTIVATE USER NOW b) ALTER USER ADD REMOTE IDENTITY AT DATABASE DB1 c) ALTER USER ENABLE CLIENT CONNECT d) ALTER USER GRANT ROLE PUBLIC e) ALTER USER GRANT CREATE ANY ON OWN SCHEMA Answer: C,D,E




180. Which activity is always recorded when auditing is active? Please choose the correct answer. Response: a) Enable or disable policies b) Grant or revoke roles c) Change system configuration d) Delete database objects Answer: A 181. Which authorizations are assigned to users of type Standard Users by default? There are 2 correct answers to this question Response: a) Create objects in schema _SYS_STATISTICS b) Read data in system views c) Grant roles to other users d) Create objects in own schema Answer: B, D 182. The SAP HANA memory pool CANNOT satisfy the memory requests for new queries. Where does the SAP HANA database request additional memory? Please choose the correct answer. Response: a) Virtual memory b) Physical memory c) Standby memory d) Resident memory Answer: A


C_HANATEC_13 SAP Certified Technology Associate – SAP HANA 2.0 Certification Made Easy!!

Recommend Documents