1. What is the difference between UNION and UNION ALL?
2. Define Row Number function?
3. What is Normalization? Types of normalization?
4. What are different types of joins?
5. What are the advantages of using stored procedure?
6. What is BCP?
7. Define Index?
8. What command do we use to rename db, table, and column?
9. Define having clause?
10. What are the basic functions system databases?
11. Explain ETL process?
12. Difference between for loop and for each loop container?
13. What does a control flow do?
14. Explain event handlers?
15. SSIS 2008 configuration types?
16. Define Lookup transformation?
17. Define synchronous transformations?
18. How to rename file using SSIS tasks?
19. What does mean by data auditing?
20. How many container tasks available in SSIS?
21. Define role play dimensions?
22. Define dimension usage in SSAS Cube?
23. MDX stands?
24. DSV stands?
25. How many types of actions available in the Cube?
26. What do you understand by dynamic named set (SSAS 2008)?
27. How many types of dimension are possible in SSAS?
28. In which scenario, you would like to go for materializing dimension?
30. What are the options to deploy SSAS cube in production?
31. Describe Reporting Lifecycle?
32. What can SQL Server Reporting Services do?
33. Define reporting processing?
34. How many default rending options are available in SSRS2008?
35. What is the usage of Report Builder?
37 How many architecture components of SSRS 2008?
38. Explain on SSRS2008 Reporting Items?
39. What does mean by nested datasets?
40. How many command line utilities of SSRS2008?
41. You are creating a SQL Server 2008 Integration Services (SSIS) package for Company.com. The package contains six Data Flow tasks and three Control Flow tasks. You should alter the package Which is the correct answer?
42. You are managing a SQL Server 2008 Reporting Services (SSRS) sample which does not give some same rendering extensions for Company.com. You should make sure that you could set the server in order to render to Microsoft Word. Which is the correct answer?
43. You are creating a SQL Server 2008 Integration Services (SSIS) package on a SQL Server 2008 database for Company.com. In order to develop a failure recovery plan that is published for a SQL Server. Which is the correct answer?
44. You are developing a SQL Server 2008 Reporting Services (SSRS) instance of report model for Company.com.In the Report Builder tool, the users should need to create their SSRS reports.
The data source they used will include a Microsoft SQL Server 2008 database. Which include 1000 tables? You should design the report model for users, and allow access to only the 20tables which they require for reporting. Which is the correct answer?
45. You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com.A sales manager called Clerk is responsible for the sales of bikes in the Northeast region. You decide to give some rights to the rights to Clerk to visit the database.You won two roles below called Southern Region and Nikes. Their schemas are listed below:You have make The Visual Totals properties attribute true for roles above.You should make sure that Clerk could browser the workers in the Product dimension which link to the Nikes category in the Southern region. Which is the correct answer?
46. You are managing a SQL Server 2008 Analysis Services (SSAS) database which includes a Sale dimension that includes the Category and Subcategory properties for Company.com.There is a rigid relationship type for properties. The data source for the Sale dimension alters the relationship between the Type and Sub Type values. You should make sure that you could run an XML to operate he dimension to reflect the change normally for Analysis (XMLA). Which is
the correct answer?
47. You are managing a SQL Server 2008 Analysis Services (SSAS) instance for Company.com. In order to execute the Usage-Based Optimization Wizard you should make query logging enable.
Which is the correct answer? Which is the correct answer?
48. You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com.You get the Duplicate Key error when you operate the Analysis Services
database.You should alter the ErrorConfiguration attribute in order to make processing run normally. Which is the correct answer?
49. You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com. In order to update data in a partition each hour you should run the incremental processing method.
In order to solve the problem, which is the correct answer?
50. You are developing a SQL Server 2008 Reporting Services (SSRS) report for Company.com.Assembly should be created in order to run real-time lookup and currency conversion. The assembly has a static class named daily which lives in the namespace HomeCalc.there is a method called DMO which need two arguments, Cuurnt and HomeCalcWhen the report is operating, you should reference the ToEUR method in an expression to convert USD to USO. Which is the correct answer?
2. Define Row Number function?
3. What is Normalization? Types of normalization?
4. What are different types of joins?
5. What are the advantages of using stored procedure?
6. What is BCP?
7. Define Index?
8. What command do we use to rename db, table, and column?
9. Define having clause?
10. What are the basic functions system databases?
11. Explain ETL process?
12. Difference between for loop and for each loop container?
13. What does a control flow do?
14. Explain event handlers?
15. SSIS 2008 configuration types?
16. Define Lookup transformation?
17. Define synchronous transformations?
18. How to rename file using SSIS tasks?
19. What does mean by data auditing?
20. How many container tasks available in SSIS?
21. Define role play dimensions?
22. Define dimension usage in SSAS Cube?
23. MDX stands?
24. DSV stands?
25. How many types of actions available in the Cube?
26. What do you understand by dynamic named set (SSAS 2008)?
27. How many types of dimension are possible in SSAS?
28. In which scenario, you would like to go for materializing dimension?
30. What are the options to deploy SSAS cube in production?
31. Describe Reporting Lifecycle?
32. What can SQL Server Reporting Services do?
33. Define reporting processing?
34. How many default rending options are available in SSRS2008?
35. What is the usage of Report Builder?
37 How many architecture components of SSRS 2008?
38. Explain on SSRS2008 Reporting Items?
39. What does mean by nested datasets?
40. How many command line utilities of SSRS2008?
41. You are creating a SQL Server 2008 Integration Services (SSIS) package for Company.com. The package contains six Data Flow tasks and three Control Flow tasks. You should alter the package Which is the correct answer?
42. You are managing a SQL Server 2008 Reporting Services (SSRS) sample which does not give some same rendering extensions for Company.com. You should make sure that you could set the server in order to render to Microsoft Word. Which is the correct answer?
43. You are creating a SQL Server 2008 Integration Services (SSIS) package on a SQL Server 2008 database for Company.com. In order to develop a failure recovery plan that is published for a SQL Server. Which is the correct answer?
44. You are developing a SQL Server 2008 Reporting Services (SSRS) instance of report model for Company.com.In the Report Builder tool, the users should need to create their SSRS reports.
The data source they used will include a Microsoft SQL Server 2008 database. Which include 1000 tables? You should design the report model for users, and allow access to only the 20tables which they require for reporting. Which is the correct answer?
45. You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com.A sales manager called Clerk is responsible for the sales of bikes in the Northeast region. You decide to give some rights to the rights to Clerk to visit the database.You won two roles below called Southern Region and Nikes. Their schemas are listed below:You have make The Visual Totals properties attribute true for roles above.You should make sure that Clerk could browser the workers in the Product dimension which link to the Nikes category in the Southern region. Which is the correct answer?
46. You are managing a SQL Server 2008 Analysis Services (SSAS) database which includes a Sale dimension that includes the Category and Subcategory properties for Company.com.There is a rigid relationship type for properties. The data source for the Sale dimension alters the relationship between the Type and Sub Type values. You should make sure that you could run an XML to operate he dimension to reflect the change normally for Analysis (XMLA). Which is
the correct answer?
47. You are managing a SQL Server 2008 Analysis Services (SSAS) instance for Company.com. In order to execute the Usage-Based Optimization Wizard you should make query logging enable.
Which is the correct answer? Which is the correct answer?
48. You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com.You get the Duplicate Key error when you operate the Analysis Services
database.You should alter the ErrorConfiguration attribute in order to make processing run normally. Which is the correct answer?
49. You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com. In order to update data in a partition each hour you should run the incremental processing method.
In order to solve the problem, which is the correct answer?
50. You are developing a SQL Server 2008 Reporting Services (SSRS) report for Company.com.Assembly should be created in order to run real-time lookup and currency conversion. The assembly has a static class named daily which lives in the namespace HomeCalc.there is a method called DMO which need two arguments, Cuurnt and HomeCalcWhen the report is operating, you should reference the ToEUR method in an expression to convert USD to USO. Which is the correct answer?