You are managing a SQL Server 2008 server instance which is use for running SQL Server 2008 Integration Services (SSIS) packages for Company.com.

You should make sure that the server runs normally.

Which is the correct answer?

You are creating a SQL Server 2008 Integration Services (SSIS) instance which utilizes a default connection manager to link to a component for Company.com.

In order to provide authentication for your report, you develop an XML configuration file.
You increase the file to an XML configuration file. But you get error message that you could not login when you running the package.

You should make sure that you should run the package normally.
Which is the correct answer?

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 Analysis Services (SSAS) solution.
You are asked to develop a (SSAS) database with several measure groups. After the development, you notice that of these measure groups, one measure group named Product Data needs more updates than other measure groups. Besides, SSAS manages a schedule named Sch1.

Now you are assigned a task to make sure that the Product Data measure group will process on Sch1 automatically.
So of the following properties, which one would be modified?

To render correctly the report with dataset for 25 column to Excel what would you use

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. You are in charge of a SQL Server 2008 Reporting Services (SSRS) instance and you use it to create a report, which is so complex that it needs a few minutes to generate.
Now you are assigned a task to find a solution to configure the report server so that it can be cached for half an hour after the original request.

Which solution should be chosen to accomplish this task?

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

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

You get report from users saying that some queries run slowly. As the technical support, you have to check and identify the problem.

You intend to use SQL Profiler to troubleshoot query performance. Of the following trace events, which one should you choose?

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 e-mail, the CIO assigns a task to you.

You implement a SQL Server 2008 Analysis Services (SSAS) solution.
In a Decision Tree data mining structure, you query a data mining model by using data mining extensions (DMX). You write the following DMX code segment. (Line numbers are used for reference only.)

1 SELECT
2 [Decision Tree].[Bike Buyer] AS Buyer
3 FROM
4 [Decision Tree]
6 (SELECT 28 AS [Age],
5. …………
7 ‘2-5 Miles’ AS [Commute Distance],
8 ‘1’ AS [House Owner Flag],
9 1 AS [Number Cars Owned],
10 2 AS [Total Children]) AS t

You must make sure that the input columns automatically map to the columns in the data mining structure. At line 5, which code fragment should be inserted?

You are creating a SQL Server 2008 Analysis Services (SSAS) database which contains some measure groups for Company.com.

One of measure groups Product Data allows refresh Than others’ frequently.
You should make sure that Product Data measure group would operate on a schedule managed through SSAS.

Which is the correct answer?

You are developing a SQL Server 2008 Analysis Services (SSAS) method for Company.com.

There is a table called Product which includes listed columns below:
* ProductKey
* Logger
* ProductNumber

Firstly you develop a dimension called DimProductOrders from the Product table, and then configure the ProductKey as a key column and the Logger column as a property.
At last you create a measure group called FactProductOrders from the Product table.
You should make sure that you could develop a dimension relationship .
Then you could make ProductNumber column gathered by the Logger column.

Which is the correct answer?