You maintain a SQL Server 2008 Integration Services (SSIS) instance.
You develop a package that creates the temporary table *employee_stgl and then loads the
data from an Excel source data flow task into *employee_stgl by using conditional
transformation splits.
The package then loads the data into a destination table.
When you try to open the package, you get an error that reads, “Invalid object name
#employee_stgl.”
You need to resolve this error message.
Which two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)

You maintain a SQL Server 2008 Integration Services (SSIS) instance.
You use the Execute SQL task to create a table in a Control Flow. Following the Execute
SQL task is a Data Flow task in which an OLE DB source component uses this table.
The package fails during runtime.
You need to delay the validation of a task in the Control Flow and the OLE DB source in the
data flow.
Which two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)

You design a report by using SQL Server 2008 Reporting Services (SSRS).
The report contains a dataset that has 25 million rows of data. The report is rendered by
using the
HTML rendering extension.
You need to ensure that users can view the report without delay during rendering.
What should you do?

HOTSPOT
You maintain a SQL Server 2008 Analysis Services (SSAS) database on a default instance.
You need to collect information to determine if performance issues are related to hardware
limitations or latch wait contention.
Which three counters should you use? (To answer, select the three appropriate counters in
the answer area.)

You maintain a SQL Server 2008 Analysis Services (SSAS) instance.
You need to configure the analysis services query log for the SSAS instance.
Which tool should you use?

You maintain a SQL Server 2008 Analysis Services (SSAS) instance.
You have a cube that contains an unprocessed dimension.
When a user attempts to process the cube, the dimension data is not refreshed.
You need to allow the user to refresh the dimension data only.
Which permissions should you grant the user?

You manage 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?

Your organization has five departments.
You are developing a SQL Server 2008 Integration Services (SSIS) project to calculate
salary increases and bonuses under each particular manager.
You need to develop a master package that meets the following requirements:
It must give each department a different ID.

These department IDs must pass on to each individual dependency package inside the
master package.
Each dependency package should have individual security settings to accept department ID
as a variable from its master package.
Which configuration method should you choose from the SSIS configuration options?

HOTSPOT
You are working as an ETL developer for a payroll company. You configure a SQL Server
2008 Integration Services (SSIS) package to use checkpoints.
The SSIS package truncates the dbo.Employee_Attendance table, loads the new employees
in the dbo.Employee table, and then loads dbo.Employee_Attendance for a particular month.
The package fails at the Derived Column transformation within the data flow task.
You need to determine where the package execution will begin after you correct the errors
and run the package again.
Where does the package execution begin? (To answer, select the appropriate task in the
control flow.)

You are developing a SQL Server 2008 Integration Services (SSIS) package.
The package performs the following tasks:
Processes multiple files by using a ForEach Loop container.
Imports the contents of the files to a table by using a Data Flow task.
Logs the results of the status into a table by using an Execute SQL task.
You need to ensure that all the tasks of the package execute within a single transaction.
What should you do?