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.

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 - You want to create a Relational connection in IDT that points to SAP HANA database, which of the following database middleware drivers you should select?

A - SAP ERP 6

B - MaxDB 7.7

C - SAP HANA database 1.0

D - mySAP ERP 2004

Answer : C

Q 3 - While defining a connection in IDT, which of the following is not an option under connection parameters?

A - Pool time Out

B - Array fetch size

C - Array Bind size

D - Login Timeout

E - Authentication Mode

Answer : E

Explanation

You can define connection parameters like - Time out, Array fetch size, Array Bind size, etc.

Q 4 - In IDT Data Foundation, to create a table with columns from other tables that includes complex calculations and function which of the following feature can be used?

A - Alias Table

B - Derived Table

C - Context

D - All of the above

Answer : B

Explanation

Derived table is a virtual table in the data foundation that combines other tables using calculations and functions.

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 - To use same font for all the components, which of the following font type should be selected under document properties?

A - Global Font

B - Device Font

C - Embedded Font

D - None of these

Answer : A

Explanation

Different fonts can be set for different components. There is an option to setup the global font if you want to use same font for all the components. This can be used on device fonts or on embedded fonts. When you use machine fonts, exported file is smaller and you cant rotate text. When embedded fonts are used, you can rotate text and file size is large.

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 items row, value, position and label into embedded spreadsheet.

Q 8 - Which of the following option allows user to select values from BEX or Universe at run time and user can select a single value to use as filter parameter or can choose selection objects?

A - Query Refresh

B - Query Prompt

C - Filters

D - Single Value Component

E - Selectors

Answer : B

Explanation

Query Prompt Selector

This allows user to select values from BEX or Universe query prompts at run time. As per prompt type, user can select a single value to use as filter parameter or can choose selection objects.

To add a query prompt, you can add it from components list and select a source query prompt or preconfigured query prompt by dragging a query prompt to canvas.

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