SSIRS

by Prasad Gavande

HTML

QUESTION NUMBER 	ANSWER
1	B
2	A
3	B
4	B
5	D
6	A
7	D
8	A
9	D
10	C
11	C
12	A
13	A
14	B
15	A
16	A
17	D
18	C
19	B
20	A
21	B
22	B
23	D
24	D
25	A
26	A
27	A
28	A
29	A
30	C
31	B
32	D
33	A
34	A
35	B
36	D
37	A
38	B
39	C
40	A
41	A
42	A
43	A
44	A
45	B
46	A
47	A
48	B
49	B
50	C

JavaScript

MSBI GT EXAM 2016

1. IS CONTROL FLOW  PART OF A DATA  FLOW?

       A. YES                         B. NO

       C. CAN'T SAY             D. NONE OF ABOVE

2. WHEN YOU RUN PACKAGE FOR EVERY TIME HOW DO YOU DELETE DATA

    FROM  TABLE BEFORE EXECUTION?


       A. BY USING EXECUTE SQL TASK                          B. DATA FLOW TASK

       C. CONDITIONAL SPLIT                                             D. NONE OF ABOVE

3.  TO RUN LOOP CONTINUOUSLY WHEN YOU DONT KNOW

    NUMBER OF ITIRATIONS THEN TO DO THIS OPERATION WHICH TASK IS 

    REQUIRED   TO USE  ?


       A. BY USING FOR LOOP                          B.  BY USING FOREACH  LOOP

       C. BOTH A  AND B                                     D. NONE OF ABOVE


4. BY USING WHICH TRANSFORMATION WE CAN EXECUTE DATA FLOW TASKS

    ORDER WISE ?


       A. BY USING FOR LOOP                          B.  BY USING SEQUNCE CONTAINER

       C. BOTH A  AND B                                     D. NONE OF ABOVE


5. LIST OUT COMPONENTS OF DATA FLOW TASK ?


       A. SOURCE                                                  B. DESTINATION  

       C. BOTH A  AND B                                     D.  OPTION C AND TRANSORMATION

6. WHICH ONE IS NOT PART OF SSIS DEFAULT PACKAGE DESIGNER?


       A. LOGGING                                                     B. CONTROL FLOW  

      C. EVENT HANDLERS                                     D.  BOTH  OPTIONS A  AND C
7. HOW TO INSERT DATA INTO DESTINATION  FROM MORE THAN 2 SOURCES ?


       A.  MERGE TRANSFORMATION              B. MERGE JOIN TRANSFORMATION  

      C. BOTH A  AND B                                      D. UNION ALL TRANSFORMATION


8. THERE IS SCENARIO THAT ACCORDING TO EMPLOYEE SALARY EMPLOYEE
    DETAILS HAS TO GO TO RELEVANT TABLE LIKE IF EMPLOYEE SALARY IS    
    LESS THAN ONE LAKH IT HAS TO GO TO 1ST TABLE AND MORE THAN ONE    
    LAKH AND LESS THAN 10 LAKHS  HAS TO GO TO 2ND TABLE AND REST 
    SHOULD BE IN 3RD TABLE , SO BY USING WHICH...