You are an ETL developer for a mortgage company. In your application you have to load
data from a Microsoft Excel source and an OLE DB source.
The Excel source contains vendor data and has approximately 1000 records.
The OLE DB source contains loan data and has approximately 1,000,000 records.
Sample vendor data (Excel source) is shown in the following table:

Sample loan data (OLE DB source) is shown in the following table:

The CIO asks you to generate an Excel file with the loan list information for each vendor.

You build a SQL Server 2008 Integration Services (SSIS) package that can generate the
Excel files dynamically. The Excel files should have the vendor name as the prefix and the
date as the suffix (e.g., VendorA_DDMMYYYY.xlsx).
You get the error message shown in the exhibit. (Click the Exhibit button.)
You need to sort both sources in order to merge join the data.
What should you do?

DRAG DROP
You are an ETL Developer for a mortgage company. You have two staging sources named
Stg_Vendor and Stg_Loan that you need to load into a destination table named Loan.
Stg_Vendor is a Microsoft Excel source.
The following table shows Stg_Vendor (Excel source) sample data:

The following table shows Stg_Loan sample data:

The following table shows Loan sample data:

You need to build the ETL package.
What should you do? (To answer, drag the appropriate components to the correct locations
in the answer area.
Each component may be used once, more than once, or not at all. You may need to drag the
split bar between panes or scroll to view content.)

You develop a SQL Server 2008 Integration Services (SSIS) package.
You need to modify the package to log event data from a text file to the SQL Server
database.
Which two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)

You work for an organization with global operations. You are responsible for the SQL Server
2008 Integration Services (SSIS) instance. You develop SSIS packages to load daily and
weekly feeds.
These packages are deployed via the SQL Server method.
The servers reside in geographies with a high risk of natural disaster.
You need to implement a disaster recovery plan to back up the SSIS packages for
availability.
What should you back up?

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.)