Hana Tech Questions
C. Data replication
A company is planning to upgrade from an SAP HANA platform license to an SAP HANA enterprise license. Which additional component will be provided? Please choose the correct answer. Choose one: A. Database for SAP NetWeaver BW B. SAP Sybase ASE C. Data replication D. XS application development
D. - 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
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? Please choose the correct answer. A. - Open Transaction Process Overview (SM50) in the SAP NetWeaver system - Sort the list by CPU time - Select the top entry - Check the User and Report columns B. - Go to the Performance tab of SAP HANA studio - Check the System load diagram C. - Open Transaction Global Work Process Overview (SM66) in the SAP NetWeaver system - Sort the list by CPU time - Select the top entry D. - 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
C. Use the authorization dependency viewer.
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. A. Check the assigned roles in the user editor. B. Query the system view EFFECTIVE_PRIVILEGES. C. Use the authorization dependency viewer. D. Investigate the authorization trace.
B. ALTER USER <username> RESET CONNECT ATTEMPTS
A user is locked due to too many failed logon attempts. Which SQL command can solve this problem? Please choose the correct answer. Choose one: A. ALTER USER <username> FORCE PASSWORD CHANGE AFTER ATTEMPTS B. ALTER USER <username> RESET CONNECT ATTEMPTS C. ALTER USER <user_name> DROP CONNECT ATTEMPTS D. ALTER USER <user_name> ACCOUNT UNLOCK
B. Autostart to "1" in the profile file /usr/sap/<SAPSID>/SYS/profile/<SID>_HDB<Instance_No>_<host_name>
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. Choose one: A. Autostart to "TRUE" in the profile file /usr/sap/<SAPSID>/SYS/profile/DEFAULT.PFL B. Autostart to "1" in the profile file /usr/sap/<SAPSID>/SYS/profile/<SID>_HDB<Instance_No>_<host_name> C. Autostart to "Enable" in the profile file /usr/sap/<SAPSID>/SYS/profile/<SID>_HDB<Instance_No>_<host_name> D. Autostart to "Yes" in the profile file /usr/sap/<SAPSID>/SYS/profile/DEFAULT.PFL
A. They provide prebuilt business content. B. They reduce the time required for implementation.
Which of the following are benefits of using accelerators with SAP HANA? There are 2 correct answers to this question. Choose: A. They provide prebuilt business content. B. They reduce the time required for implementation. C. They provide prebuilt customer-specific solutions. D. They eliminate the need for customization.
B. Index server processes on all nodes C. Shared file system for all nodes E. A statistics server on one active node
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. A name server on one active node B. Index server processes on all nodes C. Shared file system for all nodes D. Data replication to the standby nodes E. A statistics server on one active node
A. SELECT on SYS_REPL.RS_REPLICATION_COMPONENTS with grant option D. ROLE_ADMIN
Which of the following privileges are mandatory for the initial user to configure SAP LT to populate the SAP HANA database? There are 2 correct answers to this question. A. SELECT on SYS_REPL.RS_REPLICATION_COMPONENTS with grant option B. CREATE ANY in _SYS_BIC schema C. EXECUTE of REPOSITORY_REST(SYS) D. ROLE_ADMIN
C. SELECT option on the _SYS_REPO schema
Which of the following privileges do you need to activate views? Please choose the correct answer. A. SELECT option on the _SYS_BIC schema B. SELECT option on the _SYS_BI schema C. SELECT option on the _SYS_REPO schema D. SELECT option on the _SYS schema
B. SAP LT
Which of the following requires a dedicated network interface to SAP HANA? Please choose the correct answer. A. SAP HANA studio B. SAP LT C. Backup destination D. SAP BusinessObjects Business Intelligence platform
D. Go to Backup Editor -> Backup Catalog -> Delete Older Backups -> Catalog and backup location
How can you delete old data and log backups from both the backup catalog and physically from the server? Please choose the correct answer. A. Delete all files under $(DIR_GLOBAL)/hdb/log B. Run "DELETE from m_backup_catalog_files where backup_id = <backup_id>" in the SQL editor C. Delete all files under $(DIR_INSTANCE)/backup/data and $(DIR_INSTANCE)/backup/log D. Go to Backup Editor -> Backup Catalog -> Delete Older Backups -> Catalog and backup location
B. SQL
If you want to create or drop tables in a schema, which privilege type do you need? Please choose the correct answer. Choose one: A. Analytic B. SQL C. Package D. System
B. %TEMP%\hdb_studio_<time_stamp>
In Microsoft Windows, to which folder are the logs written by default during the SAP HANA studio installation? Please choose the correct answer. Choose one: A. %USERPROFILE%\hdb_studio_<time_stamp> B. %TEMP%\hdb_studio_<time_stamp> C. C:\Program Files (x86)\hdb_studio_ D. %USERNAME%\hdb_studio_
C. Columnar store D. Massive parallel processing
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. Choose: A. Asymmetric multi-processing B. Diskless data storage C. Columnar store D. Massive parallel processing
A. Create an analytic privilege B. Select an attribute and define restricted values for it . E. Assign the analytic privilege to the users
In an analytic view, you want to restrict the access for users according to their geographical reporting region. What do you have to do to achieve this? There are 3 correct answers to this question. Choose: A. Create an analytic privilege B. Select an attribute and define restricted values for it. C. Assign a package privilege to the users D. Create a filter on an attribute E. Assign the analytic privilege to the users
B. Diagnosis Files
In the SAP HANA studio, in which tab can you find information about the performance of queries? Please choose the correct answer. A. Alerts B. Diagnosis Files C. System Information D. Trace Configuration
B. Backup Editor Backup Catalog Backup Details
In the SAP HANA studio, where can you check the throughput performance of SAP HANA backups? Please choose the correct answer. A. Administration Console Diagnosis files Backup.log B. Backup Editor Backup Catalog Backup Details C. System Information Database Information D. Administration Console Performance Job Progress
B. Content node SALES schema node Tables folder double-click on the table CUST_DATA D. Content node SALES schema node Tables folder right-click on the table CUST_DATA Open Definition
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? There are 2 correct answers to this question. Choose: A. Content node SALES schema node Tables folder right-click on the table CUST_DATA Open Content B. Content node SALES schema node Tables folder double-click on the table CUST_DATA C. Content node SALES schema node Tables folder simple on the table CUST_DATA Open Definition D. Content node SALES schema node Tables folder right-click on the table CUST_DATA Open Definition
C. Reset of the system to a specific point in time D. Disk crash of the log area E. Disk crash of the data area
In which of the following situations is a recovery of an SAP HANA database applicable? There are 3 correct answers to this question. A. Corruption of kernel binary files B. Crash of the SLT server C. Reset of the system to a specific point in time D. Disk crash of the log area E. Disk crash of the data area
C. Move the log files to another volume and create a symbolic link to the new folder.
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. Choose one: A. Run "Delete older backups" in the Backup Catalog. B. Set the log_mode parameter to overwrite in global.ini. C. Move the log files to another volume and create a symbolic link to the new folder. D. Delete older log files from the log volume before the last successful database backup.
D. MS SQL Server Express
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. Choose one: A. SAP MaxDB B. MySQL C. SYBASE Adaptive Server Enterprise D. MS SQL Server Express
B. Run command./hdbaddhost --SID= --password= --role=standby.
What must you do to configure SAP HANA high availability? Please choose the correct answer. Choose one: A. Call stored procedure SYS.UPDATE_LANDSCAPE_CONFIGURATION. B. Run command./hdbaddhost --SID= --password= --role=standby. C. Run command./hdbinst --SID=<SID> --password=<password> --autostart=off. D. Right click the Navigator panel and choose Add System...
D. Application data
What type of data is transferred between the SAP HANA database and end user clients? Please choose the correct answer. Choose one: A. Configuration models B. Data models C. Configuration data D. Application data
D. An SAP HANA technician authorized by the hardware vendor delivering the appliance only
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. A certified Sybase IQ Administrator Professional B. A certified SAP HANA Technical Consultant C. An SAP HANA consultant employed by SAP AG or its subsidiaries only D. An SAP HANA technician authorized by the hardware vendor delivering the appliance only
C. Use SQL commands D. Use the BRBACKUP command
What are the recommended ways to perform a database backup? There are 2 correct answers to this question. A. Use the./hdbsetup command B. Use SAP HANA Studio C. Use SQL commands D. Use the BRBACKUP command
C. SAP BusinessObjects Data Services
What can you use to transform data from SAP Business Warehouse (BW) into SAP HANA? Please choose the correct answer. Choose one: A. SAP BW extractors B. SAP Landscape Transformation (SLT) C. SAP BusinessObjects Data Services D. SAP Legacy System Migration Workbench (LSMW)
C. The backup execution must be monitored. D. The database backup must be stored at a different location than the database server.
What do you have to consider when you design a backup plan? There are 2 correct answers to this question. A. The newest data must be backed up most often. B. The column table data needs to be compressed before a backup. C. The backup execution must be monitored. D. The database backup must be stored at a different location than the database server.
C. It saves changed data to disk at regular intervals.
What does the save point process in SAP HANA do? A. It synchronizes changed data to the disaster recovery system. B. It frees up memory by saving non-active data to disk. C. It saves changed data to disk at regular intervals. D. It saves changed data to disk when transactions are committed.
C. The standby host starts an index server and waits. D. The standby host registers with the master name server.
What happens when you add a standby host to an existing SAP HANA system? There are 2 correct answers to this question. A. The standby host takes over one of the active index servers. B. The standby host registers with the index server. C. The standby host starts an index server and waits. D. The standby host registers with the master name server.
B. Database
What is the connection type for communication between the SAP LT Replication Server and the non- SAP source system? Please choose the correct answer. Choose one: A. QRFC B. Database C. Web service D. TRFC
B. 3
What is the maximum number of master name servers that you can define in a distributed landscape? Please choose the correct answer. Choose one: A. 2 B. 3 C. 8 D. 1
D. A datastore
What must you configure in Data Services 4.0 to establish a connection to SAP ERP? Please choose the correct answer. Choose one: A. An InfoObject B. A DB connection C. An RFC connection D. A datastore
B. The log volume equals the amount of memory (RAM) of the system. D. The data volume is at least four times the amount of memory (RAM) of the system.
When you install SAP HANA, which of the following disk size requirements apply? There are 2 correct answers to this question. A. The log volume is at least four times the amount of memory (RAM) of the system. B. The log volume equals the amount of memory (RAM) of the system. C. The data volume equals the amount of memory (RAM) of the system. D. The data volume is at least four times the amount of memory (RAM) of the system.
B. Maintain the content_vendor parameter
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. A. Maintain the vendor ID B. Maintain the content_vendor parameter C. Grant REPO.MAINTAIN_NATIVE_PACKAGES privilege D. Grant REPO.MAINTAIN_DELIVERY_UNITS privilege
C. The host agent is not installed.
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. Choose one: A. The SAP HANA client is not installed. B. SAP SUM is not installed. C. The host agent is not installed. D. The SAP HANA database is not installed.
B. Administration Editor Diagnosis Files tab
Where do you check log and trace files in SAP HANA studio? Please choose the correct answer. Choose one: A. Administration Editor System Information tab B. Administration Editor Diagnosis Files tab C. Administration Editor Performance tab D. Diagnosis Files tab Modeler Diagnosis Files tab
C. Backup editor D. global.ini
Where in the SAP HANA studio can you change the path of the backup folder? There are 2 correct answers to this question. Choose: A. executor.ini B. Backup catalog C. Backup editor D. global.ini
A. net.ipv4.tcp_slow_start_after_idle and kernel.shmmni
Which Linux kernel parameters need to be adapted during SAP HANA installation depending on the SAP HANA system size? Please choose the correct answer. Choose one: A. net.ipv4.tcp_slow_start_after_idle and kernel.shmmni B. fs.file-max and net.core.wmem_max C. kernel.shmall and fs.file-max D. net.core_rmem_max and kernel.sysrq
C. USER ADMIN, CREATE STRUCTURED PRIVILEGE, ROLE ADMIN
Which combination of authorizations is required for this user? Please choose the correct answer. Choose one: A. USER ADMIN, SERVICE ADMIN, DATA ADMIN B. USER ADMIN, CREATE STRUCTURED PRIVILEGE, RESOURCE ADMIN C. USER ADMIN, CREATE STRUCTURED PRIVILEGE, ROLE ADMIN D. USER ADMIN, SERVICE ADMIN, ROLE ADMIN
B. The Calculation Engine
Which component of SAP HANA Database is used when you query an SAP HANA information model to populate a pivot table in Microsoft Excel? Please choose the correct answer. A. The Log Volumes B. The Calculation Engine C. The Transaction Manager D. The SQL Interface
B. Relational connection using JDBC D. Relational connection using ODBC
Which connectivity options can you use to create an SAP BusinessObjects universe on SAP HANA? There are 2 correct answers to this question. ??? Choose: A. Relational connection using BICS B. Relational connection using JDBC C. Relational connection using MDX D. Relational connection using ODBC
A. CONTENT_ADMIN
Which delivered role is mandatory for a system administrator in SAP HANA? Please choose the correct answer. A. CONTENT_ADMIN B. IC MODELER C. SYS_ADMIN D. SAP_ALL
B. JDBC
Which driver is required for the connection between SAP HANA and SAP BusinessObjects Explorer? Please choose the correct answer. A. BICS B. JDBC C. ODBO D. ODBC
D. Operational data provider
Which new connection type is available as of SAP BusinessObjects Data Services 4.0? Please choose the correct answer. A. BAPI function calls B. Read table via ABAP data flows C. IDOCs D. Operational data provider
B. File Repository Server D. Platform Processing Services
Which of the following Information Platform Services components must you install for Data Services 4.0? There are 2 correct answers to this question. Choose: A. Auditing Proxy Processing Service B. File Repository Server C. Monitoring Processing Server D. Platform Processing Services
D. fullSystemInfoDump.py
Which of the following SAP HANA tools is used to collect diagnostic information? Please choose the correct answer. A. landscapeHostConfiguration.py B. hdbnsutil C. hdbsql D. fullSystemInfoDump.py
A. https://<host>:8443/studio_repository/
Which of the following URLs do you define for Software Update Manager? Please choose the correct answer. A. https://<host>:8443/studio_repository/ B. https://<host>:8444/studio_repository/ C. http://:8443/studio_repository/ D. http://:8444/studio_repository/
B. Eliminates the need for customization D. Reduces reporting time
Which of the following are advantages of using the SAP CO-PA accelerator? There are 2 correct answers to this question. A. Transforms data during the load step B. Eliminates the need for customization C. Provides business configuration D. Reduces reporting time
A. Data exports D. Runtime dump files
Which of the following are allowed to be written to the disk space for the data volumes in an SAP HANA system? There are 2 correct answers to this question. A. Data exports B. Backup data files C. Log files D. Runtime dump files
A. The sizing of the current SAP NetWeaver BW application server remains valid. D. The current SAP NetWeaver BW application server hardware can be re-used.
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. Choose: A. The sizing of the current SAP NetWeaver BW application server remains valid. B. The SAP NetWeaver BW application server can be installed on the SAP HANA hardware. C. All SAP NetWeaver BW 7.x application versions can be used. D. The current SAP NetWeaver BW application server hardware can be re-used.
C. It is transportable between systems. D. It is granted through the execution of stored procedures.
Which of the following are characteristics of a design-time role? There are 2 correct answers to this question. Choose: A. It is revoked if the grantee user is deleted. B. It is granted and revoked directly by an administrator. C. It is transportable between systems. D. It is granted through the execution of stored procedures.
A. Schedule replication processes. D. Map database structures between SAP HANA and the source system.
Which of the following are functions of the controller on the SAP Landscape Transformation (SLT) server? There are 2 correct answers to this question. A. Schedule replication processes. B. Write data to the SAP HANA system using the DB connection. C. Create repositories in the source system. D. Map database structures between SAP HANA and the source system.
A. Disk sizing C. CPU sizing E. Memory sizing
Which of the following are parts of SAP HANA sizing? There are 3 correct answers to this question. Choose: A. Disk sizing B. Network bandwidth sizing C. CPU sizing D. Data and log file sizing E. Memory sizing
C. MODELING D. MONITORING
Which of the following are pre-delivered template roles? There are 2 correct answers to this question. Choose: A. HANA_ADMIN B. SAP_INTERNAL_HANA_SUPPORT C. MODELING D. MONITORING
C. SMD agent running on SAP HANA D. Host agent running on SAP HANA
Which of the following are required to monitor SAP HANA in SAP Solution Manager? There are 2 correct answers to this question. A. Host agent running on SAP Solution Manager B. SMD agent running on SAP Solution Manger C. SMD agent running on SAP HANA D. Host agent running on SAP HANA
A. Privilege to role B. Privilege to user D. Role to role
Which of the following are valid authorization assignments? There are 3 correct answers to this question. Choose: A. Privilege to role B. Privilege to user C. Privilege to privilege D. Role to role E. Role to privilege
B. Alert status of SAP HANA internal alerting C. Host level monitoring E. Availability of SAP HANA services
Which of the following can be monitored in SAP Solution Manager system monitoring? There are 3 correct answers to this question. Choose: A. Expensive SQL statements B. Alert status of SAP HANA internal alerting C. Host level monitoring D. User-specific traces E. Availability of SAP HANA services
A. Reducing the size of the row-based tables
Which of the following can decrease the startup time of an SAP HANA system after a reboot? Please choose the correct answer. Choose one: A. Reducing the size of the row-based tables B. Reducing the number of column tables in the database C. Reducing the size of the transactional data records D. Reducing the number of fields in the master data
A. Open the Plan Explanation. B. Open the Plan Visualizer.
Which of the following can you use to analyze an expensive SQL statement? There are 2 correct answers to this question. Choose: A. Open the Plan Explanation. B. Open the Plan Visualizer. C. Open the hdbcons tool. D. Open the SQL Plan Cache.
B. Name server
Which of the following components enables SAP HANA high availability? Please choose the correct answer. Choose one: A. Index server B. Name server C. Statistics server D. Preprocessor server
B. Collection script C. Host agent
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. A. CCMS agent B. Collection script C. Host agent D. SMD agent
B. global.ini
Which of the following configuration files contains the backup locations of log and data files? Please choose the correct answer. A. attributes.ini B. global.ini C. indexserver.ini D. localclient.ini
D. http connection
Which of the following connection types does Direct Extractor Connection (DXC) use to transfer data to SAP HANA? Please choose the correct answer. Choose one: A. BICS connection B. RFC connection C. Secondary database connection D. http connection
A. Servers
Which of the following do you add when you "scale out" SAP HANA? Please choose the correct answer. Choose one: A. Servers B. Data storage C. CPUs D. Memory
C. Calculation-intensive logic is pushed down to the database.
Which of the following is a result of using SAP HANA as an application platform? Please choose the correct answer. A. All database queries have a sub-second response time. B. Aggregates in data models are only materialized when required. C. Calculation-intensive logic is pushed down to the database. D. The need for indexes is eliminated.
B. DROP
Which of the following is an SQL privilege? Please choose the correct answer. A. DEVELOPMENT B. DROP C. SAVEPOINT ADMIN D. EXPORT
C. Peak used memory
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. A. Virtual memory B. Used memory C. Peak used memory D. Resident memory
A. sapstartsrv
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. A. sapstartsrv B. SMD Agent C. r3trans D. disp+work
B. Storage
Which of the following must be shared by SAP HANA nodes in a high availability scenario? Please choose the correct answer. Choose one: A. Virtual host name B. Storage C. Shared memory D. Network
A. Data Provisioning Modeling Consumption SAP HANA system setup Modeling
Which of the following sequences of steps is used to implement SAP HANA with SAP ERP? Please choose the correct answer. Choose one: SAP HANA system setup A. Data Provisioning Modeling Consumption SAP HANA system setup Modeling B. Data Provisioning Consumption SAP HANA system setup C. Data Provisioning Consumption Modeling D. Data Provisioning SAP HANA system setup Modeling Consumption
A. The memory consumption of the delta storage exceeds a limit.
Which of the following situations can trigger a delta merge? Please choose the correct answer. A. The memory consumption of the delta storage exceeds a limit. B. A pre-defined time of day has arrived. C. An SQL statement must read merged data. D. The number of records in the main storage exceeds a limit.
B. Total uncompressed size of tables required for queries
Which of the following source data sizes should you use to size SAP HANA memory? Please choose the correct answer. Choose one: A. Total compressed size of source database B. Total uncompressed size of tables required for queries C. Total uncompressed size of tables and indexes required for queries D. Total uncompressed size of source database
A. Copy the data and log volume files from system B to system A. D. Restore a complete database backup from system B to system A.
Which of the following steps allow you to create a test system (system A) based on a productive SAP HANA standalone system (system B)? There are 2 correct answers to this question. Choose: A. Copy the data and log volume files from system B to system A. B. Copy a snapshot from system B to system A. C. Export the data from system B to a file share and import the data to system A. D. Restore a complete database backup from system B to system A.
B. Define the number of jobs to be used for data replication.
Which of the following steps is required for configuring SAP Landscape Transformation (SLT)? Please choose the correct answer. Choose one: A. Define the number of background work processes in SLT. B. Define the number of jobs to be used for data replication. C. Define a DB connection from SLT to the source system. D. Define an RFC connection from SLT to SAP HANA.
A. CONTENT_ADMIN
Which of the following template roles allows a user who has been assigned this role to grant the privileges of this role to other users? Please choose the correct answer. A. CONTENT_ADMIN B. MODELING C. PUBLIC D. MONITORING
C. SAP Netweaver Identity Management D. hdbsql
Which of the following tools can you use to create and manage SAP HANA database users? There are 2 correct answers to this question. A. SAP Solution Manager B. Microsoft Active Directory C. SAP Netweaver Identity Management D. hdbsql
A. Expensive statements trace
Which of the following traces provides information about past SQL query runtime performance including the values of parameters? Please choose the correct answer. A. Expensive statements trace B. Performance trace C. User-specific trace D. SQL trace
B. HDB info
Which operating system commands show the SAP HANA processes? There are 2 correct answers to this question. Choose: A. HDB admin B. HDB info C. HDB version D. HDB proc
A. Test Data Migration Server (TDMS) C. TREX engine
Which technologies use trigger-based replication? There are 2 correct answers to this question. A. Test Data Migration Server (TDMS) B. ABAP extractors C. TREX engine D. Near Zero Downtime E. Standard SQL database replication
B. SAP BusinessObjects Data Services
Which tool do you use for complex data transformation of SAP ERP data? Please choose the correct answer. Choose one: A. Sybase Replication Server B. SAP BusinessObjects Data Services C. SAP BusinessObjects Explorer D. SAP Landscape Transformation (SLT)
B. SQL Trace
Which tools can you use to monitor the query time from SAP HANA? Please choose the correct answer. A. Performance tab of the System Monitor B. SQL Trace C. Central Management Console D. Event Viewer
A. _SYS_REPO
Which user must have SELECT privilege with the grant option on the data schema? Please choose the correct answer. Choose one: A. _SYS_REPO B. _SYS_BIC C. SYSTEM D. <SID>ADM
A. M_DATABASE
Which view displays the current SAP HANA Support Package level? Please choose the correct answer. Choose one: A. M_DATABASE B. M_HOST_INFORMATION C. M_VERSION_MEMORY D. M_LANDSCAPE_HOST_CONFIGURATION
A. Navigator view
Which view in SAP HANA studio do you use to add additional users? Please choose the correct answer. A. Navigator view B. Quick Launch view C. Properties view D. Console view
A. Use the Visualize Plan functionality in the SAP HANA studio.
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? Please choose the correct answer. A. Use the Visualize Plan functionality in the SAP HANA studio. B. Use Job Progress in the SAP HANA studio. C. Use Performance Trace in HDB admin. D. Use EXPLAIN (graphically) in the DBA Cockpit.
C. Import the metadata from SAP HANA into SAP BusinessObjects Data Services.
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. A. Import data from the SAP ERP system into SAP HANA. B. Create a connection in SAP BusinessObjects Data Services to the SAP ERP system. C. Import the metadata from SAP HANA into SAP BusinessObjects Data Services. D. Create an SAP BusinessObjects Data Services job to migrate data to SAP HANA.
A. Database changes are continuously updated to the secondary site. D. The take-over only requires a roll forward since the last synchronization point.
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. Choose: A. Database changes are continuously updated to the secondary site. B. Memory and CPU are used on the secondary site for shadow processes. C. The take-over happens in less than 3 minutes. D. The take-over only requires a roll forward since the last synchronization point.
D. When the export system is configured in CTS
You are using the Change and Transport System (CTS) with SAP HANA. When is the transport strategy determined? Please choose the correct answer. A. When the objects are attached to a transport request in the SAP HANA studio B. When the SAP HANA application type is configured in CTS C. When the connection to CTS is configured in SAP HANA studio D. When the export system is configured in CTS
A. Assign values to be restricted. Choose at least one information model to assign restrictions. C. Choose an attribute and define restricted values for it. D. Assign the analytic privilege to a user or role.
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. Choose: A. Assign values to be restricted. Choose at least one information model to assign restrictions. B. Assign restricted values to the attribute view. C. Choose an attribute and define restricted values for it. D. Assign the analytic privilege to a user or role. E. Assign values to be restricted to a content table.
C. GRANT SELECT ON SCHEMA <schema_name> TO _SYS_REPO WITH GRANT OPTION
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. A. GRANT SELECT ON SCHEMA <schema_name> TO _SYS_BIC B. GRANT CREATE ANY ON SCHEMA <schema_name> TO _SYS_REPO C. GRANT SELECT ON SCHEMA <schema_name> TO _SYS_REPO WITH GRANT OPTION D. GRANT SELECT ON SCHEMA <schema_name> TO _SYS_BI WITH GRANT OPTION
D. SAP HANA keeps the space for later reuse.
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. Choose one: A. You did not execute the ALTER SYSTEM RECLAIM LOG B. You did not execute a full backup and restore to reduce the size of the data volumes. C. SAP HANA did not trigger a delta merge yet. D. SAP HANA keeps the space for later reuse.
A. Log volumes can be backed up D. Committed transactions can be recovered E. Save points can be backed up
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. A. Log volumes can be backed up B. Non-committed transactions can be recovered C. Configuration files can be restored automatically D. Committed transactions can be recovered E. Save points can be backed up
B. 50 GB for the entire system and 150 GB individually for Host B C. 75 GB for the entire system
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. Choose: A. 100 GB for the entire system and 200 GB individually for Host A B. 50 GB for the entire system and 150 GB individually for Host B C. 75 GB for the entire system D. 300 GB for the entire system
B. Allow modeling only on the SAP HANA development system and export/import the models to the productive system. C. Use randomized data for the development of data models.
You have an SAP HANA productive system with sensitive dat a. How can you restrict modeling users from viewing this data? There are 2 correct answers to this question. A. Remove SAP_DATA_ADMIN in the SQL privileges for the modeling users. B. Allow modeling only on the SAP HANA development system and export/import the models to the productive system. C. Use randomized data for the development of data models. D. Remove ALTER SYSTEM in the system privileges for the modeling users.
C. hdbsql -o backup.sql
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. Choose one: A. hdbsql -S backup.sql B. hdbsql -c backup.sql C. hdbsql -o backup.sql D. hdbsql -I backup.sql
A. An agile data mart
You have to create an SAP HANA architecture that meets the following requirements: - Data provisioning is performed in batch mode - Data transformation is performed during the load step, - Reporting is run using analytic data models. Which of the following scenarios would you implement? Please choose the correct answer. Choose one: A. An agile data mart B. An operational data mart C. An SAP HANA accelerator D. SAP HANA as application platform
D. 35115
You installed SAP HANA Database using 51 as your system number. Which network port is used for Standard SQL communication for client access? Please choose the correct answer. Choose one: A. 55113 B. 35100 C. 31551 D. 35115
C. Virtual tables
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. A. SAP Sybase IQ B. Full-text search indexes C. Virtual tables D. SAP Landscape Transformation
B. SQL privilege SELECT for the SQL object SYS_STATISTICS D. System privilege DATA_ADMIN
You need to create a role that allows read-only access to the tabs of SAP HANA Administration Editor. Which of the following privileges do you need to assign to that role? There are 2 correct answers to this question. Choose: A. System privilege CONTENT_ADMIN B. SQL privilege SELECT for the SQL object SYS_STATISTICS C. System privilege SERVICE_ADMIN D. System privilege DATA_ADMIN
A. By assigning analytic privileges to the necessary users
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? Please choose the correct answer. Choose one: A. By assigning analytic privileges to the necessary users B. By assigning SQL privileges to the necessary users C. By assigning package privileges to the necessary users D. By assigning system privileges to the necessary users
