SAP IDT Online Quiz
Following quiz provides Multiple Choice Questions (MCQs) related to SAP IDT. You will have to read all the given answers and click over the correct answer. If you are not sure about the answer then you can check the answer using Show Answer button. You can use Next Quiz button to check new set of questions in the quiz.
Q 1 - Which of the following connection should be used to create a Universe to be published to resource repository?
Answer : A
Explanation
.cns - secured Repository connection
Q 2 - To build a Universe on ERP, you can create a Single source Data Foundation to support local connections but it doesn’t support Joins and calculated columns between tables inserted from an ERP connection?
Answer : A
Explanation
You can build a universe on SAP ERP by using Data Foundation in IDT. You have to create a Relational connection to ERP data source, Info sets, SAP Queries, and ABAP functions are treated as tables in the connection.
You can create a Single source Data Foundation to support local connections but it doesn’t support Joins and calculated columns between tables inserted from an ERP connection.
To use calculated column, Joins, you need to create a Data foundation that is multisourceenabled on a secured connection.
Q 3 - In IDT Data Foundation, each row in table 1 matches one or more rows in table 2 and this properties is defined under Join Editor as?
Answer : B
Q 4 - In IDT Data Foundation, to create a table with columns from other tables that includes complex calculations and function which of the following feature can be used?
Answer : B
Explanation
Derived table is a virtual table in the data foundation that combines other tables using calculations and functions.
Q 5 - To define Query limit options in Business layer, which of the following option you should use?
Answer : B
Explanation
Query Options −
This defines query execution properties - limit number of rows, number of minutes to limit the time passed for query execution, etc.
Q 6 - In Dashboard designer, which of the following is a part of component browser?
Answer : D
Q 7 - You want to specify currency symbol to show before the value, which of the following component property should be used?
Answer : C
Explanation
Go to Properties → Appearance → Text
Q 8 - Which of the following is not a template category under Files → Templates in Dashboard designer?
Answer : D
Q 9 - You can export models in Dashboard designer in different formats. When you complete the configuration of data model, it can be exported to flash file (SWF)?
Answer : A
Q 10 - Using ignore excel formula error options, you can make cells that contain invalid excel formulas as empty cells under Excel option?
