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

You are developing a SQL Server 2008 Integration Services (SSIS) data flow that extracts data from two
sources.
Each source database is located on a different server. Each source is based on a SELECT statement that
uses an ORDER BY clause.
The data flow is as shown in the following diagram.
When the paths from the two sources are connected to a Merge Join component, the following error
message is displayed:
"Data Flow Task: The input is not sorted. The 'input "Merge Join Left Input" (80)' must be sorted."
You need to ensure that data from each query is included in each row in the data flow. You want to achieve
this goal by using minimum amount of execution time.
What should you do?

• A.Update the sorting properties in each source component.
• B.Add an OLE DB Command transformation for each data flow.
• C.Replace the Merge Join transformation with a Union All transformation.
• D.Add a Sort transformation for each data flow.

You create a SQL Server 2008 Analysis Services (SSAS) solution. Your solution has a date dimension
named Data along with a hierarchy named Calendar. The Calendar hierarchy has levels for the Year,
Quarter, Month, and Date attributes.
You need to create a named set that refers to July of the year 2007.
Which expression should you write for the named set?

• A.ParallelPeriod ([DimTime] . [Yr-Qtr-Mth] . [Month] , 7, [DimTime] . [Yr-Qtr-Mth] . [Month] . [July 2007])
• B.ParallelPeriod ([DimTime] . [Yr-Qtr-Mth] . [Year] , 7, [DimTime] . [Yr-Qtr-Mth] . [Month] . [July 2007])
• C.PeriodsToDate ([DinTime] . [Yr-Qtr-Mth]. [Year], [DimTime] . [Yr-Qtr-Mth] . [Month]. [July 2007])
• D.PeriodsToDate ([DinTime] . [Yr-Qtr-Mth]. [Month], [DimTime] . [Yr-Qtr-Mth] . [Month]. [July 2007])

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 Calculation to the SalesOrder table, using OrderTotal,CostTotal as the expression.
• B.Create a view, SalesProfit, as Select *, OrderTotal CostTotal as Profit from SalesOrder.
• C.Create a view, SalesProfit, as Select * from SalesOrder.
• D.Add a Named Query to the DSV, using Select * from SalesOrder as the expression.
• E.Add a Named Query to the DSV and then ass a Named Calculation to that query, using OrderTotal -CostTotal as the expression.
• F.Add a Named Calculation to the SalesOrder table, using OrderTotal CostTotal 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, using Select *,OrderTotal CostTotal from SalesOrder as the expression.

You create a SQL Server 2008 R2 Reporting Services (SSRS) solution. The organization requires a drilldown report that color coordinates the values of the student's' test scores. All average scores 70% or higher should have a green background. All lower average scores should have a red background.
You need to enable this functionality.
Which expression should you use?

• A.=iif(Fields!TestScore.Value >= .70 THEN "Green" ELSE "Red")
• B.=iif(avg(Fields!TestScore.Value) >= .70,"Green","Red"
• C.=iif(avg(Fields!TestScore.Value) >= .70 THEN "Green","Red"
• D.=iif(Fields!TestScore.Value >= .70,Green","Red")

You work for an organization with global operations. You are responsible for the SQL Server 2008 Integration Services (SSIS) instance. You develop SSIS packages to load daily and weekly feeds. These packages are deployed via the SQL Server method.
These servers reside in geographies with a high risk of natural disaster.
You need to implement a disaster recovery plan to back up the SSIS packages for availability.
What should you back up?

• A.The model database
• B.The Microsoft SQL Server\90\DTS\Package folder.
• C.The tempdb database
• D.The MSDB database