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

You create a SQL Server 2008 Analysis Services (SSAS) solution.
The cube structure is as shown in the following exhibit. (Click the Exhibit button.)
You need to ensure that the Amount measure can be aggregated for the DimCustomer dimension.
What should you do?

• A.Create a referenced relationship between DimCustomer and FactCustomerAccount. Set DimAccount as an intermediate dimension.
• B.Create a regular relationship between DimCustomer and FactTransaction.
• C.Create a many-to-many relationship between DimCustomer and FactCustomerAccount. Set FactTransaction as an intermediate measure group.
• D.Create a many-to-many relationship between DimCustomer and FactTransaction. Set FactCustomerAccount as an intermediate measure group.

You have a SQL Server 2008 R2 Analysis Services (SSAS) solution.
You add a new Data Source View (DSV) to the solution. The DSV includes a SalesOrder table with columns for OrderTotal and CostTotal.
You need to derive the profit for each order without modifying the underlying data.
What should you do?

• A.Add a Named Query to the DSV, using Select * from SalesOrder as the expression.
• B.Add a Named Calculation to the SalesOrder table, using OrderTotal CostTotal as the expression.
• C.Add a Named Calculation to the SalesOrder table, using OrderTotal + CostTotal as the expression.
• D.Create a view, SalesProfit, as Select * from SalesOrder.
• E.Create a view, SalesProfit, as Select *, OrderTotal CostTotal as Profit from SalesOrder.
• F.Add a Named Query to the DSV, using Select *,OrderTotal CostTotal from SalesOrder as the expression.
• G.Add a Named Calculation to the SalesOrder table, using OrderTotal,CostTotal as the expression.
• H.Add a Named Query to the DSV and then ass a Named Calculation to that query, using OrderTotal -CostTotal as the expression.

You develop reports by using SQL Server 2008 Reporting Services (SSRS) Enterprise Edition. You need to use data-driven subscription to distribute reports based on dynamic subscription data. Which role should you use?

• A.System User
• B.Browser
• C.Content Manager
• D.Publisher

You develop a series of SQL Server 2008 Integration Services (SSIS) packages. You need to ensure that the following requirements are met:
The package contains configurations.
The configuration information is centrally stored for all packages.
There are dependencies among the packages.
Which three components should you use to configure the package? (Each correct answer presents part of
the solution. Choose three.)

• A.Parent package variable.
• B.XML configuration file.
• C.Environment variable.
• D.Registry entry
• E.SQL Server 2008 table.

You develop a SQL Server 2008 Integration Services (SSIS) package. The package downloads several
files from a remote FTP server by using multiple FTP tasks, and then processes data by using multiple
Execute SQL tasks.
You need to configure the package to restart at the point of failure after the package downloads the files.
What should you do?

• A.Move all the FTP tasks to a sequence container.
• B.Configure the package to use a checkpoint.
• C.Configure the Execute SQL tasks to support transactions.
• D.Configure the FTP tasks to support transactions.