MSBI Online free model Tests

Thank you very much for taking test

Test your caliber

1. What is the difference between UNION and UNION ALL?
Union selects only unique row (data) from all queries and Union all selects all rows from all queries	Union selects row (data) from all queries and Union all selects all rows from all queries
Union selects only unique row (data) from all queries and Union all selects rows from all queries	Union selects row (data) from all queries and Union all selects rows from all queries

2. Define Row Number function?
To generate sequence number	To generate sequence number based on order by column
To generate number	None

3. What is Normalization? Types of normalization?
Join the tables	Move the data into tables
Split the table to reduce duplicates and it has five types	None

4. What are different types of joins?
Inner, outer, self join	Equi join and cross join
Right outer join	All above

5. What are the advantages of using stored procedure?
Pre executable program	We can get the data
Security	It is similar to function

6. What is BCP?
Bulk copy program	Business continuity program
Both A and B	None

7. Define Index?
Predefined pointers to data page	It is primary key
It is foreign key	None

8. What command do we use to rename db, table, and column?
Invoke command	Commit
Rename	None

9. Define having clause?
It is similar to where but must use group by clause	It is equal to where clause
None	It is equal to from clause

10. What are the basic functions system databases?
To create functions	To create stored procedure
To maintain metadata information	None

11. Explain ETL process?
Extract, Translation, Loading	Extract, Transformation , Loading
Both a and b	None

12. Difference between for loop and for each loop container?
For loop based on conditions and for each loop based on objects collections	For loop based on objects collections and for each loop based on objects collections
None	Both a and b

13. What does a control flow do?
To control workflow	To control events
To control data flows	To control lookup

14. Explain event handlers?
To handle data validations	To handle errors
To handle events	None

15. SSIS 2008 configuration types?
Five	Four
Three	One

16. Define Lookup transformation?
Used as reference table	Used as master table
Used as fact table	None

17. Define synchronous transformations?
Input rows count and Output rows count are same	Input rows count and Output rows count are not same
None	Input rows count and Output rows count are different

18. How to rename file using SSIS tasks?
Using lookup	Using Data flow
Using File system task	None

19. What does mean by data auditing?
To maintain data load statistics in ETL process	To know the errors
To know the Primary keys	None

20. How many container tasks available in SSIS?
One	Two
Three	Four