C_HANAIMP_1 SAP HANA Certified Application Associate Exam Set 5

When you load data from SAP ECC using SAP BusinessObjects Data Services, where would youcreate an ABAP data flow?


Options are :

  • in a batch job
  • in the Job overview (transaction SM37)
  • in a query transformation
  • in the ABAP editor (transaction SE38)
  • None

Answer : in a batch job

When you activate a procedure, in which schema is the procedure stored?


Options are :

  • _SYS_BI
  • _SYS_BIC
  • SYS_REPL
  • SYSTEM

Answer : _SYS_BIC

You have an SAP HANA productive system with sensitive data.How can you restrict modelingusers from viewing this data? (Choose two)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 tothe productive system.D. Remove SAP_DATA_ADMIN in the SQL privileges for the modeling users.


Options are :

  • B,A
  • D,C
  • B,C
  • B,D

Answer : B,C

Which technologies use trigger-based replication? (Choose two)A. ABAP extractorsB. Test Data Migration Server (TDMS)C. Standard SQL database replicationD. Near Zero Downtime


Options are :

  • B,C
  • B,A
  • B,D
  • A,D

Answer : B,D

C_SM100_718 SAP Solution Manager Certified Technology Exam Set 1

Your customer wants to use SAP BusinessObjects Data Services to migrate and transform largevolumes of data to SAP HANA. What do you recommend?


Options are :

  • Use RFC/BAPI function calls.
  • Use the RFC_READ_TABLE.
  • Use IDOCs.
  • Use ABAP data flows.

Answer : Use ABAP data flows.

Which SAP BusinessObjects tools require an SAP BusinessObjects semantic layer (universe) toaccess data in SAP HANA? (Choose three)A. Crystal Reports 2011B. Crystal Reports for EnterpriseC. DashboardsD. Analysis Office v1.1E. WebIntelligence


Options are :

  • D,C,E
  • B,C,A
  • B,C,A
  • B,C,E

Answer : B,C,E

You model hierarchies in attribute views. Which of the following technologies do you use to makethese hierarchies available for reporting tools?


Options are :

  • ODBC
  • ODBO
  • BICS
  • JDBC

Answer : ODBO

C_BODI_20 SAP Business Objects Data Integrator XI R2 Test Set 1

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? (Choose three)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.


Options are :

  • B,C,E
  • D,C,E
  • B,C,A
  • B,D,E

Answer : B,C,E

Which of the following privileges do you need to activate views?


Options are :

  • SELECT option on the _SYS_REPO schema
  • SELECT option on the _SYS_BI schema
  • SELECT option on the _SYS schema
  • SELECT option on the _SYS_BIC schema

Answer : SELECT option on the _SYS_REPO schema

C_BODI_20 SAP Business Objects Data Integrator XI R2 Test Set 2

What are the advantages of using SAP BusinessObjects Data Services to load data into SAPHANA? (Choose three)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.


Options are :

  • A,B,C
  • A,C,E
  • C,B,E
  • A,B,E

Answer : A,B,E

When must you create a calculation view in SAP HANA? (Choose two)A. When you need to perform join operations.B. When you need calculations before aggregations.C. When key figures span across tables.D. When you need to perform a union of base tables.


Options are :

  • C,B
  • B,D
  • C,A
  • C,D

Answer : C,D

You created a model on a table XYZ.PRODUCTS. You successfully activated the model. Whenyou run the data preview you receive an error message "Insufficient privilege. Not authorized".Which of the following 4 statements do you execute to resolve the error before you reactivate themodel?


Options are :

  • GRANT SELECT on SCHEMA XYZ to _SYS_REPO
  • GRANT SELECT on PRODUCTS to _SYS_BIC
  • GRANT SELECT on SCHEMA XYZ to _SYS_BIC WITH GRANT OPTION
  • GRANT SELECT on PRODUCTS to _SYS_REPO WITH GRANT OPTION

Answer : GRANT SELECT on PRODUCTS to _SYS_REPO WITH GRANT OPTION

C_BODI_20 SAP Business Objects Data Integrator XI R2 Test Set 3

What is the purpose of the savepoint process in SAP HANA?


Options are :

  • Free-up memory by saving less used data to the persistent storage.
  • Save changed data to the persistent storage when a transaction is committed
  • Save logs to persistent storage when a transaction is committed
  • Save changed data and logs to the persistent storage on a regular basis

Answer : Save changed data and logs to the persistent storage on a regular basis

A calculation view that joins one fact table with dimension tables performs slowly.Which of the following can you do to improve performance?


Options are :

  • Load the calculation view into the _SYS_BI schema.
  • Load the calculation view into memory.
  • Turn the calculation view into a simple calculation view.
  • Turn the calculation view into an analytic view

Answer : Turn the calculation view into an analytic view

Which SAP BusinessObjects tool do you use to visualize real-time key performance indicators withsimu-lations?


Options are :

  • Analysis, edition for OLAP
  • Dashboards
  • Explorer
  • Web Intelligence

Answer : Dashboards

C_BODI_20 SAP Business Objects Data Integrator XI R2 Test Set 4

For what purpose do you use SQL Script in SAP HAN? (Choose two)A. To transfer a large amount of data between enginesB. To achieve very high performance on SELECT statementsC. To combine two analytic viewsD. To create database proceduresE. To shift complex calculations and logic to the client side


Options are :

  • B,D
  • C,D
  • C,A
  • C,B

Answer : C,D

What are benefits of using a business layer on top of SAP HANA? (Choose two)A. An extra layer of granular securityB. Improved database calculation speedC. Fast throughput via BICS connectivityD. Users can use business names instead of technical names


Options are :

  • A,C
  • B,D
  • A,D
  • A,B

Answer : A,D

Which of the following are functions of the DB trigger within SAP Landscape Transformation(SLT)? (Choose two)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.


Options are :

  • B,D
  • B,C
  • B,A
  • D,C

Answer : B,C

How can you evaluate the speed of a calculation within the database? (Choose two)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.C. Execute an information space using SAP BusinessObjects Explorer.D. Write and execute an appropriate SQL statement.


Options are :

  • A,D
  • A,B
  • B,D
  • A,C

Answer : A,D

When building a business layer to report on SAP HANA, what do you have to do if you want todisplay more than 5,000 rows?


Options are :

  • Deactivate the Limit Size of Result Set parameter in the business layer.
  • Deactivate the Limit Size of Result Set parameter in the Central Management Console.
  • Set the Array Fetch Size parameter to the maximum in the relational connection.
  • Remove all filters from the analytic views.

Answer : Deactivate the Limit Size of Result Set parameter in the business layer.

Where does SAP recommend you create calculated measures?


Options are :

  • In an analytic view
  • In an attribute view
  • In a column view
  • In a business layer

Answer : In an analytic view

C_BODI_20 SAP Certified Application Associate SAP BO Test Set 1

What outputs can you create in an attribute view? (Choose two)A. Key AttributesB. Calculated AttributesC. Restricted MeasuresD. Calculated MeasuresE. Private Attributes


Options are :

  • A,D
  • A,C
  • C,B
  • A,B

Answer : A,B

You are running an SAP BusinessObjects WebIntelligence report that fetches data from SAPHANA. Which components will be used inside SAP HANA for providing data to this report?(Choose two)A. Persistence LayerB. MDXC. Session ManagementD. Authorization Manager


Options are :

  • C,B
  • A,D
  • C,D
  • C,A

Answer : C,D

Which of the following are direct outputs of an analytic view? (Choose three)A. HierarchiesB. Private attributesC. Restricted attributesD. MeasuresE. Attribute views


Options are :

  • B,D,E
  • B,D,C
  • B,A,E
  • A,D,C

Answer : B,D,E

C_BODI_20 SAP Certified Application Associate SAP BO Test Set 2

In SAP ERP there are more than 50,000 application tables. How do you determine the relevantSAP ERP tables to replicate in SAP HANA and their dependencies?


Options are :

  • Use the SAP ERP Tables and Indexes Monitor(transaction DB02).
  • Use SAP ERP Data Browser (transaction SE16).
  • Use SAP ERP ABAP Dictionary Maintenance (transaction SE11).
  • Use SAP ERP Data Modeler (transaction SD11).

Answer : Use SAP ERP Data Modeler (transaction SD11).

What is one of the advantages of using SAP BusinessObjects Analysis, edition for MicrosoftOffice?


Options are :

  • Direct connection to SAP HANA via MDX
  • Direct access to column tables in SAP HANA
  • Direct access to attribute views in SAP HANA
  • Direct connection to SAP HANA via BICS

Answer : Direct connection to SAP HANA via BICS

Which connectivity combination between MS Excel and SAP HANA provides multidimensionalreporting capabilities?


Options are :

  • ODBO connector via MDX requests to column tables
  • ODBC connector via MDX requests to analytic or calculation views
  • ODBO connector via SQL requests to analytic or calculation views
  • ODBO connector via MDX requests to analytic or calculation views

Answer : ODBO connector via MDX requests to analytic or calculation views

C_BODI_20 SAP Certified Application Associate SAP BO Test Set 3

Which of the following sequences of steps is used to implement SAP HANA with SAP ERP?


Options are :

  • Data Provisioning ? SAP HANA system setup ? Modeling ? Consumption
  • SAP HANA system setup ? Data Provisioning ? Modeling ? Consumption
  • SAP HANA system setup ? Data Provisioning ? Consumption ? Modeling
  • SAP HANA system setup ? Modeling ? Data Provisioning ? Consumption

Answer : SAP HANA system setup ? Data Provisioning ? Modeling ? Consumption

Which reporting tool can you use to display native parent-child hierarchies from SAP HANA?


Options are :

  • SAP BusinessObjects Analysis, edition for Microsoft Office
  • SAP BusinessObjects Analysis, edition for OLAP
  • SAP BusinessObjects WebIntelligence
  • Microsoft Excel

Answer : Microsoft Excel

Which of the following are benefits of implementing SAP HANA? (Choose three)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.


Options are :

  • A,B,D
  • E,B,D
  • A,B,C
  • A,C,D

Answer : A,B,D

C_BODI_20 SAP Certified Application Associate SAP BO Test Set 4

Which of the following properties of a derived attribute view can you modify?


Options are :

  • Filters
  • Description
  • Calculated attributes
  • Description mapping

Answer : Description

You want to design a model in SAP HANA. Which of the following modeling constructs do you useto create an analytic view? (Choose three)A. Join typesB. Attribute viewsC. User privilegesD. TablesE. Analytic views


Options are :

  • A,B,C
  • A,C,E
  • A,B,D
  • A,E,D

Answer : A,B,D

You have a Web Intelligence report that requires data from SAP HANA filtered for a specific year.Where do you apply the filter for optimal performance?


Options are :

  • In the universe
  • In the Web Intelligence rep
  • In the Web Intelligence rep
  • In the calculation view using an attribute value variable

Answer : In the Web Intelligence rep

C_BODI_20 SAP Certified Application Associate SAP BO Test Set 5

You want to report on data from SAP HANA using MS Excel. How can you achieve this? (Choosetwo)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.


Options are :

  • A,B
  • A,D
  • B,D
  • A,C

Answer : A,D

In a reporting scenario you use an Opening Date attribute in the data foundation that containsinformation about your stores. You want to determine the number of years each store has been inbusiness. How do you achieve this?


Options are :

  • Use calculated measures
  • Use calculated attributes
  • Use private attributes
  • Use time attributes.

Answer : Use calculated attributes

Which of the following are benefits of using accelerators with SAP HANA? (Choose two)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.


Options are :

  • A,D
  • A,C
  • B,C
  • A,B

Answer : A,C

C_BOE_30 SAP BO Enterprise Certified Application Associate Set 1

You want to use an extractor to build a model in SAP HANA. Which table can you use to viewdetailed information about the extractor?


Options are :

  • ROOSOURCE
  • RSOLTPSOURCE
  • RODELTAM
  • BSEG

Answer : ROOSOURCE

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions