Questions
ayuda
option
My Daypo

ERASED TEST, YOU MAY BE INTERESTED ONMi Hana Test Maldito

COMMENTS STATISTICS RECORDS
TAKE THE TEST
Title of test:
Mi Hana Test Maldito

Description:
Test Hana Ramdom

Author:
Roberto Simo Montenegro
(Other tests from this author)

Creation Date:
08/02/2021

Category:
Others

Number of questions: 80
Share the Test:
Facebook
Twitter
Whatsapp
Share the Test:
Facebook
Twitter
Whatsapp
Last comments
No comments about this test.
Content:
1. 1. Which software components do you download to prepare the database migration option? There are 2 correct answers to this question A. SPAM/SAINT B. SAP GUI C. SAP Host Agent D. SAPUI5.
2. You register a new resource in SAP HANA cockpit 2.0. What prerequisite does the resource require? Please choose the correct answer. A. A user with CATALOG read previlage and select on _SYS_STATISTICS schema B. A user with DATA ADMin privelage and select on _SYS_TELEMETRY schema C. A multitenant configuration with SystemDB D. The target database on SAP HANA 2.0 SPS00 or higher.
3. Which prerequisite of the primary system and the secondary system are mandatory before you can activate SAP HANA system replication with the read-enabled mode? There are 2 correct answers to this question. A. An explicit read-only connection between both system must be available B. The CPU architecture must be identical C. Both must have the same SAP HANA version D. The same number of active hosts and standby hosts must be installed.
4. What are the merge methods that are triggered by the SAP HANA system processes? There are 2 correct answers to this question. A Critical B Smart C Auto D Hard.
5. Which tool do you use during the Database Migration Option (DMO) procedure to monitor table splitting? Please choose the correct answer. A. The R3LDCTL B. The Process Bucket monitor C. The Observer Monitor D. The Log viewer.
6. Which database objects can you manipulate if you have the ALL PRIVILEGES activity? There are 2 correct answers to this question. A. Tables B. Procedures C. Views D. Sequences.
7. Which file system locations are suggested to install an SAP HANA multi-host system? There are 2 correct answers to this question. A. /hana/<sid> B. /hana/<Hostname> C. /hana/log/<sid> D. /hana/shared.
8. Which technology does the SAP DBA Cockpit use to store the performance indicators? Please choose the correct answer. A. SAP Adaptive Server Enterprise B. SAP Intelligent Query C. SAP Analytics Cloud D. SAP Business Intelligence.
9. Which rules should you consider when creating a table distribution plan for SAP Business Suite on SAP HANA to get the best possible results? There are 2 correct answers to this question. A. Keep the number of key columns low. B. Keep the number of partitions per table high. C. Keep all partitions on different hosts. D. Keep the number of partitioned tables low.
10. The recovery of your productive SAP HANA tenant database fails. In which cases can you resume the incomplete recovery? There are 2 correct answers to this question. A. Aborted recovery of a delta data backup B. Aborted recovery of a complete data backup C. Aborted recovery of the configuration files D. Aborted recovery of a log backup.
11. How can the system database administrator disable tenant database functionalities? Please choose the correct answer A. Using the Blacklisted Parameter app B. Using the Manage Restricted Features app C. Using the hdbuserstore tool D. Using the resident hdblcm tool.
12. When can you load and unload individual tables and table columns manually in an SAP HANA tenant database? There are 2 correct answers to this question A. When you need to measure total memory. B. When you need to optimize the standby node memory. C. When you need to extend the scale-out memory. D. When you need to actively free up memory.
13. 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. A. Kernel profiler B. SQL C. User-specific D. End-to-End.
14. Which default users will be created during the installation of the SAP HANA database system? There are 2 correct answers to this question. A. ldapadm B. <sid>crypt C. sapadm D. sap<sid>.
15. What is a prerequisite when you install the SAP Landscape Management tool? Please choose the correct answer. A. SAP Netweaver Application Server Java B. SAP HANA XS Advanced C. SAP Netweaver Application Server ABAP D. SAP Fiori Launchpad.
16. How can you perform a complete back up of an SAP HANA database system? Please choose the correct answer. A. Backup the complete storage system. B. Back up the system database and all tenant databases individually. C. Back up the system database and all tenant databases in one step. D. Back up the complete database system.
17. Which table provides a customizing interface that can be used for the dynamic management of partitions and locations? Please choose the correct answer. A. EFFECTIVE_TABLE_PLACEMENT B. UPDATE_LANDSCAPE_CONFIGURATION C. TABLE_PLACEMENT D. TABLE_GROUP.
18. Where are the R3load processes located when performing the Database Migration Option (DMO) procedure using the in-place migration? Please choose the correct answer. A. On the Primary Application Server (PAS) host B. On the remote target database host C. On the Additional Application Server (AAS) host D. On the source and target host.
19. Which system privileges are required for administrating tenant databases when being connected to the system database? There are 2 correct answers to this question. A. MONITOR ADMIN B. BACKUP ADMIN C. DATA ADMIN D. DATABASE ADMIN.
20. Which checks are executed when you run the Hardware Configuration Check Tool (HWCCT)? There are 3 correct answers to this question. A. Validation of the operating system configuration settings for the Linux kernel B. Measurement of the data throughput between CPU and DRAM C. Measurement of data throughput between SAP HANA nodes and storage D. Validation of the LPAR configuration settings on IBM Power servers E. Measurement of data throughput between the Linux kernel and CPU.
21. Which preparation tasks do you need to perform before starting the copy and move process for a tenant database? There are 3 correct answers to this question. A. Create credentials for authenticated access to the target system. B. Create a tenant on the target system identical to the source system. C. Back up the source tenant database. D. Create credentials for authenticated access to the source system. E. Configure a secure connection from target system to source system.
22. Who owns a SAP HANA Deployment Infrastructure (HDI) role? Please choose the correct answer. A. The _SYS_REPO technical user B. The user who created the role C. The SYSTEM user of the tenant database D. The container-specific technical user.
23. Which parameters are mandatory when using the hdblcm tool in batch mode? There are 2 correct answers to this question. A. Data and Log path B. Installation path C. Password of the user sapadm D. SAP HANA System ID (SID).
24. What can you check with the SAP HANA Hardware Configuration Check Tool (HWCCT)? There are 2 correct answers to this question. A. Network configuration B. Missing OS patches C. Kernel settings D. Memory configuration.
25. Which parameter do you set to protect a SAP HANA database system against uncontrolled queries that consume excessive memory? There are 2 correct answers to this question. A. reject_memory_threshold B. total_statement_memory_limit C. statement_memory_limit D. memory_tracking.
26. How can you optimize the Database Migration Option (DMO) procedure downtime for a production system? There are 2 correct answers to this question A. Use the benchmarking option to find the optimal throughput during the DMO procedure. B. Provide the measured table migration duration data for optimal table sequencing during benchmarking. C. Set the optimal number of R31oad processes during benchmarking and the DMO procedure. D. Use the Test Cycle opt on to find the optimal number of R31oad processes in a test run.
27. You are checking and monitoring SAP HANA system replication. Which status indicates a temporary connection loss of the secondary system? Please choose the correct answer. A. Unknown B. Syncing C. Error D. Initializing.
28. What are the supported operating systems for SAP HANA on IBM Power Servers? There are 2 correct answers to this question. A. For SAP HANA 1.0, Red Hat Enterprise Linux (RHEL) 6. 10 B. For SAP HANA 2.0, Red Hat Enterprise Linux (RHEL) 7.2 C. For SAP HANA 2.0, SUSE Linux Enterprise Server (SLES) 12 and 15 D. For SAP HANA 1.0, SUSE Linux Enterprise Server (SLES) 11 SP4.
29. What additional action do you need to perform after you created a new tenant in an SAP HANA system replication configuration? Please choose the correct answer. A. Restart secondary system. B. Copy tenant database. C. Start tenant database. D. Back up tenant database.
30. Which system schema provides performance data and system alerts details to review in SAP HANA MiniChecks? Please choose the correct answer. A. _SYS_TELEMETRY B. _SYS_WORKLOAD_REPLAY C. _SYS_SQL_ANALYZER D. _SYS_STATISTICS.
31. Which SAP HANA database service can you stop from the system database? There are 2 correct answers to this question. A. Index server B. Compile server C. Preprocessor D. XS Engine.
32. 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? There are 3 correct answers to this question. A. Add dedicated tenant OS users to the sapsys group. B. Create dedicated tenant OS users for each tenant. C. Add dedicated tenant OS users to the <sid> shm group. D. Remove the <sid> adm OS user from the sapsys group. E. Lock the adm OS user.
33. How are savepoints triggered? There are 2 correct answers to this question. A. By a database soft shutdown. B. By performing a database backup. C. By performing a delta merge. D. By issuing a transactional commit.
34. What is the first node limit for planning a SAP S/4HANA scale-out system? There are 2 correct answers to this question. A. >= 6TB B. >= 8TB C. >= 12CPU D. >= 8CPU.
35. Which preparation steps do you need to perform before replaying a captured workload using the SAP HA NA capture and replay tool? There are 3 correct answers to this question. A. Restore the source system tenant backup to the target tenant. B. Store the logon credentials of the replayer user in the secure store. C. Create a replayer user account on the target operating system. D. Create a replayer user account in the target database system. E. Preprocess the captured workload on the source system.
36. Which SAP HANA database system usage types are automatically assigned to tiles in the SAP HANA cockpit? There are 3 correct answers to this question. A. Sandbox B. Test C. Development D. Custom E. Production.
37. Which features are provided by the Manage Full System Information Dumps app in SAP HANA cockpit? There are 2 correct answers to this question. A. Diagnosis information B. Runtime environment C. SAP HANA minichecks D. End-to-end Trace.
38. Which system privilege must you have to redistribute tables across the hosts in your scale-out system? Please choose the correct answer. A. DATA ADMIN B. WORKLOAD ADMIN C. OPTIMIZER ADMIN D. RESOURCE ADMIN.
39. How can you ensure that a consistent database status is saved using data snapshots? Please choose the correct answer. A. Trigger a save point B. Create an internal database snapshot. C. Create a fullback snapshot. D. Execute the hdbbackupdiag tool.
40. Which user credentials are requested during the initial run of the configuration phase when performing the Database Migration Option (DMO) procedure to a SAP HANA 2.0 database tenant? There are 3 correct answers to this question. A. The DBACOCKPIT user of the tenant database B. The SYSTEM user of the system database C. The SAP user in client 000 of the ABAP system D. The S-user for the SAP Support Portal connection E. The DDIC user in client 000 of the A BAP system.
41. 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 system with three worker and one standby nodes? Please choose the correct answer. A. 1.0 TB B. 1.5 TB C. 375 GB D. 512 GB.
42. Which types of backups can you use to copy a SAP HANA tenant? There are 2 correct answers to this question. A. Delta database backup B. Fallback snapshot C. Data snapshot D. Full database backup.
43. Which user management tasks can be performed by a Lightweight Directory Access Protocol (LDAP) server? There are 2 correct answers to this question. A. User mapping B. Role assignment C. User creation D. Password policy configuration.
44. Which role do you need in order to assign users to groups in SAP HANA cockpit? Please choose the correct answer. A. Cockpit Administrator B. Cockpit Resource Administrator C. Cockpit User Administrator D. Cockpit User.
45. Which properties can you adjust in SAP HANA Admission Control? There are 3 correct answers to this question. A. Memory limit for queuing requests B. SQL statement request memory limit C. Maximum request queue size D. CPU threshold for rejecting requests E. Maximum parallel 10 requests.
46. Which tool do you use to investigate a SAP HANA system that is started but can't be reached using SQL? There are 2 correct answers to this question. A. hdbcons B. HANASitter C. HDBAdmin D. Sapcontrol.
47. Which parameters do you need to change before you can analyse the memory usage of running SQL statements? There are 2 correct answers to this question. A. enable_tracking B. use_in_memory_tracing C. statement_memory_limit D. memory_tracking.
48. Which SAP HANA cockpit application can you use to investigate a system offline situation? Please choose the correct answer. A. CPU usage monitor B. Full system information dump C. Troubleshoot unresponsive system D. Out-of-memory event monitor.
49. During the delta merge process, to which memory areas is data inserted? There are 2 correct answers to this question. A. Main 2 B. Main 1 C. Delta 1 D. Delta 2.
50. Which prerequisites are necessary for productively using SAP HANA cockpit 2.0? There are 2 correct answers to this question A. An Intel-based system with operating system Microsoft Windows B. An IBM Power System with operating system SUSE Linux Enterprise Server (SLES) C. 16 GB RAM on a dedicated server D. 10 GBit/s network bandwidth.
51. What can you directly assign to a user with the Manage Users app in SAP HANA cockpit? There are 2 correct answers to this question A. Scopes B. Privileges C. Role collections D. Roles.
52. Which is the relationship between the user group operators and the user groups? There are 2 correct answers to this question A. Multiple user groups per user group operator B. Only one user group operator per user group C. Only one user group per user group operator D. Multiple user group operators per user group.
53. In which scenario do you need SAP expert sizing? There are 2 correct answers to this question. A. Customers want to migrate their existing SAP NetWeaver-based systems to run on SAP HANA B. Consolidating multiple ERP source systems into one ERP system on SAP HANA C. Carving out ERP functionality from the source system to the ERP on SAP HANA system. D. Customers are new to SAP applications and SAP HANA.
54. Which prerequisites are necessary for using the SAP HANA database lifecycle manager (HDBLCM) Web user interface? There are 2 correct answers to this question A. Communication port 1129 is open. B. SAP HANA database system in any version. C. Installed SAP Host Agent on the SAP HANA host. D. SAP HANA Client software locally installed.
55. What is the correct sequence of the following four steps in the restart of the SAP HANA database system? Please choose the correct answer. A. 1. Aborted transactions are rolled back. 2. Open transactions are recovered. 3. Row tables are loaded into memory. 4. Column tables are loaded. B. 1. Row tables are loaded into memory. 2. Open transactions are recovered. 3. Aborted transactions are rolled back. 4. Column tables are loaded. C. 1. Row tables are loaded into memory. 2. Column tables are loaded. 3. Open transactions are recovered. 4. Aborted transactions are rolled back. D. 1. Aborted transactions are rolled back. 2. Row tables are loaded into memory. 3. Open transactions are recovered. 4. Column tables are loaded. .
56. What do you have to consider when you perform a Tailored Data Center Integration (TDI) installation for a productive SAP HANA database system? There are 2 correct answers to this question. A. Obtaining the hardware certification from SAP for the existing hardware you are going to use. B. Having 10 GBit/s for storage zone and 1 GBit/s for internal zone for network connectivity. C. Obtaining C_HANATEC_XX Certification. D. Having the data and log volumes on the different disks.
57. Which preparation tasks do you need to perform before starting the Database Migration Option (DMO) procedure? There are 2 correct answers to this question. A. Move the latest R3trans update archive into the download folder. B. Check if the latest SPAM/SAINT update is applied. C. Extract the SAP HANA database software installation archive. D. Update the SAP Host Agent to the latest version.
58. Which alert configuration properties can you configure in SAP HANA cockpit? There are 3 correct answers to this question. A. Email alert notification B. Alert threshold values C. Schedule period D. Schedule activation E. Alert checker Category.
59. Which privileges are assigned automatically when you create a technical user during the register resource procedure in SAP HANA cockpit? There are 2 correct answers to this question. A. SELECT on the _SYS_STATISTICS schema B. CATALOG READ C. SELECT on the _SYS_TELEMETRY schema D. RESOURCE ADMIN.
60. Which migration features are supported when using the Database Migration Option (DMO) feature of SAP Software Update Manager (SUM)? There are 2 correct answers to this question. A. The target database is SAP Adaptive Server Enterprise (ASE). B. The source and target database system are of the same type. C. The Primary Application Server can be moved to a target system Landscape. D. The source system is Application Server (AS) Java-based.
61. What can you use the Secure User Store (hdbuserstore) for? There are 2 correct answers to this question. A. To configure failover supporting a 3-tier scenario B. To store connection information on the SAP HANA database client C. To store connection information on the SAP HANA XS Advanced engine D. To configure a SAP HANA Auto-Restart Fault Recovery Support.
62. What is the additional disk space factor required during delta merge operations? Please choose the correct answer A. 4.0 B. 1.2 C. 3.0 D. 1.6.
63. Which tasks can you perform using the SAP HANA database lifecycle manager (HDBLCM) on installation media? There are 2 correct answers to this question. A. Update SAP HANA and its components. B. Rename the SAP HANA database system. C. Uninstall SAP HANA database components. D. Extract components.
64. Which prerequisites must you consider to rename a tenant database in the SAP HANA cockpit? There are 2 correct answers to this question. A. The tenant database is stopped. B. The on-disk tenant directory should be a mount point. C. The database that is not in move operation. D. The tenant database must be unloaded from memory.
65. In a SAP HANA database system running in log mode "normal", in which situation does the system automatically execute a regular log backup? There are 2 correct answers to this question. A. When the time threshold is exceeded. B. When a commit occurs. C. When the log segment is full. D. When the log buffer is full.
66. How are hosts assigned to the shared storage in an SAP HANA scale-out system? There are 2 correct answers to this question. A. The standby server is assigned to the master data volume. B. The master name server is assigned to its master data volume. C. The master server is assigned to all data volumes. D. The slave servers are assigned to their own data volumes.
67. Wich Prerequisities must be fulfilled when recovery a tenant database? There are 2 correct answer to thid cuestion A You need the logon credentials of the system database user B The whole syste is shut down, including all tenant databases C you need the logonm credentials of the <sid> adm user D Before the reocvery starts, the tenant database must be stopped.
68. Wich characteristics describe an SAP HANA Multiple Data BAse Container (MDC) System? There are 3 correct answers to this question A multiple database container System in identified by a single System ID (SID) The name server owns information about the location of tables an table partirions in database Each tanant database runs its own compile server an the prepocessor server The name sever provides index functionality for the system database The database isolation increases the isolation between tenant database an the operating level.
69. Which replication modes keep the primary system waiting until a timeout in exceeded when the secondary system is not avaiable? There are 2 correct answer to this question ASYNC SYNC SYNCMEM FULL SYNC.
70. Which SAP HANA features can you use to manage the database peak load? There are 2 correct answer to this question Workload classes Capture and replay Admission control Thread throttling.
71. 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 1 TB system, log volume = 1 TB,/hana/shared/ = 1TB For 512 GB system, log volume = 512 GB,/hana/shared/ = 256 GB For 256 GB system, log volume = 128 GB,/hana/shared/ = 256 GB For 2 TB system, log volume = 1 TB,/hana/shared/ = 1TB.
72. What do you hace consider when you perfom a Tailored Data Cente Integration (TDI) installation for a productive SAP HANA database system? There are 2 correct answer to this question Obtaining the hardware certification from SAP for extisting hardware you are going to use Obtaining C_HANATEC_XX Certification Having 10GBit/s for storage zone and 1GBit/s for internal zone for network connectivity Having the data an log volumes on the different disk.
73. What do you need in a Multitenant Database Container (MDC) system to run queries across tenant database? There are 2 correct answer to this question The bidirectional communication channel must be whitelisted The cross-tenant database communication must be explicitly activated The user in the source system must have sufficient privileges in the target database The user in the source system must be assiciated with a user in the target dadataba.
74. Which file sysytem are supported for the SAP HANA database system= There ar 2 corret answer to this question EXT3 GPFS MPFS XFS.
75. Which chacks are executed when you run Hardware Configuration heck Tool (HWCCT)? There are 3 correct answer to this question validation of the operating system configuration settings for the linux kernel measurement of data throughput between the linux kernel and cpu validation of the LPAR configuration settings on IBM power servers Measurement of data Thougthput between SAP HANA nodes and storage Measurement of the data Throughput between CPU and DRAM.
76. Which activities do you have to carry out to configure your Multiple Database Container (MDC) system to a higher database isolation between tenant database on the operating system (OS) Level? 3 correts responsed Add dedicated tenant OS user to the sapsys group remove the <sid> adm OS user from the sapsys group lock the adm user create dedicated tenant OS user for each tenant add dedicated tenant OS user to the <sid> shm group.
77. Which parameter do you set to protect an SAP HANA database system against uncontrolled queries that consume excessive memory? There are 2 correct answers memory_tracking total_statement_memory_limit statement_memory_limit reject_memory_threshold.
78. 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 a correct answer colum store and row store metadata manager and transaction manager page manager and logger session management and log volmenes.
79. Which system privilege must you have to manager black listed parameters in SAP HANA cockpit? please choose the correct answer WORKLOAD ADMIN RESOURCEADMIN INIFILE ADMIN DATABADE ADMIN.
80. What is a characteristic of the Delta Data Shipping operation mode in SAP HANA system replication? Please choose the correct answer Delta data Shipping takes place in addition to continuous log Shipping Delta data shipping takes place in addition to continuous log replay Delta data shipping takes place with continuous read-only access to the secondary system Delta data shipping takes place every 5 mimutes.
Report abuse Consent Terms of use