You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008. Now you are employed in a company
named NaproStar which uses SQL Server2008. You work as the technical support. Now you
get an order from your company CIO, you’re asked to develop a SQL Server 2008
Integration Services (SSIS) data flow. The data flow loads data to a SQL Server 2008
database. Using data from the rows in your data flow, you must make sure that the existing
records in the SQL Server database is updated by the data flow. Of the following data flow
components, which one should be used?

You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008. You
work as the technical support.
Now you get an order from your company CIO, you are asked to design a SQL Server 2008
Integration Services (SSIS) package.
The package contains a Data Flow task. According to the requirement of the company CIO,
the package has to be modified to write all rows by which errors are generated to a text file.
So what should you do? (choose more than one)

You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008. Now you are employed in a company
named NaproStar which uses SQL Server2008. You work as the technical support. Now you
are in charge of a SQL Server 2008 Analysis Services (SSAS) database. Now you get an email from your company CIO, according to his requirement, he wants the data in a partition
to be refreshed every two hours. He has assigned this task to you. You have to implement
the incremental processing strategy. Of the following options, which XML for Analysis
(XMLA) command should you choose?

You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008. You
work as the technical support.
According to the requirement of the company, you’re deploying a SQL Server 2008
Integration Services (SSIS) package.
The XML configuration is not specified when deploying the package. You have to apply the
configuration to the deployed package. What action should you do?

You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008. You
work as the technical support.
According to the requirement of the company, you’re desinging a SQL Server 2008
Integration Services (SSIS) package.
The package contains a Data Flow task which copies several million rows. There is a
reference table that contains 10,000 rows.
The data flow needs a match against the reference table. During the data flow, each row in
the reference table will be used.

You must make sure that the data flow takes as little time to execute as possible. Of the
following data flow components, which one should you use?

You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008. Now you are employed in a company
named NaproStar which uses SQL Server2008. You work as the technical support.
According to the requirement of the company, you are developing a SQL Server 2008
Integration Services (SSIS) data flow. The data flow extracts data from two sources. Each
source database is located on a different server. Each source is based on a SELECT
statement that uses an ORDER BY clause. Each source is based on a SELECT statement.
An ORDER BY clause is used by the statement. The following diagram presents the data
flow. The following error message pops up when the paths from the two sources are
connected to a Merge Join component. “Data Flow Task: The input is not sorted.
The ‘input “Merge Join Left Input” (80)’ must be sorted.”
You must make sure that data from each query is included in each row in the data flow. You
must achieve this goal by using as little execution time as possible.
So what action should you perform?

You are developing a SQL Server 2008 Reporting Services (SSRS) instance for
Company.com.
In order to keep all reports render to Microsoft Excel only, you should compile the items,
which are contained in the <Extension> subelement of the <Render> element in the
RSReportServer.config file.
Which is the correct answer below?

You are creating a SQL Server 2008 Integration Services (SSIS) package which gets
information from a FTP server through utilizing many FTP tasks and operate information
through utilizing many Execute SQL tasks for Company.com.

After the package downloads the files, you should make sure that you could set the package
to restart.
In order to solve the problem, which is the correct answer?

You are developing a SQL Server 2008 Integration Services (SSIS) package for
Company.com.
There is a development server called TestSQL in your package.
For the development server and the production server, you could not move the information
between them.
When you publish the package to the TestSQL server.
You get the error message below:The package could not link to the TestSQL server.
You should make sure that you could alter the package to refer to the TestSQL server when
being implemented.
Which is the correct answer?

You are developing a SQL Server 2008 Analysis Services (SSAS) method for
Company.com.
There is a dimension called DimProductTester which includes a property called PriceTester.
You should make sure that aggregations could not link to the Price property.
Which is the correct answer?