Microsoft 70-455 Exam - Cheat-Test.com

Free 70-455 Sample Questions:

1. You're the administrator of your company network. And SQL Server 2008 has been deployed on your computer. Now you use SQL Server 2008 to design a Business Intelligence (BI) solution. You intend to analyze customer interests for the various sections of the Web site. When performing the analysis, you can get the information you need in the log files on the web server. In order to use the information, you want to load the information into a database by designing a SQL Server 2008 Integration Services (SSIS) solution. You have to enumerate the log files that are stored on the Web server. So which control flow element should you use?
A. You should use File System task
B. You should use Sequence container
C. You should use Data Profiling task
D. You should use Foreach Loop container
Answer: D

2. You're the administrator of your company network. And SQL Server 2008 has been deployed on your computer. Now you use SQL Server 2008 to design a Business Intelligence (BI) solution. Now you design a SQL Server Integration Services (SSIS) solution. The solutions includes 20 packages. So what should you do to run the packages in a predefined order? (Each correct answer presents a complete solution. choose more than one)
A. You should use data flow paths.
B. You should use precedence constraints.
C. You should use the task host container.
D. You should use the Execute Package task.
E. You should use the system variables for the packages.
Answer: B, D

3. You're the administrator of your company network. And SQL Server 2008 has been deployed on your computer. Now you use SQL Server 2008 to design a Business Intelligence (BI) solution. Now you design a SQL Server Integration Services (SSIS) solution. You intend to deploy the projects in the manner below:
A parent package on an instance which is named SSIS1.
Three child packages individually on three instances which are named SSIS2, SSIS3, SSIS4.
So what should you do make sure that the parent package can discover the execution state of the child packages?
A. You should configure the parent package to log its events to a SQL Server log provider.
B. You should configure the child package to log their events to a SQL Server log provider.
C. You should configure the child package to log their events to a SQL Server Profiler log provider.
D. You should configure the parent package to log its events to a SQL Server Profiler log provider.
Answer: B

4. You're the administrator of your company network. And SQL Server 2008 has been deployed on your computer. Now you use SQL Server 2008 to create a SQL Server 2008 Analysis Services (SSAS) solution and then you design a Business Intelligence (BI) solution. The solution contains a dimension named DProduction. In the dimension there are four attributes named Product, Color, Sub-Category, and Category. Among these, the Product attribute is the key attribute for DProduction. The table below presents a sample data set of the solution.

You notice that there are some performance problems on the DProduction. In order to optimize the performance of the dimension, you have to design attribute relationships on it. So which set of relationships should you choose?

Answer: B

5. You're the administrator of your company network. And SQL Server 2008 has been deployed on your computer. Now you use SQL Server 2008 to create a SQL Server 2008 Analysis Services (SSAS) solution and then you design a Business Intelligence (BI) solution. The exhibit below presents the data source view of the solution. (Click the Exhibit button.)

You create the components below from the corresponding tables in the data source view:
A measure group named FactSales
Two dimensions named DimCustomer and DimGeography
In the FactSales measure group, you intend to analyze data by geographic location. You have to use the DimGeography dimension to execute the rollup measures in the FactSales measure group. So what should you do?
A. You should create a regular relationship for the DimGeography dimension.
B. You should create a referenced relationship for the DimGeography dimension.
C. You should create a many-to-many relationship for the DimGeography dimension.
D. You should create a role-playing dimension instance for the DimGeography dimension.
Answer: B