Which view in SAP HANA studio do you use to add additional users?Please choose the correct answer. Navigator view Quick Launch view Properties view Console view.
Which of the following are characteristics of a design-time role?
There are 2 correct answers to this question. It is revoked if the grantee user is deleted. It is granted and revoked directly by an administrator. It is transportable between systems. It is granted through the execution of stored procedures.
Which of the following can be monitored in SAP Solution Manager system monitoring?
（3 correct answers ） 'Expensive SQL statements Alert status of SAP HANA internal alerting Host level monitoring User-specific traces Availability of SAP HANA services.
Which of the following is influenced by the audit level? The messages that are sent to the security administrator The amount of data transferred to SAP Solution Manager The order of the audit log entries in the audit log The information that is printed with the audit log entry.
Which of the following components need a server certificate when you configure the SAP HANA Automated Update function? Host agent SAP HANA studio SAP HANA database Update Manager.
Which of the following can you do in the SAP HANA studio and also in the DBA Cockpit?
（3 correct answers ） Execute system recovery Implement backup scheduling. Monitor an SQLDBC trace. Display the statuses of database resources. Ⅴiew the tables in the _SYS_STATISTICS schema.
Which of the following can be imported into and exported from SAP HANA studio?
（3 correct answers ） Models Variants SQL statements Tables Landscape.
A long-running SQL query issued by an SAP NetWeaver work process also seems to use a lot of system resources.
How can you find out which ABAP module and which SAP NetWeaver user called the query?
（1 correct answers ） Open Transaction Process Overview (SM50) in the SAP NetWeaver -Check the User and Report columns Go to the Performance tab of SAP HANA studio
Check the System load diagram Open Transaction Global Work Process Overview (SM66) in the SAP
Select the top entry In SAP HANA studio,
check the session overview.
Identify the logical CONNECTION ID for the SAP NetWeaver work process.
Check the columns APPLICATIONSOURCE and APPLICATIONUSER
.
Which tools can you use to monitor the query time from SAP HANA?
（1 correct answers ） Performance tab of the System Monitor SQL Trace Central Management Console Event Viewer.
Which of the following users allow you to install SAP HANA studio on a Windows client platform?
（2 correct answers ） Domain users with administrator privileges <SID>ADM users without administrator privileges Local users with administrator privileges Local users without administrator privileges.
How can you find out which SAP HANA parameters have been changed in your system?
（2 correct answers ） By running the SQL query select * from
"PUBLIC"."M_CONFIGURATION" where options !='DEFAULT' By checking the indexserver trace file covering the last system startup. By checking the configuration tab of the Administration Console in SAP HANA studio By running the SQL query select * from
"PUBLIC"."M_INIFILE_CONTENTS" where layer_name !='DEFAULT'.
You want to make sure that all data accesses to a specific view will be logged in the audit trail. As part of an update of the database schema, the view is dropped and recreated under the same name.
What is the consequence for auditing?
（1 correct answers ） Auditing needs to be set up again for the recreated view. The audit log-object references must be reinitialized. The audit policy needs to be reactivated. Auditing continues to work for the view.
In the SAP HANA studio, in which tab can you find information about the performance of queries?
（1 correct answers ） Alerts Diagnosis Files System Information Trace Configuration.
Where do you check log and trace files in SAP HANA studio?
（1 correct answers ） Administration Editor Performance tab Diagnosis Files tab Modeler Diagnosis Files tab Administration Editor System Information tab Administration Editor Diagnosis Files tab.
SAP Support needs to access a customer's SAP HANA studio remotely. Which entry must the client maintain in SAP Service Marketplace?
（1 correct answers ） 'Preprocessor server 'Statistics server Name server Master index server.
You have exported a system landscape from an SAP HANA studio and imported it into a different SAP HANA studio. What information must you provide to make the imported landscape work?
'Connection path 'Passwords for all connections 'Server instance numbers Server host names.
Which of the following are required to monitor SAP HANA in SAP Solution Manager?
（2 correct answers ） 'Host agent running on SAP Solution Manager 'SMD agent running on SAP Solution Manger SMD agent running on SAP HANA Host agent running on SAP HANA.
What is the correct communication data flow between diagnostics in SAP Solution Manager and SAP HANA in the monitor scenario? Solution Manager HostAgent SAP HANA Solution Manager SMDAgent SAP HANA Solution Manager HostAgent SMDAgent SAP HANA Solution Manager SMDAgent HostAgent SAP HANA.
Which of the following traces provides information about past SQL query runtime performance including the values of parameters?
（1correct answers ） Expensive statements trace Performance trace User-specific trace SQL trace.
Which of the following traces is active by default in SAP HANA? 'SQL trace Expensive statements trace Performance trace Database trace.
Which of the following can you use to analyze an expensive SQL statement?
（2 correct answers ） Open the Plan Explanation. Open the Plan Visualizer. Open the hdbcons tool. Open the SQL Plan Cache.
You are reviewing the execution plan of an SQL statement. You want to find out which plan operators (POPs) have been executed in parallel and
for how long each of them has been active
How can you accomplish this? Use the Visualize Plan functionality in the SAP HANA studio. Use Job Progress in the SAP HANA studio. Use Performance Trace in HDB admin. Use EXPLAIN (graphically) in the DBA Cockpit.
Which of the following must you configure to enable monitoring of SAP HANA in DBA Cockpit? The CCMS agent in SAP HANA A database connection in the table DBCON The CCMS connection in DBA cockpit A database connection in DBA Cockpit.
Application users report that a query sometimes runs much slower than usual. You suspect that high system load is causing the slower query execution.Which of the following can you use to review overall system resource utilization at the time of query execution? 'DBA Cockpit (DBACOCKPIT) Performance Expensive DBA Cockpit (DBACOCKPIT) Current Status Alerts SAP HANA Studio Administration Console->Performance LOAD SAP HANA Studio System Monitor Sessions.
Where do you check log and trace files in SAP HANA studio?Please choose the correct answer. Administration Editor System Information tab Administration Editor Diagnosis Files tab Administration Editor Performance tab Diagnosis Files tab Modeler Diagnosis Files tab.
In the navigator tree of the SAP HANA studio, how can you find out which indexes are defined for table CUST_DATA from the SALES schema? Content node SALES schema node Tables folder right-click
on the table CUST_DATA Open Content Content node SALES schema node Tables folder double-click
on the 'table CUST_DATA Content node SALES schema node Tables folder simple
on the table CUST_DATA Open Definition Content node SALES schema node Tables folder right-click
on the table CUST_DATA Open Definition.
Which of the following SAP HANA tools is used to collect diagnostic information?
landscapeHostConfiguration.py hdbnsutil hdbsql fullSystemInfoDump.py.
Which tab in SAP HANA studio displays CPU load history data?
( 1 answer ) Overview Volumes Landscape Performance.
Which of the following update scenarios can be selected for execution in the SAP HANA lifecycle manager?
(2 answers) Apply support package stacks Update SAP HANA replication technologies components Update SAP HANA lifecycle manager (HLM) Update the SAP HANA studio on local machines.
Which of the following tools can you use to create and manage SAP HANA database users?
(2 answers) SAP Solution Manager Microsoft Active Directory SAP Netweaver Identity Management hdbsql.
Which of the following is used to deploy SAP-delivered content in SAP HANA? Server-side export/import SAP NetWeaver Development Infrastructure (NWDI) SAP Transport Management System (STMS) Java Support Package Management (JSPM).
When you transport objects between SAP HANA systems using the Change and Transport System (CTS), you want to create and release the transport requests manually.Which transport strategy should you choose? WBO_GET_REQ_STRATEGY = Tagged WBO_REL_REQ_STRATEGY = Manual WBO_GET_REQ_STRATEGY = Smart WBO_REL_REQ_STRATEGY = Auto WBO_GET_REQ_STRATEGY = Create WBO_REL_REQ_STRATEGY = Auto WBO_GET_REQ_STRATEGY = Smart WBO_REL_REQ_STRATEGY = Manual.
Which view displays the current SAP HANA Support Package level? M_DATABASE M_HOST_INFORMATION M_VERSION_MEMORY M_LANDSCAPE_HOST_CONFIGURATION.
Which of the following actions are required in the SAP HANA studio to use the Enhanced Change and Transport System (CTS+)?
(2 answers) Create a delivery unit that contains all of the runtime objects. Create the HTTP connection named CTSDEPLOY. Configure the connection to the CTS in the preferences. Use an authorized user to attach SAP HANA content to transport requests.
Which of the following URLs do you define for Software Update Manager? https://<host>:8443/studio_repository/ https://<host>:8444/studio_repository/ http://:8443/studio_repository/ http://:8444/studio_repository/.
You have to create an SAP HANA architecture that meets the following requirements:Data provisioning is performed in batch mode
Which of the following scenarios would you implement? An agile data mart An operational data mart An SAP HANA accelerator SAP HANA as application platform.
The statistics server was stopped during an upgrade by the system administrator.Which of the following parameters in statisticsserver.ini do you modify to restart the statistics server? statsconnect in the trace section editing in the statisticsserver_general section active in the statisticsserver_general section statsserv in the trace section.
Which of the following would you use to upgrade an SAP HANA system and keep the downtime to a minimum? High availability Storage replication Partitioning System replication.
You have to transport data models from one SAP HANA system to another using the Change and Transport System (CTS).
Where do you install the CTS plug in? In SAP Solution Manager In the source system In the XS engine In the SAP HANA studio.
A company is planning to upgrade from an SAP HANA platform license to an SAP HANA enterprise license.Which additional component will be provided? Database for SAP NetWeaver BW SAP Sybase ASE Data replication XS application development.
Which operating system commands show the SAP HANA processes?
There are 2 correct answers to this question. HDB admin HDB info HDB version HDB proc.
Which of the following sequences of steps is used to implement SAP HANA with SAP ERP?
Data Provisioning Modeling Consumption SAP HANA system Modeling Data Provisioning Consumption SAP HANA system setup Data Provisioning Consumption Modeling Data Provisioning SAP HANA system setup Modeling .
Which actions to you need to perform to configure SAP HANA single sign-on?
Please choose the correct answer. Generate and import X.509 certificate Generate and import PSE key Generate and import Kerberos keytab Generate and import SSH rsa key.
Which of the following must you do in the SAP HANA studio to be able to use the Change and Transport System (CTS)?
(2 correct answers) Configure the connection to the CTS in the preferences. Create a delivery unit that contains all of the information models. Create the HTTP connection CTSDEPLOY Use a user who is authorized to attach SAP HANA content to transport requests.
Which of the following are benefits of using accelerators with SAP HANA?
There are 2 correct answers to this question. They provide prebuilt business content. They reduce the time required for implementation. They provide prebuilt customer-specific solutions. They eliminate the need for customization.
Which of the following can be done by the SAP HANA lifecycle manager?
There are 3 correct answers to this question. Add an additional SAP HANA system Change the SAP HANA license type Copy an SAP HANA system Uninstall an SAP HANA system Rename an SAP HANA system.
When you try to create a delivery unit from the SAP HANA studio you receive the following error message. 'Cannot create Delivery Unit as content vendor is not defined for this system'.
How do you troubleshoot this issue?
Please choose the correct answer. Maintain the vendor ID Maintain the content_vendor parameter Grant REPO.MAINTAIN_NATIVE_PACKAGES privilege Grant REPO.MAINTAIN_DELIVERY_UNITS privilege.
Which of the following steps allow you to create a test system (system A) based on a productive SAP HANA standalone system (system B)?
(2 answers) Copy the data and log volume files from system B to system A. Copy a snapshot from system B to system A. Export the data from system B to a file share and import the data to Restore a complete database backup from system B to system A.
Which of the following can you use to update SAP HANA (SPS06)?
Please choose the correct answer. SAP HANA lifecycle manager SAP HANA update wizard SAP HANA on-site configuration tool Software update manager (SUM) for SAP HANA.
Which of the following update scenarios can be selected for execution in the SAP HANA lifecycle manager?
There are 2 correct answers to this question. Perform automated updates of SAP HANA and SAP HANA components. Apply support package stacks. Update the SAP HANA studio on local machines. Update SAP HANA replication technology components.
Which of the following are benefits of implementing SAP HANA?
There are 3 correct answers to this question. SAP HANA provides real-time analytics SAP HANA performs much faster than the standard SAP ERP SAP HANA replaces SAP BW SAP HANA provides pre-configured BI Content SAP HANA combines OLTP and OLAP in one system.
You have an SAP HANA productive system with sensitive data.How can you restrict modeling users from viewing this data?
There are 2 correct answers to this question. Remove SAP_DATA_ADMIN in the SQL privileges for the modeling users. Allow modeling only on the SAP HANA development system and export/import the models to the productive system. Use randomized data for the development of data models. Remove ALTER SYSTEM in the system privileges for the modeling .
You are using the Change and Transport System (CTS) with SAP HANA. When is the transport strategy determined? When the objects are attached to a transport request in the SAP HANA studio When the SAP HANA application type is configured in CTS When the connection to CTS is configured in SAP HANA studio When the export system is configured in CTS.
Which of the following can performed in the SAP HANA lifecycle manager?
Note: There are 3 correct answers to this question. Uninstall an SAP HANA system. Rename an SAP HANA system. Add an additional SAP HANA system. Copy an SAP HANA system. Change the SAP HANA license type.
You want to create a role that grants read-only access to the content of the system and monitoring views and to statistics services.
which privileges should the role contain\/
( 2 answers) DATA ADMIN ALTER for SQL schema _SYS_STATISTICS SERVICE ADMIN SELECT for SQL schema _SYS_STATISTICS.
Which of the following template roles allows a user who has been assigned this role to grantthe privileges of this role to other users?
CONTENT_ADMIN MODELING PUBLIC MONITORING.
In an analytic view, you want to restrict the access for users according to their geographical reporting region.
(3 answers) Create an analytic privilege Select an attribute and define restricted values for it Assign a package privilege to the users Create a filter on an attribute Assign the analytic privilege to the users.
Which delivered role is mandatory for a system administrator in SAP HANA?
Please choose the correct answer. CONTENT_ADMIN IC MODELER SYS_ADMIN SAP_ALL.
You want the user SOLMAN_ADMIN to be able to modify the properties of the SAP HANA instance during system configuration in SAP
Solution Manager.Which role must you assign to the user SOLMAN_ADMIN to achieve this?
Please choose the correct answer. SAP_SYSREC_ALL SAP_SOLAR02_ALL SAP_SM_ADMIN_COMPONENT_ALL SAP_SYSTEM_REPOSITORY_ALL.
You create an analytic view and want to restrict access to departments with specific values using analytic privileges. Which tasks do you have
to perform to accomplish this?
There are 3 correct answers to this question. Assign values to be restricted. Choose at least one information model
to assign restrictions. Assign restricted values to the attribute view. Choose an attribute and define restricted values for it. Assign the analytic privilege to a user or role. Assign values to be restricted to a content table.
Which combination of authorizations is required for this user?Please choose the correct answer. USER ADMIN, SERVICE ADMIN, DATA ADMIN USER ADMIN, CREATE STRUCTURED PRIVILEGE, RESOURCE ADMIN USER ADMIN, CREATE STRUCTURED PRIVILEGE, ROLE ADMIN USER ADMIN, SERVICE ADMIN, ROLE ADMIN.
A company wants to restrict data access to a specific year for certain users. Which privilege type must you define in sap hana to achive this requirement?
SQL privileges Package privileges System privileges Analytic privileges.
Which of the following privileges are mandatory for the initial user to configure SAP LT to populate the SAP HANA database? SELECT on SYS_REPL.RS_REPLICATION_COMPONENTS with grant CREATE ANY in _SYS_BIC schema EXECUTE of REPOSITORY_REST(SYS) ROLE_ADMIN.
Which of the following is an SQL privilege?Please choose the correct answer. DEVELOPMENT DROP SAVEPOINT ADMIN EXPORT.
Which of the following are valid authorization assignments?
There are 3 correct answers to this question. Privilege to role Privilege to user Privilege to privilege Role to role Role to privilege.
You need to create a role that allows read-only access to the tabs of SAP HANA Administration Editor.
Which of the following privilegesdo you need to assign to that role
( 2 answers) System privilege CONTENT_ADMIN SQL privilege SELECT for the SQL object SYS_STATISTICS System privilege SERVICE_ADMIN System privilege DATA_ADMIN.
An administrator should be enabled to cancel long running commands and end sessions.Which privilege must the user be granted?
SESSION ADMIN USER ADMIN RESOURCE ADMIN MONITOR ADMIN.
If you want to create or drop tables in a schema, which privilege type do you need? Please choose the correct answer. Analytic SQL Package System.
You created an information model in the SAP HANA studio and activated it successfully. When you execute the data preview you get an error
message indicating missing privileges.Which of the following could solve the problem?
Please choose the correct answer. GRANT SELECT ON SCHEMA <schema_name> TO _SYS_BIC GRANT CREATE ANY ON SCHEMA <schema_name> TO _SYS_REPO GRANT SELECT ON SCHEMA <schema_name> TO _SYS_REPO WITH GRANT SELECT ON SCHEMA <schema_name> TO _SYS_BI WITH GRANT OPTION.
You need to retrieve data from SAP HANA that is restricted to a certain region and specific users. How can you implement this security strategy? By assigning analytic privileges to the necessary users By assigning SQL privileges to the necessary users By assigning package privileges to the necessary users By assigning system privileges to the necessary users.
Which user must have SELECT privilege with the grant option on the data schema?Please choose the correct answer. SYS_REPO SYS_BIC SYSTEM <SID>ADM.
Which of the following are pre-delivered template roles?
There are 2 correct answers to this question. HANA_ADMIN SAP_INTERNAL_HANA_SUPPORT MODELING MONITORING.
When you install SAP HANA, which of the following disk size requirements apply?
There are 2 correct answers to this question. The log volume is at least four times the amount of memory (RAM) of the system. The log volume equals the amount of memory (RAM) of the system. The data volume equals the amount of memory (RAM) of the system. The data volume is at least four times the amount of memory (RAM) of the system.
In Microsoft Windows, to which folder are the logs written by default during the SAP HANA studio installation?Please choose the correct answer. %USERPROFILE%\hdb_studio_<time_stamp> %TEMP%\hdb_studio_<time_stamp> C:\Program Files (x86)\hdb_studio_ %USERNAME%\hdb_studio_.
Which of the following Information Platform Services components must you install for Data Services 4.0?
There are 2 correct answers to this question. Auditing Proxy Processing Service File Repository Server Monitoring Processing Server Platform Processing Services.
Which of the following commands installs or updates the repository for SAP HANA studio?
Please choose the correct answer. hdbinst -a studio - -copy_repository=<target_repository_path> hdbinst -a studio - -copy_repository=<source_repository_path> hdbinst -a studio - -repository=<target_repository_path> hdbinst -a studio - -repository=<source_repository_path>.
Which of the following components must be installed in SAP HANA to enable SAP Early Watch Alerts?
There are 2 correct answers to this question. CCMS agent Collection script Host agent SMD agent.
Where do you specify the instance number during the installation of SAP HANA?
Please choose the correct answer. In the installer execution file In the installer configuration file In global.ini In a dialog box prompt.
Which of the following prerequisites must be met before you can install the SAP HANA studio on a Linux operating system?
There are 2 correct answers to this question. The Java runtime is accessible via the PATH or JAVA_HOME variable. You are logged on as the <SID>adm user. You are logged on as the root user. The installation directory has at least 10 GB of free space.
After you install an SAP HANA database, you want to ensure that it is automatically started when the host is rebooted.Which of the following parameter settings allows you to do this?
Please choose the correct answer. Autostart to "TRUE" in the profile file
/usr/sap/<SAPSID>/SYS/profile/DEFAULT.PFL Autostart to "1" in the profile file
/usr/sap/<SAPSID>/SYS/profile/<SID>_HDB<Instance_No>_
<host_name> Autostart to "Enable" in the profile file
/usr/sap/<SAPSID>/SYS/profile/<SID>_HDB<Instance_No>_
<host_name> Autostart to "Yes" in the profile file
/usr/sap/<SAPSID>/SYS/profile/DEFAULT.PFL.
Which command is recommended by SAP to install an SAP HANA database via a graphical user interface (GUI)?
Please choose the correct answer. ./hdbsetup ./sapinst ./hdbinst ./hdbinst - install.
What do you have to consider when you design a backup plan?
There are 2 correct answers to this question.
The newest data must be backed up most often. The column table data needs to be compressed before a backup. The backup execution must be monitored. The database backup must be stored at a different location than the database server.
When does SAP recommend that you execute the first system backup? After completing the post-installation steps After a complete load of master data After the first data load Before updating the system.
What does the save point process in SAP HANA do? It synchronizes changed data to the disaster recovery system. It frees up memory by saving non-active data to disk It saves changed data to disk at regular intervals It saves changed data to disk when transactions are committed.
What are the recommended ways to perform a database backup?
There are 2 correct answers to this question. Use the./hdbsetup command Use SAP HANA Studio Use SQL commands Use the BRBACKUP command.
You have created a file named backup.sql with the following information to run a backup:
/c -n <server name> -i <instance number> -u <user> -p <password> BACKUP DATA USING FILE ('backupDirectory/data/COMPLETE_BK')
Which of the following commands executes the backup?Please choose the correct answer. hdbsql -S backup.sql hdbsql -c backup.sql hdbsql -o backup.sql hdbsql -I backup.sql.
How can you delete old data and log backups from both the backup catalog and physically from the server?
Please choose the correct answer. Delete all files under $(DIR_GLOBAL)/hdb/log Run "DELETE from m_backup_catalog_files
where backup_id = <backup_id>" in the SQL editor Delete all files under $(DIR_INSTANCE)/backup/data
and $(DIR_INSTANCE)/backup/log Go to Backup Editor -> Backup Catalog -> Delete Older Backups ->
Catalog and backup location.
In which of the following situations is a recovery of an SAP HANA database applicable?
(3 correct answers ) Corruption of kernel binary files Crash of the SLT server Reset of the system to a specific point in time Disk crash of the log area Disk crash of the data area.
Which of the following can decrease the startup time of an SAP HANA system after a reboot?
Please choose the correct answer. Reducing the size of the row-based tables Reducing the number of column tables in the database Reducing the size of the transactional data records Reducing the number of fields in the master data.
Where in the SAP HANA studio can you change the path of the backup folder?
There are 2 correct answers to this question. executor.ini Backup catalog Backup editor global.ini.
What is the purpose of the save point process in SAP HANA?
Please choose the correct answer. Save changed data and logs to persistent storage on a regular basis. Free up memory by saving less frequently used data to persistent storage. Save changed data to persistent storage when a transaction is committed. Save logs to persistent storage when a transaction is committed.
In the SAP HANA studio, where can you check the throughput performance of SAP HANA backups?
Please choose the correct answer. Administration Console Diagnosis files Backup.log Backup Editor Backup Catalog Backup Details System Information Database Information Administration Console Performance Job Progress.
Which feature is supported by the backup and recovery process within the standard delivery of SAP HANA?
Please choose the correct answer. Incremental backup Information model recovery Automatic backup of archiving log files scheduled within SAP HANA Point-in-time recovery.
Which of the following are recovery types in SAP HANA database?
There are 2 correct answers to this question. Recovery with incremental backup Recovery until cancel Full recovery Point in time recovery.
Which view allows you to find the name and the size of backup files?Please choose the correct answer. M_SERVICE_STATISTICS M_BACKUP_CATALOG M_SYSTEM_OVERVIEW M_BACKUP_CATALOG_FILES.
Which of the following files should be considered in your SAP HANA backup strategy?
There are 3 correct answers to this question. Export and import files Data and log files Dump files Kernel files Configuration files.
You are using continuous system replication between SAP HANA systems in two separate data centers.What are the advantages of this scenario?
There are 2 correct answers to this question. Database changes are continuously updated to the secondary site. Memory and CPU are used on the secondary site for shadow processes. The take-over happens in less than 3 minutes. The take-over only requires a roll forward since the last synchronization point.
Which technologies use trigger-based replication?
There are 2 correct answers to this question. Test Data Migration Server (TDMS) ABAP extractors TREX engine Near Zero Downtime Standard SQL database replication.
Of the databases that can be used for Data Services 4.0, which of the following is bundled with Information Platform Services (mini-BOE)?
Please choose the correct answer. SAP MaxDB MySQL SYBASE Adaptive Server Enterprise MS SQL Server Express.
You have to size an SAP HANA system for SAP NetWeaver BW. The SAP NetWeaver BW system is currently running on a non-SAP RDBMS.
Which of the following factors influences the size of the SAP HANA system?Please choose the correct answer. The partitioning of tables The number of indexes The size of aggregates The number of tables in the row store.
Which of the following are parts of SAP HANA sizing?
There are 3 correct answers to this question. Disk sizing Network bandwidth sizing CPU sizing Data and log file sizing Memory sizing.
Which of the following memory indicators can you reset to measure the impact of a new workload on memory usage?
Please choose the correct answer. Virtual memory Used memory Peak used memory Resident memory.
In SAP HANA, what is the recommended memory size you must reserve for dynamic objects?
Please choose the correct answer. The same size as the uncompressed source data The same size as the total size of the log files The same size as the memory required for static data The same size as the total size of the data files.
To ensure the supportability of SAP HANA, who must install the SAP HANA database on the SAP HANA appliance hardware?
Please choose the correct answer. A certified Sybase IQ Administrator Professional A certified SAP HANA Technical Consultant An SAP HANA consultant employed by SAP AG or its subsidiaries only An SAP HANA technician authorized by the hardware vendor delivering .
Which of the following configuration files contains the backup locations of log and data files?
Please choose the correct answer. attributes.ini global.ini indexserver.ini localclient.ini.
Which Linux kernel parameters need to be adapted during SAP HANA installation depending on the SAP HANA system size? net.ipv4.tcp_slow_start_after_idle and kernel.shmmni fs.file-max and net.core.wmem_max kernel.shmall and fs.file-max net.core_rmem_max and kernel.sysrq.
Which of the following is a result of using SAP HANA as an application platform?
Please choose the correct answer. All database queries have a sub-second response time. Aggregates in data models are only materialized when required. Calculation-intensive logic is pushed down to the database. The need for indexes is eliminated.
Which of the following authentication methods are provided by SAP HANA?
There are 2 correct answers to this question. RADIUS NTLM Kerberos Security Assertion Markup Language (SAML).
Which of the following are allowed to be written to the disk space for the data volumes in an SAP HANA system? Data exports Backup data files Log files Runtime dump files.
What is the maximum number of master name servers that you can define in a distributed landscape?
Please choose the correct answer. 2 3 8 1.
Which of the following is most relevant for CPU sizing of a SAP HANA appliance?Please choose the correct answer. The amount of disk storage The SAP HANA hardware platform The number of concurrent users logged onto SAP HANA The number of users actively running analytics in SAP HANA.
You have an SAP HANA development environment with 4 scale out servers of 512 GB RAM each (Hosts A, B, C, and D). You would like to allocate
exactly 300 GB to install a BW on HANA development database.Which of the following are valid values for the global_allocation_limit parameter?
There are 2 correct answers to this question. 100 GB for the entire system and 200 GB individually for Host A 50 GB for the entire system and 150 GB individually for Host B 75 GB for the entire system 300 GB for the entire system.
An organization has the following infrastructure standard:
Separate Server and User network managed by the internal network team
Centralized shared storage (SAN) with RAID-5 In-house full time SAP Basis, DBA, and OS team Unified on Red Hat Linux on Intel platform
All Windows 7 desktop/laptop VPN remote access Tape based off-site backup storage and active-passive remote site Disaster Recovery
Which of the following aspects of the IT infrastructure strategy will need to be reconsidered if they are to implement SAP HANA?
There are 3 correct answers to this question. Data Volume growth Backup and recovery Client Access to data Network security and bandwidth Hardware/OS support.
To ensure the supportability of SAP HANA, who must install the SAP HANA database on the SAP HANA appliance hardware?
Please choose the correct answer. A certified Sybase IQ Administrator Professional A certified SAP HANA Technical Consultant An SAP HANA consultant employed by SAP AG or its An SAP HANA technician authorized by the hardware vendor delivering the appliance only.
Which of the following source data sizes should you use to size SAP HANA memory?
Please choose the correct answer. Total compressed size of source database Total uncompressed size of tables required for queries Total uncompressed size of tables and indexes required for queries Total uncompressed size of source database.
Which of the following situations can trigger a delta merge?
Please choose the correct answer. The memory consumption of the delta storage exceeds a limit. A pre-defined time of day has arrived. An SQL statement must read merged data. The number of records in the main storage exceeds a limit.
What happens when you add a standby host to an existing SAP HANA system?
There are 2 correct answers to this question. The standby host takes over one of the active index servers. The standby host registers with the index server. The standby host starts an index server and waits. The standby host registers with the master name server.
What is the minimum required disk space for the data volumes of an SAP HANA system in relation to its memory (RAM)?
Please choose the correct answer. 1 * RAM 3 * RAM 4 * RAM 2 * RAM.
In addition to the in-memory database, which of the following technologies are part of SAP HANA?
There are 2 correct answers to this question. Asymmetric multi-processing Diskless data storage Columnar store Massive parallel processing.
You installed SAP HANA Database using 51 as your system number. Which network port is used for Standard SQL communication 55113 35100 31551 35115.
Which of the following connections require the highest network bandwidth?
Please choose the correct answer. SAP HANA and SBO BI SAP HANA and SAP HANA studio SAP HANA and SAP BW SAP HANA and SAP NetWeaver Portal.
When you try to stop SAP HANA using the sapcontrol command, you receive the error message.
"Command not found". What is the reason for the error?
Please choose the correct answer. The SAP HANA client is not installed. SAP SUM is not installed. The host agent is not installed. The SAP HANA database is not installed.
A user is locked due to too many failed logon attempts.Which SQL command can solve this problem?
Please choose the correct answer. ALTER USER <username> FORCE PASSWORD CHANGE AFTER ATTEMPTS ALTER USER <username> RESET CONNECT ATTEMPTS ALTER USER <user_name> DROP CONNECT ATTEMPTS ALTER USER <user_name> ACCOUNT UNLOCK.
Which of the following situations result in a system lockdown?
There are 2 correct answers to this question. The license keys installed in the database have been deleted. The license type was changed from platform to enterprise. The system ID and/or hardware key of the database have been changed after a system copy or renaming. The installed license key is an unenforced license key and the current memory consumption exceeds the licensed amount plus the tolerance.
You deleted billions of records from several tables in the SAP HANA database. However,the file system for the data volumes did not gain any free space.What is the reason?
Please choose the correct answer. You did not execute the ALTER SYSTEM RECLAIM LOG You did not execute a full backup and restore to reduce the size of the data volumes. SAP HANA did not trigger a delta merge yet. SAP HANA keeps the space for later reuse.
The log volume is full and the SAP HANA database does not accept any new requests.How can you solve this problem and bring the SAP HANA database online?
Please choose the correct answer. Run "Delete older backups" in the Backup Catalog. Set the log_mode parameter to overwrite in global.ini. Move the log files to another volume and create a symbolic link to the new folder. Delete older log files from the log volume before the last successful database backup.
A backup catalog became unusable.What can you do to recover existing backups?Please choose the correct answer. Create a new data backup. In SAP HANA studio Backup Editor Display all backups select REFRESH Recreate the backup catalog based on the available backup files with the tool hdbbackupdiag. Use a third party backup tool to recover the backups.
A user cannot query an information model because of missing authorizations.How can the user find out which authorization is missing?Please choose the correct answer. Check the assigned roles in the user editor. Query the system view EFFECTIVE_PRIVILEGES. Use the authorization dependency viewer. Investigate the authorization trace.
You are investigating a problem with the SAP HANA database.You opened a customer message with SAP support. SAP support asks you to provide diagnostic information from the SAP HANA instance.How can you gather this information?
There are 2 correct answers to this question. Run the fullSystemInfoDump.py script on the SAP HANA server as <SID>adm Run the HDB info command on the SAP HANA server as <SID>adm Execute Diagnosis Files -> Diagnosis Information -> Collect function in the SAP HANA studio Select and download all files under Diagnosis Files in the SAP HANA studio.
Which of the following are required to enable SAP HANA high availability?There are 2 correct answers to this question. SAP HANA distributed systems SUSE Linux Enterprise High Availability Extension Redundant storage and network High-performance computing clustering for Linux.
Which of the following must be shared by SAP HANA nodes in a high availability scenario?
Please choose the correct answer. Virtual host name Storage Shared memory Network.
You develop a disaster recovery plan. What do you have to ensure in case of a disk failure?
There are 3 correct answers to this question. Log volumes can be backed up Non-committed transactions can be recovered Configuration files can be restored automatically Committed transactions can be recovered Save points can be backed up.
What must you do to configure SAP HANA high availability?
Please choose the correct answer. Call stored procedure SYS.UPDATE_LANDSCAPE_CONFIGURATION. Run command./hdbaddhost --SID= --password= --role=standby. Run command./hdbinst --SID=<SID> --password=<password> --autostart=off. Right click the Navigator panel and choose Add System….
Which of the following components enables SAP HANA high availability?Please choose the correct answer. Index server Name server statistics server Preprocessor server.
How do you configure an SAP HANA system of 4 nodes when implementing high availability?Please choose the correct answer. 3 master nodes 1 standby node 1 master node 2 slave nodes 1 standby node 1 master node 3 slave nodes 2 master nodes 1 slave node 1 standby node.
You have to implement disaster recovery for an SAP HANA production system.You also want to use the secondary SAP HANA appliance for
development and testing.
The data centers are more than 100km (60 miles) apart;
the network capacity between them is restricted.
Which disaster recovery option would you implement?
Please choose the correct answer. Asynchronous system replication with continuous memory loading Synchronous system replication with continuous memory loading Asynchronous system replication with shadow processes Synchronous storage replication with shadow processes.
Which of the following must you implement for high availability in an SAP HANA production system?
There are 3 correct answers to this question. A name server on one active node Index server processes on all nodes Shared file system for all nodes Data replication to the standby nodes A statistics server on one active node.
Which of the following are functions of the controller on the SAP Landscape Transformation (SLT) server?
There are 2 correct answers to this question. Schedule replication processes. Write data to the SAP HANA system using the DB connection. Create repositories in the source system. Map database structures between SAP HANA and the source system.
Which of the following must be installed during the installation of SAP Landscape Transformation (SLT)?
There are 2 correct answers to this question. SAP NetWeaver 7.02 or higher DMIS add-on to the SAP source system SAP HANADB libraries to the source system Java stack for the SLT Server.
Which of the following can you use to configure the connection between the source system and SAP HANA in the SAP LT system?There are 2 correct answers to this question. SAP HANA studio -> Administration Console -> Add System SAP NetWeaver Administrator -> Configuration -> Destination Transaction LTR Web Dynpro application IUUC_REPLICATION_CONFIG.
Which tool do you use for complex data transformation of SAP ERP data?Please choose the correct answer. Sybase Replication Server SAP BusinessObjects Data Services SAP BusinessObjects Explorer SAP Landscape Transformation (SLT).
Which of the following connection types does Direct Extractor Connection (DXC) use to transfer data to SAP HANA? BICS connection RFC connection Secondary database connection http connection.
Which new connection type is available as of SAP BusinessObjects Data Services 4.0?
Please choose the correct answer. BAPI function calls Read table via ABAP data flows IDOCs Operational data provider.
What is the connection type for communication between the SAP LT Replication Server and the non-SAP source system? QRFC Database Web service TRFC.
What is the recommended approach by SAP when loading tables into SAP HANA from SAP ERP via Data Services? Use open hub Use the data staging server Use the ABAP application tier Use the Replication Server.
Which of the following are advantages of using the SAP CO-PA accelerator?There are 2 correct answers to this question. Transforms data during the load step Eliminates the need for customization Provides business configuration Reduces reporting time.
You set up a data transfer architecture that replicates data to SAP HANA from an SAP source system using SAP Landscape
Transformation (SLT).Which of the following SLT configuration parameter changes can improve the replication performance?
There are 3 correct answers to this question. Set data class of tablespace Change initial load mode Select Allow Multiple Usage in Connection to Source System Increase the number of calculation jobs Increase the number of data transfer jobs.
Which of the following authentication methods does SAP HANA support for http(s) access?There are 2 correct answers to this question. X.509 client certificates Header-based authentication LDAP authentication SAP logon tickets.
What type of data is transferred between the SAP HANA database and end user clients?Please choose the correct answer. Configuration models Data models Configuration data Application data.
Your customer wants to implement an SAP product that:-Providesnear real-time replication to SAP HANA,-ConnectsSAP HANA to a non-SAP SAP Legacy System Migration Workbench (LSMW) SAP BusinessObjects Data Services 4.0 SAP Landscape Transformation (SLT) Sybase Replication Server.
You are replicating data in real-time from a source system to SAP HANA using System Landscape Transformation (SLT). The source system had to be restored using a point-intime recovery to an earlier point in time. The systems are now out of sync.
How can you synchronize the systems again?
Please choose the correct answer. Select "Suspend" and "Resume" in the Data Provisioning dialog Run the hdbnsutil program on the command line Restart the master job using transaction LTR in the SLT system Select "Stop Replication" and "Replicate" in the Data Provisioning .
Your SAP HANA usage scenario does not require SAP HANA XS.What do you have to consider before you remove the SAP HANA XS service from the configuration?
There are 3 correct answers to this question. User <sid>adm is required to remove the SAP HANA XS service. A data backup must be taken after the SAP HANA XS service has been removed. The SAP HANA XS service must be removed from all hosts of the SAP HANA instance. The user privileges for accessing SAP HANA XS must be revoked.
Which of the following requires a dedicated network interface to SAP HANA?
Please choose the correct answer. SAP HANA studio SAP LT Backup destination SAP BusinessObjects Business Intelligence platform.
You need to replicate data from an SAP ERP production system to SAP HANA.Where does SAP recommend that you install the productive SAP Landscape Transformation (SLT) instance?
Please choose the correct answer. With the SAP Solution Manager system On the SAP HANA server On a dedicated server With the SAP ERP system.
What can you use to transform data from SAP Business Warehouse (BW) into SAP HANA?Please choose the correct answer. SAP BW extractors SAP Landscape Transformation (SLT) SAP BusinessObjects Data Services SAP Legacy System Migration Workbench (LSMW).
Which driver is required for the connection between SAP HANA and SAP BusinessObjects Explorer?Please choose the correct answer. BICS JDBC ODBO ODBC.
Which of the following are functions of the DB trigger within SAP Landscape Transformation (SLT)?
There are 2 correct answers to this question. Include only relevant tables for DB recording. Record relevant changes in logging tables. Ensure that replicated changes are kept within the logging tables. Decluster table classes into a transparent format.
You are using SAP BusinessObjects Data Services as your ETL tool. What is the next step required after you have created the datastore and imported the metadata from an SAP ERP system into SAP HANA?
Please choose the correct answer. Import data from the SAP ERP system into SAP HANA. Create a connection in SAP BusinessObjects Data Services to the SAP ERP system. Import the metadata from SAP HANA into SAP BusinessObjects Data Services. Create an SAP BusinessObjects Data Services job to migrate data to SAP HANA.
What must you configure in Data Services 4.0 to establish a connection to SAP ERP?Please choose the correct answer. An InfoObject A DB connection An RFC connection A datastore.
You need to combine unstructured data from an Apache Hadoop database with data in your SAP HANA system.What do you use to achieve this?Please choose the correct answer. SAP Sybase IQ Full-text search indexes Virtual tables SAP Landscape Transformation.
What must you do in SAP LT to establish a connection between a non-SAP source system database and SAP HANA.
There are 3 correct answers to this question. Create the source database connection in table DBCON. Add a source database connection in the DBA Cockpit. Define an RFC connection to the source system. Define the SAP LT RFC connection to SAP HANA. Define the SAP LT database connection to SAP HANA.
Which of the following steps is required for configuring SAP Landscape Transformation (SLT)?
Please choose the correct answer. Define the number of background work processes in SLT. Define the number of jobs to be used for data replication. Define a DB connection from SLT to the source system. Define an RFC connection from SLT to SAP HANA.
Which connectivity options can you use to create an SAP BusinessObjects universe on SAP HANA?
There are 2 correct answers to this question. Relational connection using BICS Relational connection using JDBC Relational connection using MDX Relational connection using ODBC.
Which of the following commands stops the SAP HANA database?Please choose the correct answer. HDB stop stopsap hdb HDB -stop stop HDB.
Which parameters do you change to configure the trace file rotation?
There are 2 correct answers to this question. maxfilesize tracefile maxfiles trace.
Which parameters do you change to configure the trace file rotation?There are 2 correct answers to this question. maxfilesize tracefile maxfiles trace.
Which of the following must be running to view SAP HANA Diagnosis Files if the SAP HANA database is offline?
Please choose the correct answer. sapstartsrv SMD Agent r3trans disp+work.
Which of the following are characteristics of SAP NetWeaver Business Warehouse (SAP NetWeaver BW) when it is migrated to run on the SAP HANA database?
There are 2 correct answers to this question. The sizing of the current SAP NetWeaver BW application server remains valid. The SAP NetWeaver BW application server can be installed on the SAP All SAP NetWeaver BW 7.x application versions can be used. The current SAP NetWeaver BW application server hardware can be re-used.
|
