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 option can be used if you want to transform table and column name to user friendly names?
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?
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?
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?
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?
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?
This auto hide feature is used to automatically hide the panels when they are not in used. This function is available for below components −
Q 7 - You want to specify currency symbol to show before the value, which of the following component property should be used?
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?
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 −
Q 9 - What is the maximum number of rows that you can embed to a spreadsheet to use as component binding?
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?
In case you have large amount of data in spreadsheet, you can create multiple tabs.