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.
In a fuzzy search, when would you perform a freestyle search? A. When you want to search with a low fuzziness threshold B. When you want to search in only one column C. When you want to search in multiple columns D. When you want to search with a high fuzziness threshold.
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? A. Create a table in the SAP HANA studio. B. Map the source structure to the template table. C. Import metadata of the target table from the SAP HANA datastore. D. Drop a template table into the data flow. E. Enter the table name and schema name.
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? A. Shared network drive B. SAP BusinessObjects Information Design Tool C. SAP HANA database D. SAP HANA studio Content node.
In SAP HANA, which join type yields the same results as a referential join when fields from both
tables are selected? A. Left outer join B. Full outer join C. Inner join D. Temporal join.
What is the advantage of reporting directly from column tables? A. It provides multi-language support B. It eliminates the need for additional modeling C. It shifts complex calculations and logic to SAP HANA D. It supports analytical privileges.
Which SAP tool would you use for data cleansing before data is loaded into SAP HANA? A. SAP BusinessObjects Information Steward B. SAP BusinessObjects Data Services C. SAP Landscape Transformation D. SAP NetWeaver Master Data Management.
What are the key benefits of using SAP BusinessObjects Explorer with SAP HANA? A. You do not need to create your own queries to access information. B. You can easily create your own queries to access information. C. You can access information for data discovery intuitively. D. You can execute ad-hoc business analytics quickly. E. You can easily create an IDT business layer.
Which of the following nodes can you use when you create a calculation view with the SAP HANA
studio graphical interface? A. Data Foundation B. Aggregation C. Join D. Analytic Privilege.
Which transaction is used for releasing extractors specified by the customers in SLT? A. RODPS_OS_OPEN B. RODPS_OS_CLOSE C. RODPS_OS_EXPOSE D. RODPS_OS.
Which feature is supported by the backup and recovery process within the standard delivery of
SAP HANA? A. Incremental backup B. Information model recovery C. Point-in-time recovery D. Automatic backup of archiving log files scheduled within SAP HANA.
How can you improve the performance of a scripted calculation view? A. Read data from column tables using nested SELECT statements B. Convert SQL code to equivalent CE functions C. Combine analytic views using a CE_JOIN function D. Combine data from the row store and column store.
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? A. When a line item table contains sales values of two different currencies. B. When an aggregate table by country contains sales values in one currency. C. When a line item table contains sales values in one currency. D. When an aggregate table by country contains sales values in three different currencies.
Which of the following must you avoid to ensure your calculation view uses only the calculation
engine? A. Combining SQL and CE Functions B. Reading from tables in the column store C. Reading from tables using SELECT statements D. Joins using SQL E. DO WHILE loops.
Which of the following are characteristics of using a Rapid Deployment Solution (RDS), such
asOperational Reporting for SAP HANA? A. Relevant tables are replicated. B. SAP will create information models based on customer requirements. C. Customized tables and columns are replicated. D. Pre-designed information models are imported into SAP HANA.
You want to create a customer segmentation on your SAP HANA data. Which of the following do
you use? A. RODBC library B. SAP HANA Business Function Library C. SAPUI5 runtime library D. SAP HANA Predictive Analysis Library.
When loading data into SAP HANA, which of the following tasks can you perform using SAP Data
Services? A. Upload data via the SAP HANA studio B. Data filtering C. Real-time replication D. Data transformations.
Which of the following remote data sources can you access with SAP HANA smart data access? A. SAP NetWeaver Business Warehouse B. Microsoft SQL Server C. Apache Hadoop D. Teradata Database E. SAP Sybase Adaptive Service Enterprise.
You need to create an SAP HANA data model based on a star schema.
Which SAP HANA engine is recommended for analytical purposes? A. Calculation engine B. OLAP engine C. Row store engine D. Join engine.
Which SAP HANA model is recommended for reporting purposes where read operations on mass
data are required? A. Analytic view B. Calculation view using SQL C. Calculation view using SQL Script D. Attribute view.
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? A. Drag the information space to the Home page B. Refresh the list of information spaces on the Home page C. Select the "Show on Home page" checkbox in the information space properties D. Index the information space again.
If you want to create or drop tables in a schema, which privilege type do you need? A. SYSTEM B. ANALYTIC C. PACKAGE D. SQL.
How can you improve the quality of your information model design? A. Use “case’ or ‘if’ statements whenever possible. B. Use row-based database expressions. C. Design your views to be reusable. D. Modularize your views. E. Avoid duplications in your modeling.
If you notice, Unique Constraint Error while loading flat file then A. Modify the table and remove primary key B. Modify column with different data type C. Convert column table to row table or vice versa D. Check the data for this Constraint and make sure there are no duplicate values.
In which tool can you create information spaces for reporting? A. in the SAP HANA modeler perspective B. in the SAP HANA SQL editor C. in SAP BusinessObjects Explorer D. in the Information Design Tool.
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? A. Full-text search UI toolkit B. Python-based text analysis scripts C. Fuzzy search D. Application function libraries.
How can you generate documentation of your information models? A. Right-click on your information model and select the Auto Documentation function. B. Use the Export SQL button in the column view of your information model. C. Right-click on the column view of your information model and select the export function. D. Use the Auto Documentation button in your information model.
Which of the following are direct outputs of an analytic view? A. Hierarchies B. Private attributes C. Restricted attributes D. Measures E. Attribute views.
When you use SAP Landscape Transformation (SLT) replication, which of the following can you
set up in the advanced replication settings? A. Change a character field length of a table. B. Change the target table for specific records of a table. C. Assign a specific mass transfer ID to a table. D. Add a field to a table.
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? A. Remove all filters from the analytic views. B. Deactivate the Limit Size of Result Set parameter in the Central Management C. Console. D. Set the Array Fetch Size parameter to the maximum in the relational connection. E. Deactivate the Limit Size of Result Set parameter in the business layer.
What does SAP HANA smart data integration use for data provisioning? A. SAP HANA smart data access B. SAP HANA smart data streaming C. Database triggers D. Database logs E. Real-time adapters.
In which engines is an analytic view executed that contains a calculated column? A. Calculation engine B. Row store engine C. OLAP engine D. Join engine.
When you activate a procedure, in which schema is the procedure stored? A. SYSTEM B. _SYS_BIC C. SYS_REPL D. _SYS_BI.
Which engine is used for calculation and aggregation based on star schema A. Join Engine B. Calculation Engine C. SQL Optimizer Engine D. OLAP Engine.
What can you use to transform data from SAP Business Warehouse (BW) into SAP HANA? A. SAP Landscape Transformation (SLT) B. SAP BW extractors C. SAP BusinessObjects Data Services
D. SAP Legacy System Migration Workbench (LSMW).
When you activate an analytic view, a column view is created. In which schema is this column
view stored? A. _SYS_BIC B. _SYS_BI C. _SYS_REPO D. _SYS.
Which of the following can you use as sources for the vocabulary in a decision table? A. Calculation views B. Table C. OData models D. Procedures E. Physical tables.
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? A. CREATE ANY to user A B. REFERENCES to user A C. CREATE ANY to user B D. REFERENCES to user B.
Which of the following are functions of the controller in the SAP Landscape Transformation (SLT)
server? A. Create repositories in the source system. B. Write data to the SAP HANA system using the DB C. Map database structures between SAP HANA and the source system. D. Schedule replication processes.
Which SAP BusinessObjects tools require an SAP BusinessObjects semantic layer (universe) to
access data in SAP HANA? A. Crystal Reports 2011 B. Crystal Reports for Enterprise C. Dashboards D. Analysis Office v1.1 E. WebIntelligence.
How can you restrict SAP HANA modeling users from viewing sensitive data? A. Use scrambled source data. B. Remove SAP_DATA_ADMIN in the SQL privileges for the modeling users. C. Use the pre-delivered MODELER role. D. Remove ALTER SYSTEM in the system privileges for the modeling users.
When working with your data models, which of the following do you use to get detailed
information about tables, number of rows, and partitioning? A. Performance analysis mode B. Catalog node of your system C. Visualize plan D. Explain plan.
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? A. One analytic privilege. the combination of company code = 1000 and fiscal year = 2000, and the
combination of company code = 1005 and fiscal year = 2005 B. One analytic privilege: company code = 1000, fiscal year = 2000 One analytic privilege: company
code = 1005, fiscal year = 2005 C. One analytic privilege: company codes = 1000 and 1005, and fiscal years = 2000 and D. One analytic privilege: company codes = 1000 and 1005 One analytic privilege: fiscal years =
2000 and 2005.
What are advantages of implementing SAP HANA using an SAP rapid-deployment solution over
a traditional implementation project? A. Fixed-scope implementation B. No need for consultants C. Lower risk D. Pre-configured content E. Customized content.
Which of the following are required to build a SQLScript calculation view? A. Define a data foundation. B. Define a measure. C. Set the MultiDimensional Reporting property to false. D. Add columns to the var_out output parameter.
What are characteristics of a constraint filter? A. It is defined during the design time on a table. B. It is applied on a table before the query execution. C. It is applied on the result set of an SQL query. D. It is defined during the runtime in the SQL .
What type of calculation would you create to ensure the fastest calculation performance? A. A report variable in an SAP BusinessObjects reporting client B. A calculated column in an SAP HANA information model C. An input parameter in an SAP HANA information model D. An calculated measure in an SAP BusinessObjects universe.
A calculation view that joins one fact table with dimension tables performs slowly.
Which of the following can you do to improve performance? A. Turn the calculation view into an analytic view. B. Turn the calculation view into a simple calculation view. C. Load the calculation view into memory. D. Load the calculation view into the _SYS_BI schema.
Which view need be considered in development for read operations on mass data required? A. Analytic B. Attribute C. Calculation D. Analytic / Calculation.
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? A. Update the alias in the properties of ID_1. B. Change the label of ID_1. C. Create a restricted column with a different name based on ID_1. D. Create a derived attribute view with an alias for ID_1.
You want to perform a multiple linear regression on your data. Which of the following do you use? A. SAPUI5 runtime library B. RODBC library C. SAP HANA Predictive Analysis Library D. SAP HANA Business Function Library.
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? A. SAP NetWeaver BW master data tables B. DataStore Objects (DSOs) C. ABAP system tables D. Persistent Staging Area (PSA) tables.
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? A. Use the SAP ERP Data Browser (transaction SE16). B. Use the Catalog node to open table contents. C. Use transaction IUUC_REPL_CONTENT. D. Use the Data Provisioning view from the Quick Launch.
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? A. Persistence Layer B. MDX C. Session Management D. Authorization Manager.
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? A. Activation status of the information models B. Transaction SAP ERP Data Modeler (SD11) C. Transaction LTR on SLT D. Data Provisioning view in SAP HANA studio.
Which data provisioning method can you use to load data from SAP business content
DataSources into SAP HANA? A. SAP Landscape Transformation (SLT) B. SAP Landscape Directory (SLD) C. SAP Direct Extractor Connection (DXC) D. SAP BusinessObjects Data Services.
Which of the following can you use to implement currency conversion in an information model? A. A calculated column in a calculation view B. A restricted column in an analytic view C. A calculated column in an analytic view D. A calculated column in an attribute view.
Which of the following objects would SAP HANA identify as the left object of a join in the
graphical calculation view? A. The object that has its field identified first in the join output. B. The object that is displayed on the left hand side in the join details panel. C. The object that is connected to the join node first. D. The object that is displayed on the left hand side in the graphical calculation view.
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)? A. Create a delivery unit on system1 B. Import the models into system2 C. Create a schema on system2 D. Create a delivery unit on system2 E. Export the models from system1.
What is features available in Project Creation Wizard A. New option to auto-share an XS Project to the SAP HANA Repository during the project creation
wizard B. New option to auto-share an XS Server - side Project to the SAP HANA Repository during the
project creation wizard C. New option to auto-share an XS client - side Project to the SAP HANA Repository during the
project creation wizard D. New option to auto-share an XS Server - side secure Project to the SAP HANA Repository during
the project creation wizard.
You are experiencing performance problems with SAP BusinessObjects reports based on SAP
Which of the following can you do to increase performance? A. Add only relevant data to the report queries. B. Avoid aggregation and work on raw data. C. Merge all relevant data into a consolidated report. D. Use drill-down or linked reports.
With which of the following do you build the vocabulary of a decision table? A. Actions B. Attributes C. Conditions D. Measures.
Which of the following sequences of steps is required before you can create a report on an
analytic view using replicated SAP ERP data? A. Set up replication from ERP - Create an analytic view - Create analytic privileges - Create a
business layer B. Create a business layer - Set up replication from ERP - Create an analytic view - Create analytic
privileges C. Create an analytic view - Create analytic privileges - Set up replication from ERP - Create a
business layer D. Create an analytic view - Set up replication from ERP - Create analytic privileges - Create a
You modified an active analytic view in the SAP HANA studio and saved it without activating it.
What is the consequence? A. The inactive view is not available. B. The inactive view is in "Read Only" mode. C. The active view is not available. D. The active view is in "Read Only" mode.
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
What must you do to avoid this problem? 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.
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? A. Use SAP ERP Data Modeler (transaction SD11). B. Use SAP ERP ABAP Dictionary Maintenance (transaction SE11). C. Use the SAP ERP Tables and Indexes Monitor(transaction DB02). D. Use SAP ERP Data Browser (transaction SE16).
Which of the following can be part of an analytic view? A. Query transformation B. Unions C. Logical joins D. Data foundation E. Attributes.
Which of the following is a best practice in calculation views? A. Apply a static filter on a projection node. B. Combine analytic views with a join node. C. Change an attribute to a measure. D. Push calculations down to the attribute views.
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? A. SAP Legacy System Migration Workbench (LSMW) B. SAP Landscape Transformation (SLT) C. Sybase Replication Server D. SAP BusinessObjects Data Services 4.0.
When you use SLT replication, which of the following determines the name of the SAP HANA
schema where replicated data is stored? A. The name of the secondary database connection B. The name of the replication configuration C. The name of the source system schema D. The name of the RFC connection.
Which of the following objects can you use when you build an analytic view? A. Attribute views B. Analytic views C. Hierarchies D. Variables E. Projections.
Which of the following SAP data provisioning methods provide complex transformations? A. SAP Data Services B. SAP HANA smart data access C. SAP Replication Server D. SAP HANA smart data quality.
You need to find out which users logged on to the SAP HANA system over the course of the last
What would you check? A. The Audit log B. Entries in M_CONNECTIONS C. The nameserver_history.trc file D. The indexserver_alert.trc file.
Which type of connection does Direct Extractor Connection (DXC) use to transfer data to SAP
HANA? A. RFC connection B. Secondary database connection C. http connection D. ODBC connection.
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? A. Global temporary table B. Decision table C. Row table D. Column table.
You have imported models from the development system. What is the recommended way
toactivate dependent models in SAP HANA? A. Use the Activate with History function. B. Use the Where-Used List function. C. Use the Cascade Activate function. D. Activate each view manually.
Which of the following authentication methods are supported for Single Sign-On for SAP HANA? A. Kerberos B. LDAP over SSL C. Secure Network Communication (SNC) D. SAML CAS (Central Authentication Service).
What happens when you turn on replication of an SAP ERP source system using SAP Landscape
Transformation (SLT)? A. SLT creates ABAP code in the ERP system that writes to application tables. B. SLT creates ABAP code in the ERP system that writes to logging tables. C. SLT creates database triggers in the ERP system that write to logging tables. D. SLT creates database triggers in the ERP system that write to application tables.
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? A. Use a calculation view based upon two analytic views using a union. B. Use a calculation view based upon two analytic views using a join. C. Use a single source data foundation in the Universe Design Tool and include the two analytic
views. D. Use a multisource-enabled data foundation in the Universe Design Tool for each 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? A. By checking the session client of the user accessing the view B. By reading the client of the tables in the view C. By applying the filtering conditions on the client field D. By executing a procedure in the user's own schema.
What are benefits of using a business layer on top of SAP HANA? A. An extra layer of granular security B. Improved database calculation speed C. Fast throughput via BICS connectivity D. Users can use business names instead of technical names.
Union can be performed only at... A. Analytic B. Attribute C. Calculation D. Analytic / Calculation.
How can you import information models into SAP HANA using the Quick Launch view? A. Select the Redeploy button B. Select Data Provisioning -> Load C. Select Import -> SAP HANA Content -> Import Data From Local File D. Select Import -> SAP HANA Content -> Delivery Unit.
Which of the following tools can you use to monitor the query time from SAP HANA? A. Central Management Console B. Performance tab of the System Monitor C. Event Viewer D. SQL Trace.
Which of the following privileges do you need to activate views? A. SELECT option on the _SYS_BIC schema B. SELECT option on the _SYS schema C. SELECT option on the _SYS_BI schema D. SELECT option on the _SYS_REPO schema.
How can you improve the performance of a report that is based on SAP HANA data? A. Ensure that all SAP HANA tables are in the same schema. B. Maintain appropriate constraint filters in SAP HANA. C. Ensure that all calculations are pushed down to the SAP HANA database. D. Gather new database statistics.
In SAP HANA studio, in which of the following can you create users? A. The Administration console B. The Roles node C. The Content node D. The SQL editor.
You want to create a graphical calculation view using the SAP HANA studio. Which steps are
mandatoryfor this task? A. Define a projection. B. Write an SQL script. C. Save and activate the view. D. Define output fields. E. Choose a data source.
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? A. Assign restricted values to the attribute view. B. Assign values to be restricted. Choose at least one information model to assign restrictions. C. Assign the analytic privilege to a user or role. D. Assign values to be restricted to a content table. E. Choose an attribute to define restricted values for it.
Company needs to load external data from a flat file into SAP HANA. How can you do this? A. SAP HANA Direct Extractor Connection (DXC) B. SAP System Landscape Transformation (SLT) C. SAP HANA SQL Import statement D. SAP BusinessObjects Data Services.
Where is the physical data stored, on which a calculation view is based? A. In the _SYS_BI schema B. In a schema C. In the _SYS_BIC schema D. In a package.