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

You maintain a SQL Server 2008 Analysis Services (SSAS) database.
When you process the Analysis Services database using the Process Add option in Management Studio, you discover that a KeyNotFound error occurs.
You need to modify the ErrorConfiguration property so that the error condition id reported and processing continues.
Which object should you modify?

• A.Measure group
• B.Cube
• C.Dimension
• D.Partition

You implement a SQL Server 2008 Analysis Services (SSAS) solution. You use data mining extensions
(DMX) to query a data mining model.
You write the following DMX code segment to query a Bike Buyer data mining model in a Decision Tree
data mining structure. (Line numbers are included for reference only.)
01 SELECT
02 [Decision Tree].[Bike Buyer] AS Buyer
03 FROM
04 [Decision Tree] 06 (SELECT 28 AS [Age],
07 '2-5 Miles' AS [Commute Distance],
08 '1' AS [House Owner Flag],
09 1 AS [Number Cars Owned],
10 2 AS [Total Children]) AS t
You need to ensure that the input columns automatically map to the columns in the data mining structure.
Which code fragment should you insert at line 05?

• A.INNER JOIN
• B.OPEN QUERY
• C.NATURAL PREDICTION JOIN
• D.PREDICTION JOIN

You are developing a SQL Server 2008 Integration Services (SSIS) package.
The package uses an OLE DB connection manager to connect to a third-party database server. The
database does not support Integrated Windows authentication.
You create an XML configuration file that provides configuration for the connection manager. You add the
configuration file to the package.
When the package executes, you receive an error message which indicates that login failure occurred.
You need to execute the package successfully.
What should you do?

• A.Use a Microsoft ADO.NET connection manager instead of an OLE DB connection manager.
• B.Edit the XML configuration file.
• C.Use an indirect XML configuration.
• D.Run the package on the same server as the third-party database server.

You are developing a sales report by using SQL Server 2008 Reporting Services (SSRS).
The report contains a table.
You need to implement a technology that allows users to open a new report when they click on a field in a
table.
Which SSRS technology should you use?

• A.Subreport
• B.Tablix Data Region
• C.Drillthrough action
• D.Interactive Sorting

You create a SQL Server 2008 Analysis Services (SSAS) solution.
You enable proactive caching for a partition.
You need to ensure that SSAS can query relational data when multidimensional storage is being updated.
What should you do?

• A.Set the ProcessingMode property for the partition to Regular.
• B.Set the OnlineMode property for the partition to Immediate.
• C.Set the ProcessingMode property for the partition to LazyAggregations.
• D.Set the OnlineMode property for the partition to OnCacheComplete.