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?
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?
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 - To connect to SAP NetWeaver BW, Which of the following middleware should be used to provide access to BEx query?
BICS client −
To connect to SAP NetWeaver BW, you can use SAP BICS client middleware to provide access to BEx query.
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?
Derived table is a virtual table in the data foundation that combines other tables using calculations and functions.
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 is not a template category under Files → Templates in Dashboard designer?
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 - Using ignore excel formula error options, you can make cells that contain invalid excel formulas as empty cells under Excel option?