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 create multilingual Universe in Information Design tool, which of the following option should be used to determine language of metadata in query panel?

A - Business Layer Editor

B - Check Integrity

C - Repository Resources

D - Show Values

E - Preferred Viewing locale

Answer : E

Explanation

Go to Information Design Tool → Preferences → Data Foundation Editor → Preferred Viewing Locale determines the language of the metadata and data in the Query Panel.

Q 3 - Which of the following pane in Data Foundation editor allows you to create Aliases and Contexts, LOV’s and parameters?

A - View Pane

B - Properties Pane

C - Browsing Pane

D - All of the above

Answer : C

Explanation

Using browsing pane, you can work on different elements in data foundation like connections, Data Foundation, Aliases and Contexts, LOV’s and parameters.

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 - Auto hide feature is used to automatically hide the panels when they are not in use. This function is available for which of the following components?

A - Property

B - Object Browser

C - Component Browser

D - Query Browser

E - All of the above

Answer : E

Explanation

This auto hide feature is used to automatically hide the panels when they are not in used. This function is available for below components −

  • Property
  • Object Browser
  • Component Browser
  • Query Browser

Q 7 - You want to specify currency symbol to show before the value, which of the following component property should be used?

A - General

B - Behavior

C - Appearance

D - Alerts

Answer : C

Explanation

Go to Properties → Appearance → Text

Q 8 - Which of the following can be used to add user interactivity and output element is used to display value of cells?

A - Container Component

B - Tab Set

C - Selector Component

D - Single Value Component

Answer : D

Explanation

Single value components are used for adding interactivity to data models. You can use them to add more attention to important parameters.

Single value components can be used in different styles −

  • Horizontal Progress Bar
  • Vertical Progress Bar
  • Dual Slider
  • Dual Slider 2
  • Dial and many more

Q 9 - What is the maximum number of rows that you can embed to a spreadsheet to use as component binding?

A - 256

B - 512

C - 1024

Answer : B

Explanation

You can select a maximum range of 512 rows in range. Larger the value slower the performance of data model. To change this value, go to File → Preferences → Excel Options.

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