Prepare with Microsoft 070-448 exam torrent, pass for sure

Microsoft 070-448 Exam Overview:

Microsoft 070-448 Exam Syllabus Topics:

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

Question 1

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 Set Security Policies for Items task to the role.
D. Assign the Manage Resources task to the role.
E. Assign the Manage All Subscriptions task to the role.

Question 2

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 VersionGUID variable.
B. Use the SourceID variable.
C. Use the TaskID variable.
D. Use the ExecutionGUID variable.

Question 3

You create a SQL Server 2008 R2 Reporting Services (SSRS) solution.
The school district needs to be able to retrieve the median value of all tests scores.
You build a custom function named Median that accepts the test scores and returns the median test score.
You need to run this custom function.
Which expression should you use?

A. =Code.Function.Median()
B. =Execute.Median(Fields!TestScores)
C. =Code.Median(Fields!TestScores)
D. =Execute Function Median(Fields!TestScores)

Question 4

You are an ETL developer for a mortgage company. In your application you have two tables names Vendor and Loan.
Vendor
VendorID VendorName
1 VendorA
2 VendorB
3 VendorC
4 VendorD
5 VendorE
Loan
LoanNumber VendorID LoanAmount
I-100 1 120000
I-200 1 130000
I-300 2 150000
I-400 3 150000
I-500 4 160000
I-600 4 170000
I-700 5 180000
You need to build a SQL Server 2008 Integration Service (SSIS) package that meets the following requirements: The package should be able to generate the Excel files dynamically. Each file should have the vendor name as a prefix and the date as the suffix (e.g., VendorA_DDMMYYYY.xlsx). All the vendor names should be added to a variable and loop through the variable to generate and load
separate files for each vendor dynamically. Which Type of variable should you create?

A. Int32
B. Object
C. String
D. Int64
E. Table

Question 5

You create a SQL Server 2008 Analysis Services (SSAS) solution. Your solution has a date dimension
named Date 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 the first seven months 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([DimTime].[Yr-Qtr-Mth].[Month], [DimTime].[Yr-Qtr-Mth].[Month].[July 2007])
C. ParallelPeriod([DimTime].[Yr-Qtr-Mth].[Year], 7, [DimTime].[Yr-Qtr-Mth].[Month].[July 2007])
D. PeriodsToDate([DimTime].[Yr-Qtr-Mth].[Year], [DimTime].[Yr-Qtr-Mth].[Month].[July 2007])

Solutions: