get the app get the app       get the app       get the app

70-448 MS SQL Server 2008, Business Intelligence

Exam Name70-448 MS SQL Server 2008, Business Intelligence
Description70-448 MS SQL Server 2008, Business Intelligence questions and Answers exams contains the questions from various interview of IT industry.These questions are helpful to crack the IT interview.
Exam TypeMASTER EXAM
Authenticity10005
creatorAnirudh(39259)

Back to Parent Category
Create QuestionPDF   Start Exam
.
Question: 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?


Answer:Use the DTEXEC command line utility.


Question: You are editing a SQL Server 2008 Integration Services (SSIS) package by using Business Intelligence

Development Studio. The package uses a custom data flow component. The package runs successfully.

You attempt to add another instance of the custom data flow component to the package. The data flow

component does not appear in the toolbox or in the Choose Toolbox Items dialog box.

You need to add the custom data flow component to the toolbox.

What should you do?


Answer:Copy the assembly to the appropriate folder.


Question: 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?


Answer:Add a Named Calculation to the SalesOrder table, using OrderTotal ­ CostTotal as the expression.
Answer:Add a Named Query to the DSV, using Select *,OrderTotal ­ CostTotal from SalesOrder as the expression.


Question: You create a SQL Server 2008 R2 Analysis Services (SSAS) solution.

You are configuring security settings for a new database role with the following requirements:

Only the West member can be viewed by the database role. All other existing members and any newly added members of the Region attribute will not be visible. Members in attribute hierarchies that include a member of the Region attribute remain visible. The members in other attribute hierarchies remain visible.
The state of Washington is visible.
The aggregated totals for the ALL Level and Region attributes include only the values for members that are visible.

You need to ensure that the database role has these security settings.

What should you do? (Each correct answer presents part of the solution. Choose two.)


Answer:Set the Region attribute's IsAllowed = True, DeniedSet = "Except(Region..Members,{West})", ApplyDenied = False, and VisualTools = True.
Answer:Set the State attribute's IsAllowed = True, AllowedSet = "Except(Region..Members,{West} + {Washington})", ApplyDenied = False, and VisualTools = False.


Question: You are working as reporting administrator for a product development company. The company uses SQL Server 2008 Reporting Services (SSRS) deployed in a native mode.

You need to deploy multiple reports via InstallShield.
Which three components are you required to use? (Each correct answer presents part of the solution. Choose three.)


Answer:RS.exe
Answer:ReportService2005.asmx
Answer:.RSS File


Question: You are an ETL developer. You maintain a SQL Server 2008 Integration Services (SSIS) instance.

You need to develop a parent package that meets the following requirements:
The parent package can execute child packages by using multiple execute Package tasks.
A notification needs to be sent before executing the parent package and after executing all child packages.
If any packages have errors during execution, the subsequent package should run after the failure.
Only one error notification email should be sent that lists all package errors from the parent package.

What should you do? (Each correct answer presents part of the solution. Choose three.)


Answer:Set the precedence constraints between child packages Completion.
Answer:Add a Send Mail Task to the child packages' OnPostExecution event handler.
Answer:Send Mail Task to the parent packages' OnError event handler.


Question: You maintain a SQL Server 2008 Analysis Services (SSAS) database.

You plan to troubleshoot query performance by using SQL Profiler.

You need to replay the queries issued to the SSAS database.

Which three trace events should you use? (Each correct answer presents part of the solution.
Choose three.)


Answer:Audit Login event with all its data columns.
Answer:Query Begin event with all its data columns.
Answer:Query End event class with all its data columns.


Question: You maintain a SQL server 2008 Analysis Services (SSAS) data warehouse for a school district. All tests are administered via a third-party application. Results are collected in your SSAS data warehouse and moved to a Scores fact table for analysis. This warehouse also includes a Student Dimension which contains attributes related to each student.

The school year is starting, and the district administration wants the Student Dimension updated hourly so that new students can be identified and tracked. However, test scores located in the Scores fact table should not be updated as part of this incremental processing strategy.

You need to implement this functionality.
Which option should you use?


Answer:Process Update


Question: You are developing a SQL Server 2008 Integration Services (SSIS) data flow that loads data to a SQL Server 2008 database.

You need to ensure that the data flow updates the existing records and inserts the updated records into the SQL Server database by using data from the rows in your data flow.

Which three data flow components should you use? (Each correct answer presents part of the solution. Choose three.)


Answer:OLE DB Destination
Answer:OLE DB Command Transformation
Answer:Lookup Transformation