Learn with Microsoft : 70-460 training material for 100% pass

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. You are creating a new report in SQL Server Report Builder. You add a Windows Azure SQL Database data source. Then you add a dataset that has four fields named Year, Country, Category, and Sales.
You must design a matrix as shown in the following table.

The category rows (the first three rows as shown in the diagram) must present total sales amount by category. The country rows (the next six rows as shown in the diagram) must present total sales amount by country. The total row must present the total sales for each year.
You add a matrix to the report. You add a grouping of the Country field on the rows and a grouping of the Year field on the columns.
You need to add the categories on the rows of the matrix.
Which Row Group option should you select when you add the group?

A) Parent Group
B) Child Group
C) Adjacent Below
D) Adjacent Above

2. You need to use SQL Server Management Studio (SSMS) to make the SSAS databases available for application testing.
What should you do?

A) Use the Import/Export Wizard to copy the databases from the production server to the development server.
B) Script the databases as a Create script to a new window and then execute the script on SSAS01.
C) Restore the SSAS databases from the latest backup to SSAS01.
D) Detach the SSAS databases from the SSASCluster, and then attach them to SSAS01.

3. 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) Add a measure that uses the DistinctCount aggregate function to an existing measure group.
B) Create a dimension. Then add a cube dimension and link it several times to the measure group.
C) 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.
D) Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.
E) 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.
F) 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.
G) Use role playing dimensions.
H) Create several dimensions. Add each dimension to the cube.
I) Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.
J) Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes.
K) Use the Business Intelligence Wizard to define dimension intelligence.
L) Add a measure group that has one measure that uses the DistinctCount aggregate function.
M) Add a measure that uses the Count aggregate function to an existing measure group.
N) 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.
O) 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.

4. DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) tabular project based on a Microsoft Azure SQL Database database. The ProcessingOption property for the project is set to Do Not Process.
Several calculated columns have been added to a table. The project has been deployed to the production server.
You need to ensure that newly added data is processed on the production server.
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.)

5. You are developing a SQL Server Analysis Services (SSAS) tabular project.
A column named City must be added to the table named Customer. The column will be
used in the definition of a hierarchy. The City column exists in the Geography table that is
related to the Customer table.
You need to add the City column to the Customer table.
How should you write the calculation?

A) Option B
B) Option E
C) Option A
D) Option D
E) Option F
F) Option C

Solutions: