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 - When you perform project synchronization, synchronization status- A resource was changed in shared project but not in local project represents?
Answer : C
Explanation
Different Synchronization status −
- Added Locally − A resource is added in local project but not in shared project.
- Changed Locally − A resource was changed in local project but not in shared project.
- Deleted Locally −A resource was deleted in local project but still exists in shared project.
- Added on server − A resource is not in local project but exists in shared project.
- Changed on server − A resource was changed in shared project but not in local project.
- Deleted on server − A resource exists in local project but was deleted in shared project.
- Synchronize − Both resources are identical.
Q 4 - In Business Layer under IDT, which of the following state defines an object- not valid and hidden?
Answer : C
Explanation
An Object in Business Layer can have below three states −
Active −
This is default state of an object and objects are available in query panel.
Hidden −
These objects are valid but are hidden in query panel
Deprecated −
These objects are not valid and hidden.
Q 5 - In which of the following Data warehousing scenario’s, a fan trap normally doesn’t occur?
A - DW based on Kimball model with direct join on fact tables
Answer : B
Q 6 - In which of the component view, components are arranged in alphabetical order and are not grouped based on the category?
Answer : B
Explanation
In list view, components are arranged in alphabetical order and they are not grouped based on the category.
Q 7 - Which of the following property of a component is used to set the Blank cell, visibility, range limit, etc.?
Answer : B
Explanation
Behavior −
It is used to set behavior of component in the model - limits, Blank cell, visibility, etc.
Q 8 - Which of the following can be used to add user interactivity and output element is used to display value of cells?
Answer : D
Explanation
Single value components are used for adding interactivity to data models. You can use them to add more attention to important parameters.
Single value components can be used in different styles −
- Horizontal Progress Bar
- Vertical Progress Bar
- Dual Slider
- Dual Slider 2
- Dial and many more
Q 9 - Which of the following preview options is/are not available under SAP Dashboard?
Answer : D
Q 10 - Consider Reporting and Dashboard tools, Web Intelligence and Crystal Reports can hold huge data, but Dashboard can’t hold bulk data as at runtime it shows the performance?
Answer : A
Explanation
Dashboard holds some buffered data. The advantage of this feature is to avoid unnecessary hits to the server but sloe performance if data size is large
