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?
.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?
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?
Q 4 - Which of the following can be used to break the loops in Data Foundation when you are not able break loop using an Alias table?
Context are also used to break the loops in Data Foundation when you are not able to break loop using an Alias table.
When you have multiple fact tables that are connected to a single dimension table, you create a Context for each fact table in this case.
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
Q 6 - In Dashboard designer, which of the following is a part of component browser?
Q 7 - Which of the following component feature allows users to pick different options at run time?
Selector component allows users to pick different options at run time. Selector can be used to configure item’s row, value, position and label into embedded spreadsheet.
Q 8 - Which of the following text component type allows you to add comments-explanation, help in a Dashboard?
Label component allows you to add comments - explanation, help, etc.
Q 9 - Which of the following preview options is/are not available under SAP Dashboard?
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?
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