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

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 MSDB database
• C.The Microsoft SQL Server\90\DTS\Package folder.
• D.The tempdb database

You develop a report by using SQL Server 2008 Reporting Services (SSRS). The report has a dataset that
contains 25 columns of data. You plan to render the dataset to a Microsoft Excel worksheet.
You need to implement drilldown technology when rendering to Excel.
Which type of data region should you use?

• A.List
• B.Rectangle
• C.Matrix
• D.Textbox

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 manage the security in SQL Server 2008 R2 Reporting Services (SSRS).
You create a new role.
You need to grant the following permissions to the role:
View and modify security settings for reports, folders, resources, and shared data sources.
Create and delete reports.
Modify report properties.
View content, definition, and property for reports.
Which three actions should you perform? (Each correct answer presents part of the solution, Choose
three.)

• A.Assign the Consume Reports task to the role.
• B.Assign the Manage Reports task to the role.
• C.Assign the Manage All Subscriptions task to the role.
• D.Assign Set Security Policies for Items task to the role.
• E.Assign the Manage Resources task to the role.

You develop a SQL Server 2008 Reporting Services (SSRS) solution.
You add a report that contains a single dataset and a query parameter.
You need to ensure that the report executes without user interaction from the Report Manager.
What should you do?

• A.Configure available values for the parameter from the dataset.
• B.Configure the default value for the parameter based on an expression.
• C.Configure the report to use snapshot execution.
• D.Configure the parameter data to refresh whenever the parameter is refreshed.