70-452 무료 덤프문제 온라인 액세스

You design a Business Intelligence (BI) solution by using SQL Server 2008. A SQL Server 2008 Reporting Services (SSRS) instance contains a report. Employees execute the report by using Report Manager. Each employee has his own specific set of parameters to execute the report. Data for the report is updated once daily. For each employee, the report takes more than five minutes to execute. You discover that data retrieval takes most of the time during report execution. You need to reduce the execution time of the report. What should you do?

• A.Create a data-driven subscription that uses the file share delivery method.
• B.Create a data-driven subscription that uses the NULL delivery method.
• C.Create a report execution snapshot.
• D.Create a standard subscription that uses the file share delivery method.

You design a Business Intelligence (BI) solution by using SQL Server 2008. At the end of every business
day, an application records the inventory to the Products table. The business solution for the application
must accommodate the following features:
-The content of the Products table varies every day.
-Historical product attributes are not stored.
You need to identify an appropriate dimensional model to meet the business solution. Which model should you use?

• A.Type II Slowly Changing Dimension
• B.Degenerate Dimension
• C.Type I Slowly Changing Dimension
• D.ParentChild Dimension

You are the administrator of your company network. And you??re in charge of a Microsoft SQL Server 2005 Reporting Services (SSRS) instance which has the following features: It is set as a single server and configured to use Native mode and a custom data extension is developed by using Microsoft .NET Framework 2.0You intend to upgrade the instance to SQL Server 2008 Reporting Services while ensure that there??s no loss of functionality.So what should you do?

• A.You should install a new instance of SSRS and move the existing configuration files and database to the new instance.
• B.You should uninstall Internet Information Services (IIS).
• C.You should upgrade the data extension to .NET Framework 3.5.
• D.You should edit the RSWebapplication.config file to refer to the upgraded SSRS endpoint location.

You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008
Analysis Services (SSAS) solution. The solution contains a cube that has a measure named SalesAmount.
The measure contains customer sales data for the last six months. The cube has a single partition that has
the storage property set to real-time hybrid online analytical processing (HOLAP).
Queries against the cube must return current sales data that is entered one hour before cube processing.
The partition takes two hours to process and the response time for the queries is slow. You need to
improve the cube processing and query response time.
What should you do?

• A.Change the storage setting of the partition to multidimensional online analytical processing (MOLAP).
• B.Change the storage setting of the partition to real-time relational online analytical processing (ROLAP).
• C.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.
• D.Create a partition for each customer. Set the storage setting of every partition to low-latency multidimensional online analytical processing (MOLAP).

You are the administrator of your company network. You use SQL Server 2008 to develop a Business Intelligence (BI) solution. You create a SQL Server 2008 Reporting Services (SSRS) solution. And you use Microsoft Visual Studio .NET 2008 to develop a report which is named ProductSell.The report that you created must display the following details: The total amount of year-wise sales for each product category. The product category as rows and the corresponding year of sales as columns.The number of sales years and the number of product categories for the report must be able to vary. So which report item should you add to the report?

• A.You should add Subreport
• B.You should add Textbox
• C.You should add Matrix
• D.You should add Rectangle