Pass with professional 070-460 actual quiz materials

Microsoft 070-460 Exam Overview:

Microsoft 070-460 Exam Syllabus Topics:

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

1. After you deploy the RegionalSales report, users report that they cannot see product data when they receive the reports by email.
You need to ensure that the sales department managers can see all of the data.
In the report, you update the Hidden property of each group.
What should you do next?

A) In When the report is initially run, select Show or hide based on an expression. Se: The expression to =NOT (GlobalslRenderFormat.IsInteractive)
B) In When the report is initially run, select Show or hide based on an expression. Set the expression to = (GlobalsIRenderFormaUsInteractive).
C) In when the report is initially run, select Show.
D) In When the report is initially run, select Hide.

2. You are designing a SQL Server Reporting Services (SSRS) report based on a SQL Server Analysis Services (SSAS) cube. The cube is used to measure sales growth by salesperson.
The cube contains a Key Performance Indicator (KPD to show if a salesperson's sales are off target, slightly off target, or on target.
You need to add a report item that visually displays the KPI status value as a red, yellow, or green flag.
Which report item should you add?

A) a Data Bar
B) a Gauge that uses the Radial type
C) a Gauge that uses the Linear type
D) a Sparkline
E) an Indicator

3. You are developing a SQL Server Analysis Services (SSAS) cube named Sales Planning. The cube consists of two measure groups named Sales and Planning. Each measure group is based on a data warehouse fact table and consists of a single MOLAP partition that has the same name as its measure group.
The Planning measure group consists of two measures:
- Forecast, which uses the Sum aggregate function
- Forecast Count, which uses the Count aggregate function
Users contribute planning values by using a legacy application. An extract, transform, load (ETL) process is scheduled to periodically transfer the planning values from the database of the legacy application to the data warehouse.
Financial analysts query the Sales Planning cube and report that the planning values are sometimes out of date. A new company requirement mandates that the planning values be entered directly into the cube by using Microsoft Excel 2010 PivotTable What-If Analysis.
You need to write-enable the Planning partition.
What should you do before write-enabling the partition?

A) Set the ProcessingMode property of the Planning partition to LazyAggregations.
B) Set the StorageMode property of the Planning partition to Rolap
C) Remove the Forecast Count measure.
D) Set the ProcessingMode property of the Planning measure group to LazyAggregations.
E) Set the Type property of the Planning measure group to Budget.
F) Convert the Planning measure group to a linked measure group.

4. 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 F
B) Option B
C) Option E
D) Option D
E) Option C
F) Option A

5. You are troubleshooting query performance for a SQL Server Analysis Services (SSAS)
cube.
A user reports that a Multidimensional Expressions (MDX) query is very slow.
You need to identify the MDX query statement in a trace by using SQL Server Profiler.
Which event class should you use?

A) Query Begin
B) Query Subcube
C) Get Data From Aggregation
D) Calculate Non Empty Begin
E) Progress Report Begin
F) Execute MDX Script Begin

Solutions: