Microsoft Transition Your MCITP: Business Intelligence Developer 2008 to MCSE: Business Intelligence 認定 70-460 試験問題:
1. 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) an Indicator
B) a Gauge that uses the Radial type
C) a Data Bar
D) a Sparkline
E) a Gauge that uses the Linear type
2. 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 F
C) Option D
D) Option A
E) Option E
F) Option C
3. HOTSPOT
You are developing a SQL Server Analysis Services (SSAS) cube.
You are writing the following Multidimensional Expressions (MDX) statement for use by a calculated measure. The measure computes the sales amount for the same time period of the previous year. (Line numbers are included for reference only.)
You need to complete the MDX statement. Which MDX function should you use in line 03? To answer, select the appropriate MDX
function in the functions list.
4. You execute the SalesbyCategory report and receive the following error message: "Members, types, or sets must use the same hierarchies in the function."
You need to ensure that the query executes successfully.
Which two actions should you perform? Each correct answer presents part of the solution.
A) Move the Date and Product clauses on line 11 to axis
B) Move the Product clause from line 08 to line 10.
C) Move the Date clause from line 10 to line 08.
D) Move the Measures clause on line 02 to axis 1.
5. DRAG DROP
You need to extend the schema design to store the product dimension data.
Which design should you use?
To answer, drag the appropriate table or tables to the correct location or locations in the answer area. (Fill from left to right. Answer choices may be used once, more than once, or not all.)
質問と回答：
| 質問 # 1 正解： A | 質問 # 2 正解： D | 質問 # 3 正解： メンバーにのみ表示されます | 質問 # 4 正解： B、D | 質問 # 5 正解： メンバーにのみ表示されます |
832 お客様のコメント
品質保証JPexamはIT認定試験のシラバスに従って、試験問題の範囲を正確に絞って、的中率が99％の最新問題集を捧げます。
1年間の無料更新サービスJPexamは1年以内に問題集の無料更新サービスを提供し、お客様がいつでも最新版の問題集を持つことを保証いたします。もし試験の内容が変更されたら、弊社は直ちにお客様にお知らせします。それに、弊社の問題集が更新されたら、早速メールで最新バージョンを送付いたします。
全額返金JPexamの問題集を利用すると、短時間で勉強しても試験に合格できるのを保証いたします。試験に不合格になってしまった場合、弊社は全額返金いたします。(
ご購入前のお試しJPexamは問題集のサンプルを無料で提供いたします。ご購入前にサンプルを試用して製品の品質を確認することができます。ご遠慮なく利用してください。
