Pa
g
e
1
QUESTION:
1
How can you import information models into SAP HANA using the Quick
Launch view?
A. Choose the Redeploy button.
B. Choose Import -> SAP HANA Content -> Delivery Unit.
C. Choose Data Provisioning -> Load.
D. Choose Import -> SAP HANA Content -> Import Data From Local File.
Answer:
B
QUESTION:
2
Which versions of your information models are visible on the History tab of
the Modeler perspective in the SAP HANA studio?
A. Only the last active version
B. The last active and inactive versions
C. All active and inactive versions
D. All active versions
Answer:
D
QUESTION:
3
Which of the following actions must you perform in an SAP HANA system to
transport content to another SAP HANA system?
Note: There are multiple correct answers to the question
A. Generate and save an export file.
B. Mass copy the content repository into the other SAP HANA system.
C. Assign the package to a delivery unit.
D. Assign the content repository to a transport request.
Answer:
A, C
QUESTION:
4
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 available for reporting.
B. The active view is in "read-only" mode.
C. The inactive view is in "read-only" mode.
D. The active view is not available for reporting.
Answer:
B
QUESTION:
5
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?
Pa
g
e
2
A. History function
B. Where-used function
C. Auto Documentation function
D. Display XML function
Answer:
B, C
QUESTION:
6
Which of the following can be grouped inside a single schema in an SAP
HANA database?
A. Information models
B. Packages
C. Users
D. Database tables
Answer:
D
QUESTION:
7
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)?
Note: There are multiple correct answers to the question
A. Export the models from system1.
B. Create a delivery unit on system1.
C. Create a delivery unit on system2.
D. Import the models into system2.
E. Create a schema on system2.
Answer:
A, B, D
QUESTION:
8
Which of the following SAP HANA schemas contains the runtime objects of
activated views?
A. _SYS_STATISTICS
B. _SYS_REPO
C. _SYS_BI
D. _SYS_BIC
Answer:
D
QUESTION:
9
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?
A. Python-based text analysis scripts
B. Full-text search UI toolkit
C. Application function libraries
Pa
g
e
3
D. Fuzzy search
Answer:
A
QUESTION:
10
Which of the following can be grouped inside a single schema in an SAP
HANA database?
A. Information models
B. Packages
C. Users
D. Database tables
Answer:
D
QUESTION:
11
Which of the following can be grouped inside a single schema in an SAP
HANA database?
A. Information models
B. Packages
C. Users
D. Database tables
Answer:
D
QUESTION:
12
How can you import information models into SAP HANA using the Quick
Launch view?
A. Choose the Redeploy button.
B. Choose Import -> SAP HANA Content -> Delivery Unit.
C. Choose Data Provisioning -> Load.
D. Choose Import -> SAP HANA Content -> Import Data From Local File.
Answer:
B
QUESTION:
13
When you try to delete an attribute view you receive the error message,
"One or moreobjects are dependent upon this object".
Which of the following functions can you use to find out which objects
depend on this view?
Note: There are 2 correct answers to this question.
A. History function
B. Where-used function
C. Auto Documentation function
D. Display XML function
Pa
g
e
4
Answer:
B, C
QUESTION:
14
Which versions of your information models are visible on the History tab of
the Modelerperspective in the SAP HANA studio?
A. Only the last active version
B. The last active and inactive versions
C. All active and inactive versions
D. All active versions
Answer:
D
QUESTION:
15
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 available for reporting.
B. The active view is in "read-only" mode.
C. The inactive view is in "read-only" mode.
D. The active view is not available for reporting.
Answer:
B
QUESTION:
16
Which of the following steps do you have to execute to import models from
one SAP HANAsystem (system1) to another SAP HANA system (system2)?
Note: There are multiple correct answers to the question
A. Export the models from system1.
B. Create a delivery unit on system1.
C. Create a delivery unit on system2.
D. Import the models into system2.
E. Create a schema on system2.
Answer:
A, B, D
QUESTION:
17
Which of the following SAP HANA schemas contains the runtime objects of
activated views?
A. _SYS_STATISTICS
B. _SYS_REPO
C. _SYS_BI
D. _SYS_BIC
Pa
g
e
5
Answer:
D
QUESTION:
18
Which of the following actions must you perform in an SAP HANA system to
transportcontent to another SAP HANA system?
Note: There are multiple correct answers to the question
A. Generate and save an export file.
B. Mass copy the content repository into the other SAP HANA system.
C. Assign the package to a delivery unit.
D. Assign the content repository to a transport request.
Answer:
A, C
QUESTION:
19
Which of the following can you use to implement currency conversion in an
informationmodel?
Note: There are multiple correct answers to the question
A. A calculated column in a calculation view
B. A calculated column in an attribute view
C. A calculated column in an analytic view
D. A restricted column in an analytic view
Answer:
A, C
QUESTION:
20
In a fuzzy search, when would you perform a freestyle search?
A. When you want to search with a high fuzziness threshold
B. When you want to search in multiple columns
C. When you want to search in only one column
D. When you want to search with a low fuzziness threshold
Answer:
B
QUESTION:
21
Which of the following criteria indicate that you should store data in row
tables?
Note: There are multiple correct answers to the question
A. The tables have a large number of columns
B. The information models search the table based on the values of a few
columns.
Pa
g
e
6
C. The information models frequently need to access all columns.
D. The tables require frequent write access.
Answer:
C, D
QUESTION:
22
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
Answer:
A
QUESTION:
23
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?
Note: There are multiple correct answers to the question
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.
Answer:
A, D
QUESTION:
24
You have imported models from the development system. What is the
recommended waytoactivate 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.
Answer:
C
QUESTION:
25
Which SAP BusinessObjects tool do you use to visualize real-time key
performance indicators with simulations?
A. Explorer
B. Analysis, edition for OLAP
C. Web Intelligence
D. Dashboards
Pa
g
e
7
Answer:
D
QUESTION:
26
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
Answer:
C
QUESTION:
27
Which tool do you use for real-time data provisioning into SAP HANA?
A. SAP Landscape Transformation (SLT)
B. SAP BusinessObjects Data Federation Administration
C. SAP BusinessObjects Data Services
D. SAP Direct Extractor Connection (DXC)
Answer:
A
QUESTION:
28
In SAP ERP there are more than 50,000 application tables. How do you
determine therelevant 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).
Answer:
A
QUESTION:
29
Which of the following CE functions can you use to query an analytic view
directly?
A. CE_CALC
B. CE_AGGREGATION
C. CE_OLAP_VIEW
D. CE_JOIN_VIEW
Answer:
C
QUESTION:
30
Which package privileges are required to extend an SAP HANA Live view?
Note: There are multiple correct answers to the question
Pa
g
e
8
A. REPO.ACTIVATE_NATIVE_OBJECTS
B. REPO.EDIT_IMPORTED_OBJECTS
C. REPO.READ
D. REPO.EDIT_NATIVE_OBJECTS
E. REPO.MAINTAIN_NATIVE_PACKAGES
Answer:
A, C, D
QUESTION:
91
Which view in SAP HANA studio do you use to add additional users?
A. Properties View
B. Quick launch View
C. Console View
D. Navigator View
Answer:
D
QUESTION:
92
Which of the following actions must you perform in an SAP HANA system to
transport content to another SAP HANA system?
Note: There are multiple correct answers to the question
A. Generate and save an export file to a shared directory.
B. Assign the content repository to a transport request.
C. Mass copy the content repository into the other SAP HANA system.
D. Assign the package to a delivery unit.
Answer:
A, D
QUESTION:
93
You model hierarchies in attribute views. Which of the following technologies
do you use tomake these hierarchies available for reporting tools?
A. JDBC
B. BICS
C. ODBO
D. ODBC
Answer:
C
QUESTION:
94
HANA Currency Conversion supported only via ___
A. Analytic
B. Attribute
C. Calculation
D. Analytic / Calculation
Pa
g
e
9
Answer:
D
QUESTION:
95
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
Answer:
D
QUESTION:
96
Which of the following can you set up to enable the extraction of data from
SAP Business Warehouse (BW) into SAP HANA?
Note: There are multiple correct answers to the question
A. SAP System Landscape Directory (SLD)
B. SAP BusinessObjects Data Services
C. SAP Landscape Transformation (SLT)
D. Open hub
E. SAP HANA Direct Extractor Connection (DXC)
Answer:
B, D, E
QUESTION:
97
What are the key benefits of using SAP BusinessObjects Explorer with SAP
HANA?
Note: There are multiple correct answers to the question
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.
Answer:
A, C, D
QUESTION:
98
You are implementing the SAP CO-PA Accelerator to enable real-time
profitability reporting. Which configuration steps must you do?
Note: There are multiple correct answers to the question
A. Activate continuous data replication of tables CE1xxxx, CE2xxxx,
CE4xxxx.
B. Configure the SAP BusinessObjects Data Services replication jobs.
Pa
g
e
1
0
D. Build attribute and analytic views in SAP HANA.
E. Create a secondary
database connection in SAP ERP.
Answer:
A, C, E
QUESTION:
99
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
Answer:
B
QUESTION:
100
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
Answer:
C
Pa
g
e
1
1
QUESTION: 251What is the default maximum number of rows in Data preview? A. 500 B. 1000 C. 5000 D. 10000 Answer: C QUESTION: 252
Validation rules of Analytic View can be selected and deselected from the ‘Manage Preferences’?
A. True B. False
Answer: A
QUESTION: 253
A Package within a package can be created? A. True
B. False
Answer: A
QUESTION: 254
SAP delivered content Information models can be activated from? A. Import
B. Migrate C. Mass Copy D. All of the above
Answer: C
QUESTION: 255
Auto-documentation generates technical design document in which format? A. .doc
B. .pdf C. .xml
Pa
g
e
1
2
Answer: B QUESTION: 256Hierarchies with hierarchy levels are supported in Attribute view? A. True
B. False
Answer: A
QUESTION: 257
SAP BO Data Services can connect to any OLTP system including DBMS & RDBMS? A. True
B. False
Answer: A
QUESTION: 258
Calculation engine performs the following: A. Create joins at run-time
B. Create calculated measures & calculated attributes C. Compute & executes Calculation Views
D. All of the above
Answer: D
QUESTION: 259
The HANA optimized Info cubes has the following features A. No dimension tables
B. No secondary fact-table
C. They represent “flat structures D. All of the above
Answer: D
QUESTION: 260
LT replication “Schema” can be configured to support extraction jobs as follows: A. Real-Time
B. Schedule by Interval C. Schedule by Time D. All of the above
Pa
g
e
1
3
Answer: DPa
g
e
1
4
QUESTION: 261For Time Attribute views, which calendar types can be created?
Note: There are multiple correct answers to the question
A. Gregorian calendar B. Fiscal calendar C. Factory calendar D. All of the above
Answer: A, B
QUESTION: 262
Procedures can be created with Invokers rights only? A. True
B. False
Answer: B
QUESTION: 263
Filter values can assigned at the ‘Data foundation’ in the Analytic view? A. True
B. False
Answer: A
QUESTION: 264
SAP Solution Manager is used to provide remote access to HANA Studio? A. True
B. False
Answer: A
QUESTION: 265
Security & Authorization of SAP HANA is required to maintain the following? A. Control access to objects/views
B. Field-level security
C. Restrict users from viewing Information models D. All of the above
Answer: D
QUESTION: 266
Pa
g
e
1
5
Which of the following cardinalities are supported in Attribute view? A. 1:N
B. N:1 C. 1:1 D. N:N
E. All of the above
Answer: A, B, C
QUESTION: 267
Pre-requisite to execute Crystal reports enterprise?
Note: There are multiple correct answers to the question
A. JDBC/ODBC interfaces B. Relational Universe C. MDX
D. All of the above Answer: A, B
QUESTION: 268
Is it possible to add tables later after the Analytic view is created? A. True
B. False
Answer: A
QUESTION: 269
Packages can be exported without assigning Delivery units for Server type exports? A. True
B. False
Answer: B
QUESTION: 270
Information Composer is a browser like application for End-users to create reports? A. True
B. False
Pa
g
e
1
6
QUESTION: 271You 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 Answer: A
QUESTION: 272
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 Answer: B
QUESTION: 273
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 Answer: C QUESTION: 274
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 Answer: C
QUESTION: 275
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 Answer: B
QUESTION: 276
What outputs can you create in an attribute view?
Note: There are multiple correct answers to the question
A. Key Attributes B. Calculated Attribute
Pa
g
e
1
7
C. Restricted Measures D. Calculated Measures E. Private Attributes Answer: A, B QUESTION: 277Which data provisioning method can you use to load data from SAP business content Data Sources into SAP HANA?
Note: There are multiple correct answers to the question
A. SAP Landscape Transformation (SLT) B. SAP Landscape Directory (SLD)
C. SAP Direct Extractor Connection (DXC) D. SAP BusinessObjects Data Services
Answer: C, D
QUESTION: 278
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 Answer: D QUESTION: 279
When you activate a procedure, in which schema is the procedure stored? A. SYSTEM B. _SYS_BIC C. SYS_REPL D. _SYS_BI Answer: B QUESTION: 280
In which tool can you create information spaces for reporting? A. SAP HANA modeler perspective
B. SAP HANA SQL editor
C. SAP BusinessObjects Explorer D. Information Design Tool
Answer: C
QUESTION: 281
Which of the following are functions of the controller in the SAP Landscape Transformation (SLT) server? Note: There are multiple correct answers to the question
A. Create repositories in the source system
Pa
g
e
1
8
C. Map database structures between SAP HANA and the source system D. Schedule replication processes
Answer: C, D
QUESTION: 282
Which of the following is used to make hierarchies available to reporting tools?
A. CE Functions B. MDX C. SQLScript D. SQL Answer: B QUESTION: 283
You discover row count discrepancies between source data and SAP HANA information models. Which of the following can you investigate to find the source of the discrepancies?
Note: There are multiple correct answers to the question
A. Client filtering in the Delivery unit view B. Joins in information models
C. Memory leaks
D. Client filtering in SAP Landscape Transformation (SLT)
Answer: B, D
QUESTION: 284
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?
Note: There are multiple correct answers to the question
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
Answer: C, D
QUESTION: 285
When must you create a calculation view in SAP HANA?
A. When you need to create a star schema
B. When key figures (measures) span across tables C. When you need calculations before aggregations D. When you need analytic operations like aggregation
Answer: B
QUESTION: 286
What is an example of a selective data load using SAP Landscape Transformation?
Pa
g
e
1
9
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
Answer: D
QUESTION: 287
You want to create a custom attribute in addition to your data model. How can you achieve this?
A. Create the attribute as a calculated attribute within the analytic view B. Create the attribute and add it to the appropriate system table manually C. Create the attribute as a calculated measure within the attribute view D. Create the attribute as a restricted attribute within the calculation view
Answer: A
QUESTION: 288
You modify an existing view. How can you determine which models are affected by this change?
A. Use the audit trail
B. Use the History feature for the changed model
C. Use the "Where-Used List" feature for the changed model
D. Use the "Auto Documentation" to compare the object version of the changed model
Answer: C
QUESTION: 289
Which of the following sequences of steps is used to implement SAP HANA with SAP ERP?
A. Data Provisioning => SAP HANA system setup => Modeling => Consumption
B. SAP HANA system setup => Modeling => Data Provisioning => Consumption
C. SAP HANA system setup => Data Provisioning => Modeling => Consumption
D. SAP HANA system setup => Data Provisioning => Consumption => Modeling
Answer: C
QUESTION: 290
Which of the following are benefits of implementing SAP HANA? Note: There are multiple correct answers to the question
A. SAP HANA provides real-time analytics
B. SAP HANA performs much faster than the standard SAP ERP C. SAP HANA provides pre-configured BI Content
D. SAP HANA combines OLTP and OLAP in one system E. SAP HANA replaces SAP BW
Pa
g
e
2
0
QUESTION: 291You 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?
A. Universe
B. Web Intelligence report C. Analytic view
D. Calculation view using an Attribute value variable Answer: C
QUESTION: 292
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?
A. BSEG B. RODELTAM C. ROOSOURCE D. RSOLTPSOURCE Answer: C QUESTION: 293
You have an SAP HANA productive system with sensitive data.How can you restrict modeling users from viewing this data?
Note: There are multiple correct answers to the question
A. Remove ALTER SYSTEM in the system privileges for the modeling users B. Use randomized data for the development of data models
C. Allow modeling only on the SAP HANA development system and export/import the models to the productive system
D. Remove SAP_DATA_ADMIN in the SQL privileges for the modeling users Answer: B, C
QUESTION: 294
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 business layer
C. Set the Array Fetch Size parameter to the maximum in the relational connection D. Deactivate the Limit Size of Result Set parameter in the Central Management Console Answer: B
Pa
g
e
2
1
QUESTION: 295Which of the following properties of a derived attribute view can you modify? A. Description B. Description mapping C. Calculated attributes D. Filters Answer: A QUESTION: 296
Which of the following operations can you use when you create a calculation view using the SAP HANA studio graphical interface?
Note: There are multiple correct answers to the question A. Projection B. Union C. Intersect D. Aggregation Answer: A, B QUESTION: 297
Which data store type is recommended for write-intensive scenarios? A. Row store B. Column store C. Object store D. Table store Answer: A QUESTION: 298
Which delivered role is mandatory for a system administrator in SAP HANA? A. SYS_ADMIN B. IC MODELER C. CONTENT_ADMIN D. SAP_ALL Answer: C QUESTION: 299
What is the purpose of the savepoint process in SAP HANA?
A. Free-up memory by saving less used data to the persistent storage B. Save changed data and logs to the persistent storage on a regular basis C. Save changed data to the persistent storage when a transaction is committed D. Save logs to persistent storage when a transaction is committed
Pa
g
e
2
2
Answer: B QUESTION: 300Which best practices should you apply when you use SQL script in SAP HANA?
Note: There are multiple correct answers to the question
A. Use the WHERE clause for updates B. Use UNION ALL instead of UNION C. Use dynamic SQL with variables D. Use Cursors
E. Use CE functions Answer: A, B, E
QUESTION: 301
You want to create a graphical calculation view using the SAP HANA studio. Which steps are mandatory for this task?
Note: There are multiple correct answers to the question A. Define output fields
B. Define a projection C. Choose a data source D. Write an SQL script
E. Save and activate the view Answer: A, C, E
QUESTION: 302
How many result tables can a calculation view generate per session? A. Unlimited B. One C. Two D. None Answer: B QUESTION: 303
What are the advantages of using SAP BusinessObjects Data Services to load data into SAP HANA?
Note: There are multiple correct answers to the question A. You can use the same hardware
B. You can load unstructured data into SAP HANA
C. You can use BI Content Extractors or Function Modules D. You can merge Data Streams
Pa
g
e
2
3
E. You can perform real-time data replication Answer: B, C, D
QUESTION: 304
Which technologies use trigger-based replication?
Note: There are multiple correct answers to the question A. Near Zero Downtime
B. ABAP extractors
C. Test Data Migration Server (TDMS) D. Standard SQL database replication Answer: A, C
QUESTION: 305
Which reporting tool can you use to display native parent-child hierarchies from SAP HANA? A. Microsoft Excel
B. SAP BusinessObjects WebIntelligence
C. SAP BusinessObjects Analysis, edition for OLAP
D. SAP BusinessObjects Analysis, edition for Microsoft Office Answer: A
QUESTION: 306
What is one of the advantages of using SAP BusinessObjects Analysis edition for Microsoft Office?
A. Direct access to attribute views in SAP HANA B. Direct connection to SAP HANA via BICS C. Direct connection to SAP HANA via MDX D. Direct access to column tables in SAP HANA Answer: B
QUESTION: 307
Which of the following privileges do you need to activate views? A. SELECT option on the _SYS_BI schem
B. SELECT option on the _SYS_BIC schema C. SELECT option on the _SYS schema
D. SELECT option on the _SYS_REPO schema Answer: D
QUESTION: 308
Which SAP BusinessObjects tools require an SAP BusinessObjects semantic layer (Universe) to access data in SAP HANA?
Pa
g
e
2
4
A. WebIntelligence B. Crystal Reports 2011 C. Analysis Office v1.1D. Crystal Reports for Enterprise E. Dashboards
Answer: A, D, E
QUESTION: 309
For what purpose do you use SQL Script in SAP HANA?
Note: There are multiple correct answers to the question A. To combine two analytic views
B. To shift complex calculations and logic to the client side C. To create database procedures
D. To transfer a large amount of data between engines E. To achieve very high performance on SELECT statements Answer: A, C
QUESTION: 310
Which connectivity combination between MS Excel and SAP HANA provides multidimensional reporting capabilities?
A. ODBO connector via SQL requests to analytic or calculation views B. ODBC connector via MDX requests to analytic or calculation views C. ODBO connector via MDX requests to analytic or calculation views D. ODBO connector via MDX requests to column tables
Answer: C
QUESTION: 311
Which of the following are benefits of using accelerators with SAP HANA? Note: There are multiple correct answers to the question
A. They provide pre-built business content
B. They provide pre-built customer-specific solutions C. They reduce the time required for implementation D. They eliminate the need for customization
Answer: A, C
QUESTION: 312
How can you evaluate the speed of a calculation within the database? Note: There are multiple correct answers to the question
A. Use the Data Preview function in the SAP HANA studio
B. Execute a Web Intelligence report and check the duration of the previous refresh
Pa
g
e
2
5
C. Execute an information space using SAP BusinessObjects Explorer D. Write and execute an appropriate SQL statement
Answer: A, D
QUESTION: 313
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?
Note: There are multiple correct answers to the question A. Persistence Layer B. MDX C. Session Management D. Authorization Manager Answer: C, D QUESTION: 314
You want to design a model in SAP HANA. Which of the following modeling constructs do you use to create an analytic view?
Note: There are multiple correct answers to the question A. Join types B. Attribute views C. User privileges D. Tables E. Analytic views Answer: A, B, D QUESTION: 315
Which of the following are functions of the DB trigger within SAP Landscape Transformation (SLT)? Note: There are multiple correct answers to the question
A. Ensure that replicated changes are kept within the logging tables B. Record relevant changes in logging tables
C. Include only relevant tables for DB recording D. Decluster table classes into a transparent format Answer: B, C
QUESTION: 316
Your customer wants to use SAP BusinessObjects Data Services to migrate and transform large volumes of data to SAP HANA. What do you recommend?
A. Use ABAP data flows
B. Use RFC/BAPI function calls C. Use the RFC_READ_TABLE D. Use IDOC
Pa
g
e
2
6
Answer: A QUESTION: 317Where does SAP recommend you create calculated measures? A. In an attribute view B. In a column view C. In a business layer D. In an analytic view Answer: D QUESTION: 318
You want to test the quality of SAP HANA data by using a set of results from the source system. How can you retrieve the required data from SAP HANA?
Note: There are multiple correct answers to the question A. Use SAP Landscape Transformation (SLT) B. Use the data preview in SAP HANA studio
C. Use an SAP BusinessObjects client tool (such as Explorer or Web Intelligence) D. Use the database schema _SYS_REPO
E. Write and execute an appropriate SQL statement Answer: B, C, E
QUESTION: 319
What are benefits of using a business layer on top of SAP HANA? Note: There are multiple correct answers to the question 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 Answer: A, D
QUESTION: 320
You want to report on data from SAP HANA using MS Excel. How can you achieve this? Note: There are multiple correct answers to the question
A. Select an analytic view using the Data Connection wizard B. Create a ODBC connection between SAP HANA and MS Excel C. Select an attribute view using the Data Connection wizard D. Create an ODBO connection between SAP HANA and MS Excel Answer: A, D
QUESTION: 321
Pa
g
e
2
7
You are building a calculation view and want to select data from an analytic view. How can you achieve better performance for this requirement?
A. Use CE functions B. Use SQL statements C. Use L programming D. Use table indexing Answer: A
QUESTION: 322
Which connectivity options can you use to create a SAP BusinessObjects universe on SAP HANA? Note: There are multiple correct answers to the question
A. OLAP connection using MDX B. Relational connection using BICS C. Relational connection using ODBC D. Relational connection using MDX E. Relational connection using JDBC Answer: C, E
QUESTION: 323
You are using SAP BusinessObjects Data Services as your ETL tool. What is the next step required after you have created the DataStore and imported the metadata from an SAP ERP system into SAP HANA?
A. Import data from the SAP ERP system into SAP HANA
B. Create an SAP BusinessObjects Data Services job to migrate data to SAP HANA C. Import the metadata from SAP HANA into SAP BusinessObjects Data Services D. Create a connection in SAP BusinessObjects Data Services to the SAP ERP system Answer: C
QUESTION: 324
Which of the following tasks must you perform before you build a business layer within the SAP BusinessObjects Information Design Tool (IDT) on top of SAP HANA?
Note: There are multiple correct answers to the question A. Publish the connection to CMS
B. Build a query to test the connection C. Build a relational connection to SAP HANA D. Build an OLAP connection to SAP HANA E. Build a data foundation
Answer: A, C, E
QUESTION: 325
Which of the following are functions of the controller in the SAP Landscape Transformation (SLT) server? A. Create repositories in the source system
Pa
g
e
2
8
C. Map database structures between SAP HANA and the source system D. Schedule replication processes
Answer: C, D
QUESTION: 326
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
Answer: A
QUESTION: 327
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?
Note: There are multiple correct answers to the question 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 Answer: B, C, E
QUESTION: 328
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 Answer: D
QUESTION: 329
Which of the following steps is required for configuring SAP Landscape Transformation (SLT)? A. Define the number of background work processes in SLT
Pa
g
e
2
9
B. Define an RFC connection from SLT to SAP HANA C. Define a DB connection from SLT to the source system D. Define the number of jobs to be used for data replication Answer: D
QUESTION: 330
Which tasks do you have to perform if you want to use SAP BW with SAP HANA as the underlying database? A. Recreate SAP BW indexes after SAP HANA database migration
B. Do a heterogeneous system copy from your current DB to SAP HANA DB
C. Ensure that you have at least SAP NetWeaver Business Warehouse 7.02 installed D. Do a homogeneous system copy from your current DB to SAP HANA DB
Answer: B
QUESTION: 331
Which statement best describes an analytic view as a multidimensional view?
A. Analytic views are composed of one data foundation and one or more attribute views B. Analytic views are composed of at least one attribute view joined with more than one data foundation
C. Analytic views are composed of multiple joined data foundations D. Analytic views are composed of at least one attribute view Answer: A
QUESTION: 332
Which application enables you to create a Multisource Universe in SAP BusinessObjects BI 4.0? A. SAP HANA Studio
B. Information Design Tool C. Universe Design Tool D. Information Engine Answer: B
QUESTION: 333
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) Answer: C
Pa
g
e
3
0
You develop a disaster recovery plan. What do you have to consider in case of a disk failure? Note: There are multiple correct answers to the question
A. Configuration files can be restored automatically B. Savepoints can be backed up
C. Log volumes can be backed up
D. Non-committed transactions can be recovered E. Committed transactions can be recovered Answer: B, C, E
QUESTION: 335
What is the behavior of a Text Table Join where language column SPRAS is available? A. Left Outer Join
B. Right Outer Join C. Inner Join D. Referential Join Answer: A
QUESTION: 336
How can you improve the quality of your information model design? Note: There are multiple correct answers to the question
A. Use ´case´ or ´if´ statements whenever possible B. Use row-based database expressions
C. Design your views to be reusable D. Modularize your view
E. Avoid duplications in your modeling Answer: C, D, E
QUESTION: 337
Which new connection type is available as of SAP BusinessObjects Data Services 4.0? A. Operational Data Provider
B. BAPI function calls C. IDOCs
D. Read table via ABAP data flows Answer: A
QUESTION: 338
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 dimension Cost allocation reports with significantly faster processing time
Which application do you recommend? A. SAP Bank Analyzer with SAP HANA
Pa
g
e
3
1
B. SAP Deposits Management with SAP HANA C. SAP HANA CO-PA Accelerator
D. SAP HANA for Banking Answer: C
QUESTION: 339
Which of the following tasks are prerequisites for creating a hierarchy in SAP HANA? Note: There are multiple correct answers to the question
A. Define an output structure for the attribute view B. Define the data foundation
C. Choose the type of hierarchy
D. Define calculated attributes for the nodes of the hierarchy E. Define an analytic view
Answer: A, B, C QUESTION: 340
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?
A. By assigning SQL privileges to the necessary users B. By assigning Analytic privileges to the necessary users C. By assigning System privileges to the necessary users D. By assigning Package privileges to the necessary users Answer: B
QUESTION: 341
You want to broadcast reports that use data from SAP HANA. Which SAP BusinessObjects tool do you use? A. Analysis, edition for OLAP
B. Dashboards C. Crystal Reports D. Explorer Answer: C QUESTION: 342
What can be used as a source for the data foundation of an analytic view? Note: There are multiple correct answers to the question
A. A table that contains surrogate IDs referring to primary keys in the attribute views B. A table that contains foreign keys referring to primary keys in the attribute views C. A table that contains business facts or measures
Pa
g
e
3
2
Answer: B, C QUESTION: 343If you want to create or drop tables in a schema, which privilege type do you need? A. SYSTEM B. ANALYTIC C. PACKAGE D. SQL Answer: D QUESTION: 344
Which SAP BusinessObjects reporting tool should you use to answer ad-hoc questions and interact with shared information? A. Crystal Reports B. Dashboards C. Explorer D. WebIntelligence Answer: D QUESTION: 345
How can you assess the quality of the loaded data in SAP HANA?
A. Configure the SAP Landscape Transformation tool to implement the data quality process B. Compare data from reports in SAP BusinessObjects against the SAP HANA
_SYS_STATISTICS table
C. Perform master data quality checks in SAP ERP prior to replication in SAP HANA D. Compare reports in SAP BusinessObjects against source data for specific selections Answer: C, D
QUESTION: 346
What are the advantages of using SAP BusinessObjects Data Services to load data into SAP HANA? Note: There are multiple correct answers to the question
A. You can load unstructured data into SAP HANA B. You can merge data streams
C. You can use the same hardware
D. You can perform real-time data replication
E. You can use BI Content extractors or function modules Answer: A, B, E
QUESTION: 347
In the SAP HANA studio, which of the following SQL thread details can you monitor by using the Threads sub-tab of the Performance sub-tab of the Administration editor?
Note: There are multiple correct answers to the question
Pa
g
e
3
3
A. The SQL statement B. The generated data C. The service name D. The blocking status E. The visual execution plan Answer: B, C, DQUESTION: 348
Which of the following can you determine using the Backup catalog report? Note: There are multiple correct answers to the question
A. The path for the backup files B. Whether a recovery is possible C. Which backup files are obsolete D. When to execute the net backup Answer: B, C
QUESTION: 349
Your SAP HANA database performs slowly. Which of the following might be reasons for the performance decrease? Note: There are multiple correct answers to the question
A. Many replication jobs are running B. Backup jobs are running
C. Too many information models have been created D. Large tables are updated with frequent delta merges Answer: A, D
QUESTION: 350
Which column do you use to identify long-running SQL statements within the SQL Plan Cache view? A. TOTAL_EXECUTION_OPEN_TIME B. AVG_EXECUTION_OPEN_TIME C. TOTAL_EXECUTION _TIME D. AVG_EXECUTION_TIME Answer: D QUESTION: 351
Which system privilege do you need to modify the global_allocation_limit parameter? A. SERVICE_ADMIN
B. MONITOR_ADMIN C. SESSION_ADMIN D. INIFILE_ADMIN
Pa
g
e
3
4
Answer: D QUESTION: 352Which of the following are prerequisites for the integration of SAP Solution Manager and SAP HANA? Note: There are multiple correct answers to the question
A. Register SAP HANA in the System Landscape Directory
B. Create a connection to SAP HANA in the managed system configuration C. Configure SAP NetWeaver Landscape Virtualization Management
D. Configure SAP Early Watch Alerts for SAP HANA
Answer: A, B QUESTION: 353
A customer has started stress testing their SAP HANA solution. The actual performance of a calculation view is 100 times slower than the customer requires. The main table accessed contains billions of rows. Join logic in the calculation view is implemented using SQL. The customer explains that this was needed because a required join type is not supported in analytic views or CE functions.
Which of the following do you recommend to overcome the performance issue? Note: There are multiple correct answers to the question
A. Force query parallelization of the SQL
B. Re-design the data model to use an analytic view C. Re-design the SQL
D. Persist the result set of the calculation view
Answer: B, D QUESTION: 354
To support high availability, which of the following are valid index server actual roles for a 5 node scale-out SAP HANA system?
A. Two masters, two slaves, one standby B. One master, four slaves
C. One master, three slaves, one standby D. Four masters, one standby
Answer: C QUESTION: 355
Which of the following reduces the amount of data transferred from the OLAP engine to the Calculation Engine? A. Unions
B. Projections
C. Calculated attributes in an attribute view
Pa
g
e
3
5
D. Calculated attributes in an analytic view
Answer: B QUESTION: 356
The values for budget and actuals are in the same fact table identified by value type. You want to move budget and actual to the same row to be able to calculate the variance (Key Figure Model). How could you fulfill the
requirement?
A. Add two instances of the fact table to the data foundation. Implement a constant union in the analytic view.
B. Add two instances of the fact table to the data foundation. Join them via inner join and design a star schema on the logical view.
C. Implement a constant union by designing two analytic views and build a graphical calculation view with a union.
D. Implement a union by designing two analytic views and build a calculation view using CE_UNION_ALL.
Answer: C QUESTION: 357
What are the advantages of SAP BW on HANA compared to SAP BW with BWA? Note: There are multiple correct answers to the question
A. Reduced data latency B. Modeling flexibility
C. Decreased data load frequency D. Usage of Near Line Storage (NLS)
Answer: A, B
QUESTION: 358
Which of the following can you use to perform ranking in an SAP HANA data model? Note: There are multiple correct answers to the question
A. A CE function
B. A Calculated Attribute C. An SQL query
Pa
g
e
3
6
Answer: A, C QUESTION: 359A customer is implementing an SAP HANA solution. The major requirements for data sourcing are:
Extract data from the customer's ECC system using all Business Content extractor types and custom extractors.
Provide job scheduling and monitoring. Which of the following supports all requirements? A. SAP BusinessObjects Data Services
B. BW on SAP HANA
C. DXC using embedded BW D. SAP Landscape Transformation
Answer: B
QUESTION: 360
You are asked to develop a concept for transporting SAP HANA content from development to production.
Which of the following are prerequisites to use CTS+ transports?
A. SAP HANA content has been copied using „Mass Copy…“ in SAP HANA Studio B. SAP HANA content has been placed in a built-in package
C. SAP HANA content is bundled in a delivery unit D. SAP HANA content has been exported
QUESTION: 361
A customer complains about the performance of an analytic view. During your analysis you find out that there are calculated measures based on multiple restricted measures.
How can you improve the performance? A.
Create a calculation view Add multiple analytic views Use filters on attributes
Provide the output via an inner join operation in the calculation view
Pa
g
e
3
7
B. Create a calculation view Add multiple analytic views
Create calculated measures on the analytic views
Provide the output via union operation in the calculation view C.
Create a calculation view Add multiple analytic views Use filters on attributes
Provide the output via a union operation in the calculation view D.
Create multiple analytic views Use filters on the attributes
Create calculated measures on the analytic view Use a Universe to join the data
Answer: C
QUESTION: 362
Which of the following SQL statements deletes the user HANADEMO including all dependent objects? A. REVOKE USER HANADEMO CASCADE
B. DROP USER HANADEMO RESTRICT C. DROP USER HANADEMO CASCADE D. REVOKE USER HANADEMO RESTRICT Answer: C
QUESTION: 363
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?
A. Create an input parameter B. Create a filter on the table C. Create a calculated column D. Create a restricted column Answer: B
QUESTION: 364
Which of the following nodes can you use when you create a calculation view with the SAP HANA studio graphical interface?
Note: There are multiple correct answers to the question A. Data Foundation
B. Aggregation C. Join
Pa
g
e
3
8
D. Analytic Privilege Answer: B, C QUESTION: 365When table replication is suspended, what does the SAP Landscape Transformation (SLT) server do? A. It prevents the RFC connection from reading the source system logging tables B. It deletes the database triggers and the logging tables in the source system C. It stops the RFC connection and deletes the target tables in SAP HANA
D. It keeps reading via the RFC connection from the source system but does not load the data into SAP HANA
Answer: A QUESTION: 366
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?
Note: There are multiple correct answers to the question 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 Answer: C, D
QUESTION: 367
You create a business layer in the SAP BusinessObjects Information Design Tool (IDT). Which of the following could you add to the data foundation?
Note: There are multiple correct answers to the question A. Packages B. Column Tables C. Synonyms D. Information Models Answer: B, D QUESTION: 368
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?
A. You have not created a calculation view to expose the data to the users B. The data has not been loaded into SAP HANA memory yet
C. The schema mapping was not set up correctly
D. The import of business content was performed with the _SYS_REPO user Answer: C
QUESTION: 369
Pa
g
e
3
9
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?
A. SELECT on _SYS_REPO
B. SELECT on _SYS_REPO with the grant option C. REPO.READ for the package
D. REPO.MAINTAIN_NATIVE_PACKAGES for the package Answer: C
QUESTION: 370
Which data provisioning method can you use to load data from SAP business content DataSources into SAP HANA?
Note: There are multiple correct answers to the question A. SAP Landscape Transformation (SLT)
B. SAP Landscape Directory (SLD)
C. SAP Direct Extractor Connection (DXC) D. SAP BusinessObjects Data Services Answer: C, D
QUESTION: 371
Your customer requires real-time replication. Where do you select the tables to be replicated to SAP HANA? A. In transaction LTR in SAP Landscape Transformation (SLT)
B. In the Import dialog of the Quick Launch of SAP HANA studio C. In transaction SAP ERP Tables and Indexes Monitor (DB02) D. In the Data Provisioning dialog of SAP HANA studio
Answer: D QUESTION: 372
Which of the following can you use as a source for a graphical calculation view? Note: There are multiple correct answers to the question
A. Calculation view B. SQL view C. Table D. Decision table E. Procedure Answer: A, C, D QUESTION: 373
Which of the following can you check to investigate the query time in SAP HANA? Note: There are multiple correct answers to the question
A. The SQL plan cache
Pa
g
e
4
0
D. The statistics server warning for long running statements E. The System information tab of the Administration console Answer: A, C, D
QUESTION: 374
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?
Note: There are multiple correct answers to the question
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 Answer: A, D,E
QUESTION: 375
Which of the following does an SAP BusinessObjects universe use to communicate with SAP HANA? A. ABAP B. SQL C. MDX D. BICS Answer: B QUESTION: 376
Which of the following must you do in order to use SAP BusinessObjects Explorer on SAP HANA data? Note: There are multiple correct answers to the question
A. Create a delivery unit B. Create a business layer C. Create an information model D. Create an information space Answer: C, D
QUESTION: 377
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
Pa
g
e
4
1
Answer: B QUESTION: 378Which of the following automatically aggregates data? Note: There are multiple correct answers to the question A. Analytic view B. Calculation view C. Column table D. Attribute view Answer: A, B QUESTION: 379
Which privilege type do you have to assign to a role, when you want to provide row-level access to data? A. ANALYTIC B. PACKAGE C. SYSTEM D. SQL Answer: A QUESTION: 380
Using SAP BusinessObjects Data Services, in which of the following can you perform data transformations? Note: There are multiple correct answers to the question
A. Query B. DataStore C. XML File D. Script Answer: A, D QUESTION: 381
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 Answer: C
QUESTION: 382
During loading of data into SAP HANA you want to filter the source data. Where can you apply the filters? Note: There are multiple correct answers to the question
A. In a query transformation in SAP BusinessObjects Data Services
Pa
g
e
4
2
C. In a SQL WHERE clause in SAP Landscape Transformation (SLT) D. In an ABAP code rule in SAP Landscape Transformation (SLT) Answer: A, D
QUESTION: 383
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? Note: There are multiple correct answers to the question
A. The schema mapping B. The restricted measures C. The analytic privileges D. The universe
Answer: C, D QUESTION: 384
Which of the following must you avoid to ensure your calculation view uses only the calculation engine?
Note: There are multiple correct answers to the question 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 Answer: A, C, D QUESTION: 385
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 business layer
Answer: A QUESTION: 386
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?
Note: There are multiple correct answers to the question
Pa
g
e
4
3
A. Dashboards B. Web Intelligence C. Explorer D. Crystal Reports Answer: B, D QUESTION: 387A 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? A. SAP BusinessObjects Dashboard
B. SAP BusinessObjects Web Intelligence C. SAP BusinessObjects Explorer
D. SAP BusinessObjects Crystal Reports for Enterprise Answer: C
QUESTION: 388
Which of the following are required elements when you create any type of hierarchy in SAP HANA? Note: There are multiple correct answers to the question
A. A Child node B. An Analytic view C. A Data Foundation D. An Attribute view Answer: C, D QUESTION: 389
On which of the following servers can you configure SAP HANA Direct Extractor Connection (DXC) data sources? Note: There are multiple correct answers to the question
A. SAP Business Warehouse server
B. SAP BusinessObjects Data Services server C. SAP HANA server
D. SAP ECC server Answer: A, D QUESTION: 390
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?
Note: There are multiple correct answers to the question
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
Pa
g
e
4
4
Answer: B, D QUESTION: 391How 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 Answer: A
QUESTION: 392
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. A derived attribute view B. A shared attribute view C. Two data foundations
D. An attribute view using the Copy From method Answer: A
QUESTION: 393
How can you improve the performance of an information model? Note: There are multiple correct answers to the question A. Use generated columns
B. Use analytic views wherever possible C. Use indexes on all measure
D. Use attribute views wherever possible E. Use constraint filters
Answer: A, B, E QUESTION: 394
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?
Note: There are multiple correct answers to the question A. Use a calculated attribute
B. Use a calculated measure C. Use a variable
D. Use a CE function Answer: B, D
Pa
g
e
4
5
QUESTION: 395Which of the following are required to create an attribute view? Note: There are multiple correct answers to the question A. Data Foundation B. Default Schema C. Join D. Key Attribute Answer: A, D QUESTION: 396
You are running an SAP BusinessObjects Web Intelligence report that fetches data from an analytic view. Which of the following 4 components is used by SAP HANA to provide data for this report?
A. SAP host agent B. Delivery unit C. XS engine D. OLAP engine Answer: D QUESTION: 397
Which of the following are required to build a SQLScript calculation view? Note: There are multiple correct answers to the question
A. Define a data foundation B. Define a measure
C. Set the Multi-dimensional Reporting property to false D. Add columns to the var_out output parameter
Answer: B, D QUESTION: 398
A company needs to load external data from a flat file into SAP HANA. How can you do this? Note: There are multiple correct answers to the question
A. SAP HANA Direct Extractor Connection (DXC) B. SAP System Landscape Transformation (SLT) C. SAP HANA SQL Import statement
D. SAP BusinessObjects Data Services Answer: C, D
QUESTION: 399
How can you create a computed column in an information model? Note: There are multiple correct answers to the question
A. Create a calculated attribute within a calculation view B. Create a counter in an analytic view
