Prep and try our 070-448 valid and latest training questions & answers

Microsoft 070-448 Exam Overview:

Microsoft 070-448 Exam Syllabus Topics:

Microsoft TS:MS SQL Server 2008.Business Intelligence Dev and Maintenan Sample Questions:

1. You are a server administrator of a SQL Server 2008 Analysis Services (SSAS) instance. The instance
contains a database that is used by the members of the Sales group.
You configure a new role named Northern Region by using the "{[Customers].[Region].[Region].[Northern]}"
allowed permission set.
You assign the Sales group to the Northern Region role.
You need to verify that users in the Northern Region role can view data only for their region.
What should you do?

A) Select the Enable Visual Totals check box for the Northern Region role.
B) Add the Roles=Northern Region; parameter to the connection string.
C) Temporarily add your account to the Northern Region role.
D) Add the User ID=Northern Region; parameter to the connection string.

2. You build and deploy a SQL Server 2008 Integration Services (SSIS) package.
During package development, the XML configuration is not specified.
You need to apply the configuration to the deployed package.
What should you do?

A) Use the SETX command line utility.
B) Use the Deployment utility.
C) Use the DTEXEC command line utility.
D) Use the DTUTIL command line utility.

3. You implement a SQL Server 2008 Integration Services (SSIS) package. The package contains the following components: A data flow task contained in a For Loop container A Flat File destination component that uses a Flat File connection manager An OnError event handler When an error occurs in the package, you plan to write diagnostic information from an expression that includes the version of the package to a text file.
You need to ensure that the required information is written to the text file. What should you do?

A) Use the TaskID variable.
B) Use the VersionGUID variable.
C) Use the ExecutionGUID variable.
D) Use the SourceID variable.

4. Two months ago you created a report by using SQL Server 2008 Reporting Services (SSRS).
The report is already in production and is currently being emailed to the CID every Monday at 8:30am. The
CIO wants to report also to be emailed to members of the finance management team.
You need t enable this functionality.
What should you do?

A) Select the My Subscriptions page, and the click the New Data-driven Subscription button.
B) Select the report you created, click the Subscriptions tab, and then click the New Subscription button.
C) Select the report you created, click the Subscription tab, and then click the New Data-driven Subscription button.
D) Select the report you created, and click the New Subscription button.

5. You maintain a SQL Server 2008 Integration Services (SSIS) instancE.The instance stores packages in
a SQL Server 2008 instance.
You need to deploy the package of an instance of SSIS to another SSIS instance that stores its packages in
a shared directory.
What should you do?

A) Execute the dtutil command.
B) Execute the dtexec command.
C) Execute the dtexecui command.
D) Execute the dtswizard command.

Solutions: