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 allows you to create a data model as multisource enabled that extracts data from one or more data sources using multiple connections?

A - IDT

B - UDT

C - CMC

D - Explorer

Answer : A

Explanation

IDT is multi source enabled means you can extract the data from different data sources while creating a Universe.

Q 2 - To design a Universe on SAP BW, you should use a data foundation based on single source enabled structure. All the tables and Joins in SAP BW are automatically imported to Data Foundation?

A - True

B - False

Answer : B

Explanation

If you want to use SAP BW to design a Universe, you should use a data foundation based on multi source enabled structure. All the tables and Joins in SAP BW are automatically imported to Data Foundation. When a Business Layer is created on Data Foundation, all objects are automatically moved to Business Layer.

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 - In Business Layer under IDT, which of the following state defines an object- not valid and hidden?

A - Active

B - Hidden

C - Deprecated

D - Invalid

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 SAP Business Objects, a derived table is present at Universe level, a view is created at data base level. View is preferred over Derived tables to perform calculations?

A - True

B - False

Answer : A

Explanation

In normal scenario, views are preferred to perform the calculation to remain on the database and it does not load the BO server.

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 - To set the notifications for data values, values are acceptable or require attention for a Dashboard component, which of the following component property has to be set?

A - General

B - Behavior

C - Appearance

D - Alerts

Answer : D

Explanation

Alerts are used to set notifications for data values, if values are acceptable or require attention. To enable alerts, click the check box.

You can set Alert Thresholds, enable auto color, etc.

Q 8 - In SAP Dashboards, you can apply same layout, appearance and formatting to data models when you need all models with same look?

A - True

B - False

Answer : A

Explanation

Using themes, you can apply same layout, appearance and formatting to data models when you need all models with same look. Theme provides you with a color scheme but you can customize it as per requirement.

To apply a theme, go to Format → Theme

Answer : E

Explanation

In your data model, you can link your components to cells in the spreadsheet. It support many features that are supported by Excel files however few of functions like Macros, conditional formatting and function formulas, etc. are not supported.

You can insert data in spreadsheets using different ways

  • You can copy paste data from other excel spreadsheet to embedded spreadsheet.

  • You can import a spreadsheet from excel.

  • You can manually enter data in spreadsheet.

  • You can link query objects from a BEX or Universe query to cells in embedded spreadsheet.

Q 10 - You want to import data from WebI or a Crystal Report to Dashboard. Which of the following support this feature?

A - Explorer

B - BICS

C - Live Office

D - IDT

Answer : C


sap_idt_questions_answers.htm

Advertisements