Free Microsoft 070-452 Exam Dumps Questions & Answers

You are the administrator of your company network. You use Server 2008 to develop a Business Intelligence (BI) solution. You intend to analyze customer interests for the various sections of the Web site of your company. Information that you need for analysis is stored in the log files on the Web server. You plan to work out a SQL Server 2008 Integration Services (SSIS) solution to load the information from the log files into a database. You need to enumerate the log files that are stored on the Web server.So which control flow element should you utilize?

• A.You should utilize Foreach Loop container
• B.You should utilize File System task
• C.You should utilize Sequence container
• D.You should utilize Data Profiling task

You design a SQL Server 2008 Analysis Services (SSAS) solution. Your solution has a measure named
Sales Amount and a dimension named Date. The Date dimension has a hierarchy named Fiscal that has
levels named Fiscal Year, Fiscal Quarter, and Fiscal Month.
You need to create a calculated member to analyze the Sales Amount share percentage at different levels
compared to the total sales for a given Fiscal Year.
Which code segment should you use?

• A.Case When [Date].[Fiscal].CurrentMember.Level.Ordinal = 0 Then 1 Else [Measures].[Sales Amount]/([Measures].[Sales Amount], [Date].[Fiscal].CurrentMember.Parent) End
• B.Case When [Date].[Fiscal].CurrentMember.Level.Ordinal = 0 Then 1 Else [Measures].[Sales Amount]/([Measures].[Sales Amount], [Date].[Fiscal].[Fiscal Year].CurrentMember) End
• C.Case When [Date].[Fiscal].CurrentMember.Level.Ordinal = 0 Then 1 Else [Measures].[Sales Amount]/([Measures].[Sales Amount], Ancestor([Date].[Fiscal].CurrentMember, [Date].[Fiscal].[Fiscal Year])) End
• D.Case When [Date].[Fiscal].CurrentMember.Level.Ordinal = 0 Then 1 Else [Measures].[Sales Amount]/([Measures].[Sales Amount], Descendants([Date].[Fiscal].CurrentMember, [Date].[Fiscal].[Fiscal Year], SELF_AND_AFTER)) End

You are the administrator of your company network. You use SQL Server 2008 to develop a Business Intelligence (BI) solution. And you develop a SQL Server 2008 Reporting Services (SSRS) solution. You use Microsoft Visual Studio .NET 2008 to create reports. The manager of your company asks to create 60 SSRS reports. You mustmake sure that the company logo and the company name are included in the page header of all the reports. So what should you do?

• A.You should create a SSRS report and include the required page header in the report. Create a class library that includes the report and add the class library as an
• B.You should create a SSRS report and include the required page header in the report. Copy the report definition to an XML file and add the XML file as a data
• C.You should create an SSRS report and include the required page header in the report. And use the report as a template for all the reports.
• D.You should create an SSRS report and include the required page header in the report and create a subreport that refers to the report. Include the subreport to all

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to develop a report
that will use data obtained from a SQL Server 2008 Analysis Services (SSAS) instance. The solution has
many key performance indicators (KPIs). You need to ensure that users can perform the following tasks in
the minimum amount of time and by using the minimum amount of development effort:
-Browse through the report offline.
-View the KPIs that they want to see.
Which tool should you use?

• A.Report Builder
• B.a custom Microsoft ASP.NET application that has the ReportViewer control
• C.Microsoft Excel 2007
• D.SQL Server 2008 Reporting Services (SSRS)

You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008
Integration Services (SSIS) package to perform an extract, transform, and load (ETL) process to load data
to a DimCustomer dimension table that contains 1 million rows.
Your data flow uses the following components:
-A SQL Destination data flow task to insert new customers.
-An OLE DB Command transform that updates existing customers.
On average, 25 percent of existing customer records is updated each night. You need to reduce the
amount of time required to update customer records.
What should you do?

• A.Stage the data in the data flow. Replace the OLE DB Command transform in the data flow with an Execute SQL task in the control flow.
• B.Stage the data in the data flow. Replace the UPDATE statement in the OLE DB Command transform with a DELETE statement followed by an INSERT statement.
• C.Modify the UPDATE statement in the OLE DB Command transform to use the TABLOCK table hint.
• D.Modify the UPDATE statement in the OLE DB Command transform to use the PAGLOCK table hint.