Microsoft TS:MS SQL Server 2008.Business Intelligence Dev and Maintenan - 070-448 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

You have a SQL Server 2008 R2 Analysis Services (SSAS) solution.
You add a new Data Source View (DSV) to the solution. The DSV includes a SalesOrder table with columns for OrderTotal and CostTotal.
You need to derive the profit for each order without modifying the underlying data.
What should you do?

A. Add a Named Query to the DSV and then ass a Named Calculation to that query, using OrderTotal -CostTotal as the expression. B. Create a view, SalesProfit, as Select * from SalesOrder. C. Add a Named Calculation to the SalesOrder table, using OrderTotal CostTotal as the expression. D. Add a Named Calculation to the SalesOrder table, using OrderTotal + CostTotal as the expression. E. Add a Named Query to the DSV, using Select * from SalesOrder as the expression. F. Add a Named Calculation to the SalesOrder table, using OrderTotal,CostTotal as the expression. G. Add a Named Query to the DSV, using Select *,OrderTotal CostTotal from SalesOrder as the expression. H. Create a view, SalesProfit, as Select *, OrderTotal CostTotal as Profit from SalesOrder.

Discussion 0

Correct Answer: C,G Vote an answer

Question 2

You are designing a SQL Server 2008 Integration Services (SSIS) package. The package includes a
Data Flow task.
You need to modify the package to write all rows that generate errors to a text file.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

A. Use a Flat File Destination component. B. Add an Error output to the Data Flow component C. Use a Raw File Destination component. D. Use the SSIS log provider for the SQL Profiler. E. Use the SSIS log provider for the text file.

Discussion 0

Correct Answer: A,B Vote an answer

Question 3

You maintain a SQL Server 2008 Analysis Services (SSAS) database that contains a dimension named
Customer.
You need to configure the Dimension Data settings to meet the following requirements:
Deny access to the {[Customer].[Country].&[Germany],[Customer].[Country].&[France]} set of attribute
members.
New members added to the attribute are visible by default.
What should you do?

A. Add the following set to the Denied Set property. Except([Customer].[Country].[Country] ,{[Customer].[Country].&[Germany] ,[Customer].[Country].&[France]}) B. Add the following set to the Denied Set property. {[Customer].[Country].&[Germany] ,[Customer].[Country].&[France]} C. Add the following set to the Allowed Set property. Extract({[Customer].[Country].&[Germany] ,[Customer].[Country].&[France]} ,[Customer].[Country]) D. Add all the country members except those of France and Germany to the Allowed Set property.

Discussion 0

Correct Answer: B Vote an answer

Question 4

You maintain a SQL Server 2008 Analysis Services (SSAS) instance.
You plan to update only the Products dimension while processing the cube by using an XML for Analysis
(XMLA) script.
You need to ensure that only the dimensions are updated.
What should you do?

A. Execute a processIndex command. B. Execute a processDefault command. C. Execute a processStructure command. D. Execute a processUpdate command.

Discussion 0

Correct Answer: D Vote an answer

Question 5

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) instances for a an insurance company.
You develop a package named Memberinformation.dtsx and save it in the SSISpackages folder on the company network. The package is configured externally to the file Mamberinformationconfig.cfg.
You need to execute the package.
Which command syntax should you use?

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

Discussion 0

Correct Answer: B Vote an answer

Question 6

You use SSIS to consolidate customer data from a relational database and several Microsoft Excel files into a single data warehouse.
The data warehouse is missing information that exists in the Excel files.
You need to discover why the data warehouse is missing data. What should you verify first to begin troubleshooting?

A. That MSDTC has been started on the system. B. That system event logs are not full. C. That SSRS has been installed and configured. D. That SSAS has been installed and configured.

Discussion 0

Correct Answer: A Vote an answer

Question 7

You develop a SQL Server 2008 Analysis Services (SSAS) database.
Your database includes several measure groups. A measure group named Sales Data requires frequent
updates than other measure groups.
You need to ensure that the Sales Data measure group will automatically process on a schedule managed
by SSAS.
What should you do?

A. Modify the DataAggregation property. B. Modify the ProactiveCaching property. C. Modify the ProcessingPriority property. D. Modify the ProcessingMode property.

Discussion 0

Correct Answer: B Vote an answer