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 option can be used if you want to transform table and column name to user friendly names?

A - Appearance

B - Check Integrity

C - Data Foundation Editor

D - Business Layer Editor

Answer : D

Q 2 - To use .unv Universes in IDT, you first need to convert them. Which of the following can be converted in Information Design Tool?

A - Relational Universes created using SAP BusinessObjects 4 UDT tool or Desktop edition

B - Relational Universes designed in SAP BusinessObjects Enterprise XI3 design tool

C - Both of the above

D - None

Answer : C

Explanation

To use .unv Universes in IDT, you first need to convert them. You can convert below unv Universes in Information Design Tool −

Relational Universes created using SAP BusinessObjects 4 UDT tool or Desktop edition.

Relational Universes designed in SAP BusinessObjects Enterprise XI3 design tool.

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 improve the query performance and query generator retrieves the data from table with highest aggregation level?

A - Context

B - Aggregate Awareness

C - Alias

D - Derived table

Answer : B

Explanation

Using aggregate awareness, you can use pre-aggregated data in tables in the database. It is used to improve query performance by processing less number of rows.

When you add an aggregate aware object in query, query generator retrieves the data from table with highest aggregation level.

Q 5 - In IDT Security editor, which of the following security profile-security policy is applied on Data Foundation objects and connections?

A - Business Security Profile

B - Data Security Profile

C - Object Security Profile

D - None of these

Answer : B

Explanation

You can define two types of security profiles in IDT −

Data Security Profile

In data security profile, security policy is applied on Data Foundation objects and connections.

Business Security Profile

This include objects in Business layer on which security profile is applied.

Q 6 - In SAP Dashboard, which of the following is not a format type to export under Export toolbar?

A - PDF

B - MS Word

C - Power Point

D - Text File

Answer : D

Explanation

Export Toolbar

It contains button for exporting your model to different formats.

Different Formats

Q 7 - Bar and Column charts are used to compare one or more items over specific period of time. Bar and column charts are same and only difference is orientation?

A - True

B - False

Answer : A

Q 8 - Which of the following is not a template category under Files → Templates in Dashboard designer?

A - Government

B - HR

C - Sales

D - Operations

E - Layout

Answer : D

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 - You want to insert huge amount of data in spreadsheet in Dashboard designer. Which of the following option you should use to make it performance optimized and use large dataset?

A - Avoid using Macros

B - Avoid using Excel Function formulas

C - Create Multiple tabs

D - All of the above

Answer : C

Explanation

In case you have large amount of data in spreadsheet, you can create multiple tabs.

sap_idt_questions_answers.htm
Advertisements