EMT Practice Test

1. Question Content...

---

Question1: 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.

Question2: The SAP HANA database is NOT reachable, and the root cause is unclear. Which SAP HANA cockpit functions allow you to investigate this situation? Note: There are 2 correct answers.

Question3: You are performing a database migration option (DMO) procedure and applying SAP support packages in combination as in-place migration. Which steps take place during downtime?
There are 2 correct answers to this question.

Question4: Which user credentials do you need to stop the SAP HANA database system using the SAP HANA cockpit?
There are 3 correct answers to this question.

Question5: Which actions are always recorded when auditing is active? Note: There are 2 correct answers.

Question6: Which default users will be created during the installation of the SAP HANA database system? There are 2 correct answers to this question.

Question7: Which SAP HANA feature ensure that committed data is NOT lost if there is a power failure? Note: There are
2 correct answers.

Question8: Which checks are executed when you run the Hardware Configuration Check Tool (HWCCT)? There are 3 correct answers to this question.

Question9: What is a prerequisite before you can install SAP HANA Cockpit 2.0 as a central monitoring tool for productive SAP HANA databases?

Question10: You upgrade an SAP HANA 1.0 system to SAP HANA 2.0. Which of the following activities are required to avoid compatibility issues after the upgrade. Note: There are 2 correct answers.

Question11: Why does SAP HANA have a persistence storage layer that is disk-based? There are 2 correct answers to this question.

Question12: What is the first node limit for planning an SAP S/4HANA scale-out system? There are 2 correct answers to this question.

Question13: The design-time version of a security role can contain which of the following information? There are 2 correct answers to this question.

Question14: How can you perform a complete back up of an SAP HANA database system? Please choose the correct answer.

Question15: You migrate an SAP HANA system using SUM database migration option. Which activities do you perform to activate the viewer mode for SAP support? Note: There are 2 correct answers.

Question16: Which R3load mode is used during an inplace SUM database migration option procedure?

Question17: Which information can you analyze using the Troubleshoot Unresponsive System application?

Question18: Which value for the Autostart parameter do you use to control the automatic start of an SAP HANA system? Please choose the correct answer.

Question19: Who owns an SAP HANA Deployment Infrastructure (HDI) role? Please choose the correct answer.

Question20: How are hosts assigned to the shared storage in an SAP HANA scale-out system? There are 2 correct answers to this question.

Question21: 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.

Question22: Which operations are performed by SAP Landscape Management? Note: There are 2 correct answers.

Question23: 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.

Question24: Your customer wants to know when the productive SAP HANA system was updated and to which version. Where do you find this information? There are 2 correct answers to this question

Question25: 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?

Question26: Which prerequisites have to be fulfilled before you reset a database migration option (DMO) procedure?
There are 2 correct answers in this question.

Question27: 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?

Question28: Which activity must you perform before you can replay a workload using the Capture and Replay Application? Note: There are 2 correct answers.

Question29: Which tool do you use during the Database Migration Option (DMO) procedure to monitor table splitting? Please choose the correct answer.

Question30: 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.

Question31: Which operation is executed before a table is repartitioned?

Question32: What do you need in a Multitenant Database Container (MDC) system to run queries across tenant databases? There are 2 correct answers to this question.

Question33: What is the first node limit for planning an SAP S/4HANA scale-out system? There are 2 correct answers to this question.

Question34: 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.

Question35: How can troubleshoot HANA installer when its crashes There are 2 correct answers to this question.

Question36: Which of the following recovery types is not supported for delta backups?

Question37: What software innovations did SAP deliver with SAP HANA? There are 2 correct answers to this question.

Question38: Which backup scenarios are allowed in multitenant database containers? Note: There are 2 correct answers.

Question39: Your customer has purchased a 3 TB SAP HANA license. To which value do you set the GLOBAL_ALLOCATION_LIMIT parameter when you have four 2TB nodes in an SAP HANA scale-out system with three worker and one standby nodes?
Please choose the correct answer.

Question40: What are advantages of column store tables? There are 3 correct answers to this question.

Question41: Why does SAP HANA have a persistence storage layer that is disk-based? Note: There are 2 correct answers.

Question42: What are the supported operating systems for SAP HANA on IBM Power Servers? There are 2 correct answers to this question.

Question43: Which prerequisites must be fulfilled when recovering a tenant database? There are 2 correct answers to this question.

Question44: Which hardware KPIs do you need to size before performing a tailored data center integration (TDI) installation for a productive SAP HANA database system?
There are 2 correct answers to this questions.

Question45: A technical user is required when you register an SAP HANA system as a resource in SAP HANA cockpit 2.0.
Which system privileges do you assign to the technical user account on the target system?

Question46: What is the minimum space requirement for the Data Volume? There are 2 correct answers to this question.

Question47: Which role do you need in order to assign users to groups in SAP HANA cockpit? Please choose the correct answer.

Question48: How can you shorten the delta merge runtime of a table?

Question49: Which table partitioning types does SAP HANA support? There are 3 correct answers to this question.

Question50: Which user credentials do you need to stop the SAP HANA database system using the SAP HANA cockpit?
There are 3 correct answers to this question.

Question51: Your application runs with a technical user in a database of an SAP HANA multitenant database container. You want to execute a query across tenant databases. Which of the following prerequisites are required? There are 2 correct answers to this question.

Question52: What is the correct sequence of the following four steps when you restart the SAP HANA database system?
Please choose the correct answer.

Question53: Where is SDI used? There are 2 correct answers to this question.

Question54: You define the parameters for the password policy of an SAP HANA tenant database. Where are these parameters stored?

Question55: Which update methods can yo use to minimize the business downtime during the upgrade of an SAP HANA database? Note: There are 2 correct answers.

Question56: Which connection types are allowed when you use system replication with the Active/Active option? There are 2 correct answers to this question.

Question57: What can you assign to a user with the User Management app in SAP HANA cockpit?
There are 2 correct answers to this question.

Question58: Which option do you choose to protect your SAP HANA scale-out system using host autofailover?

Question59: For which scenarios is it mandatory to define the authorizations at HANA Level? There are 2 correct answers to this question.

Question60: Which SAP HANA database service can you stop from the system database? There are 2 correct answers to this question

Question61: Which kinds of patches are available in the SAP HANA2.0 revision strategy? Note: There are 2 correct answers.

Question62: What is included with the Predictive Analysis Library (PAL)? There are 2 correct answers to this question.

Question63: What is the recommended disk space for /hana/shared/<SID> for single-node SAP HANA systems? Please choose the correct answer:.

Question64: Which script can you trigger from SAP HANA cockpit to collect diagnosis information?

Question65: You register a new resource in SAP HANA cockpit 2.0. What prerequisite does the resource require?

Question66: Which of the following elements are valid rules for the location of the backup files? There are 3 correct answers to this question.

Question67: The data storage of your productive SAP HANA instance crashed and you need to recover the database. The log storage is still intact. You have a full data backup that is 9 hours old and an incremental backup that is 4 hours old To which point in time you can recover to minimize the data.

Question68: Which of the following events occur while the merge operation is running? There are 2 correct answers to this question.

Question69: Which of the following are characteristics of SAP HANA Smart Data Streaming?

Question70: 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.

Question71: What do you require to perform a migration using the SUM database migration option? Note: There are 2 correct answers.

Question72: Which certificates do you require for a trusted secure communication between the client and the SAP HANA database? Note: There are 2 correct answers.

Question73: In which scenario do you need SAP expert sizing? There are 2 correct answers to this question.

Question74: Which backup and recovery scenario is allowed in multitenant database containers?

Question75: Which technology does the SAP DBA Cockpit use to store the performance indicators? Please choose the correct answer.

Question76: What must you do to configure the data backup on a scale-out SAP HANA system? Note: There are 2 correct answers

Question77: What is the additional disk space factor required during delta merge operations? Please choose the correct answer.

Question78: 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.

Question79: What happens when you rename a tenant in an SAP HANA database Note: There are 2 correct answers.

Question80: What can a user do when the backup operator system privileges is assigned?

Question81: Which file systems are supported for the SAP HANA database system? There are 2 correct answers to this question.

Question82: Which tool do you use to backup the root encryption keys?

Question83: Which tool do you use to check that the actual size of the backup file is the same as the size recorded in the backup file header?
Please choose the correct answer.

Question84: Which value for the Autostart parameter do you use to control the automatic start of an SAP HANA system?
Please choose the correct answer.

Question85: 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.

Question86: 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:

Question87: Assume your current partitioning plan of SAP HANA is NOT optimal. Which option of the Manage Table Distribution tool do you use to evaluate if a partitioned table needs to be repartitioned? Please choose the correct answer.

Question88: Which alert configuration properties can you configure in SAP HANA cockpit? There are 3 correct answers to this question.

Question89: 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

Question90: The SAP HANA memory pool CANNOT satisfy the memory requests for new queries. Where does the SAP HANA database request additional memory?

Question91: Which information is stored in the SYSTEMDB of an SAP HANA multitenant database container system? Note: There are 2 correct answers.

Question92: 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.

Question93: 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.

Question94: 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.

Question95: Which system privilege must you have to restrict features for tennant databases in the SAP HANA cockpit?
Please choose the correct answer.

Question96: Which tools can you use to start and stop an SAP HANA database? Note: There are 3 correct answers.

Question97: Which tool shows the difference of tables and indexes between your ABAP dictionary and your SAP HANA database?

Question98: Which parameters are mandatory when using the hdblcm tool in batch mode? There are 2 correct answers to this question.

Question99: Which information is recorded in the database trace of the SAP HANA database?

Question100: 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?

Question101: 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.

Question102: A technical user is required when you register an SAP HANA system as a resource in SAP HANA cockpit 2.0. Which system privileges do you assign to the technical user account on the target system?

Question103: Which actions take place during a database migration option (DMO) procedure when performing an in-place migration?
There are 2 correct answers to this question.

Question104: What are some advantages of a system replication with operation mode logreplay compared to delta_datashipping Note: There are 2 correct answers.

Question105: SQL statements are rejected by the Workload Admission Control application, and you need to investigate the reason. Which parameters do you adjust to manage the event log? There are 2 correct answers to this question.

Question106: Which of the following privileges allow read access to data in SAP HANA information models depending on certain values or combination of values?

Question107: Which types of backup can you use to copy an SAP HANA tenant database?
There are 2 correct answers to this question.

Question108: SAP HANA system replication is configured and active between two SAP HANA systems. After which action must you perform manual steps to synchronize the systems? Please choose the correct answer.