Purchase Microsoft : 70-460 Exam Materials and then pass exam easily

Microsoft 70-460 Exam Overview:

Microsoft 70-460 Exam Syllabus Topics:

Microsoft Transition Your MCITP: Business Intelligence Developer 2008 to MCSE: Business Intelligence Sample Questions:

1. Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.
You are designing a SQL Server Analysis Services (SSAS) cube.
You need to create a measure to count unique customers.
What should you do?

A) Create a dimension with one attribute hierarchy. Set the IsAggrcgatable property to False and then set the DefaultMember property. Use a regular relationship between the dimension and measure group.
B) Use the Business Intelligence Wizard to define dimension intelligence.
C) Use role playing dimensions.
D) Add a measure that uses the Count aggregate function to an existing measure group.
E) Create a dimension. Then add a cube dimension and link it several times to the measure group.
F) Create several dimensions. Add each dimension to the cube.
G) Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.
H) Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.
I) Add a measure that uses the DistinctCount aggregate function to an existing measure group.
J) Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes.
K) Create a new named calculation in the data source view to calculate a rolling sum. Add a measure that uses the Max aggregate function based on the named calculation.
L) Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a many-to-many relationship to link the dimension to the measure group.
M) Add a measure group that has one measure that uses the DistinctCount aggregate function.
N) Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a many-to-many relationship to link the dimension to the measure group.
O) Create a dimension with one attribute hierarchy. Set the ValueColumn property, set the IsAggregatable property to False, and then set the DefaultMember property. Configure the cube dimension so that it does not have a relationship with the measure group. Add a calculated measure that uses the MemberValue attribute property.

2. DRAG DROP
You are developing a SQL Server Reporting Services (SSRS) report that sources data from a SQL Azure database and a SQL Server Analysis Services (SSAS) cube. The cube contains a date dimension and other dimensions. The report design includes two report
parameters named StartDate and FinishDate as shown in the following diagram.

The Data Type property of the parameters is set to Date/Time.
You need to create the dataset based on the SSAS cube. You also need to ensure that the dataset is filtered by the existing report parameters.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

3. DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) cube.
You need to add a calculated member to the Customer dimension to evaluate the sum of values for the United Kingdom and the United States.
Which expression should you use? (To answer, drag the appropriate expression to the answer area.)

4. DRAG DROP
You are developing a SQL Server Reporting Services (SSRS) report to display a list of employees. The report will be embedded into a Microsoft SharePoint Server Web Part Page of the company intranet site.
The report consists of a single table. The design of the table is shown in the following diagram.

You need to configure the EmailAddress detail text box to create a new email message. The email message must be addressed to the email address that was clicked by the user.
Which four actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

5. DRAG DROP
You are designing a business intelligence (BI) solution for a hotel booking system. Each hotel booking may have more than one guest.
The BI solution contains a fact table named Booking, a factless fact table named Booking_Guest and a dimension named Guest.
Booking contains an entry for each booking. Booking_Guest contains an entry for each guest in each booking. Guest contains an entry for each guest.
You need to define the many-to-many relationship in SQL Server Analysis Services (SSAS) for the hotel booking system.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Solutions: