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
Pa
g
e
4
6
D. Create a restricted measure in an analytic view Answer: A, D
QUESTION: 400
You have loaded data into SAP HANA using SAP BusinessObjects Data Services. Where can you view that data? Note: There are multiple correct answers to the question
A. In the Catalog node of SAP HANA studio
B. In the SAP BusinessObjects Data Services job monitor C. In the Content node of SAP HANA studio
D. In the SAP BusinessObjects Data Services table preview Answer: A, D
QUESTION: 401
What are benefits of using an SAP BusinessObjects business layer on top of SAP HANA? Note: There are multiple correct answers to the question
A. Business layers can be exported to the SAP BusinessObjects repository and be used by SAP BusinessObjects client tools
B. Reporting users can change replication settings in the business layer to access more data C. Business layers can be exported to an SAP HANA database and be used for modeling D. Reporting users can create individual reports based on separate information models using one business layer
Answer: A, D QUESTION: 402
What must you configure to directly access an SAP HANA analytic view using SAP BusinessObjects Analysis edition for Microsoft Office?
A. RFC connection
B. SAP HANA Direct Extractor Connection (DXC) C. Pre-delivered MODELING role
D. System DSN Answer: D QUESTION: 403
What is the purpose of a template table in SAP BusinessObjects Data Services? A. To create pre-designed information models
B. To fill an existing target table with new data
C. To read source data and perform data transformations D. To create a target table and fill this table with data Answer: D
QUESTION: 404
Pa
g
e
4
7
Which of the following tasks must you perform before you publish a universe within the SAP BusinessObjects Information Design Tool (IDT) on top of SAP HANA?
Note: There are multiple correct answers to the question A. Add the INFORMATION_CONSUMER role to the user B. Add dimensions and measures to the business layer C. Add information models to the data foundation D. Add an information space to the business layer Answer: B, C
QUESTION: 405
You define a measure CURR_CONV to perform a currency conversion in an analytic view. When you query the analytic view it fails with a currency/unit conversion error message. What can you do to ensure that the query runs without error message?
Note: There are multiple correct answers to the question
A. Maintain valid conversion rate entries in TCUR tables
B. Set the Upon conversion failure parameter of CURR_CONV to Ignore C. Remove the Target Currency property in CURR_CONV
D. Unselect the Enable for decimal shifts property in CURR_CONV Answer: A, B
QUESTION: 406
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? A. In the Authorization schema
B. In the Authoring schema C. In the _SYS_BI schema D. In the Physical schema Answer: D
QUESTION: 407
An SAP BusinessObjects Web Intelligence report throws an SQL error during query execution. Which of the following could you check to resolve the error?
Note: There are multiple correct answers to the question A. The business layer
B. The business view
C. The Web Intelligence report variables D. The SAP HANA information model Answer: A, D
Pa
g
e
4
8
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 Answer: C
QUESTION: 409
Which of the following are characteristics of using a Rapid Deployment Solution (RDS), such as Operational Reporting for SAP HANA?
Note: There are multiple correct answers to the question 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 Answer: A, D
QUESTION: 410
Which tasks do you have to perform if you want to use SAP BW with SAP HANA as the underlying database? Note: There are multiple correct answers to the question
A. Install SAP Business Warehouse Accelerator (BWA)
B. Perform a database migration from your current DB to SAP HANA DB C. Execute the report RS_BW_POST_MIGRATION
D. Upgrade to at least SAP NetWeaver Business Warehouse 7.30 SP5 E. Recreate SAP BW indexes after SAP HANA database migration Answer: B, C, D