Exam 70-455 study material Made available by Testkingprep.com
Free 70-455 Exam Preparation Questions Exam 70-455: Upgrade: Transition Your MCITP SQL Server 2005 BI Developer to MCITP SQL Server 2008 BI Developer
For Latest 70-455 Exam Questions and study guides- visit- http://www.testkingprep.com/70-455.html
Question:1 You're the administrator of your company network. And SQL Server 2008 has been deployed on your computer. You develop a SQL Server 2008 Analysis Services (SSAS) solution. You have two dimensions respectively named TT and List. The dimension named TT is a time dimension. You also have a fact table which includes a column named PresentEven. PresentEven contains the current account balance. In order to display the closing account balance for a time period, you need to create a measure named AccountBalance from the PresentEven column. So what should you do? A. You should set the AggregationFunction property of AccountBalance to Sum. B. You should set the AggregationFunction property of AccountBalance to ByAccount. C. You should set the AggregationFunction property of AccountBalance to FirstNonEmpty. D. You should set the AggregationFunction property of AccountBalance to LastNonEmpty. Answer: D Question:2 You're the administrator of your company network. And SQL Server 2008 has been deployed on your computer. You develop a SQL Server 2008 Analysis Services (SSAS) database which contains some measure groups. A measure group called Selling Info needs more frequent updates than others. So what should you do to make sure that the Selling Info measure group can process on a schedule automatically managed by SSAS? A. You should change the ProcessingMode property. B. You should change the DataAggregation property. C. You should change the ProactiveCaching property. D. You should change the ProcessingPriority property. Answer: C Question:3 You're the administrator of your company network. And SQL Server 2008 has been deployed on your computer. You develop a SQL Server 2008 Analysis Services (SSAS) report which contains a parameter called @SellingFeesID. You select a specific region to set the value of this parameter in the report. Now you must protect the value of the @SellingFeesID from being changed by users. You have to confure the report. So what should you do? A. You should clear the Prompt value. B. You should set the Hidden property. C. You should set the Internal property. D. You should remove the default values. Answer: D Question:4 You're the administrator of your company network. And SQL Server 2008 has been deployed on your computer. Now you develop a SQL Server 2008 Reporting Services (SSRS) solution. You add a report which includes a single dataset and a query parameter. What should you do to make sure that report executes without user interaction from the Report Manager? A. You should configure the report to use snapshot execution. B. You should configure available values for the parameter from the dataset. C. You should configure the default value for the parameter based on an expression. D. You should configure the parameter data to refresh whenever the parameter is refreshed. Answer: C Question: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 solution has a cube named SSR. And the cube has a measure called Selling which contains sales information for the last four months. In the cube, there's a single partition which has the storage property set to real-time hybrid
For Latest 70-455 Exam Questions and study guides- visit- http://www.testkingprep.com/70-455.html
online analytical processing (HOLAP). Queries against the cube must return current sales data that is entered one hour before cube processing. It takes about two hours for the partition to process. And the queries make response quite slow. So now you have to improve the cube processing and reduce the response time for the query. So what should you do to achieve this? A. You should change the storage setting of the partition to multidimensional online analytical processing (MOLAP). B. You should change the storage setting of the partition to real-time relational online analytical processing (ROLAP). C. You should create a partition for each customer. Set the storage setting of every partition to lowlatency multidimensional online analytical processing (MOLAP). D. You should create a partition for every month. Set the storage setting of the partition for the current month to low-latency multidimensional online analytical processing (MOLAP) and that of the other partitions to MOLAP. Answer: D Question:6 You're the administrator of your company network. And SQL Server 2008 has been deployed on your computer. You develop a SQL Server 2008 Analysis Services (SSAS) report which contains a table named WVP. You must make sure that alternate rows in the table. So which code segment should you choose to use for each text box? A. =iif(CountRows() / 2, "PaleGreen", "White") B. =iif(CountRows() Mod 2, "PaleGreen", "White") C. =iif(RowNumber(Nothing) / 2, "PaleGreen", "White") D. =iif(RowNumber(Nothing) Mod 2, "PaleGreen", "White") Answer: D
For Latest 70-455 Exam Questions and study guides- visit- http://www.testkingprep.com/70-455.html
For complete Exam 70-455 Training kits and Self-Paced Study Material Visit: http://www.testkingprep.com/70-455.html
http://www.testkingprep.com/
For Latest 70-455 Exam Questions and study guides- visit- http://www.testkingprep.com/70-455.html