|Which SAP HANA model is recommended for reporting purposes where read operations
on mass data are required? Analytic view Calculation view using SQL Calculation view using SQL Script Attribute view.
You want to aggregate the grand total sales amount into one currency.
In which of the following cases would you perform the calculation before aggregation? When a line item table contains sales values of two different currencies. When an aggregate table by country contains sales values in one currency. When a line item table contains sales values in one currency.
When an aggregate table by country contains sales values in three different currencies.
You have imported models from the development system. What is the recommended way
toactivate dependent models in SAP HANA? Use the Activate with History function. Use the Where-Used List function. Use the Cascade Activate function. Activate each view manually.
Which SAP BusinessObjects tool do you use to visualize real-time key performance
indicators with simu-lations? Explorer Analysis, edition for OLAP Web Intelligence Dashboards.
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 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).
In SAP ERP there are more than 50,000 application tables. How do you determine the
relevant SAP ERP tables to replicate in SAP HANA and their dependencies? Use SAP ERP Data Modeler (transaction SD11). Use SAP ERP ABAP Dictionary Maintenance (transaction SE11). Use the SAP ERP Tables and Indexes Monitor(transaction DB02). Use SAP ERP Data Browser (transaction SE16).
Which of the following CE functions can you use to query an analytic view directly? CE_CALC CE_AGGREGATION CE_OLAP_VIEW CE_JOIN_VIEW.
Which package privileges are required to extend an SAP HANA Live view? REPO.ACTIVATE_NATIVE_OBJECTS REPO.EDIT_IMPORTED_OBJECTS REPO.READ REPO.EDIT_NATIVE_OBJECTS REPO.MAINTAIN_NATIVE_PACKAGES.
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 nodes can you use when you create a calculation view with the SAP
HANA studio graphical interface? Data Foundation Aggregation Join Analytic Privilege.
You want to retrieve data from SAP HANA and restrict access to certain data columns for
specific user groups. Where can you implement this? In the analytic privileges In the data foundation In the business layer In the SQL privileges.
Which of the following are required to build a SQLScript calculation view? Define a data foundation. Define a measure. Set the MultiDimensional Reporting property to false. Add columns to the var_out output parameter.
What is features available in Project Creation Wizard New option to auto-share an XS Project to the SAP HANA Repository during the project
creation wizard New option to auto-share an XS Server - side Project to the SAP HANA Repository
during the project creation wizard New option to auto-share an XS client - side Project to the SAP HANA Repository during
the project creation wizard New option to auto-share an XS Server - side secure Project to the SAP HANA
Repository during the project creation wizard.
In which engines is an analytic view executed that contains a calculated column? Calculation engine Row store engine OLAP engine Join engine.
In a reporting scenario you use an Opening Date attribute in the data foundation that
contains information about your stores. You want to determine the number of years each
store has been in business. How do you achieve this? Use calculated measures. Use time attributes. Use calculated attributes. Use private attributes.
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.
In SAP HANA studio, in which of the following can you create users? The Administration console The Roles node The Content node The SQL editor.
Which security settings can you apply in analytic privileges? A. Grant access to analytic views. B. Restrict access within an analytic view using measure values. C. Restrict access within an analytic view using attribute values. D. Restrict access to hierarchies.
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
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.
Which versions of your information models are visible on the History tab of the Modeler
perspective in the SAP HANA studio? Only the last active version All active and inactive versions All active versions The last active and inactive version.
Which types of calendar are available for time attribute views in SAP HANA? Fiscal Factory Gregorian Julian.
Union can be performed only at... Analytic Attribute Calculation Analytic / Calculation.
What does the following SQL statement do?
SCORE() as SCORE, PRODUCT_NAME, *
PRODUCT_NAME It performs a fuzzy search on all columns in the PRODUCT_NAME table for the term
'Paper'. It performs a fuzzy search count on the number of columns in the PRODUCT_NAME
table that contain the term 'Paper'. It performs a fuzzy search on the PRODUCT_NAME column in the PRODUCT_ITEMS
table for the term 'Paper'. It performs a fuzzy search of all columns in the PRODUCT_ITEMS table for the term
You want to perform a multiple linear regression on your data. Which of the following do
you use? SAPUI5 runtime library RODBC library SAP HANA Predictive Analysis Library SAP HANA Business Function Library.
You want to model customer master data.
Which of the following must you select? Filter Table Hierarchy Key attribute.
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.
You are experiencing performance problems with SAP BusinessObjects reports based on
SAP HANA data.
Which of the following can you do to increase performance? 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.
You have to design a report that shows actual, planned, and variance values. How do you
implement this requirement if you want to achieve the best performance? Use a calculation view based upon two analytic views using a union. Use a calculation view based upon two analytic views using a join. Use a single source data foundation in the Universe Design Tool and include the two
analytic views. Use a multisource-enabled data foundation in the Universe Design Tool for each
Which connectivity combination between MS Excel and SAP HANA provides
multidimensional reporting capabilities? ODBO connector via SQL requests to analytic or calculation views ODBC connector via MDX requests to analytic or calculation views ODBO connector via MDX requests to analytic or calculation views ODBO connector via MDX requests to column tables.
Which of the following would you use to determine the engines that are used when an
information model is queried? SQL plan cache Timeline Explain plan Visualize plan.
Which of the following is a best practice in calculation views? Apply a static filter on a projection node. Combine analytic views with a join node. Change an attribute to a measure. Push calculations down to the attribute views.
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.
Where can you reactivate a user after too many invalid logon attempts? In the SQL console In the user specific schema In the INVALID_CONNECT_ATTEMPS view In the user properties.
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 delivered role is mandatory for a system administrator in SAP HANA? SYS_ADMIN CONTENT_ADMIN SAP_ALL IC MODELER.
You receive an activation error in a scripted calculation view that uses the following
function: CE_PROJECTION(:table1, ["AMOUNT"], '"PROD" = A')
What could be a reason for this error? The filter condition is not set within square brackets. The projection list contains a field that is not specified in the filter condition. The filter condition must be specified inside the projection list. The filter condition contains a field that is not part of the projection list.
You have made modifications to an information model within a delivery unit. You want to
export the model to an SAP HANA target system.
In the Schema Mapping dialog, where do you define the target system schema? In the Authorization schema In the Authoring schema In the _SYS_BI schema In the Physical schema.
In which of the following can you use a FOR loop over your data? Monitoring View Calculation View Analytic View Analytic View.
Which SAP BusinessObjects reporting tool should you use to answer ad-hoc questions and
interact with shared information? Crystal Reports Dashboards Explorer WebIntelligence.
For which SAP HANA data types is a FULLTEXT index created automatically during table
creation? TEXT SHORTTEXT VARCHAR NCLOB.
Which of the following are restrictions of the SAP HANA flat file upload? 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.
How can you improve the performance of a report that is based on SAP HANA data? Ensure that all SAP HANA tables are in the same schema. Maintain appropriate constraint filters in SAP HANA. Ensure that all calculations are pushed down to the SAP HANA database. Gather new database statistics.
You want to run a report on data with multiple currencies. You want to allow end users to
select the target currency at run time.
Which option does SAP recommend for defining the currency conversion? A calculated column in an analytic view Currency conversion during data load Measures enabled for conversion in an analytic view A CE_CONVERSION function in a calculation view.
Which of the following are characteristics of SAP NetWeaver Business Warehouse (SAP
BW) when migrating it to run on SAP HANA? The sizing of your current SAP BW application servers remains valid. It allows co-deployment of the SAP BW application server on the SAP HANA database
hardware. It allows re-use of your available SAP BW application servers. It eliminates the need to upgrade to the latest SAP BW application version. The system usage is the same as an equivalent SAP BW on non-SAP databases.
Your data models use hierarchies.
In which front end tool can you access these hierarchies? SAP BusinessObjects Dashboards SAP BusinessObjects Crystal Reports 2011 SAP BusinessObjects Analysis, edition for OLAP SAP BusinessObjects Analysis, edition for Microsoft Office.
What are benefits of using an SAP BusinessObjects business layer on top of SAP HANA? Business layers can be exported to the SAP BusinessObjects repository and be used by
SAP BusinessObjects client tools. Reporting users can change replication settings in the business layer to access more
data. Business layers can be exported to an SAP HANA database and be used for modeling. Reporting users can create individual reports based on separate information models
using one business layer.
Which view in SAP HANA studio do you use to add additional users? Properties View Quick launch View Console View Navigator View.
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.
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? Analytic privilege System privilege Package privilege Object privilege.
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.
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? 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 privilege type do you have to assign to a role, when you want to provide row-level
access to data? ANALYTIC PACKAGE SYSTEM SQL.
Which connectivity options can you use to create a SAP BusinessObjects universe on SAP
HANA? OLAP connection using MDX Relational connection using BICS Relational connection using ODBC Relational connection using MDX Relational connection using JDBC.
Which of the following can you use to build the data foundation for an attribute view? Referential Join Union Projection Text Join.
In a calculation view you define a calculated column and set the Calculate Before
Which of the following activities is mandatory to activate the view? Set the column type to Attribute Add a new aggregation node Mark the column as hidden Select the aggregation type.
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)? Create a delivery unit on system1 Import the models into system2 Create a schema on system2 Create a delivery unit on system2 Export the models from system1.
Which of the following is used to make hierarchies available to reporting tools? CE Functions MDX SQLScript SQL.
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.
What are characteristics of a constraint filter? 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.
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.
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.
A company wants to use SAP BusinessObjects reporting tools. They cannot use Adobe
Flash. They require scheduled, ready-made reports.
Which reporting tool do you recommend? Dashboards Web Intelligence Explorer Crystal Reports.
Which of the following must an analytic view contain? A measure A calculated measure A hierarchy An attribute view.
Which of the following are required to create an attribute view? Data Foundation Default Schema Join Key Attribute.
Which CE function do you use to implement an inner join between two tables on a list of
join attributes? CE_COLUMN_TABLE CE_JOIN_VIEW CE_OLAP_VIEW CE_JOIN.
Which feature is supported by the backup and recovery process within the standard
delivery of SAP HANA? Incremental backup Information model recovery Point-in-time recovery Automatic backup of archiving log files scheduled within SAP HANA.
If you want to create or drop tables in a schema, which privilege type do you need? SYSTEM ANALYTIC PACKAGE SQL.
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? 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 need to find out which users logged on to the SAP HANA system over the course of
the last week.
What would you check? The Audit log Entries in M_CONNECTIONS The nameserver_history.trc file The indexserver_alert.trc file.
What type of calculation would you create to ensure the fastest calculation performance? A report variable in an SAP BusinessObjects reporting client A calculated column in an SAP HANA information model An input parameter in an SAP HANA information model An calculated measure in an SAP BusinessObjects universe.
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.
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.
Which of the following are functions of the DB trigger within SAP Landscape
Transformation (SLT)? 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.
Which SAP BusinessObjects tools require an SAP BusinessObjects semantic layer
(universe) to access data in SAP HANA? Crystal Reports 2011 Crystal Reports for Enterprise Dashboards Analysis Office v1.1 WebIntelligence.
Which SAP tool would you use for data cleansing before data is loaded into SAP HANA? SAP BusinessObjects Information Steward SAP BusinessObjects Data Services SAP Landscape Transformation SAP NetWeaver Master Data Management.
Which of the following must you do in order to use SAP BusinessObjects Explorer on SAP
HANA data? Create a delivery unit. Create a business layer. Create an information model. Create an information space.
What are new Code templates for File Creation Wizard XSACCESS XSHTTPDEST XSJOBT XSSQLCT.
Which of the following properties of a derived attribute view can you modify? Description Description mapping Calculated attributes Filters.
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 want to repeatedly load data from a flat file into SAP HANA with SAP Data Services.
The target table is not available in SAP HANA and must be recreated with every scheduled
data load. The structure of the target table is identical to the structure of the source table.
Which of the following steps must you perform? Create a table in the SAP HANA studio. Map the source structure to the template table. Import metadata of the target table from the SAP HANA datastore. Drop a template table into the data flow. Enter the table name and schema name.
When loading data into SAP HANA, which of the following tasks can you perform using
SAP Data Services? Upload data via the SAP HANA studio Data filtering Real-time replication Data transformations.
Which of the following operations can you use when you create a calculation view using the
SAP HANA studio graphical interface? PROJECTION UNION INTERSECT INSERT.
You have to do reverse pivot transformations on large data tables before loading the data
into SAP HANA.
Which of the following do you recommend to use? SAP Landscape Transformation (SLT) SAP BusinessObjects Data Services 4.0 SAP HANA Direct Extractor Connection (DXC) SAP System Landscape Directory (SLD).
Which of the following are direct outputs of an analytic view? Hierarchies Private attributes Restricted attributes Measures Attribute views.
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.
Company needs to load external data from a flat file into SAP HANA. How can you do this? SAP HANA Direct Extractor Connection (DXC) SAP System Landscape Transformation (SLT) SAP HANA SQL Import statement SAP BusinessObjects Data Services.
When you use SAP Landscape Transformation (SLT) replication, which of the following can
you set up in the advanced replication settings? Change a character field length of a table. Change the target table for specific records of a table. Assign a specific mass transfer ID to a table. Add a field to a table.
When must you create a calculation view in SAP HANA? When you need to perform join operations. When you need calculations before aggregations. When key figures span across tables. When you need to perform a union of base tables.
Which of the following automatically aggregates data? Analytic view Calculation view Column table Attribute 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 can you use? Full-text search UI toolkit Python-based text analysis scripts Fuzzy search Application function libraries.
How can you improve the performance of an information model? Use generated columns. Use analytic views wherever possible. Use indexes on all measures. Use attribute views wherever possible. Use constraint filters.
What is an example of a selective data load using SAP Landscape Transformation? Selected data field values are randomized and loaded into SAP HANA. Selected units or currencies are converted into recalculated amounts or values and
loaded into SAP HANA. Selected data for transformation is split into portions. Selected data for a range of years is loaded into SAP HANA.
HANA Currency Conversion supported only via ___ Analytic Attribute Calculation Analytic / Calculation.
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_BI schema.
You are using SAP Landscape Transformation to replicate data into SAP HANA.
Which of the following can you use to define the schema that the replicated data
populates? Advanced replication settings (transaction iuuc_repl_content) Change Authoring Schema in the Quick Launch view Data Provisioning in the Quick Launch view Configuration & Monitoring Dashboard (transaction LTR).
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.
In an aggregation node of a calculation view, which is the default aggregation type for an
aggregated measure? COUNT MAX SUM MIN.
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.
How can you improve the quality of your information model design? Use ´case´ or ´if´ statements whenever possible. Use row-based database expressions. Design your views to be reusable. Modularize your views. Avoid duplications in your modeling.
Which of the following tools can you use to load data into SAP HANA from SAP
DataSource extractors? SAP Data Services SAP Sybase Replication Server SAP Landscape Transformation Server SAP Direct Extractor Connection.
In an SQLScript calculation view, one variable contains the records that are the result of a
SELECT * statement from a database table with 10 fields. You want to use this variable to
populate a new variable with the same result set restricted to 1 of the 10 fields.
Which CE function do you use? CE_COLUMN_TABLE CE_PROJECTION CE_CALC CE_AGGREGATION.
How can you improve the performance of a scripted calculation view? Read data from column tables using nested SELECT statements Convert SQL code to equivalent CE functions Combine analytic views using a CE_JOIN function Combine data from the row store and column store.
What is the behavior of a Text Table Join where language column SPRAS is available? Left Outer Join Right Outer Join Inner Join Referential Join.
You need to retrieve data from SAP HANA that is restricted to a certain region and specific
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.
Company needs to load external data from a flat file into SAP HANA. How can you do this? SAP HANA Direct Extractor Connection (DXC) SAP System Landscape Transformation (SLT) SAP HANA SQL Import statement SAP BusinessObjects Data Services.
Which of the following remote data sources can you access with SAP HANA smart data
access? SAP NetWeaver Business Warehouse Microsoft SQL Server Apache Hadoop Teradata Database SAP Sybase Adaptive Service Enterprise.
What happens when you turn on replication of an SAP ERP source system using SAP
Landscape Transformation (SLT)? SLT creates ABAP code in the ERP system that writes to application tables. SLT creates ABAP code in the ERP system that writes to logging tables. SLT creates database triggers in the ERP system that write to logging tables. SLT creates database triggers in the ERP system that write to application tables.
Which of the following tools use SQL to communicate with SAP HANA? SAP BusinessObjects Web Intelligence SAP BusinessObjects Analysis, edition for OLAP SAP BusinessObjects Information Design Tool SAP BusinessObjects Analysis, edition for Microsoft Office SAP BusinessObjects Dashboards.
Which of the following can you set up to enable the extraction of data from SAP Business
Warehouse (BW) into SAP HANA? SAP System Landscape Directory (SLD) SAP BusinessObjects Data Services SAP Landscape Transformation (SLT) Open hub SAP HANA Direct Extractor Connection (DXC).
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.
You create a business layer in the SAP BusinessObjects Information Design Tool (IDT).
Which of the following could you add to the data foundation? Packages Column Tables Synonyms Information Models.
You want to design a model in SAP HANA. Which of the following modeling constructs do
you use to create an analytic view? Join types Attribute views User privileges Tables Analytic views.
Which of the following can you use as a source for a graphical calculation view? Calculation view SQL view Decision table Table Procedure.
Which transaction is used for releasing extractors specified by the customers in SLT? RODPS_OS_OPEN RODPS_OS_CLOSE RODPS_OS_EXPOSE RODPS_OS.
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.
Which of the following does an SAP BusinessObjects universe use to communicate with
SAP HANA? ABAP SQL MDX BICS.
Which of the following tasks are prerequisites for creating a hierarchy in SAP HANA? Define an output structure for the attribute view. Define the data foundation. Choose the type of hierarchy. Define calculated attributes for the nodes of the hierarchy. Define an analytic view.
If you notice, Unique Constraint Error while loading flat file then Modify the table and remove primary key Modify column with different data type Convert column table to row table or vice versa Check the data for this Constraint and make sure there are no duplicate values.
Which technologies use trigger-based replication? ABAP extractors Test Data Migration Server (TDMS) Standard SQL database replication Near Zero Downtime.
You are using SAP NetWeaver Business Warehouse (SAP NetWeaver BW) in your
company as the enterprise data warehouse. You want to use SAP NetWeaver BW as a
data provisioning tool for SAP HANA without disturbing your BW reporting.
Which of the following are SAP recommended actions? Automate the ETL processes in SAP NetWeaver using process chains. Write data back from SAP HANA into the replicated SAP NetWeaver BW tables. Create new InfoObjects for the SAP HANA InfoProviders. Schedule the real-time data loads into SAP HANA.
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.
What are advantages of implementing SAP HANA using an SAP rapid-deployment solution
over a traditional implementation project? Fixed-scope implementation No need for consultants Lower risk Pre-configured content Customized content.
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? Activation status of the information models Transaction SAP ERP Data Modeler (SD11) Transaction LTR on SLT Data Provisioning view in SAP HANA studio.
Where does SAP recommend you create calculated measures? In a column view In a business layer In an attribute view In an analytic view.
In a graphical calculation view you specify the default client to be dynamic.
How is the client value determined when the view is used? By checking the session client of the user accessing the view By reading the client of the tables in the view By applying the filtering conditions on the client field By executing a procedure in the user's own schema.
When building a business layer to report on SAP HANA, what do you have to do if you
want to display more than 5,000 rows? Remove all filters from the analytic views. Deactivate the Limit Size of Result Set parameter in the Central Management Console. Set the Array Fetch Size parameter to the maximum in the relational connection. Deactivate the Limit Size of Result Set parameter in the business layer.
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? History function Auto Documentation function Display XML function Where-Used function.
Which of the following SAP data provisioning methods provide complex transformations? SAP Data Services SAP HANA smart data access SAP Replication Server SAP HANA smart data quality.
An analytic view has two columns, SHIP_TO_COUNTRY and SHIP_FROM_COUNTRY,
that contain ISO country codes. You must replace these codes with the English country
names by joining to the same country attribute view twice.
What must you create to achieve this? A derived attribute view A shared attribute view Two data foundations An attribute view using the Copy From method.
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.
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.
What are the key benefits of using SAP BusinessObjects Explorer with SAP HANA? You do not need to create your own queries to access information. You can easily create your own queries to access information. You can access information for data discovery intuitively. You can execute ad-hoc business analytics quickly. You can easily create an IDT business layer.
You are running an SAP BusinessObjects WebIntelligence report that fetches data from
SAP HANA. Which components will be used inside SAP HANA for providing data to this
report? Persistence Layer MDX Session Management Authorization Manager.
What is the lowest level of granularity you can use in an analytic privilege? An attribute A view An attribute value A column.
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:
What must you do to avoid this problem? Recreate the role with the command CREATE ROLE InfoUser. Recreate user PETER with GRANT OPTION. Grant the role the WITH ADMIN OPTION. Recreate the role with the command CREATE ROLE INFOUSER. Grant the role with the command GRANT "InfoUser" to PETER.
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 data foundation of an attribute view
- Join both in the logical join of analytic view
**** - Model the transactional data in the projection node of an calculation view
- Model the master data in the data foundation of an attribute view
- Combine both 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 projection node of a calculation view
- Combine both in the union node of the calculation view
**** - Model the transactional data in the projection node of an calculation view
- Model the master data in the datafoundation of an attribute view
- Combine both in the join node of the calculation view
You create an analytic view and want to restrict access to departments with specific values
using analytic privileges. Which tasks do you have to perform to accomplish this? Assign restricted values to the attribute view. Assign values to be restricted. Choose at least one information model to assign
restrictions. Assign the analytic privilege to a user or role. Assign values to be restricted to a content table. Choose an attribute to define restricted values for it.
Which of the following are phases of an SAP rapid-deployment solution (RDS)? Start Blueprint Deploy Run Realization.
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.
Which of the following can be part of an analytic view? Query transformation Unions Logical joins Data foundation Attributes.
Prior to modeling in SAP HANA, you want to validate referential integrity between two very
large tables in the SAP HANA database.
Which SAP HANA tool would you use? Data preview View contents View log SQL console.
When working with your data models, which of the following do you use to get detailed
information about tables, number of rows, and partitioning? Performance analysis mode Catalog node of your system Visualize plan Explain plan.
What do you have to define in an attribute view to reduce the initial amount of data selected
from the data foundation tables? A static filter value on any column in the data foundation tables A column marked as "Hidden" in the output structure A restricted column in the output structure A dynamic filter value on a measure in the attribute view.
Your customer wants to implement a SAP product that:
Provides near real-time replication to SAP HANA
Connects SAP HANA to a non-SAP source system and SAP BW
Uses SAP extractors
What do you recommend? SAP Legacy System Migration Workbench (LSMW) SAP Landscape Transformation (SLT) Sybase Replication Server SAP BusinessObjects Data Services 4.0.
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.
Which SAP BusinessObjects reporting tool would you recommend? SAP BusinessObjects Dashboards SAP BusinessObjects Web Intelligence SAP BusinessObjects Explorer SAP BusinessObjects Crystal Reports for Enterprise.
What does SAP HANA smart data integration use for data provisioning? SAP HANA smart data access SAP HANA smart data streaming Database triggers Database logs Real-time adapters.
With which of the following do you build the vocabulary of a decision table? Actions Attributes Conditions Measures.
During loading of data into SAP HANA you want to filter the source data. Where can you
apply the filters? In a query transformation in SAP BusinessObjects Data Services In a row generation transformation in SAP BusinessObjects Data Services In a SQL WHERE clause in SAP Landscape Transformation (SLT) In an ABAP code rule in SAP Landscape Transformation (SLT).
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.
You want to broadcast reports that use data from SAP HANA. Which SAP BusinessObjects
tool do you use? Analysis, edition for OLAP Dashboards Crystal Reports Explorer.
In which order are views consumed by the SAP HANA Live virtual data model? 1. Reuse 2.Private 3. Query 1. Query 2.Reuse 3.Private 1. Reuse 2.Query 3.Private 1. Query 2.Private 3.Reuse.
Which of the following authentication methods are supported for Single Sign-On for SAP HANA? Kerberos LDAP over SSL Secure Network Communication (SNC) SAML CAS (Central Authentication Service).
Which of the following must you avoid to ensure your calculation view uses only the
calculation engine? Combining SQL and CE Functions Reading from tables in the column store Reading from tables using SELECT statements Joins using SQL DO WHILE loops.
Which of the following are functions of the controller in the SAP Landscape Transformation
(SLT) server? Create repositories in the source system. Write data to the SAP HANA system using the DB connection. Map database structures between SAP HANA and the source system. Schedule replication processes.
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.
What are benefits of using a business layer on top of SAP HANA? An extra layer of granular security Improved database calculation speed Fast throughput via BICS connectivity Users can use business names instead of technical names.
You want to add a column to a calculation view that displays the year-to-date revenue of
the current fiscal year.
How can you achieve this? Use a calculated attribute. Use a calculated measure. Use a variable. Use a CE function.
Which of the following can you use as sources for the vocabulary in a decision table? Calculation views Table types OData models Procedures Physical tables.
In which View, client queries can be less optimized and could significantly be slower
compare to other models Analytic Attribute Calculation (SQL) Calculation (CE Functions).
You have an SAP HANA productive system with sensitive data.How can you restrict
modeling users from viewing this data? Remove ALTER SYSTEM in the system privileges for the modeling users. Use randomized data for the development of data models. Allow modeling only on the SAP HANA development system and export/import the
models to the productive system. Remove SAP_DATA_ADMIN in the SQL privileges for the modeling users.
A new user has implemented an SAP HANA data model.
Which technical user requires select rights on the new user's schema? _SYS_REPO _SYS_BIC _SYS_BI _SYS_SECURITY.
In a fuzzy search, when would you perform a freestyle search? When you want to search with a low fuzziness threshold When you want to search in only one column When you want to search in multiple columns When you want to search with a high fuzziness threshold.
Which reporting tool can you use to display native parent-child hierarchies from SAP
HANA? Microsoft Excel SAP BusinessObjects WebIntelligence SAP BusinessObjects Analysis, edition for OLAP SAP BusinessObjects Analysis, edition for Microsoft Office.
You modify an existing view. How can you determine which models are affected by this change? Use the audit trail. Use the History feature for the changed model. Use the "Where-Used List" feature for the changed model. Use the "Auto Documentation" to compare the object version of the changed model.
Which connection type is required from the SAP ERP system to SAP HANA to enable COPA
side by side scenario? HTTP connection JDBC Secondary database connection Remote Function Call.
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? Add the columns in SAP Landscape Transformation replication. Add the columns to the query panel of the report. Add the columns to the source table in the catalog node in SAP HANA studio. Add the columns to the business layer.
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.
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 privileges do you need to activate views? SELECT option on the _SYS_BIC schema SELECT option on the _SYS schema SELECT option on the _SYS_BI schema SELECT option on the _SYS_REPO schema.
Which of the following objects would SAP HANA identify as the left object of a join in the
graphical calculation view? The object that has its field identified first in the join output. The object that is displayed on the left hand side in the join details panel. The object that is connected to the join node first. The object that is displayed on the left hand side in the graphical calculation view.
Which of the following can you use to implement currency conversion in an information
model? 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.
You modified an active analytic view in the SAP HANA studio and saved it without
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.
In a two system landscape, you want to transport SAP HANA information models from the
source system to a target system. The source system has information objects that refer to
physical schema S1. The target system uses physical schema S2. When you import the information objects into the target system, the information objects at the target cannot be
opened as they still refer to schema S1.
What must you do to be able to open the information objects in the target system? Add a schema mapping. Create a new schema. Execute a refactoring. Reimport the information models.
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 sequences of steps is required before you can create a report on an
analytic view using replicated SAP ERP data? Set up replication from ERP ? Create an analytic view ? Create analytic privileges ?
Create a business layer Create a business layer ? Set up replication from ERP ? Create an analytic view ?
Create analytic privileges Create an analytic view ? Create analytic privileges ? Set up replication from ERP ?
Create a business layer Create an analytic view ? Set up replication from ERP ? Create analytic privileges ?
Create a business layer.
You want to restrict access to SAP HANA information models based on user groups. The
models are accessed through an SAP BusinessObjects report.
In which of the following can you implement these restrictions? The schema mapping The restricted measures The analytic privileges The universe.
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 are characteristics of using a Rapid Deployment Solution (RDS),
such asOperational Reporting for SAP HANA? Relevant tables are replicated. SAP will create information models based on customer requirements. Customized tables and columns are replicated. Pre-designed information models are imported into SAP HANA.
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 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 running an SAP BusinessObjects Web Intelligence report that fetches data from an
Which of the following 4 components is used by SAP HANA to provide data for this report? SAP host agent Delivery unit XS engine OLAP engine.
Which of the following objects can you use when you build an analytic view? Attribute views Analytic views Hierarchies Variables Projections.
An SAP BusinessObjects Web Intelligence report throws an SQL error during query
Which of the following could you check to resolve the error? The business layer The business view The Web Intelligence report variables The SAP HANA information model.
What are the advantages of using SAP BusinessObjects Data Services to load data into
SAP HANA? 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 BI Content extractors or function modules.
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.
Which of the following criteria indicate that you should store data in row tables? 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.
Your customer has the following reporting requirements:
Real-time profitability reporting on large-scale data volumes
On-the-fly analysis of profitability data at any level of granularity, aggregation, and
Cost allocation reports with significantly faster processing time
Which application do you recommend? SAP Bank Analyzer with SAP HANA SAP Deposits Management with SAP HANA SAP HANA CO-PA Accelerator SAP HANA for Banking.
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.
What can you use to transform data from SAP Business Warehouse (BW) into SAP
HANA? SAP Landscape Transformation (SLT) SAP BW extractors SAP BusinessObjects Data Services SAP Legacy System Migration Workbench (LSMW).
Which data provisioning method can you use to load data from SAP business content
DataSources into SAP HANA? SAP Landscape Transformation (SLT) SAP Landscape Directory (SLD) SAP Direct Extractor Connection (DXC) SAP BusinessObjects Data Services.
You discover row count discrepancies between source data and SAP HANA information
Which of the following can you investigate to find the source of the discrepancies? Client filtering in the Delivery unit view. Joins in information models. Memory leaks. Client filtering in SAP Landscape Transformation (SLT).
When you activate a procedure, in which schema is the procedure stored? SYSTEM _SYS_BIC SYS_REPL _SYS_BI.
Which of the following are benefits of implementing SAP HANA? SAP HANA provides real-time analytics. SAP HANA performs much faster than the standard SAP ERP. SAP HANA provides pre-configured BI Content. SAP HANA combines OLTP and OLAP in one system. SAP HANA replaces SAP BW.
Which of the following are advantages of running SAP HANA Live embedded in the SAP
Business Suite? 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.
A company needs to load external data from a flat file into SAP HANA. How can you do
this? SAP HANA Direct Extractor Connection (DXC) SAP System Landscape Transformation (SLT) SAP HANA SQL Import statement SAP BusinessObjects Data Services.
Which view need be considered in development for read operations on mass data
required? Analytic Attribute Calculation Analytic / Calculation.
Which engine is used for calculation and aggregation based on star schema Join Engine Calculation Engine SQL Optimizer Engine OLAP Engine.
Where can you deploy the column view of a decision table? In SAP Visual Intelligence In Microsoft Excel In calculation views In analytic views.
Which programming language do you use for SAP Landscape Transformation based
You are implementing the SAP CO-PA Accelerator to enable real-time profitability
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 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 information model can you use with measures from multiple fact tables? Analytic privilege Attribute view Analytic view Calculation view.
Which of the following must you do when you create an analytic view? 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 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 graphical calculation view using the SAP HANA studio. Which steps
are mandatoryfor this task? Define a projection. Write an SQL script. Save and activate the view. Define output fields. Choose a data source.
When you activate an analytic view, a column view is created. In which schema is this
column view stored? _SYS_BIC _SYS_BI _SYS_REPO _SYS.
Which of the following are characteristics of an operational data mart based on SAP
HANA? 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.
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.
Which tasks do you have to perform if you want to use SAP BW with SAP HANA as the
underlying database? 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.
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 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. 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 code = 1000, fiscal year = 2000
One analytic privilege: company code = 1005, fiscal year = 2005 One analytic privilege: company codes = 1000 and 1005, and fiscal years = 2000 and
2005 One analytic privilege: company codes = 1000 and 1005
One analytic privilege: fiscal years = 2000 and 2005.
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 have created SAP HANA information models from replicated SAP ECC data.
How can you compare the data of the replicated tables with the underlying ECC source
data? Use the SAP ERP Data Browser (transaction SE16). Use the Catalog node to open table contents. Use transaction IUUC_REPL_CONTENT. Use the Data Provisioning view from the Quick Launch.
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? 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.
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.
Which of the following can be grouped when multiple schemas exist in an SAP HANA
database? Information models Data tables Packages Users.
Your customer wants to use SAP BusinessObjects Data Services to migrate and transform
large volumes of data to SAP HANA. What do you recommend? Use ABAP data flows. Use RFC/BAPI function calls. Use the RFC_READ_TABLE. Use IDOCs.
How can you generate documentation of your information models? Right-click on your information model and select the Auto Documentation function. Use the Export SQL button in the column view of your information model. Right-click on the column view of your information model and select the export function. Use the Auto Documentation button in your information model.
Which tasks can you perform with the data provisioning view in the SAP HANA studio? Start replication of tables Filter replicated data Apply data transformations Suspend replication of tables.
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.