070-452 試験問題を無料オンラインアクセス

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to deploy a new SQL
Server 2008 Reporting Services (SSRS) solution for an accounting department. The department currently
uses Microsoft Excel 2007based reports hosted on Windows SharePoint Services (WSS) 3.0.
You need to replace the existing Excel 2007 reports with SSRS-based reports.
Your solution must meet the following requirements:
-Users must be able to access the reports by using WSS.
-Reports must be version-controlled.
-Developers must be able to deploy the reports to a WSS document library.
Which two tasks should you perform? (Each correct answer presents part of the solution. Choose two.)

• A.Configure the SSRS instance by using SharePoint integration mode.
• B.Install SharePoint Web Part in the WSS server. Configure the Web Part to point to the reports in Report Manager.
• C.Configure the SSRS instance by using native mode.
• D.Install the Reporting Services Add-in for SharePoint Technologies in the WSS server.

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to develop SQL Server 2008 Reporting Services (SSRS) reports. Several reports will contain identical data regions. You need to minimize the amount of maintenance when changes are made to the data regions. What should you do?

• A.Create a shared data source in the SSRS project. Use the new shared data source for all reports.
• B.Grant the Create Linked Reports role to all users.
• C.Create a report template for each data region. Use the report template to create each report.
• D.Create each data region as a report. Embed the reports by using the subreport control.

You are the administrator of your company network. You use Server 2008 to develop a Business Intelligence (BI) solution. Now you intend to upgrade a Microsoft SQL Server 2005 Integration Services (SSIS) package which performs an extract, transform, and load (ETL) process for a sales data warehouse. And the package uses only OLE DB sources and destinations. You notice that the Lookup Transformation process takes a long time to run. So what should you do to optimize the performance of theprocess that populates the Fact tables?

• A.You should add a Cache Transformation to populate the Lookup Transformation.
• B.You should add a Fuzzy Lookup Transformation.
• C.You should add a Raw File Source to populate the Lookup Transformation
• D.You should add an Import Column Transformation.

You design a Business Intelligence (BI) solution by using SQL Server 2008. Your company processes all
transaction data in a Point of Sale (POS) application. Based on the transaction data, you design a solution
to predict the type of products a customer tends to purchase on a single visit.
You need to identify the appropriate algorithm to design the solution.
Which algorithm should you use?

• A.Association Rules
• B.Naive Bayes
• C.Time Series
• D.Clustering

You design a SQL Server 2008 Analysis Services (SSAS) solution. The data source view has tables as shown in the exhibit. (Click the Exhibit button.)

The FactInternetSales measure will be queried frequently based on the city and country of the customer.
You need to design a cube that will provide optimal performance for queries.
Which design should you choose?

• A.Create two dimensions named Customer and Geography from the DimCustomer table and the DimGeography table, respectively. Create a materialized reference relationship between the Geography dimension and the FactInternetSales measure by using the Customer dimension as an intermediate dimension.
• B.Create a dimension named Customer by joining the DimGeography and DimCustomer tables. Add an attribute relationship from CustomerKey to City and from CustomerKey to Country. Create a regular relationship in the cube between the Customer dimension and the FactInternetSales measure.
• C.Create two dimensions named Customer and Geography from the DimCustomer table and the DimGeography table, respectively. Create an unmaterialized reference relationship between the Geography dimension and the FactInternetSales measure by using the Customer dimension as an intermediate dimension.
• D.Create a dimension named Customer by joining the DimGeography and DimCustomer tables. Add an attribute relationship from CustomerKey to City and from City to Country. Create a regular relationship in the cube between the Customer dimension and the FactInternetSales measure.