Free Microsoft 070-448 Exam Dumps Questions & Answers

You are developing a SQL Server 2008 Integration Services (SSIS) data flow that extracts data from two sources: a Mircosoft Excel sources and ADO.net. The ADO.net source is based on a SELECT statement that uses an ORDER BY clause.
The data flow is as shown in the following exhibit. (Click the Exhibit button.)
When the paths from the two sources are connected to the Merge Join component, the following error
message is displayed:
Data Flow Task: the input is not sorted. The `input "Merge Join Left Input"(48)' must be sorted.
You need to ensure that data from each query is included in each row in the data flow.
What should you do? (Each correct answer presents part of the solution. Choose two.)

• A.Add a Sort transformation for the Excel source.
• B.Replace the Merge Join transformation with a Union All transformation.
• C.Add an OLE DB Command transformation for each data flow.
• D.Update the sorting properties in the ADO.net source component.

Note: This question is part of a series of questions that use the same of similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You maintain the SQL Server 2008 Integration Services (SSIS) instance for a healthcare device manufacturing company.
You develop a package named Memberinformation.dtsx with Windows authentication. You deploy it to SQL Server.
You need to validate Memberinformation.dtsx packages without package execution.
Which command syntax should you use?

• A.dtexec /sq Memberinformation / verify (a400e860-38d5-11c5-11ce-ae62-08002b2b79ef)
• B.dtutil /FILE c:\SSISpackages\Memberinformation.dtsx /COPY FILE;W: \ProdSSISpackages\ Memberinformation_Prod.dtsx
• C.dtutil /SQL Memberinformation /COPY DTS;c:\SSISpackages\Memberinformation
• D.dtexec /f "c: \ Memberinformation .dtsx" /1 " DTS.LogProviderTextFile;Y:\Loginformation.txt"
• E.dtutil /FILE c:\ SSISpackages|Memberinformation.dstx /DestServer DBPROD /COPY SQL; Memberinformation.dtsx
• F.dtexec /sq Memberinformation /ser productionServer / va
• G.dtutil /FILE c:\ SSISpackages|Memberinformation.dstx /COPY SQL; Memberinformation.dtsx
• H.dtexec /f " Z:\ Memberinformation.dtsx " /conf "
  Z: \Memberinformationconfig,cfg "

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You maintain a SQL Server 2008 Reporting Services (SSRS) instance for a shoe company.
An existing report on shoe sales allows the user to see the company's revenue across many different
attributes.
You need to create a drop down list that filters the report by one or more shoe colors.
You alter the main dataset and configure the report parameter to accept multiple values.
What should you do next?

• A.Create a distinct dataset that includes all possible values and attach it to the parameter.
• B.Develop a report for each environment.
• C.Create a dynamic data source from a dataset by using the IN operator.
• D.Configure the Internal Visibility option for the parameter.
• E.Create a dynamic data source from a dataset that includes a list of distinct servers.
• F.Configure the Hidden Visibility property.
• G.Create a dynamic dataset that includes a list of the different users.
• H.Create a dynamic dataset that utilizes the WHERE clause to filter by the parameter.

You design a SQL Server 2008 Integration Services (SSIS) data flow that inserts data from a source
query to a destination table.
You need to insert only those rows that do not already exist in the destination tablE.What are two possible
ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

• A.Use the Union All transformation.
• B.Use the Fuzzy Lookup transformation.
• C.Use the Fuzzy Grouping transformation.
• D.Use the Merge transformation.
• E.Use the Lookup transformation.
• F.Use the Merge Join transformation.

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 QueryLogConnectionString server property to a valid connection string.
• B.Set the QueryLogSampling server property to 10.
• C.Set the LogDir server property to a valid path.
• D.Set the AllowedBrowsingFolders server property to include the folder from the LogDir setting.