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 CIO, you design a SQL Server 2008
Integration Services (SSIS) data flow. The data flow inserts data from a source query to a
destination table. But now you must make sure that only those rows that do not already exist
in the destination table are inserted. So what should you do to accomplish this task? (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.

You make modification on a SQL Server 2008 Integration Services (SSIS) package. Look at
the following SQL Server 2008 table. The package loads the data extracted from a text file to
this table.
Now you receive an order from your company CIO, the package has to be updated to extract
data from multiple text files of the same directory.
In order to achieve this goal, 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 receive an e-mail from your company CIO, in the e-mail, the CIO assigns a task to
you.
You use SQL Server 2008 Reporting Services (SSRS) to create a solution.
There is a dimension named Number and a time dimension named Day.
A column named PresentBalance is contained in a fact table. PresentBalance contains the
current account balance.
A measure named NumberBalance has to be created from the PresentBalance column.
The NumberBalance is used to display the closing account balance for a time period. So
what action should you perform?

You are a database developer and you have about two years experience in reating 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 receive an e-mail from your company CIO, in the e-mail, the CIO assigns a task to
you.
You use SQL Server 2008 Reporting Services (SSRS) to create a solution.
Your solution includes a time dimension named DimDay.
And the DimDay dimension contains a hierarchy named Yr-Qtr-Mth.
There is a measure group named Measures01 which contains a measure named Number.
Now a calculated member has to be created, then it will be used to display the Number
measure in the previous time period for the current level of the Yr-Qtr-Mth hierarchy.
In the following options, which expression 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 receive an e-mail from your company CIO, in
the email, the CIO assigns a task to you.
You use SQL Server 2008 Reporting Services (SSRS) to create a solution. You enable
proactive caching for a partition.
A data source view (DSV) is added to the solution. The DSV contains a table which is
named Worker.
The table has two columns: WorkerKey and ExecutiveKey.
The ExecutiveKey column references the executive of the workers.
In the DSV, you have to define the relationship between the employees and their manager.
What action should you perform?

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.
Now you are in charge of a SQL Server 2008 Analysis Services (SSAS) instance.
There is a database in the instance.
After the DataDir property of the instance is changed to a new folder, you must make sure
that the instance uses the new folder with as little downtime as possible.
So what action should you perform?

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 receive an e-mail from your company CIO, in
the email, the CIO assigns a task to you.
You use SQL Server 2008 Reporting Services (SSRS) to create a solution.
There is a time dimension named DimDay in the solution.
There is a table named FinishedSales. This table contains two columns both of which refer
to the DimDay dimension.
The two columns are respectively named BillDate and MailDate.
Now you get an e-mail from your company CIO, in the e-mail the CIO posts a requirement.
The DimDay dimension must be able to be used to browse through measures in the
FinishedSales table for both BillDate and MailDate.
You have to ensure this. So what action should you perform?

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 receive an e-mail from your company CIO, in the e-mail, the CIO assigns a task to
you.
You use SQL Server 2008 Reporting Services (SSRS) to create a solution.
The solution contains a dimension named DimDay and a measure group named
FinishedSales.
The DimDay dimension contains an attribute which is named Week. The FinishedSales
references the DimDay dimension. According to the requirement of the company CIO, you
must make sure that the aggregations designed on FinishedSales always include the Week
attribute.
So what action should be performed?

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
receive an e-mail from your company CIO, in the e-mail, the CIO assigns a task to you. You
use SQL Server 2008 Reporting Services (SSRS) to create a solution. There is a table in the
solution. The table is named FinishedBills. The table contains two columns respectively
named BillKey and ClientKey. You have to create a measure, the number of customers who
have placed bills is returned by the measure. So what action should you perform?

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 receive an e-mail from your company CIO, in the e-mail, the CIO assigns a task to
you.
You use SQL Server 2008 Reporting Services (SSRS) to create a project.
Data from a SQL Server 2005 Analysis Services database will be displayed by the report.
According to the requirement of the company CIO, you must make sure that member
properties and extended properties are displayed by the report.
So what should you do?