You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server2008.

You are employed in a company which is named NaproStar and work as the technical support for the company which uses SQL Server2008.
Now you are in charge of a SQL Server 2008 Reporting Services (SSRS) instance.

Currently the network security model of the instance under the domain has changed.
Your manager requires you to make sure that only Kerberos authentication will be supported by the instance.

In order to meet the requirements, 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. You implement a SQL Server 2008 Integration Services (SSIS) package. The package contains the components below:

A String variable named FileName.
A String variable named DirectoryPath.

A Foreach Loop container for the Collection property as shown in the following exhibit. (Click the Exhibit button.)
A Foreach Loop container for the Variable Mappings property as shown in the following exhibit. (Click the Exhibit button.)

In order to make the DirectoryPath variable return the directory path for the file path stored in the FileName variable, you have to update the package.
What should you do? (choose more than one)

You design a SQL Server 2008 Integration Services (SSIS) package. The package extracts data from flat files and loads this data to a SQLServer 2008 database.
The package contains two Boolean variables named @IsWeekday and @IsHoliday.
When the package is executed on week days, the @IsWeekday variable is set to True.
When the package is executed onholidays, the @IsHoliday variable is set toTrue.

You need to implement the following business logic in the control flow of the package:
– When the @IsWeekday variable is set to True, the PerformWeekday Processing Data Flow task is executed.
– When the @IsWeekday variable is set to False, thePerformWeekend Processing Data Flow task is executed.
– When the @IsHoliday variable is set toTrue, the Perform Holiday Processing Data Flow task is executed.

Which control flow logic should you implement? (Exhibit)

You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server2008.

Now you are employed in a company which is named NaproStar and work as a developer of a SQL Server 2008 Integration Services (SSIS) package for the company.
The package not only uses a Data Flow task to import the contents of the files to a table, but also uses a ForEach Loop container to process multiple files.

Besides, it uses an Execute SQL task to log the results of the status into a table. Now you are assigned a task to make sure that within a single transaction, both of a Data Flow task and a ForEach Loop container task are executed successfully, but the Execute SQL task fails to execute.

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

You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server2008.

Now you are employed in a company which is named NaproStar and work as the technical support for the company which uses SQL Server2008.
To meet the business development, you create a SQL Server 2008 Analysis Server (SSAS) solution with a measure group contained.

The measure group named Meatruth has a single partition. Now you are asked to not only make sure you have all aggregations that are part of the measure group stored in a multidimensional format, but also make sure the queries that use the measure group always refer to the newest edition of the source detail data. So what action should you perform to achieve that goal?

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.
There is a SQL Server 2008 instance. Now you are in charge of SQL Server 2008 Integration Services (SSIS) on this instance.

Now you get an order from your company, according to the company requirement, a failure recovery plan has to be created for packages that are deployed to a SQL Server.
As the IT support, you have to accomplish this task. 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.
According to the requirement of the company CIO, you develop a report by using SQL Server 2008 Reporting Services (SSRS).

The report utilizes the "User!UserID" expression in a text box within the report header.
Now you get a requirement from your company Manager, data-driven subscriptions must successfully execute for this report.

So what should you do to make sure of this?

You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server2008.

You are employed in a company which is named NaproStar and work as the technical support for the company which uses SQL Server2008 Reporting Services (SSRS).
Now you are using SSRS to create a report and you attempt to have the report deployed on a report server.

In order to have the report delivered to a dynamic list of subscribers regularly, a new subscription should be created on the report server.
What action should you perform to achieve this goal?