SAP IDT Online Quiz


Advertisements

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.

Questions and Answers

Q 1 - Which of the following connection should be used to create a Universe to be published to resource repository?

A - .cns

B - .cnx

C - .dfx

D - .blx

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?

A - True

B - False

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?

A - Join

B - Cardinality

C - Expression

D - Aliases

Answer : B

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?

A - Alias Table

B - Derived Table

C - Context

D - Joins

Answer : C

Explanation

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

B - DW based on Inmom model with data marts design

C - Both of these

D - None of these

Answer : B

Q 6 - In Dashboard designer, which of the following is a part of component browser?

A - Category

B - List

C - Tree

D - All of the above

Answer : D

Q 7 - Which of the following component feature allows users to pick different options at run time?

A - Container Component

B - Tab Set

C - Selector Component

D - Single Value component

E - None

Answer : C

Explanation

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?

A - Label

B - Input text

C - Map

D - None

Answer : B

Explanation

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?

A - Desktop (flash)

B - Mobile (fit to screen)

C - Mobile (Original Size)

D - Tablet (Fit to screen)

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?

A - True

B - False

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

sap_idt_questions_answers.htm
Advertisements