Are you ready for SAP HANA Certification? Find out Today

Test your skills by taking this questionnaire and to figure out if you are ready to get trained and certified in SAP HANA

1. Which of the following nodes can you use when you create a calculation view with the SAP HANA studio graphical interface? (Choose two)
a. Data Foundation
b. Aggregation
c. Join
d. Analytic Privilege

2. When 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.

3. Which of the following can be part of an analytic view? (Choose three)
a. Query transformation
b. Unions
c. Logical joins
d. Data foundation E. Attributes

4. 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)

5. You are experiencing performance problems with SAP BusinessObjects reports based on SAP HANA data. Which of the following can you do to increase performance? (Choose two)
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.

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

7. You create a business layer in the SAP BusinessObjects Information Design Tool (IDT). Which of the following could you add to the data foundation? (Choose two)
a. Packages
b. Column Tables
c. Synonyms
d. Information Models

Learn SAP HANA from Industry Experts

8. 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.

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

10. Which data provisioning method can you use to load data from SAP business content DataSources into SAP HANA? (Choose two)
a. SAP Landscape Transformation (SLT)
b. SAP Landscape Directory (SLD)
c. SAP Direct Extractor Connection (DXC)
d. SAP BusinessObjects Data Services

11. 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

12. Which of the following can you use as a source for a graphical calculation view? (Choose three)
a. Calculation view
b. SQL view
c. Decision table
d. Table E. Procedure

13. Which of the following can you check to investigate the query time in SAP HANA? (Choose three)
a. The SQL plan cache
b. The Central Management Console
c. The expensive statements trace
d. The statistics server warning for long running statements E. The System information tab of the Administration console

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

Register for live webinar on SAP HANA by Industry Experts

15. Which of the following can you set up to enable the extraction of data from SAP Business Warehouse (BW) into SAP HANA? (Choose three)
a. SAP System Landscape Directory (SLD)
b. SAP BusinessObjects Data Services
c. SAP Landscape Transformation (SLT)

16. Which of the following does an SAP BusinessObjects universe use to communicate with SAP HANA?
a. ABAP
b. SQL
c. MDX
d. BICS

17. Which of the following must you do in order to use SAP BusinessObjects Explorer on SAP HANA data? (Choose two)
a. Create a delivery unit.
b. Create a business layer.
c. Create an information model.
d. Create an information space.

18. 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

19. Which of the following automatically aggregates data? (Choose two)
a. Analytic view
b. Calculation view
c. Column table
d. Attribute view

20. 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

Click here to Download the Answers