Microsoft TS:MS SQL Server 2008.Business Intelligence Dev and Maintenan Sample Questions:

1. Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You develop a SQL Server 2008 Reporting services (SSRS) instance of a report model.
The organization requires that users of a report be able to dynamically change the server environment.
You need to create a parameter that gives the user the option to choose the server before report execution.
What should you do?

A) Create a dynamic dataset that includes a list of the different users.
B) Create a dynamic dataset that utilizes the WHERE clause to filter by the parameter.
C) Configure the Internal Visibility option for the parameter.
D) Create a distinct dataset that includes all possible values and attach it to the parameter.
E) Create a dynamic data source from a dataset by using the IN operator.
F) Develop a report for each environment.
G) Configure the Hidden Visibility property.
H) Create a dynamic data source from a dataset that includes a list of distinct servers.

2. You create a SQL Server 2008 Analysis Services (SSAS) solution.
The cube structure is as shown in the following exhibit. (Click the Exhibit button.)
You need to ensure that the Amount measure can be aggregated for the DimCustomer dimension.
What should you do?

A) Create a referenced relationship between DimCustomer and FactCustomerAccount. Set DimAccount as an intermediate dimension.
B) Create a many-to-many relationship between DimCustomer and FactCustomerAccount. Set FactTransaction as an intermediate measure group.
C) Create a many-to-many relationship between DimCustomer and FactTransaction. Set FactCustomerAccount as an intermediate measure group.
D) Create a regular relationship between DimCustomer and FactTransaction.

3. You create a SQL Server 2008 Analysis Services (SSAS) solution. The solution includes a table named FactOrders that contains two columns as shown in the following table: Column Name Description OrderKey primary key for FactOrders CustomerKey relates to the customer who places the order You need to create a measure that returns the number of customers who have placed orders. What should you do?

A) Set the Usage property to Distinct count and the Source Column property to OrderKey.
B) Set the Usage property to Count of rows and the Source Column property to OrderKey.
C) Set the Usage property to Distinct count and the Source Column property to CustomerKey.
D) Set the Usage property to Count of rows and the Source Column property to CustomerKey.

4. Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You maintain a SQL Server 2008 Reporting Services (SSRS) instance for a shoe company.
An existing report on shoe sales allows the user to see the company's revenue across many different
attributes.
You need to create a drop down list that filters the report by one or more shoe colors.
You alter the main dataset and configure the report parameter to accept multiple values.
What should you do next?

A) Create a dynamic dataset that includes a list of the different users.
B) Create a dynamic dataset that utilizes the WHERE clause to filter by the parameter.
C) Configure the Internal Visibility option for the parameter.
D) Create a distinct dataset that includes all possible values and attach it to the parameter.
E) Create a dynamic data source from a dataset by using the IN operator.
F) Develop a report for each environment.
G) Configure the Hidden Visibility property.
H) Create a dynamic data source from a dataset that includes a list of distinct servers.

5. You maintain SQL Server 2008 Integration Services (SSIS) on a SQL Server 2008 instance. You need to design a failure recovery plan for packages that are deployed to a SQL Server. What should you do?

A) Back up the MSDB database.
B) Back up the master database.
C) Back up the model database.
D) Back up the tempdb databse.

Solutions: