True or False: When you mark an information model as deprecated, it no longer works.
Please choose the correct answer.
Response: True False.
What statement is allowed in a user defined function?
There are 2 correct answers to this question.
Response: COMMIT EXEC INSERT JOIN.
You use parallelism to calculate a year-to-date value quickly, and you eliminate a table from the database. What are some of the implications of this action?
There are 3 correct answers to this question.
Response: Smaller database backups Less code Better user interfaces Faster response times Faster inserts into the database.
Which engine do most SAP HANA Live views use?
Please choose the correct answer.
Response: Join engine OLAP engine SQL engine Calculation engine.
Modeling package Shops is a sub-package of package Regions. You want to authorize a user to list the content of package Regions, but prevent listing the content of package Shops. How can you achieve this?
Please choose the correct answer.
Response: Refactor package Shops to another package. Assign REPO.EXPORT only to package Shops. Assign REPO.READ privilege only to package Regions. Revoke analytic privileges for models in package Shops.
True or False: SAP HANA is just a database.
Please choose the correct answer.
Response: False True.
What character is used to terminate SQL statements?
Please choose the correct answer.
Response: . (period) : (colon) ; (semicolon) ? (question mark).
When do you always have both an active and an inactive version of an information model available in the SAP HANA development system?
Please choose the correct answer.
Response: When you selected Revert to Active on an inactive version When you edit an existing model When validation of a model fails When you create a new model.
You created a user-defined function with a return type of BIGINT. What type of function have you created?
Please choose the correct answer.
Response: SQL function Scalar function Table function Window function.
Which of the following are features of a data warehouse?
There are 3 correct answers to this question. Data governance Consolidation Both OLTP and OLAP in one system Realtime reporting A full transactional history.
Which of the following SAP data provisioning methods provide complex transformations?
There are 2 correct answers to this question SAP HANA smart data quality SAP HANA smart data access SAP Replication Server SAP Data Services.
Where do you graphically create a design¬time role in SAP HANA?
Please choose the correct answer. In the Roles area under Security in SAP HANA studio In the Repository area in the development perspective in SAP HANA studio In the Security area of the SAP HANA web¬-based development workbench In the Editor area of the SAP HANA web-¬based development workbench.
What is the recommended way to create full¬text indexes going forward?
Please choose the correct answer. Core Data Services SQL statements in the SQL Console Procedures Userdefined functions.
What can be used to return multiple result sets?
There are 2 correct answers to this question. Scalar function Table function Procedure View.
What statement do you have to run before you can return table results from a procedure?
Please choose the correct answer. CREATE TYPE CREATE VIEW CREATE TABLE CREATE TABLE TYPE.
Which business intelligence tool queries SAP HANA using MDX?
Please choose the correct answer. SAP BusinessObjects Web Intelligence SAP Lumira Microsoft Excel SAP BusinessObjects Analysis, edition for Microsoft Office.
What should you keep in mind when using imperative logic in SQLScript?
Please choose the correct answer. You can loop through records. You can only use ifthen logic. It delivers the best possible performance. It matches SQL’s setoriented paradigm.
You want to reuse a decision table on multiple tables with a similar data structure. You design the decision table that passes a specific table name as an input parameter when you execute the decision table. What do you have to use in the data foundation to achieve this?
Please choose the correct answer. A dynamic join A scripted calculation view A table type A virtual table.
What is a new and recommended way to work with SQL and SQLScript?
Please choose the correct answer. Create runtime objects rather than design¬time objects. Use table functions rather than scripted calculation views. Use CE¬functions rather than SQL syntax. Use .procedure files rather than creating SQL and SQLScript via the package context menu.
You are using the SAP HANA studio. Which of the following SAP HANA modeling artifacts require the SAP HANA application function modeler (AFM) to be installed?
There are 3 correct answers to this question. SAP HANA predictive analytics library (PAL) flows SAP HANA enterprise information manager (EIM) jobs SAP HANA smart data access (SDA) queries SAP HANA extended application services (XS) programs SAP HANA smart data streaming (SDS) projects.
Which of the following describe design¬time objects?
There are 3 correct answers to this question. Inactive Repository objects Catalog objects Active Native objects.
What performance techniques should you implement to improve join performance?
There are 3 correct answers to this question. Use left outer joins instead of right outer joins. Use unions instead of joins for combining large data sets. Always specify the cardinality of a join. Join as many tables as possible in an analytic view’s data foundation. Always mark joins as dynamic to improve performance.
In which type of node can you create calculated columns?
There are 2 correct answers to this question. Union node Rank node Projection node Join node.
Which steps do you have to perform once before you can create SAP HANA development objects?
There are 2 correct answers to this question. Create an SAP HANA XS project. Create a predictive model using PAL. Create a dataflow model in the AFM. Create a repository workspace.
What PAL algorithm category can you use for supervised learning?
Please choose the correct answer. Social network analysis Classification Clustering Association.
Which of the following ways of publishing SAP HANA information model content could require some JavaScript knowledge?
There are 2 correct answers to this question. Creating business intelligence content with SAP BusinessObjects Design Studio Creating a composite provider in SAP BW Creating a REST web service in the SAP HANA XS engine Creating a report in SAP Crystal Reports for Enterprise.
What can you use to limit the number of records produced by a calculation view?
There are 3 correct answers to this question. Filter expressions SAP client restrictions Generated columns Domain fix values Restricted columns.
You have a discussion with board members of a company. They want your recommendation on a business intelligence tool that they can use on their Apple iPad to display KPI dashboards. They also want a WYSIWYG design environment that allows scripting, should it be required. Which tool do you recommend?
Please choose the correct answer. SAP BusinessObjects Design Studio SAP Crystal Reports for Enterprise SAP Lumira SAP BusinessObjects Web Intelligence.
Which of the following data operations can you perform with SDA?
There are 3 correct answers to this question. Data federation Logical data warehouse Big data Physical data warehouse Realtime replication.
Which of the following VDM views can be called by applications and reports?
There are 2 correct answers to this question. Private views Query views Value help views Reuse views.
You want to publish your business intelligence content directly to SAP Cloud for Analytics. Which tool do you use?
There are 2 correct answers to this question. SAP Predictive Analytics SAP Lumira SAP BusinessObjects Analysis, edition for Microsoft Office SAP Crystal Reports for Enterprise.
Which tasks are part of the migration tool workflow?
There are 2 correct answers to this question. The tool produces a table function linked to a graphical calculation view. The tool requires a graphical calculation view as input. The tool requires a script-based calculation view as input. The tool produces only a table function.
HANA Currency Conversion supported only via__ Analytic Attribute Calculation Analytic / Calculation.
What is the advantage of reporting directly from column tables? It provides multi-language support It eliminates the need for additional modeling It shifts complex calculations and logic to SAP HANA It supports analytical privileges.
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 SQL privileges to the necessary users By assigning Analytic privileges to the necessary users By assigning System privileges to the necessary users By assigning Package privileges to the necessary users.
You have created an input parameter in an information model. In which of the following can you use the input parameter? The creation of an SAP BEx query reading from the information model The creation of an SAP BusinessObjects Web Intelligence report directly on the information model The definition of objects in an SAP BusinessObjects universe The definition of an information space that reads from the information model.
How can you improve the performance of an information model? (3) Use generated columns. Use analytic views wherever possible. Use indexes on all measures. Use attribute views wherever possible. Use constraint filters.
You want to aggregate the grand total sales amount into 1 currency.
In which of the following cases would you select the Calculate Before Aggregation checkbox?
(Choose two) When an aggregate table by country contains sales values in 3 different currencies When a line item table contains sales values of 2 different currencies When a line item table contains sales values in 1 currency When an aggregate table by country contains sales values in 1 currency.
A company loads data every night from several source systems into multiple tables in SAP HANA using complex transformation rules. The calculation view that joins these tables performs unexpectedly slow. Which of the following could you investigate to be able to improve performance? (2) Whether the joins and transformations of the tables can be moved to the data loading process of SAP BusinessObjects Data Services. Whether an InfoCube compression is running. Whether the calculation view needs to create large intermediate result sets. Whether savepoints are written during execution.
In a fuzzy search, when would you perform a freestyle search? When you want to search with a high fuzziness threshold When you want to search in multiple columns When you want to search in only one column When you want to search with a low fuzziness threshold.
Which programming language do you use for SAP Landscape Transformation based transformation rules? JavaScript SQLScript ABAP Java.
Which of the following can you use as a source for a graphical calculation view? (Choose three) Calculation view SQL view Decision table Table Procedure.
Which of the following can you use to implement currency conversion in an information model? (2) A calculated column in a calculation view A restricted column in an analytic view A calculated column in an analytic view A calculated column in an attribute view.
Company needs to load external data from a flat file into SAP HANA. How can you do this? (2) SAP HANA Direct Extractor Connection (DXC) SAP System Landscape Transformation (SLT) SAP HANA SQL Import statement SAP BusinessObjects Data Services.
You want to create a customer segmentation on your SAP HANA data. Which of the following do you use? RODBC library SAP HANA Business Function Library SAPUI5 runtime library SAP HANA Predictive Analysis Library.
Which reporting tool can you use to display native parent-child hierarchies from SAP HANA? Microsoft Excel SAP BusinessObjects Weblntelligence SAP BusinessObjects Analysis, edition for OLAP SAP BusinessObjects Analysis, edition for Microsoft Office.
Which of the following actions can you do with a derived attribute view? (Choose two) Define the name of the derived attribute view. Use the derived attribute view in the data foundation of an analytic view. Define the output of the derived attribute view. Use the derived attribute view in the logical join view of an analytic view.
Which transaction is used for releasing extractors specified by the customers in SLT? RODPS_OS_OPEN RODPS_OS_CLOSE RODPS_OS_EXPOSE RODPS OS.
Which of the following can you use as a source for a graphical calculation view? (3) Calculation view SQL view Decision table Table Procedure.
A customer wants to report on large amounts of SAP HANA data. The users want to drill from the top aggregation level to the lowest granularity and try different types of graphical representations of the data on the fly. SAP BusinessObjects Dashboards SAP BusinessObjects Web Intelligence SAP BusinessObjects Explorer SAP BusinessObjects Crystal Reports for Enterprise.
Which of the following tools can you use to monitor the query time from SAP HANA? Central Management Console Performance tab of the System Monitor Event Viewer SQL Trace.
How can you restrict SAP HANA modeling users from viewing sensitive data? Use scrambled source data.
Remove SAP_DATA_ADMIN in the SQL privileges for the modeling users. Use the pre-delivered MODELER role. Remove ALTER SYSTEM in the system privileges for the modeling users.
You modified an active analytic view in the SAP HANA studio and saved it without
activating it. What is the consequence? The inactive view is available for reporting The active view is in "read-only" mode. The inactive view is in "read-only" mode. The active view is not available for reporting.
In a SQLScript calculation view, one table variable contains the records that are the result
of a SELECT: statement from a database table with 10 fields. You want to use this table
variable to populate a new table variable with the same result set, which is restricted to 1 of
the 10 fields. Which CE function do you use? CE_UNION CE_CALC CE_COLUMN_TABLE CE PROJECTION.
You are running an SAP BusinessObjects Weblntelligence report that fetches data from
SAP HANA. Which components will be used inside SAP HANA for providing data to this
report?(2) Persistence Layer MDX Session Management Authorization Manager.
You have two analytic views: one contains actual data and the other contains plan data.
You want to combine the two result sets and keep actual and plan data on separate
records. In the SAP HANA studio, which of the following can you use to achieve this? JOIN in an analytic view UNION in a calculation view PROJECTION in a calculation view JOIN in a graphical calculation view.
When loading data into SAP HANA, which of the following tasks can you perform using
SAP Data Services? Replicate data using database triggers. Read data from SAP ERP using the embedded SAP BW system. Replicate data by reading database logs Read data from SAP ERP using ABAP data flows.
What are characteristics of a constraint filter?(2) It is defined during the design time on a table. It is applied on a table before the query execution. It is applied on the result set of an SQL query. It is defined during the runtime in the SQL query.
Where can you create a restricted column in a graphical calculation view?
Aggregation node Join node Union node Projection node.
You have a Web Intelligence report that requires data from SAP HANA filtered for a
specific year. Where do you apply the filter for optimal performance? In the universe In the Web Intelligence report In the analytic view In the calculation view using an attribute value variable.
Which information model can you use with measures from multiple fact tables? Analytic privilege Attribute view Analytic view Calculation view.
What is the function of an aggregation node in a calculation view? It provides grouping of filter criteria. It allows grouping of columns required for your information model. It calculates the sum, minimum, or maximum values for selected columns. It joins the result sets from different data sources.
Which data provisioning method can you use to load data from SAP business content
DataSources into SAP HANA? (2) SAP Landscape Transformation (SLT) SAP Landscape Directory (SLD) SAP Direct Extractor Connection (DXC) SAP BusinessObjects Data Services.
Which SAP Business Objects reporting tool should you use to answer ad-hoc questions and
interact with shared information? Crystal Reports Dashboards Explorer Weblntelligence.
When you try to delete an attribute view you receive the error message "One or more
objects are dependent upon this object".
Which of the following functions can you use to find out which objects depend on this view?(2)
History function Auto Documentation function Display XML function Where-Used function.
Which type of connection does SAP HANA Direct Extractor Connection (DXC) use to
transfer data to SAP HANA?
Secondary database connection RFC connection ODBC connection HTTP connection.
In SAP HANA, which join type yields the same results as a referential join when fields from
both tables are selected?
Left outer join Full outer join Inner join Temporal join.
Which of the following nodes can you use when you create a calculation view with the SAP
HANA studio graphical interface? (2)
Data Foundation
Aggregation
Join
Analytic Privilege
.
Which of the following describes an SAP HANA analytic view?
It is a set of tables joined together in a star schema.
It is a copy of data after transformation.
It is a reusable object in attribute views.
It is a materialized set of data.
.
Which of the following criteria indicate that you should store data in row tables?(2) The tables have a large number of columns.
The tables require frequent write access.
The information models search the table based on the values of a few columns.
The information models frequently needs to access complete records.
.
When loading data into SAP HANA, which of the following tasks can you perform using
SAP Data Services?(2) Data filtering
Real-time replication
Data transformations
Upload data via the SAP HANA studio
.
Which of the following would you create to ensure the fastest calculation performance?
A calculated measure in an SAP BusinessObjects universe
An input parameter in an SAP HANA information model
A report variable in an SAP BusinessObjects reporting client
A calculated column in an SAP HANA information model
.
You are experiencing performance problems with SAP BusinessObjects reports based on
SAP HANA data. Which of the following can you do to increase performance? (2)
Add only relevant data to the report queries.
Avoid aggregation and work on raw data. Merge all relevant data into a consolidated report.
Use drill-down or linked reports.
.
Which of the following nodes do you use to implement filters in a graphical calculation
view? (2)
Join
Projection
Aggregation
Union
.
Which of the following are advantages of running SAP HANA Live embedded in the SAP
Business Suite? (3)
It provides real-time replication.
It allows use of generic virtual data models.
It runs in older versions of the SAP Business Suite.
It uses the built-in capabilities of SAP HANA, such as the SAP HANA extended application services.
It provides real-time operational reporting.
.
You have set up replication from SAP ERP using SAP Landscape Transformation (SLT).
You notice that the information models do not show the latest data from ERP. What do you
check to investigate this? (2) Activation status of the information models Transaction SAP ERP Data Modeler (SDH) Transaction LTR on SLT Data Provisioning view in SAP HANA studio.
You create a business layer in the SAP BusinessObjects Information Design Tool (IDT).
Which of the following could you add to the data foundation? (2)
Packages
Column Tables
Synonyms
Information Models
.
What must you configure to directly access an SAP HANA analytic view using SAP
BusinessObjects Analysis edition for Microsoft Office?
RFC connection
SAP HANA Direct Extractor Connection (DXC)
Pre-delivered MODELING role
System DSN
.
Which of the following must you do in order to use SAP BusinessObjects Explorer on SAP
HANA data? (2)
Create a delivery unit.
Create a business layer. Create an information model.
Create an information space.
Your data models use hierarchies.
In which front end tool can you access these hierarchies?(2)
SAP BusinessObjects Dashboards
SAP BusinessObjects Crystal Reports 2011
SAP BusinessObjects Analysis, edition for OLAP
SAP BusinessObjects Analysis, edition for Microsoft Office
.
Which of the following operations can you use when you create a calculation view using the
SAP HANA studio graphical interface?(2)
PROJECTION
UNION
INTERSECT
INSERT
.
Which of the following sequences of steps is used to implement SAP HANA with SAP
ERP? Data Provisioning ? SAP HANA system setup ? Modeling ? Consumption
SAP HANA system setup ? Modeling ? Data Provisioning ? Consumption
SAP HANA system setup ? Data Provisioning ? Modeling ? Consumption
SAP HANA system setup ? Data Provisioning ? Consumption ? Modeling
.
You want to load a large amount of source data (more than one billion rows) into SAP
HANA for read-intensive information models. Which table type is recommended for this
scenario?
Global temporary table
Decision table
Row table
Column table
.
Which type of connection does Direct Extractor Connection (DXC) use to transfer data to
SAP HANA?
RFC connection
Secondary database connection
http connection
ODBC connection
.
Which of the following must you do when you create an analytic view?(3)
Define a column as an attribute Define a column as a measure
Select a data foundation table.
Define a join.
Select an attribute view.
.
Which of the following can be part of an analytic view?(3)
Query transformation
Unions
Logical joins
Data foundation
Attributes
.
Which of the following are direct outputs of an analytic view?(3)
Hierarchies
Private attributes
Restricted attributes
Measures
Attribute views
.
Which security settings can you apply in analytic privileges?(2)
Grant access to analytic views.
Restrict access within an analytic view using measure values.
Restrict access within an analytic view using attribute values. Restrict access to hierarchies.
.
Two attribute views in the same analytic view contain the same column name (ID from
attribute view Customer and ID from attribute view Product). In the output, the system
automatically renamed one column to ID_1.
Which of the following can you do to indicate that ID_1 originated from attribute view
Product?
Update the alias in the properties of ID_1. Change the label of ID_1. Create a restricted column with a different name based on ID_1. Create a derived attribute view with an alias for ID 1.
A calculation view that joins one fact table with dimension tables performs slowly. Which of
the following can you do to improve performance?
Turn the calculation view into an analytic view.
Turn the calculation view into a simple calculation view.
Load the calculation view into memory.
Load the calculation view into the_SYS_Bl schema.
.
Union can be performed only at...
Analytic Attribute
Calculation
Analytic / Calculation
.
You have created a graphical calculation view with a large number of columns.
Which of the following do you use to ensure that only required columns are shown when
querying the created view? (2)
Function CE_PROJECTION
The Type selection in the semantics area
Projection nodes
The Hidden checkbox in the semantics area
.
Which of the following are functions of the DB trigger within SAP Landscape
Transformation (SLT)?(2)
Ensure that replicated changes are kept within the logging tables.
Record relevant changes in logging tables.
Include only relevant tables for DB recording.
Decluster table classes into a transparent format.
.
What are the advantages of implementing SAP HANA using an SAP rapid-deployment
solution over a traditional implementation project? (3)
Preconfigured content Fixed-scope implementation No need for consultants Customized content Lower risk.
In an analytic view, you need two different logical joins from the data foundation to an
attribute view. The analytic view already contains the attribute view but you have to use the
attribute view again. To which of the following do you connect the second join?(2)
To a shared attribute view
To a derived attribute view
To a new instance of the attribute view
To a copy of the attribute view
.
Which CE function do you use to implement the following SQL statement?
SELECT DATE, SHOPJD, PRODUCTJD, QUANTITY * COST AS "PRICE" FROM
SALES_DATA; CE_AGGREGATION
CE_CALC_VIEW
CE_CONVERSION
CE_CALC
.
When you activate an analytic view, a column view is created. In which schema is this
column view stored?
_SYS_BIC _SYS_BI
C. _SYS_REPO
D. _SYS
.
Which of the following can you set up to enable the extraction of data from SAP Business
Warehouse (BW) into SAP HANA?(3)
SAP System Landscape Directory (SLD)
SAP BusinessObjects Data Services
SAP Landscape Transformation (SLT)
Open hub
SAP HANA Direct Extractor Connection (DXC)
.
Which tool do you use for real-time data provisioning into SAP HANA?
SAP Landscape Transformation (SLT)
SAP BusinessObjects Data Federation Administration
SAP BusinessObjects Data Services
SAP Direct Extractor Connection (DXC)
.
You have created several information models. A colleague has to create new tables in the
existing schema and extend your information models. Which privileges do you give to your
colleague?
System privileges Analytic privileges
Package privileges
Object privileges
.
Table SALES_TABLE contains the columns COUNTRY and SALES. Function calc_tax
calculates sales tax based on input parameter SALES.
Using a scripted calculation view, how can you call the calc_tax function?
v_tax=CE_PROJECTION(SALES_TABLE, [“COUNTR”,”calc_tax(SALES)”]);
v tax = CE PROJECTION (SALES_TABLE, ["COUNTRY","CALL :calc_tax(SALES)"]);
:V_tax = SELECT COUNTRY, CALL : calc_tax(SALES) AS TAX FROM
:SALES_TABLE;
V_tax + SELECT COUNTRY, calc_tax(SALES) AS TAX FROM SALES_TABLE;
.
You would like to authorize a user to see data in an analytic view only for company code
1000 and fiscal year 2000 or for company code 1005 and fiscal year 2005. Which of the
following achieves this requirement? • One analytic privilege: company code = 1000, fiscal year = 2000
• One analytic privilege: company code = 1005, fiscal year = 2005
• One analytic privilege: company codes = 1000 and 1005
• One analytic privilege: fiscal years = 2000 and 2005
One analytic privilege: the combination of company code = 1000 and fiscal year = 2000,
and the combination of company code = 1005 and fiscal year = 2005
One analytic privilege: company codes = 1000 and 1005, and fiscal years = 2000 and
2005.
Which of the following must you do in order to use SAP BusinessObjects Explorer on SAP
HANA data?(2) Create a delivery unit.
Create a business layer.
Create an information model.
Create an information space.
.
When table replication is suspended, what does the SAP Landscape Transformation (SLT)
server do?
It prevents the RFC connection from reading the source system logging tables.
It deletes the database triggers and the logging tables in the source system.
It stops the RFC connection and deletes the target tables in SAP HANA.
It keeps reading via the RFC connection from the source system but does not load the
data into SAP HANA.
.
Which of the following automatically aggregates data? (Choose two) Analytic view
Calculation view
Column table
Attribute view
.
In which tool can you create information spaces for reporting? in the SAP HANA modeler perspective in the SAP HANA SQL editor
in SAP BusinessObjects Explorer
in the Information Design Tool
.
For which SAP HANA data types is a FULLTEXT index created automatically during table
creation?
A. TEXT
B. SHORTTEXT
C. VARCHAR
D. NCLOB
.
Which of the following actions must you perform in an SAP HANA system to transport
content to another SAP HANA system? (Choose two)
Generate and save an export file.
Mass copy the content repository into the other SAP HANA system.
Assign the package to a delivery unit.
Assign the content repository to a transport request.
.
What is an example of a selective data load using SAP Landscape Transformation?
A. Selected data field values are randomized and loaded into SAP HANA.
B. Selected units or currencies are converted into recalculated amounts or values and loaded into SAP HANA.
C. Selected data for transformation is split into portions.
D. Selected data for a range of years is loaded into SAP HANA.
.
What is the advantage of creating analytic views in SAP HANA over reporting directly from
column tables? (Choose two)
A. Shifting of complex calculations and logic to SAP HANA.
B. Supporting analytical privileges.
C. Reporting directly from SAP BusinessObjects Web Intelligence.
D. Eliminating the need for additional modeling.
.
Which of the following can you check to investigate the query time in SAP HANA? (Choose
three)
The SQL plan cache
The Central Management Console
The expensive statements trace
The statistics server warning for long running statements
The System information tab of the Administration console
.
What is the lowest level of granularity you can use in an analytic privilege?
An attribute
A view An attribute value
A column
.
What are the consequences of executing the Stop activity on the Data Provisioning view in
the SAP HANA studio for a table that is currently replicated?
The table is dropped from the SAP HANA database.
Triggers and logging tables are deleted.
The replication of the table is temporarily stopped and can be resumed.
Triggers and logging tables are kept
.
Which of the following properties of a derived attribute view can you modify?
Description
Description mapping
Calculated attributes
Filters
.
Which engine is used for calculation and aggregation based on star schema
Join Engine
Calculation Engine
SQL Optimizer Engine
OLAP Engine
.
When you use SAP Landscape Transformation (SLT) replication, which of the following can
you do in the advanced replication settings? (Choose two)
Add afield to a table.
Change the target table for specific records of a table.
Assign a specific mass transfer ID to a table.
Change the length of a character field of a table.
.
When you activate a procedure, in which schema is the procedure stored?
SYSTEM
_SYS_BIC
SYS_REPL
_SYS_Bl
.
You want to investigate the runtime of a SELECT statement against an analytic view.
Which of the following tools do you use to analyze the model performance, including
transferred data?
Plan visualizer
Load graph
SQL Editor
SQL Debugger
.
You would like to authorize a user to select and delete data from a specific column table.
The user should also be able to grant this authorization to other users. Which privilege do
you need to implement?
System privilege
Object privilege
Package privilege
Analytic privilege
.
How can you create a computed column in an information model? Create a calculated attribute within a calculation view.
Create a counter in an analytic view.
Create a restricted measure in a calculation view.
Create a restricted measure in an analytic view.
.
You want to model customer master data.
Which of the following must you select?
Filter
Table
Hierarchy
Key attribute
.
You modified an active analytic view in the SAP HANA studio and saved it without
activating it. What is the consequence?
The inactive view is not available.
The inactive view is in "Read Only" mode.
The active view is not available.
The active view is in "Read Only" mode.
.
Your customer requires real-time replication.
Where do you select the tables to be replicated to SAP HANA?
in transaction LTR in SAP Landscape Transformation (SLT)
in the Import dialog of the Quick Launch of SAP HANA studio
in transaction SAP ERP Tables and Indexes Monitor (DB02)
in the Data Provisioning dialog of SAP HANA studio
.
Which of the following remote data sources can you access with SAP HANA smart data
access? (Choose three)
XMLfile
SAP Adaptive Server Enterprise
SAP NetWeaver Business Warehouse
Apache Hadoop
Teradata Database
.
Which new connection type is available as of SAP BusinessObjects Data Services 4.0 Operational Data Provider
BAPI function calls
IDOCs
Read table via ABAP data flows
.
You want to create a custom attribute in addition to your data model. How can you achieve
this?
Create the attribute as a calculated attribute within the analytic view.
Create the attribute and add it to the appropriate system table manually.
Create the attribute as a calculated measure within the attribute view.
Create the attribute as a restricted attribute within the calculation view.
.
You have to extract entities such as persons, countries, products, and places from
business text such as PDF files.
Which of the following tools in SAP HANA could you use? Python-based text analysis scripts
Full-text search Ul toolkit
Application function libraries
Fuzzy search
.
Which privilege type do you have to assign to a role, when you want to provide row-level
access to data? ANALYTIC PACKAGE
SYSTEM
SQL
.
User A has to set up tables and views in a database schema that is owned by user B.
Which of the following privilege must you grant? CREATE ANY to user A
REFERENCES to user A
CREATE ANY to user B
REFERENCES to user B
.
Which tasks can you perform with the data provisioning view in the SAP HANA studio?(2)
A. Start replication of tables
B. Filter replicated data
C. Apply data transformations
D. Suspend replication of tables
.
When you try to delete an attribute view you receive the error message, "One or more
objects are dependent upon this object".Which of the following functions can you use to find out which objects depend on this view?
(Choose two) History function
Where-used function
Auto Documentation function
Display XML function
.
Which of the following are included in a rapid-deployment solution (RDS) implemented on
SAP HANA? (Choose three) A step-by-step Configuration Guide
Packages with views and procedures
The SAP HANA database license
A fixed-price consulting project
Conversion of all SAP BEx queries to analytic views
.
Which of the following steps is required for configuring SAP Landscape Transformation
(SLT)?
Define the number of background work processes in SLT.
Define an RFC connection from SLT to SAP HANA.
Define a DB connection from SLT to the source system.
Define the number of jobs to be used for data replication.
.
You need to run a Web Intelligence report that requires data from SAP HANA filtered for a specific year based on ad hoc user input.
For best performance, how would you achieve this? Use a pre-defined prompt based on a self-join in the business layer. Use input from a Web Intelligence report passed to a variable in an information model. Use a dynamic transformation rule during data provisioning. Use a prompt in the query of the Web Intelligence report.
An analytic view has a long runtime.
Which of the following can be a root cause for the bad performance? (Choose two) The Execute In option is set to SQL Engine. The analytic view uses calculated columns. The analytic view uses generated columns. The Calculation Before Aggregation flag is set.
Which tasks do you have to perform if you want to use SAP BW with SAP HANA as the
underlying database?(3) Install SAP Business Warehouse Accelerator (BWA).
Perform a database migration from your current DB to SAP HANA DB.
Execute the report RS_BW_POST_MIGRATION.
Upgrade to at least SAP NetWeaver Business Warehouse 7.30 SP5.
Recreate SAP BW indexes after SAP HANA database migration.
.
When you use SLT replication, which of the following determines the name of the SAP
HANA schema where replicated data is stored? The name of the RFC connection
The name of the secondary database connection
The name of the source system schema
The name of the replication configuration
.
Which of the following can be grouped when multiple schemas exist in an SAP HANA
database? Information models
Data tables
Packages
Users
.
You need real-time profitability reporting from an SAP ECC system running on a non-SAP
database. Which of the following steps must you perform to implement the SAP CO-PA
Accelerator? (Choose 2) Configure an ABAP dataflow in SAP Data Services. Create an SAP Landscape Transformation configuration. Build attribute and analytic views in SAP HANA. Install SAP HANA as a secondary database.
You have created an information space in SAP BusinessObjects Explorer but the
information space is not available on the Home page.
How can you make the information space available on the Home page?(2) Drag the information space to the Home page
Refresh the list of information spaces on the Home page
Select the "Show on Home page" checkbox in the information space properties
Index the information space again
.
You plan to migrate your existing SAP NetWeaver landscape with a non-SAP HANA
database. Which of the following are key considerations for the migration of your database
to SAP HANA? (Choose three) Reuse existing SAP NetWeaver application servers. Plan downtime for the migration of the old database to SAP HANA Provision hardware that runs SUSE Linux (SLES) for SAP HANA. Upgrade all end-user front-end workstations to SUSE Linux (SLES). Resize application servers to handle incremental data volumes.
You have a replicated an SAP ERP transaction table that contains a language field and a
text table containing descriptions in various languages. You create an attribute view by
joining these two tables using a text join.
As which of the following join types does the text join act in this context? Referential join
Inner join
Left outer join
Right outer join
.
Which of the following are advantages of running SAP HANA Live embedded in the SAP
Business Suite?(3) It uses the generic capabilities of SAP HANA such as the XS Engine
It provides real-time operational reporting
It allows using generic virtual data models
It provides real-time replication
It runs in older versions of the SAP Business Suite
.
Which of the following are characteristics of an operational data mart based on SAP
HANA?(2) It is based on analytic denormalized data models
It uses real-time replication of time-critical data
it runs directly on top of the operational data
It persists transformed data
.
Which of the following tools can you use to load data into SAP HANA from SAP
DataSource extractors?(2) SAP Data Services
SAP Sybase Replication Server
SAP Landscape Transformation Server
SAP Direct Extractor Connection
.
You have an SAP NetWeaver Business Warehouse (SAP NetWeaver BW) on SAP HANA
system installed on multiple nodes.
Which of the following information objects are stored on the master node? SAP NetWeaver BW master data tables
DataStore Objects (DSOs)
ABAP system tables
Persistent Staging Area (PSA) tables
.
How can you add an existing attribute view to the logical view of your analytic view twice?
(Choose two) Copy the attribute view.
Create a derived analytic view.
Create a derived attribute view.
Rename the attribute view.
.
Which of the following are restrictions of the SAP HANA flat file upload? (Choose two) The upload does not allow changes to the column names of new tables.
The upload prevents data type changes when appending data.
A table must have the same column order as the flat file when you append data.
A new table always has a 1:1 mapping between the flat file columns and the table
columns.
.
You want to improve query performance by introducing filters into the SAP HANA
information model. Which of the following can you use to reduce data transfer between
views? (Choose two) A. Analytic privileges
B. Calculated columns
C. Client-independent views
D. Constraint filters
.
You create a role with the following command: CREATE ROLE "InfoUser"
When you try to assign this role to user PETER with the following command:
GRANT InfoUser to PETER you receive an error message "Invalid user privilege:
INFOUSER".
What must you do to avoid this problem? (Choose three) A. Recreate the role with the command CREATE ROLE InfoUser.
B. Recreate user PETER with GRANT OPTION.
C. Grant the role the WITH ADMIN OPTION.
D. Recreate the role with the command CREATE ROLE INFOUSER.
E. Grant the role with the command GRANT "InfoUser" to PETER.
.
Which of the following deployment scenarios of SAP HANA can be side-car scenarios?
(Choose two) SAP CO-PA Accelerator
SAP HANA Live
SAP CRM powered by SAP HANA
SAP Business Suite powered by SAP HANA
.
A corporation with over 15.000 cost centers would like to ensure that only the person
responsible for the cost center may view salary information for individuals assigned to their
cost center. How can the corporation achieve this in SAP HANA? Create a dynamic analytic privilege using the cost center and employee master data.
Create an analytic privilege using the cost center and the salary measure.
Create an analysis authorization using the cost center and employee master data. Create an object privilege on the cost center and employee master data schema.
.
How can you import information models into SAP HANA using the Quick Launch view? Select the Redeploy button
Select Data Provisioning -> Load
Select Import -> SAP HANA Content -> Import Data From Local File
Select Import -> SAP HANA Content -> Delivery Unit
.
Which of the following are characteristics of a referential join? (Choose two)
It requires referential integrity between right and left tables.
If a field is selected from the right table, it acts similar to a left outer join. It assumes referential integrity between right and left tables.
If a field is selected from the right table, it acts similar to an inner join.
.
Which of the following is used to make hierarchies available to reporting tools? CE Functions
MDX
SQLScript
SQL
.
Which data provisioning method can you use to load data from SAP business content
DataSources into SAP HANA?(2) SAP Landscape Transformation (SLT)
SAP Landscape Directory (SLD)
SAP Direct Extractor Connection (DXC)
SAP BusinessObjects Data Services
.
Your data models use hierarchies.
In which of the following front end tools can you access these hierarchies? (Choose three)
SAP Lumira
SAP BusinessObjects Analysis, edition for Microsoft Office
SAP BusinessObjects Dashboards
SAP Crystal Reports 2011 SAP BusinessObjects Analysis, edition for OLAP
.
Which of the following are required elements when you create any type of hierarchy in SAP
HANA? A child node
An analytic view
A data foundation
An attribute view
.
You want to run a report on data with multiple currencies. You want to allow end users to
select the target currency at runtime.
Which options does SAP recommend for defining the currency conversion? (Choose two) Currency conversion during data load
A CE_CONVERSION function in a calculation view
Measures enabled for conversion in an analytic view
A calculated column in an analytic view
.
You develop a disaster recovery plan. What do you have to consider in case of a disk
failure?
Configuration files can be restored automatically.
Savepoints can be backed up. Log volumes can be backed up.
Non-committed transactions can be recovered.
Committed transactions can be recovered.
.
With which of the following do you build the vocabulary of a decision table? Actions
Attributes
Conditions
Measures
.
Which of the following data provisioning tasks can you perform in the SAP HANA studio?
(Choose three)
Configure remote sources for SAP HANA smart data access.
Activate the SAP Web Dispatcher service for SAP HANA Direct Extractor Connection
(DXC).
Start replication of tables for SAP Landscape Transformation (SLT).
Create replication configurations for SAP Landscape Transformation (SLT).
Create an SAP ECC extractor datastore for SAP Data Services.
.
You model hierarchies in attribute views. Which of the following technologies do you use to
make these hierarchies available for reporting tools? JDBC
BICS
ODBO ODBC.
Which of the following must you avoid to ensure your calculation view uses only the
calculation engine?(3) Combining SQL and CE Functions
Reading from tables in the column store
Reading from tables using SELECT statements
Joins using SQL
DO WHILE loops
.
You have created an MS Excel report on SAP HANA data.
On which of the following could you store the Excel file and make it available for other users? Shared network drive
SAP BusinessObjects Information Design Tool
SAP HANA database
SAP HANA studio Content node
.
You are implementing the SAP CO-PA Accelerator to enable real-time profitability
reporting. Which configuration steps must you do?
Activate continuous data replication of tables CE1xxxx, CE2xxxx, CE4xxxx. Configure the SAP BusinessObjects Data Services replication jobs.
Install the SAP HANA database clients on all SAP ERP application servers.
Build attribute and analytic views in SAP HANA.
Create a secondary database connection in SAP ERP.
.
You have a table of transactional data with different transaction types. You want to create
an analytic view for only one of the transaction types.
How can you ensure that only rows with the required transaction type are displayed in the
analytic view? Create an input parameter
Create a filter on the table
Create a calculated column
Create a restricted column
.
Where is the physical data stored, on which a calculation view is based? In the _SYS_BI schema
In a schema
In the _SYS_BIC schema
In a package
.
Which of the following tools can you use to load data into SAP HANA from SAP
DataSource extractors? (Choose two) SAP Direct Extractor Connection SAP Data Services
SAP Landscape Transformation Server
SAP Replication Server
.
You want to create a sales analysis by combining your customer master data with your
transactional sales data.
How do you model your data to ensure best performance? • Model the transactional data in the data foundation of an analytic view.
• Model the master data in the projection node of a calculation view.
• Combine them in the union node of the calculation view. • Model the transactional data in the data foundation of an analytic view.
• Model the master data in the data foundation of an attribute view.
• Join them in the logical join of the analytic view. • Model the transactional data in the projection node of a calculation view.
• Model the master data in the data foundation of an attribute view.
• Combine them in the join node of the calculation view. • Model the transactional data in the projection node of a calculation view.
• Model the master data in the data foundation of an attribute view.
• Combine them in the union node of the calculation view.
Which of the following are phases of an SAP rapid-deployment solution (RDS)?(3)
Answer: A,C,D Start
Blueprint
Deploy
Run
Realization
.
Which of the following actions must you perform in an SAP HANA system to transport
content to another SAP HANA system? Generate and save an export file to a shared directory.
Assign the content repository to a transport request.
Mass copy the content repository into the other SAP HANA system.
Assign the package to a delivery unit.
.
Which of the following does an SAP BusinessObjects universe use to communicate with
SAP HANA? ABAP
SQL
MDX
BICS
.
You have two analytic views. One contains actual data and the other one contains plan
data. You want to combine the two result sets and keep actual and plan data on separate
records. In the SAP HANA studio, which of the following can you use to achieve this? JOIN in a calculation view
JOIN in an analytic view
UNION in a calculation view
PROJECTION in a calculation view
.
When loading data into SAP HANA, which of the following tasks can you perform using
SAP Data Services?(2) Upload data via the SAP HANA studio
Data filtering
Real-time replication
Data transformations
.
Which of the following information models does SAP recommend to combine fact table
fields with the corresponding master data attributes? (Choose two) Database view
Calculation view
Analytic view
Attribute view
.
When you create a report in SAP BusinessObjects you notice that some columns of your
SAP HANA information model are not available in the report. How can you make the
columns available?(2) A. Add the columns in SAP Landscape Transformation replication.
B. Add the columns to the query panel of the report.
C. Add the columns to the source table in the catalog node in SAP HANA studio.
D. Add the columns to the business layer.
.
What is the minimum requirement for a valid analytic view? One fact table and one attribute view One attribute view
One fact table and two attribute views
One fact table
.
What are the advantages of using SAP BusinessObjects Data Services to load data into
SAP HANA?(3) You can load unstructured data into SAP HANA.
You can merge data streams.
You can use the same hardware.
You can perform real-time data replication.
You can use Bl Content extractors or function modules.
.
What must you do to enable currency conversions with a fixed currency in an analytic
view? Create the target currency using an input parameter.
Create a measure with the measure type Simple.
Base the target currency on a currency column.
Set the Enable for Conversion option.
.
Refer to the exhibit.
You have been asked to create an SAP HANA attribute view using the tables Employee
(left table) and Department (right table), shown in the attached diagram. Your view shouldcontain the columns NAME and D_Name for all employees. Which of the following join
types do you use? Referential join
Left outer join
Text join
Inner join
.
Which of the following should you try to implement as best practices for data modeling?
(Choose two) Perform aggregation in an attribute view.
Use filters to restrict the number of rows on the tables that make up the analytic views.
Execute calculated columns before any aggregation is performed.
Use a UNION when combining analytic views in a calculation view.
.
Which of the following objects can you use when you build an analytic view? (Choose
three)
Attribute Views
Hierarchies
Variables
Projections
Analytic Views
.
Which of the following must an analytic view contain? A measure A calculated measure
A hierarchy
An attribute view
.
Which tool do you use for real-time data provisioning into SAP HANA? SAP Landscape Transformation (SLT)
SAP BusinessObjects Data Federation Administration
SAP BusinessObjects Data Services
SAP Direct Extractor Connection (DXC)
.
You implemented SAP-delivered business content on SAP HANA. When you try to activate
the business content the activation fails.
What could be a reason for this? You have not created a calculation view to expose the data to the users. The data has not been loaded into SAP HANA memory yet.
The schema mapping was not set up correctly.
The import of business content was performed with the _SYS_REPO user.
.
Which of the following tools use SQL to communicate with SAP HANA? (Choose three)
SAP BusinessObjects Information Design Tool SAP BusinessObjects Analysis, edition for OLAP SAP BusinessObjects Dashboards
SAP Lumira
SAP BusinessObjects Web Intelligence
.
What is the purpose of a template table in SAP BusinessObjects Data Services? To create pre-designed information models
To fill an existing target table with new data
To read source data and perform data transformations
To create a target table and fill this table with data
.
You want to allow another developer to access the information models in one of your
packages. What privilege do you have to assign to this user to allow access? SELECT on _SYS_REPO
SELECT on _SYS_REPO with the grant option
REPO.READ for the package
REPO.MAINTAIN_NATIVE_PACKAGES for the package
.
You want to use an extractor to build a model in SAP HANA. Which table can you use to
view detailed information about the extractor?
BSEG
RODELTAM
ROOSOURCE RSOLTPSOURCE.
Which of the following is a characteristic of SAP NetWeaver Business Warehouse (SAP
NetWeaver BW) when migrating it to run on SAP HANA? The SAP NetWeaver BW Accelerator becomes faster.
The sizing of your current SAP NetWeaver BW application servers has to be reevaluated.
The SAP NetWeaver BW application server can be co-deployed on the SAP HANA
database hardware.
The usage of the SAP NetWeaver BW Accelerator becomes obsolete.
.
Which of the following steps do you have to execute to import models from one SAP HANA
system (system1) to another SAP HANA system (system2)? (Choose three) Export the models from system1.
Create a delivery unit on system1.
Create a delivery unit on system2.
Import the models into system2.
Create a schema on svstem2.
.
You create a graphical calculation view that is based on analytic views.
What do you use to combine the data from the analytic views?
Referential join
Projection node
Aggregation node Union.
Which of the following are restrictions of the SAP HANA flat file upload?(2) A table must have the same column order as the flat file when you append data.
The upload does not allow to change the column names of new tables.
A new table must have a 1:1 mapping between the flat file columns and the table
columns. The upload prevents data type changes when appending data.
.
What must you do to enable currency conversions with a fixed currency in an analytic
view? Set the Enable for Conversion option
Create a measure with the measure type Simple
Base the target currency on a currency column
Create the target currency using an input parameter
.
Which of the following selection types are available when creating a variable in an analytic
view? (Choose three)
Single value
Direct
Interval
Range
Column.
Two attribute views in the same analytic view contain the same column name: the ID from
the Customer attribute view and the ID from the Product attribute view. In the output, the
system automatically renamed one column to ID_1. You want to indicate that ID_1
originated from the Product attribute view by renaming it to ID_PRODUCT. Where in the
attribute properties of ID_1 can you change this?
In the alias label
In the label
In the alias name
In the name
.
You need to create an SAP HANA data model based on a star schema. Which SAP HANA
engine is recommended for analytical purposes? Calculation engine
OLAP engine
Row store engine
Join engine
.
Which of the following modeling objects can you use with a Star Join node? (Choose two)
Aggregation node before the Star Join node
Aggregation node after the Star Join node
Calculation views of type dimension
Projection node after the Star Join node.
When you use SLT replication, which of the following determines the name of the SAP
HANA schema where replicated data is stored? The name of the secondary database connection
The name of the replication configuration
The name of the source system schema
The name of the RFC connection
.
You are building a calculation view and want to select data from an analytic view. How can
you achieve better performance for this requirement? Use CE functions
Use SQL statements
Use L programming
Use table indexing
.
You want to implement an SAP HANA data model based on tables in a new schema that
you just created. Which technical user requires select rights on your new schema? _SYS_BI
_SYS_SECURITY
_SYS_BIC
_SYS_REPO
.
|
