Which role do you need in order to assign users to groups in SAP HANA cockpit? Cockpit User
Cockpit Administrator
Cockpit Resource Administrator
Cockpit User Administrator
.
Which tool do you use during the Database Migration Option (DMO) procedure to monitor table splitting?
The Log viewer
The R3LDCTL The Process Bucket monitor
The Observer Monitor
.
Which parameter do you set to protect an SAP HANA database system against uncontrolled queries that consume excessive memory? (2 Correct)
statement_memory_limit
total_statement_memory_limit
memory_tracking
reject_memory_threshold
.
How can the system database administrator disable tenant database functionalities?
Using the Manage Restricted Features app
Using the resident hdblcm tool
Using the hdbuserstore tool Using the Manage Blacklisted Parameter app
.
Which migration features are supported when using the Database Migration Option (DMO) feature of SAP Software Update Manager (SUM)? (2 Correct)
The Primary Application Server can be moved to a target system Landscape.
The source and target database system are of the same type.
The target database is SAP Adaptive Server Enterprise (ASE).
The source system is Application Server (AS) Java-based.
Which is the relationship between the user group operators and the user groups? (2 Correct)
Only one user group operator per user group
Multiple user groups per user group operator
Only one user group per user group operator
Multiple user group operators per user group
.
Which tools do you use to delete diagnosis files? (2 Correct)
SAP HANA database explorer
SAP HANA cockpit
SAP HANA Web-based Development Workbench
SAP HANA cleaner
.
Which prerequisites are necessary for productively using SAP HANA cockpit 2.0? (2 Correct)
10 GBit/s network bandwidth
An IBM Power System with operating system SUSE Linux Enterprise Server (SLES)
16 GB RAM on a dedicated server
An Intel-based system with operating system Microsoft Windows
.
Which connections do you need to enable explicitly for a Restricted User? (2 Correct)
OLEDB JDBC ODBC ADO.NET
.
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? (2 Correct)
The disk resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same.
The memory resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be added.
The instance number for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same.
The System ID (SID) for the SAP NetWeaver AS ABAP system and the SAP HANA database must be different.
.
What are the merge methods that are triggered by the SAP HANA system processes? (2 Correct)
Hard
Critical Smart Auto
.
Which SAP HANA database service can you stop from the system database? (2 Correct)
Preprocessor
Compile server Index server
XS Engine
.
Who owns an SAP HANA Deployment Infrastructure (HDI) role?
The container-specific technical user
The user who created the role
The _SYS_REPO technical user
The SYSTEM user of the tenant database
.
In a Multiple Database Container (MDC) system, which privilege do you need to perform database-specific backups on all tenant databases?
BACKUP ADMIN
DATABASE ADMIN
BACKUP OPERATOR
TENANT ADMIN
.
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?
An upgrade of the primary system
An upgrade of the secondary system
A restart of the secondary system
A restart of the primary system
.
In which scenario do you need SAP expert sizing? (2 Correct)
Customers are new to SAP applications and SAP HANA
Carving out ERP functionality from the source system to the ERP on SAP HANA system.
Consolidating multiple ERP source systems into one ERP system on SAP HANA
Customers want to migrate their existing SAP NetWeaver-based systems to run on SAP HANA.
What is the additional disk space factor required during delta merge operations?
4 1.2 3 1.6.
Which backup and recovery scenario is allowed in multitenant database containers?
A backup of a tenant database can be recovered to the system database.
A tenant database can initiate its own backup, but the system database executes the recovery.
After the recovery of a tenant database, the system database needs a backup.
The system database should be recovered first in order to recover the tenant databases.
.
Which database objects can you manipulate if you have the ALL PRIVILEGES activity? (2 Correct) Views Sequences Procedures Tables
.
What is a characteristic of the Delta Data Shipping operation mode in SAP HANA system replication?
Delta data shipping takes place every 5 minutes.
Delta data shipping takes place in addition to continuous log shipping.
Delta data shipping takes place with continuous read-only access to the secondary system.
Delta data shipping takes place in addition to continuous log replay.
.
What is the correct minimum requirement for log volume and/hana/shared/ file system for an SAP HANA database system?
For 512 GB system, Log volume = 512 GB,/hana/shared/ = 256 GB
For 1 TB system, Log volume = 1 TB,/hana/shared/ = 1TB
For 256 GB system, Log volume = 128 GB,/hana/shared/ = 256 GB
For 2 TB system, Log volume = 1 TB,/hana/shared/ = 1TB
.
What are the supported operating systems for SAP HANA on IBM Power Servers? (2 Correct)
For SAP HANA 2.0, Red Hat Enterprise Linux (RHEL) 7.2
For SAP HANA 1.0, Red Hat Enterprise Linux (RHEL) 6. 10
For SAP HANA 2.0, SUSE Linux Enterprise Server (SLES) 12 and 15
For SAP HANA 1.0, SUSE Linux Enterprise Server (SLES) 11 SP4
.
Which SAP HANA cockpit application can you use to investigate a system offline situation? (2 Correct)
Full system information dump
Out-of-memory event monitor
Troubleshoot unresponsive system
CPU usage monitor
.
Which file system locations are suggested to install an SAP HANA multi-host system? (2 Correct)
/hana/<hostname>
/hana/<sid>
hana/log/<sid>
/hana/shared
.
Which parameters do you need to change before you can analyse the memory usage of running SQL statements? (2 Correct)
statement_memory_limit
use_in_memory_tracing
memory_tracking enable_tracking.
Which system privileges are required for administrating tenant databases when being connected to the system database? (2 Correct)
ADMIN DATABASE ADMIN
MONITOR ADMIN
BACKUP ADMIN
.
Which system privilege must you have to redistribute tables across the hosts in your scale-out system?
WORKLOAD ADMIN
RESOURCE ADMIN
OPTIMIZER ADMIN
DATA ADMIN
.
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?
Check the correct location of tables and partitions
Redistribute tables after adding host(s)
Check the number of partitions
Balance table distribution
.
Which prerequisites must you consider to rename a tenant database in the SAP HANA cockpit? (2 Correct)
The on-disk tenant directory should be a mount point.
The database that is not in move operation.
The tenant database is stopped.
The tenant database must be unloaded from memory.
.
Which prerequisites are necessary for using the SAP HANA database lifecycle manager (HDBLCM) Web user interface? (2 Correct)
Communication port 1129 is open.
SAP HANA Client software locally installed. SAP HANA database system in any version.
Installed SAP Host Agent on the SAP HANA host.
.
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? (3 Correct) Add dedicated tenant OS users to the <sid> shm group.
Create dedicated tenant OS users for each tenant.
Remove the <sid> adm OS user from the sapsys group.
Add dedicated tenant OS users to the sapsys group.
.
How are hosts assigned to the shared storage in an SAP HANA scale-out system? (2 Correct)
The standby server is assigned to the master data volume.
The master name server is assigned to its master data volume.
The master server is assigned to all data volumes.
The slave servers are assigned to their own data volumes.
.
You are checking and monitoring SAP HANA system replication. Which status indicates a temporary connection loss of the secondary system? Initializing Error
Unknown Syncing
.
Which prerequisites must you consider to add hosts to an SAP HANA scale-out system? (2 Correct)
The additional host is placed in a different data center
The host has access to the installation directories.
The SAP HANA database server is shut down.
The SAP HANA system installation should be on a shared file system.
.
Which table provides a customizing interface that can be used for the dynamic management of partitions and locations? TABLE_PLACEMENT TABLE_GROUP EFFECTIVE_TABLE_PLACEMENT UPDATE_LANDSCAPE_CONFIGURATION.
What do you need in a Multitenant Database Container (MDC) system to run queries across tenant databases? (2 Correct)
The cross-tenant database communication must be explicitly activated.
The user in the source system must be associated with a user in the target database. The user in the source system must have sufficient privileges in the target database.
The bidirectional communication channel must be whitelisted.
.
Which rules should you consider when creating a table distribution plan for SAP Business Suite on SAP HANA to get the best possible results? (2 Correct)
Keep the number of partitioned tables low.
Keep all partitions on different hosts.
Keep the number of partitions per table high.
Keep the number of key columns low.
.
The data storage of your productive SAP HANA instance crashed, and you need to recover the database. The log storage is still intact. You have a full data backup that is 9 hours old and an incremental backup that is 4 hours old. To which point in time can you recover to minimize the data loss?
The last full data backup
The latest log backup
The last commited transaction
The latest incremental backup
.
How are savepoints triggered? (2 Correct)
By performing a delta merge.
By issuing a transactional commit.
By a database soft shutdown.
By performing a database backup.
Which types of backups can you use to copy an SAP HANA tenant? (2 Correct) Full database backup Delta database backup
Data snapshot
Fallback snapshot
.
What is a prerequisite when you install the SAP Landscape Management tool? SAP NetWeaver Application Server ABAP SAP Fiori launchpad SAP NetWeaver Application Server Java SAP HANA XS Advanced.
What can you use the Secure User Store (hdbuserstore) for? (2 Correct)
To store connection information on the SAP HANA database client To store connection information on the SAP HANA XS Advanced engine To configure failover supporting a 3-tier scenario To configure an SAP HANA Auto-Restart Fault Recovery Support.
SQL statements are rejected by the Workload Admission Control application, and you need to investigate the reason. Which parameters do you adjust to manage the event log? (2 Correct) max_queue_size
queue_wait_time_threshold record_limit queue_timeout.
Which SAP HANA database system usage types are automatically assigned to tiles in the SAP HANA cockpit? (3 Correct) Test Development Custom Sandbox Production.
Which alert configuration properties can you configure in SAP HANA cockpit? (3 Correct) Schedule period Alert checker category Email alert notification Schedule activation Alert threshold values.
What additional action do you need to perform after you created a new tenant in an SAP HANA system replication configuration? Start tenant database. Restart secondary system. Copy tenant database. Back up tenant database.
Which user management tasks can be performed by a Lightweight Directory Access Protocol (LDAP) server? (2 Correct) Role assignment User creation User mapping Password policy configuration.
Which tool do you use to investigate an SAP HANA system that is started but can't be reached using SQL? (2 Correct) Sapcontrol hdbcons HDBAdmin HANASitter.
How can you ensure that a consistent database status is saved using data snapshots? Create a fullback snapshot. Trigger a save point. Execute the hdbbackupdiag tool.
Create an internal database snapshot.
.
Which parameters are mandatory when using the hdblcm tool in batch mode? (2 Correct)
Data and Log path
Installation path SAP HANA System ID (SID)
Password of the user sapadm
.
Which prerequisites must be fulfilled when recovering a tenant database? (2 Correct) Before the recovery starts, the tenant database must be stopped. The whole system is shut down, including all tenant databases. You need the logon credentials of the system database user. You need the logon credentials of the <sid> adm user.
Where are the R3load processes located when performing the Database Migration Option (DMO) procedure using the in-place migration? On the Additional Application Server (AAS) host
On the remote target database host
On the Primary Application Server (PAS) host On the source and target host.
Which privileges are assigned automatically when you create a technical user during the register resource procedure in SAP HANA cockpit? (2 Correct) CATALOG READ RESOURCE ADMIN SELECT on the _SYS_TELEMETRY schema SELECT on the _SYS_STATISTICS schema.
Which products do you use for SAP HANA administration? (2 Correct) SAP HANA cockpit SAP Solution Manager SAP Web IDE for SAP HANA SAP Master Data Governance.
Which SAP HANA features can you use to manage the database peak load? (2 Correct) Workload classes Admission control Capture and replay Thread throttling.
Which technology does the SAP DBA Cockpit use to store the performance indicators? SAP Adaptive Server Enterprise SAP Intelligent Query SAP Analytics Cloud SAP Business Intelligence.
What is the first node limit for planning an SAP S/4HANA scale-out system? (2 Correct) >= 8TB >= 8CPU >= 12CPU >= 6TB.
Which prerequisites must be fulfilled when recovering a tenant database? (2 Correct) You need the logon credentials of the system database user. The whole system is shut down, including all tenant databases. Before the recovery starts, the tenant database must be stopped. You need the logon credentials of the <sid> adm user.
Which system privilege must you have to manage black listed parameters in SAP HANA cockpit?
INIFILE ADMIN
DATABASE ADMIN
RESOURCEADMIN WORKLOAD ADMIN
.
During the delta merge process, to which memory areas is data inserted? (2 Correct)
Delta 2
Delta 1
Main 2
Main 1
.
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?
375 GB
1.0 TB
512 GB
1.5 TB.
You plan to migrate a non-SAP database to SAP HANA using the database migration option (DMO) of the Software Update Manager. Which processes can you adjust in the advanced mode to speed up the migration? (2 Correct)
TP SQL R3trans SAPup.
Which SAP HANA trace must you activate to analyze performance issues with systems where third-party software cannot be installed?
End-to-End
Kernel profiler
SQL
User-Specific
.
How can you perform a complete back up of an SAP HANA database system?
Back up the system database and all tenant databases in one step. Backup the complete storage system.
Back up the complete database system.
Back up the system database and all tenant databases individually.
.
Which characteristics describe an SAP HANA Multiple Database Container (MDC) System? (3 Correct)
The name server owns information about the location of tables and table partitions in databases.
The Database Isolation increases the isolation between tenant databases on the operating system level.
Each tenant database runs its own compile server and the preprocessor server.
A Multiple Database Container system is identified by a single System ID (SID).
The name server provides index server functionality for the system database.
.
You create a new user by copying an existing user. Which predelivered role of the existing user is automatically granted to the new user?
Monitoring Modeling Runtime Repository.
Which system schema provides performance data and system alerts details to review in SAP HANA MiniChecks? _SYS_WORKLOAD_REPLAY
_SYS_SQL_ANALYZER _SYS_TELEMETRY _SYS_STATISTICS.
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? (2 Correct)
An explicit read-only connect on between both systems must be available.
Both systems are located in the same data center.
The CPU architecture must be identical.
Both must have the same SAP HANA version.
.
When can you load and unload individual tables and table columns manually in an SAP HANA tenant database? (2 Correct) When you need to actively free up memory.
When you need to measure total memory.
When you need to optimize the standby node memory.
When you need to extend the scale-out memory.
.
Where is the name server running in a multitenant database container system?
Each tenant
Master node
SYSTEMDB Standby node
.
Which SAP HANA features are secured by certificates saved in the SAP HANA certificate store? (2 Correct)
Internal communication channels with the system PKI
SAP HANA tenant database replication
Client-server communication over JDBC
HTTPS client access using the SAP HANA Web Dispatcher
.
Which default users will be created during the installation of the SAP HANA database system? (2 Correct)
sapadm <sid>crypt
ldapadm
sap<sid>
.
Which preparation tasks do you need to perform before starting the copy and move process for a tenant database? (3 Correct)
Back up the source tenant database.
Create credentials for authenticated access to the target system.
Configure a secure connection from target system to source system
Create a tenant on the target system identical to the source system.
Create credentials for authenticated access to the source system.
.
Which user credentials are requested during the initial run of the configuration phase when performing the Database Migration Option (DMO) procedure to an SAP HANA 2.0 database tenant? (3 Correct)
The SAP user in client 000 of the ABAP system
The DBACOCKPIT user of the tenant database
The S-user for the SAP Support Portal connection
The SYSTEM user of the system database
The DDIC user in client 000 of the A BAP system
.
What can you check with the SAP HANA Hardware Configuration Check Tool (HWCCT)? (2 Correct)
Kernel settings
Network configuration
Missing OS patches
Memory configuration
.
How can you optimize the Database Migration Option (DMO) procedure downtime for a production system? (2 Correct)
Provide the measured table migration duration data for optimal table sequencing during benchmarking.
Set the optimal number of R31oad processes during benchmarking and the DMO procedure.
Use the Test Cycle opt on to find the optimal number of R31oad processes in a test run.
Use the benchmarking option to find the optimal throughput during the DMO procedure
.
Which preparation steps do you need to perform before replaying a captured workload using the SAP HA NA capture and replay tool? (3 Correct)
Restore the source system tenant backup to the target tenant.
Create a replayer user account on the target operating system.
Preprocess the captured workload on the source system. Create a replayer user account in the target database system.
Store the logon credentials of the replayer user in the secure store.
.
In an SAP HANA database system running in log mode "normal", in which situation does the system automatically execute a regular log backup? (2 Correct)
When a commit occurs.
When the log buffer is full.
When the log segment is full.
When the time threshold is exceeded.
.
The recovery of your productive SAP HANA tenant database fails. In which cases can you resume the incomplete recovery? (2 Correct)
Aborted recovery of a delta data backup
Aborted recovery of a complete data backup
Aborted recovery of the configuration files
Aborted recovery of a log backup
.
Which replication modes keep the primary system waiting until a timeout is exceeded when the secondary system is not available? (2 Correct)
SYNC ASYNC SYNCMEM FULL SYNC
.
A Text Join is a Right Outer Join used to join a text table containing multi-language descriptions, to an attribute in a dimension.
FALSE TRUE.
How many result tables are produced from running an End User Unit Test?
3 4 2.
As well as reading records one by one, using cursors allows you to change the record, too.
True False.
The results of a hierarchy generator function can be used only once.
True False.
In a SELECT with an OVER() clause, which of the following statements are true? (2 Correct)
An OVER clause with ORDER BY cannot contain a PARTITIONED BY.
PARTITIONED BY specifies the order of the rows in the result set.
ORDER BY specifies the order of the rows in the result set.
The SELECT statement cannot return NULL values.
The PARTITION BY clause is optional.
.
A transactional savepoint allows you to perform a partial rollback within a complex transaction.
TRUE
FALSE.
Which are true statements relating to calculation views of the type SQL access only? (2 Correct)
They do not expose their meta data to reporting tools
They are mainly used for reusing inside other calculation views
They include a star join node
They must include at least one measure
.
What are the three types of hierarchy function? (3 Correct)
Table
Navigation
Generation
Scalar
.
In a union, you do not have to select all source columns and the source columns do not have to have the same name.
TRUE FALSE.
The SQL Console is found in the Development view of the Web IDE.
TRUE
FALSE
.
What does SAP recommend you use to check your calculation view produces correct result?
Excel pivot tables
Custom SQL queries
Data preview function in the SAP Web IDE for SAP HANA
.
You have customers who appear in table A and sometimes they also appear in table B. You want to select the customers that appear ONLY in table A. Which node type do you use?
Minus Intersect Union
.
In a calculation view semantic node, which are valid column types? (2 Correct)
Dimension
Cube
Attribute Measure.
Which are supported data source types for calculation view consumption? (4 Correct)
Calculation views
Virtual tables
Column tables
Flat files
Row tables
.
What is a time-based dimension calculation view?
A view that stores the values of attributes across time
A view that is only accessible by users for a limited time
.
Why do you implement SQLScript Logging?
To record timestamps of all developers who have updated a SQL object
To identify the SQLScript code that is never used and can be removed
To highlight weak code design that might lead to poor performance
To capture the runtime log at the user level to support debugging
.
What is the purpose of the Projection node? (2 Correct)
To apply filters on the data
To join data sources
To extract only the required columns from a data source
To aggregate measures
.
What are best practices with SQLScript? (2 Correct)
Split complex queries into logical sub-queries.
Avoid cursors.
Use dynamic SQL.
.
If the current row has a value of 5000 and the three preceding rows have a value (in order) of 1000, 1500, and 3000, which rows would be included in ROWS BETWEEN 2 PRECEDING AND 1 PRECEDING?
1000, 1500, 3000, and 5000
1000 and 1500
1500 and 3000
1500.
Table User-Defined Functions can accept any number of input parameters and return any number of table results.
FALSE
TRUE.
What is the difference between GROUP BY CUBE and GROUP BY ROLLUP?
GROUP BY ROLLUP cannot be used in a SELECT statement. GROUP BY CUBE is not part of the ANSI SQL-99 standard.
GROUP BY CUBE aggregates in every dimension.
.
Which two statements are correct regarding table functions? (2 Correct)
They can return multiple tables.
They must be free of side effects.
They can have any number of input parameters.
They are used in the WHERE clause of a SELECT statement.
.
What is a user-defined library?
A repository for storing custom SQL code that is used frequently.
A group of variables, procedures and functions, which are related. A collection of frequently used input parameters that form part of a test script
.
What is the SAP HANA Deployment Infrastructure (HDI)? A source code versioning framework for SAP HANA source files
A type of application that is built from components developed in multiple languages
An isolated environment for storing SAP HANA database runtime objects
.
What is SQLScript?
A replacement for SQL that provides a more powerful language for developers
An open source version of SQL that is supported by most well-known databases
A set of extensions on top of standard SQL that exploit the specific features of SAP HANA
.
Declarative Logic can only use a limited set of SQL Script language
FALSE
TRUE.
What states can be returned using a combination of EXISTS and IN predicates? (3 Correct)
Unknown
FALSE TRUE
Incorrect.
Why do you use a Referential Join?
When you want to display facts even when the associated master data attributes are missing.
To improve performance of joins that do not need to check integrity if no column from the right table is selected by a query.
When you need to display only facts that have associated master data attributes.
.
What is the recommended approach for creating procedures?
Use the CREATE PROCEDURE statement in the SQL Console.
Define a source file .hdbprocedure in the development view of SAP Web IDE.
.
Identify the type of join that ensures records are only selected if they fit within a specified date range.
Temporal Join
Full Outer Join
Left Outer Join
Right Outer Join
.
If the current row has a value of 5000 and the three preceding rows have a value (in order) of 1000, 1500, and 3000, which rows would be included in RANGE BETWEEN 3500 PRECEDING AND CURRENT ROW?
1500, 3000, and 5000 1000, 1500, 3000, and 5000
5000
1000, 1500, and 3000
3000 and 5000
.
Why do you use SQL Hints?
To expose the contents of the internal variables during runtime to help with debugging
To provide the SQL Optimizer with information about recent executions to enable better performance
To add additional parameters to statements to deactivate default runtime behavior or to influence access paths to data
.
Why do you hide columns in a dimension calculation view?
When you do not want to expose a sensitive column to a consuming calculation view.
When you want to hide a column that is not required or allowed for client consumption.
To ensure they can only be displayed along with other attributes and not used for drill-down navigation of filtering.
.
A dimension can have attributes and measures.
TRUE FALSE.
Stored procedures must utilize only scalar parameters, or only table parameters.
TRUE FALSE.
What are temporal tables?
Tables that support time travel queries
Tables that persist only during a session
.
Why do we use imperative logic?
To improve performance of data-intensive tasks
To take control of the data flow using conditional logic To define reusable modules of code
.
Which of the following are types of calculation views? (3 Correct)
Composite Cube
Dimension Cube with star join
.
Why do we use MAP_MERGE operators? To replace sequential FOR-loops and union patterns with a parallel operator to improve performance
To push back complex conditional logic to the source database when using remote data connections
.
Why do you use the SQL Code Analyzer?
Identify bottlenecks in the runtime performance of the query.
Trace the data flow to expose the contents of internal variables.
Scan the source code to look for potential problems.
.
In a Star Join node, what do you join to the central entity (fact table)?
CUBE calculation views
Column tables
DIMENSION calculation views
.
What are the prerequisite skills needed to develop SAP HANA applications, if they are based on a Fiori UI and use Node.js in the application server? (3 Correct)
ABAP language
HTTP protocol
SQL language
JavaScript language
SAP Screen Personas
.
An XS Advanced project can contain multiple HDB modules.
TRUE
FALSE.
When is the design time filter expression applied in a calculation view? (2 Correct)
Before any joins are executed within the calculation view
Before a query on the calculation view begins to execute
On the final result of a query, similar to a ‘where’ clause
.
A calculation view CV1 has been created in your project folder but has never been built. Your perform a build of another calculation view CV2 that consumes CV1. The CV1 file will be included in the build of CV2.
FALSE TRUE.
While converting currencies, in addition to source and target currencies, which value is also needed?
Country VAT rate
Time.
Where possible, in your SQL code, always use calculation engine (CE) functions to ensure best performance.
TRUE FALSE.
Why do you implement data anonymization?
To hide sensitive data by adding noise at the record level so that aggregated values still make sense but individual records are not exposed.
To remove complete records so that they cannot be seen by unauthorized users
To hide sensitive data using alternative characters such as ‘XXXXX’.
.
Why is knowledge of SQL important to an SAP HANA modeler? (2 Correct)
So that they can choose to create calculation views using only SQL language
So that they can understand how to implement a function or procedure and consume this within a calculation view
So that they can extend the capabilities of a calculation view using SQL expressions
.
To which storage tier does Native Store Extension (NSE) belong?
Warm Cold Hot.
In a hierarchy, what is an orphan node?
A node that has no higher nodes
A node that has no lower nodes
A node that contains only one member
.
Identify the object that adds a WHERE clause to the query.
Variable
Modeler Attributes Input parameter
.
Which of the following tools is used to analyze dependencies between models? (2 Correct)
Impact analysis
Column lineage
Data lineage
.
Which are valid source file types used to define the persistence layer of SAP HANA? (2 Correct)
.hdbcds
hdbtable sqltable.
Which of the following development layers of an XS Advanced application are provided by an HDB module? (2 Correct)
Persistence layer
Business logic
User interface
Data modeling
.
What is a dynamic analytic privilege?
A temporary analytic privilege that has a defined time validity set for its use
An analytic privilege that takes its filter values from variables defined in the calculation view
A reusable analytic privilege that can be used for several users who need to access different data.
.
The Git architecture relies on a central server that stores a unique version of your source code and includes a check-out process that prevents several users from modifying the same source file at the same time.
TRUE
FALSE
.
You are using the SQL console of the Web IDE. When are schema references not required in your code?
When writing SQL against a database connection of the type HDI Container
When writing SQL against a database connection of the type SAP HANA Database.
In a calculated column, which do you use as a placeholder for a dynamic value in an expression?
Variable
Input parameter
.
Why should I define my SAP HANA tables using source files rather than using the SQL statement ‘CREATE TABLE’ in the SQL Console of Web IDE?
The syntax is simpler
Performance of the table is better.
The table definition is easily transported as part of the overall application to ensure all project artifacts are kept together.
.
How should you create a procedure?
Use the CREATE PROCEDURE statement in SQL Console
Write your code in a source file in the SAP Web IDE with the extension .hdbprocedure
.
A HDB module always corresponds to a database schema.
TRUE
FALSE.
Where do I define a pruning configuration table?
Join nodes.
Union nodes.
Projection nodes.
.
You have successfully built a project that you imported into the SAP Web IDE workspace, but you cannot see the corresponding runtime database objects. What could be the reason?
Building a project does not generate the database objects defined in its HDB modules.
The project is not assigned to a Space.
You do not have the Developer role in the assigned Space.
.
What is data masking? Replacing column values with a higher level group such as replacing a person id with team name
Obscuring column values by hiding some or all characters with replacement characters
Removing complete rows of data that should not be seen by users
.
What are two types of modeled hierarchy you can create using calculation views? (2 Correct)
Parent-Child
Referential
Level
.
Which flags are relevant to the control of the aggregation behavior? (2 Correct)
Keep Flag
Dynamic join
Transparent filter
.
The database objects defined in design-time files located in the same project folder can have different namespaces.
TRUE
FALSE
.
Procedures can be used in the FROM clause of a SELECT statement.
FALSE TRUE.
When the Default Client property of a calculation view is set to Session Client, the data is filtered dynamically based on the CLIENT assigned to the user.
FALSE TRUE.
When writing SQL against a database connection of the type SAP HANA Database.
Scalar Functions
Column Engine Functions
Table Functions
.
Which type of node is used to end the parallelization of a data flow?
Projection
Union Aggregation.
A restricted column provides a subset of the original column filtered by attribute values.
FALSE
TRUE.
Which are valid table partition types in SAP HANA? (3 Correct)
Range Column Round Robin
Hash
.
In an Aggregation node, a calculated column is always computed before the aggregate function.
TRUE FALSE.
Why would you use SQL functions when modeling in calculation views?
When you need to define custom data processing logic that the graphical calculation view cannot provide
When you need to write results back to a table from a calculation view
As an alternative to developing a graphical calculation view when you prefer to use script.
What is the purpose of the SQL Analyzer?
To highlight syntax errors in my SQL code.
To investigate the generated SQL for each node in my calculation view.
To identify the longest running SQL statements.
.
Which database artifact do you use to access external data from an XS Advanced project?
Calculation view
Logical schema
User-provided service
Synonym
.
To work with calculation view debug query, you first need to build the calculation view?
TRUE FALSE.
Which are three valid aggregation functions for a rank node? (3 Correct)
Row Rank Sort Sum
.
Upon build, the CDS entity triggers the generation of a database view with the corresponding name and structure.
TRUE FALSE.
In the SAP Web IDE for SAP HANA, you want to use Core Data Services to define the persistency layer. Which extension do you use for the design time file?
.hdbtable .hdbddl
hdbcds.
Which of the following statements are true about SAP HANA Express Edition? (3 Correct)
It can only run on certified hardware.
It is packed with essential SAP HANA features, yet utilizes a smaller footprint.
It is free to use up to 32 GB memory use, and expandable to 128 GB for a fee.
It can be used in production scenarios.
.
What is the SAP Fiori Master-Detail template?
A demo application, part of SHINE (SAP HANA Interactive Education)
A guideline document that explains the best practice to create a Fiori compliant Master-Detail application
A wizard that generates a UI5 Master-Detail application based on an existing OData service
A Master-Detail application, used to generate a documentation template for your application
.
What is OData?
A software tool
A protocol
An SAP design guideline
A document format.
How can you access the schema WALLDORF of HDI container WALLDORF?
By using the credentials of user WALLDORF#OO.
By assigning your user the role WALLDORF::access_role.
By creating a service binding to the deploy service and using the generated credentials.
By creating a service key and using the generated WALLDORF_..._DT user.
.
You are setting up security for an HTML application. Where do you link an HTML page with the role needed to visualize it?
In the scope definition.
In a route definition.
In the authentication method definition.
In the role definition.
.
What do you use calculation views for?
To read data in real time for analytical reporting.
To code using the R programming language.
To resolve complex mathematical equations.
To provision data from remote sources.
.
Which keywords are used in an XSODATA association definition? (2 Correct)
Join Key
Principal
Dependent
.
In SAP HANA, you create a stored procedure. What can you set in the header properties? (3 Correct)
Global variables
Security
Read/write access
Programming language
Storage type
.
Which checks are executed when you run the Hardware Configuration Check Tool (HWCCT)? (3 Correct)
Measurement of data throughput between the Linux kernel and CPU
Validation of the LPAR configuration settings on IBM Power servers
Measurement of data throughput between the Linux kernel and CPU
Measurement of the data throughput between SAP HANA nodes and storage
Validation of the operating system configuration settings for the Linux kernel
.
Which file extension do you use for the definition file for an OData service?
.odata
.xsodata
.data
.
In the SAP Web IDE for SAP HANA, when you create a new SAP HANA database module, what is added to the mta.yaml file? (2 Correct)
A module of type HDB
A service of type com.sap.xs.hdi-container
A route to the SAP HANA database
A service of type OData
.
Which features are provided by the Manage Full System Information Dumps app in SAP HANA cockpit? (2 Correct)
Diagnosis information
End-to-end Trace
SAP HANA minichecks
Runtime environment
.
What is Node.js?
It is a scripting language specialized in the execution of data intensive calculations.
It is a server-side runtime environment for JavaScript. It is a client-side JavaScript library, providing components to design the user interface.
.
Marta creates an HDI container PORTEMONNAIE and deploys it in space COAT_POCKET. Which user owns the created schema PORTEMONNAIE?
Portemonnaie, which was created during deployment.
Marta, because she deployed the container.
Marta, because she created the container.
Portemonnaie#OO, which was created during the deployment.
.
Compared to standard SQL, which of the following are the advantages of SQLScript? (3 Correct)
It returns a single set.
It enables complex logic to be broken up into smaller chunks of code that enables modular programming, reuse, and a better understanding by functional abstraction.
It has control logic, such as if/else.
One can make use of table variables structure complex SQL statements.
.
Waldemar creates a plain database schema and grants Constanze the CREATE ANY privilege on that schema. Who can access the table DUMMY which Constanze creates in Waldemars schema? (2 Correct)
Every user owning an object in Waldemars schema
Every user having theCREATE ANY privilege
Waldemar, because he own the schema Constanze, because she owns the table
.
Which file contains route definitions?
security.json
package.json
mta.yaml
xs-app.json
.
What can you directly assign to a user with the Manage Users app in SAP HANA cockpit? (2 Correct)
Role collections
Scopes
Privileges
Roles
.
Which properties can you adjust in SAP HANA Admission Control? (3 Correct)
Maximum request queue size
SQL statement request memory limit
CPU threshold for rejecting requests
Maximum parallel 10 requests
Memory limit for queuing requests
.
What is the origin of the name “Multi-target Application”?
It is an application targeting multiple user profiles.
It is an application made of modules that can be reused across applications.
It is an application made of multiple modules running in different runtime environments.
It is an application made to run on multiple front-end devices.
.
In the SAP Web IDE for SAP HANA, what features are provided in the SQLScript debugger pane? (3 Correct)
Runtime code change
Runtime analysis
Console
Expressions
Watchpoints.
What is Git?
A tool for static code analysis
A tool for tracking changes in source code during software development
A tool for web-based team code collaboration
A tool for automated code testing
.
In your HTML page, you want to have a placeholder replaced at runtime with the actual URL of the back-end application. Which design time files do you modify to obtain this? (2 Correct)
security.json
package.json
mta.yaml
xs-app.json
.
Which tasks can you perform using the SAP HANA database lifecycle manager (HDBLCM) on installation media? (2 Correct)
Update SAP HANA and its components.
Extract components.
Uninstall SAP HANA database components.
Rename the SAP HANA database system.
.
What is OpenUI5?
A guideline for an optimal user experience
A platform providing free video courses
An extensibility framework for UI5
An open-source project
.
Which preparation tasks do you need to perform before starting the Database Migration Option (DMO) procedure? (2 Correct)
Update the SAP Host Agent to the latest version
Extract the SAP HANA database software installation archive.
Check if the latest SPAM/SAINT update is applied.
Move the latest R3trans update archive into the download folder.
.
Which part of a full-stack application is defined within the HTML5 module? (2 Correct)
The HTTP services
The user interface
The router configuration
The security role templates
.
Which information source is based on YouTube videos?
SAP HANA Interactive Education
SAP Help Portal
SAP HANA Academy
openSAP.
You are creating the index.html file of an UI5 application. What does the bootstrap contain?
The primary UI anchor The libraries to be loaded
The initial construction of the application
.
Eva creates an HDI container Franntz. It only contains a view with the statement SELECT BRICKS FROM MILANO.DUOMO. Why does the deployment fail?
EVA is not the object owner of MILANO.DUOMO.
Schema references are not allowed in HDI containers.
Tables need to be consumed via calculation views.
Franntz#OO wasn't granted privileges on MILANO.DUOMO.
.
What are the two features of the storage engine in the SAP HANA index server that enable data consistency and maintain durable changes?
Metadata Manager and Transaction Manager
Session Management and log Volumes
Page Management and logger
Column Store and Row Store
.
How can you assign the authorizations needed to perform specific tasks executing XS Advanced applications?
You can directly assign the necessary permissions to the user.
You can add the necessary roles to a role collection and then assign this role collection to the user.
You can directly assign the necessary roles to the user.
You can add the necessary permissions to a role collection and then assign this role collection to the user.
.
You are programming using the SAP Cloud Application Programming Model. You need to define an OData service. Which is the extension of the file you create?
cds xsodata hdbcds odata.
CDS associations define:
Distribution of entity data across multiple database tables.
Relationships between columns of the same entity.
Relationships between entities.
.
You are developing the persistency layer for a multi-target application. You want to create a database view that reads data from a table in a remote SAP HANA schema. What do you need to use?
An OData service
A remote desktop connection
A user-defined service
A schema synonym
.
Who is the Object Owner in SAP HANA?
The administrator of the HDI Container group
The technical user _SYS_REPO
The creator of the schema containing the object
The user who created the object
.
Which resources do you find in XS Advanced spaces? (3 Correct)
Application domains
Services
Memory
Application routes
.
What do you have to consider when you perform a Tailored Data Center Integration (TDI) installation for a productive SAP HANA database system? (2 Correct)
Obtaining the hardware certification from SAP for the existing hardware you are going to use.
Obtaining C_HANATEC_XX Certification.
Having 10 GBit/s for storage zone and 1 GBit/s for internal zone for network connectivity.
Having the data and log volumes on the different disks.
.
In SAP HANA, the debugger needs to be attached to a Node.js module before it stops at any breakpoint. TRUE
FALSE
.
|
