EMT Practice Test

1. Question Content...

---

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

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

Question3: Which SAP HANA cockpit application can you use to investigate a system offline situation? Please choose the correct answer.

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

Question5: Which information is provided via the SUM Ul? There are 3 correct answers to this question.

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

Question7: Which system schema provides performance data and system alerts details to review in SAP HANA MiniChecks? Please choose the correct answer.

Question8: What are the prerequisites for using the Web user interface for HDBLCM? There are 2 correct answers to this question.

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

Question10: You switched the SAP HANA database to normal log mode. When does the system perform a regular log backup? Note: There are 2 correct answers.

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

Question12: Which of the following elements are required for implementing a database copy? There are 2 correct answers to this question.

Question13: In which SAP HANA configuration file can you view the assignments of hosts to their scale-out role?

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

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

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

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

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

Question19: Which system privilege must you have to redistribute tables across the hosts in your scale-out system?

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

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

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

Question23: Where are the R3load processes located when performing the Database Migration Option (DMO) procedure using the in-place migration? Please choose the correct answer.

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

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

Question26: What can you check with the SAP HANA Hardware Configuration Check Tool (HWCCT)? There are 2 correct answers to this question.

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

Question28: Which characteristics describe an SAP HANA Multiple Database Container (MDC) System?
There are 3 correct answers to this question.

Question29: What are the advantages of the DMO procedure? There are 3 correct answers to this question.

Question30: SAP HANA, in the context of user management, allows you to do which of the following? There are 3 correct answers to this question.

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

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

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

Question34: Which removal statuses allow you to remove a host from an SAP HANA scale-out landscape Note: There are 2 correct answers.

Question35: You perform an SAP HANA migration to a scale-out landscape. When do you setup the table distribution?

Question36: You setup email notification for a specific alert threshold by using Alerts Configuration. When are the email notification sent? Note: There are 2 correct answers.

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

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

Question39: What is a characteristic of the Delta Data Shipping operation mode in SAP HANA system replication? There are 2 correct answers to this question.

Question40: How do you ensure that Web-based applications send HTTPS requests to specific databases in an SAP HANA multiple-container system? Note: There are 2 correct answers.

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

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

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

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

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

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

Question47: You need to recover a tenant database backup from SAP HANA system 1 into SAP HANAsystem2. Which activities do you perform to restore the tenant? Note: There are 2 correct answers.

Question48: Which actions are performed during the database migration option (DMO) procedure when you select the 'Do not compare table contents' option?
There are 2 correct answers to this question.

Question49: After confirming Lock now, which actions are still possible? Choose the correct answer:.

Question50: Which fault recovery features can you implement to make your SAP HANA 2.0 production system more resilient against local hardware errors and software faults? There are 2 correct answers to this question.

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

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

Question53: Why do we still need a persistent layer? There are 2 correct answers to this question.

Question54: Which information is provided via the SUM UI? There are 3 correct answers to this question.

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

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

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

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

Question59: How are user group administrators and user groups related?
There are 2 correct answers to this question.

Question60: You install an SAP HANA database and SAP NetWeaver AS ABAP 7.5 on one productive system. Which of the following installation requirements are mandatory? There are 2 correct answers to this question.

Question61: Which components of SAP HANA Indexserver allow clients to connect and communicate with the SAP HANA database? Please choose the correct answer:.

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

Question63: You needt to integrate an existing SAP HANA2.0 SPS05 database system into the SAP HANA cockpit monitor infrastructure. Where do you create the technical user needed for the resource registration?

Question64: Which of the following system privileges can you assign to an SAP HANA database user? Note: There are 3 correct answers.

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

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

Question67: Which system privileges do you require to view roles that are granted to other users? Note: There are 2 correct answers.

Question68: Which tools do you use to delete diagnosis files? There are 2 correct answers to this question.

Question69: What is a prerequisite when you install the SAP Landscape Management tool? Please choose the correct answer.

Question70: Which database objects can you manipulate if you have the ALL PRIVILEGES activity? There are 2 correct answers to this question.

Question71: Which prerequisites of the primary system and the secondary system are mandatory before you can activate the SAP HANA system replication with secondary time travel? There are 2 correct answers to this question.

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

Question73: Which tasks can you perform using the SAP HANA database lifecycle manager (HDBLCM) on installation media? There are 2 correct answers to this question.

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

Question75: How can you ensure that a consistent database status is saved using data snapshots? Please choose the correct answer.

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

Question77: In which replication mode is the primary system blocked until the secondary system is available?

Question78: You plan to set up an SAP HANA2.0 system on intel-based hardware platform. Which of the following operating systems can you use Note: There are 2 correct answers.

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

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

Question81: After you start the SAP HANA database, what does the system do to ensure that it is in a consistent mode?

Question82: Which properties can you adjust in SAP HANA Admission Control? There are 3 correct answers to this question.

Question83: Which technology is used to install the SAP Landscape Management tool?
Please choose the correct answer.

Question84: Where is the name server running in a multitenant database container system? Please choose the correct answer.

Question85: Your SAP HANA database is locked down. Which action can you still perform?

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

Question87: Which file system locations do you need to specify when installing the SAP HANA multi-host database system using the default settings?
There are 2 correct answers to this question.

Question88: Which system usage types are automatically assigned to ties in the SAP HANA cockpit?
There are 3 correct answers to this question.

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

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

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

Question92: Which information is provided by the backup catalog. Please choose the correct answer:.

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

Question94: Which replication modes keep the primary system waiting until a timeout is exceeded when the secondary system is not available? There are 2 correct answers to this question.

Question95: Which is the relationship between the user group operators and the user groups? There are 2 correct answers to this question.