Skip to contentSkip to footer

Msbi Developer Interview Questions

Salaries
Interviews

78 msbi developer interview questions shared by candidates

1) What is control flow 2) What is data flow 3) Explain multicast 4) What is checkpoint 5) What is transactions 6) How to get count in the table 7) How to debug the script task -> mentioned breakpoints 8) Do you know deployment 9) How to backup the ssis package 10) What is manifest file -> created at the tme of deployement 11) What is subquery -> A subquery is a query that is nested inside a SELECT , INSERT , UPDATE , or DELETE statement, or inside another subquery. A subquery can be used anywhere an expression is allowed. 12) What is circular reference /deadlock A circular reference is a recursive condition in which one table references a second table, which in turn references the first table. Troubleshoot deadlock 13) What is serialization and deserialization Serialization is the process of converting an object into a stream of bytes to store the object or transmit it to memory, a database, or a file. Its main purpose is to save the state of an object in order to be able to recreate it when needed. The reverse process is called deserialization. 14) What is public and static All these keywords are part of the main method of any C# program. ... public − This is the access specifier that states that the method can be accesses publically. static − Here, the object is not required to access static members. void − This states that the method doesn't return any value. 15) What types of variable types in SSIS string bollen int 32 int64 16) https://www.red-gate.com/simple-talk/sql/ssis/ssis-basics-introducing-variables/ 17) Normalization and denormalization 18) Normalization is used to remove redundant data from the database and to store non-redundant and consistent data into it. Denormalization is used to combine multiple table data into one so that it can be queried quickly. ... Denormalization does not maintain any data integrity. Normalization is the technique of dividing the data into multiple tables to reduce data redundancy and inconsistency and to achieve data integrity. ... In contrast, denormalization reduces the number of tables and join. Disk space is wasted in denormalization because same data is stored in different places. 19) What are DB constraints a. Primary key, foreign key, unique, check , default 20) What sources have you used in DFT Second Round was managerial. It was pretty easy. Tell me about experience and complex scenario you worked on. Handle team and size of team. What is estimation and how you can provide?
avatar

MSBI Developer

Interviewed at Infosys

3.6★
Jul 5, 2020

1) What is control flow 2) What is data flow 3) Explain multicast 4) What is checkpoint 5) What is transactions 6) How to get count in the table 7) How to debug the script task -> mentioned breakpoints 8) Do you know deployment 9) How to backup the ssis package 10) What is manifest file -> created at the tme of deployement 11) What is subquery -> A subquery is a query that is nested inside a SELECT , INSERT , UPDATE , or DELETE statement, or inside another subquery. A subquery can be used anywhere an expression is allowed. 12) What is circular reference /deadlock A circular reference is a recursive condition in which one table references a second table, which in turn references the first table. Troubleshoot deadlock 13) What is serialization and deserialization Serialization is the process of converting an object into a stream of bytes to store the object or transmit it to memory, a database, or a file. Its main purpose is to save the state of an object in order to be able to recreate it when needed. The reverse process is called deserialization. 14) What is public and static All these keywords are part of the main method of any C# program. ... public − This is the access specifier that states that the method can be accesses publically. static − Here, the object is not required to access static members. void − This states that the method doesn't return any value. 15) What types of variable types in SSIS string bollen int 32 int64 16) https://www.red-gate.com/simple-talk/sql/ssis/ssis-basics-introducing-variables/ 17) Normalization and denormalization 18) Normalization is used to remove redundant data from the database and to store non-redundant and consistent data into it. Denormalization is used to combine multiple table data into one so that it can be queried quickly. ... Denormalization does not maintain any data integrity. Normalization is the technique of dividing the data into multiple tables to reduce data redundancy and inconsistency and to achieve data integrity. ... In contrast, denormalization reduces the number of tables and join. Disk space is wasted in denormalization because same data is stored in different places. 19) What are DB constraints a. Primary key, foreign key, unique, check , default 20) What sources have you used in DFT Second Round was managerial. It was pretty easy. Tell me about experience and complex scenario you worked on. Handle team and size of team. What is estimation and how you can provide?

Viewing 31 - 40 interview questions

Glassdoor has 78 interview questions and reports from Msbi developer interviews. Prepare for your interview. Get hired. Love your job.