Practice Questions
These practice questions will help you evaluate your understanding of the topic. The questions shown are similar in nature to those found on the certification examination. Although none of these questions will be found on the exam itself, they will allow you to review your knowledge of the subject. Select the correct answers and then check the completeness of your answers in the Practice Question Answers and Explanations section. Remember that on the exam you must select all correct answers and only correct answers to receive credit for the question.
- Which of the following SAP data provisioning tools can provide real-time data provisioning? (There are 3 correct answers.)
A. SDI
B. SAP Data Services
C. SRS
D. DXC
E. SLT - What is the correct sequence for loading data with SAP Data Services?
A. Extract · Load · Transform
B. Load · Transform · Extract
C. Load · Extract · Transform
D. Extract · Transform · Load - You are loading data into SAP HANA using DXC. Which of the following are executed in the embedded SAP BW system? (There are 3 correct answers.)
A. InfoPackage
B. Transformation
C. Extractor
D. Activation
E. IMDSO - Which of the following database terms are used when providing OLAP data with hierarchies? (There are 3 correct answers.)
A. ODBC
B. ODBO
C. BICS
D. JDBC
E. MDX - Which of the following data provisioning tools can provide a delta load of a table from the source system?
A. SDS
B. SDA
C. DXC
D. Flat files - Which of the following data operations can you perform with SDA? (There are 3 correct answers.)
A. Data federation
B. Logical data warehouse
C. Physical data warehouse
D. Big data
E. Real-time replication - You get the following requirements from a customer: They have a lot of purchasing data in their SAP system which they wish to analyze in SAP HANA. They want to have reports every morning showing the total expenditure per department. Their SAP BW developers have not yet had any SAP HANA training. Which data provisioning tool would you recommend?
A. SLT
B. SDA
C. EIM
D. DXC - You want to pause the SLT replication in SAP HANA studio. What do you select to achieve this?
A. Quick View · Data Provisioning · Stop
B. Quick View · Import · Selected Import of Metadata
C. Quick View · Data Provisioning · Suspend
D. Quick View · Configure Import Server - Which programming language do you use for streaming projects?
A. CCL
B. JavaScript
C. SQL
D. SQLScript - You want to retrieve data from a web application. Which of the following could you use? (There are 3 correct answers.)
A. JSON
B. REST
C. JDBC
D. BICS
E. OData - True or False: SAP Data Services can read all the SAP extractors.
A. True
B. False - Why would you recommend SAP Replication Server?
A. If the data contains some rubbish information in several places.
B. If database administrators do not want triggers in their database.
C. If the data is financial ticker tape data.
D. If the source data is in a virtual table. - Which data provisioning tools can use SAP HANA adapters? (There are 2 correct answers.)
A. SDA
B. SDS
C. SDI
D. SRS - Which of the following data provisioning tools can you use to read data directly from Twitter? (There are 3 correct answers.)
A. SRS
B. SAP HANA XS engine
C. SAP Data Services
D. SDI
E. SDA