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

You create a report in SQL Server 2008 Reporting Services (SSRS) solution.
You write the following code segment in the report.
Private Shared Function GetCmFromInches(ByVal InchValue As Decimal) As Decimal
If IsNothing(InchValue) Then Return Nothing Else Return InchValue * 2.54 End If End Function The code segment generates errors when compiled. You need to ensure that the following requirements are met: The code segment compiles successfully. The GetCmFromInches function can be called from other reports. What should you do?

• A.Remove the Private keyword from the function definition.
• B.Create a custom assembly by using Microsoft Visual Basic .NET. Declare the function as Public Shared.
• C.Remove the Shared keyword from the function definition.
• D.Declare the function as Public Shared instead of Private Shared.

You maintain a SQL Server 2008 Analysis Services (SSAS) instance.
You plan to run the Usage-Based Optimization Wizard.
You need to enable query logging.
What should you do?

• A.Set the LogDir server property to a valid path.
• B.Set the QueryLogSampling server property to 10.
• C.Set the QueryLogConnectionString server property to a valid connection string.
• D.Set the AllowedBrowsingFolders server property to include the folder from the LogDir setting.

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 OnlineMode property for the partition to Immediate.
• B.Set the OnlineMode property for the partition to OnCacheComplete.
• C.Set the ProcessingMode property for the partition to Regular.
• D.Set the ProcessingMode property for the partition to LazyAggregations.

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.PeriodsToDate ([DinTime] . [Yr-Qtr-Mth]. [Year], [DimTime] . [Yr-Qtr-Mth] . [Month]. [July 2007])
• C.ParallelPeriod ([DimTime] . [Yr-Qtr-Mth] . [Year] , 7, [DimTime] . [Yr-Qtr-Mth] . [Month] . [July 2007])
• D.PeriodsToDate ([DinTime] . [Yr-Qtr-Mth]. [Month], [DimTime] . [Yr-Qtr-Mth] . [Month]. [July 2007])

You maintain a SQL Server 2008 Analysis Services (SSAS) database.
When you process the Analysis Services database, you discover that a Duplicate Key error occurs.
You need to modify the ErrorConfiguration property so that the error condition is reported and processing
continues.
Which object should you modify?

• A.The partition
• B.The cube
• C.The dimension
• D.The measure group