- SAP IDT Tutorial
- SAP IDT – Home
- SAP IDT – Overview & User Interface
- SAP IDT – Resources
- SAP IDT – Creating Universe
- SAP IDT – .unv Universe Introduction
- Dealing With Published Universes
- SAP IDT – Projects
- SAP IDT – Managing Connections
- Managing Resources In Repository
- SAP IDT – Data Foundation Layer
- SAP IDT – Building Data Foundation
- SAP IDT – Qualifiers & Owners
- SAP IDT – Joins In Data Foundation
- SAP IDT – Business Layer
- SAP IDT – Business Layer Properties
- SAP IDT – Folders In Business Layer
- SAP IDT – Business Layer View
- Building Query In Query Panel
- Dependency Among Resources
- SAP IDT – Publishing
- SAP IDT – Security
- Running Query Published Universe
- SAP IDT – Format Editor Overview
- SAP IDT Useful Resources
- SAP IDT - Questions Answers
- SAP IDT - Quick Guide
- SAP IDT - Useful Resources
- SAP IDT - Discussion
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.
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?
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 create multilingual Universe in Information Design tool, which of the following option should be used to determine language of metadata in query panel?
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?
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?
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 - To define Query limit options in Business layer, which of the following option you should use?
Answer : B
Explanation
Query Options −
This defines query execution properties - limit number of rows, number of minutes to limit the time passed for query execution, etc.
Q 6 - To use same font for all the components, which of the following font type should be selected under document properties?
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 can’t rotate text. When embedded fonts are used, you can rotate text and file size is large.
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?
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 - Which of the following is not a template category under Files → Templates in Dashboard designer?
Answer : D
Q 9 - In your data model, you can link your components to cells in the spreadsheet. Which of the following is incorrect about inserting data in spreadsheet in Dashboard?
A - You can copy paste data from other excel spreadsheet to embedded spreadsheet.
B - You can import a spreadsheet from excel.
C - You can manually enter data in spreadsheet.
D - You can link query objects from a BEX or Universe query to cells in embedded spreadsheet.
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 - Using ignore excel formula error options, you can make cells that contain invalid excel formulas as empty cells under Excel option?