Microsoft Transition Your MCITP: Business Intelligence Developer 2008 to MCSE: Business Intelligence 認定 070-460 試験問題:
1. You are developing a SQL Server Analysis Services (SSAS) tabular project.
You need to grant the minimum permissions necessary to enable users to query data in a tabular model.
Which role permission should you use?
A) Process
B) Explorer
C) Browser
D) Read Definition
E) Select
F) Read
2. A production SQL Server Analysis Services (SSAS) cube is processed daily. The users query products by using a hierarchy named Products from a dimension named Product.
The DimProduct table in the data source view is used as the source of the Product dimension. The table has the following structure.
The Product dimension has three attribute hierarchies:
---
Product
Subcategory
Category
The attributes have the following relationships defined: Product > Subcategory - Category. Each attribute has a key and a name sourced from the related key and name columns in theDimProduct table.
During processing, you receive the following error message: "Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_DimProducf, Column: 'SubCategoryKey', Value: '23'. The attribute is Subcategory'."
You verify that the data is accurate.
You need to ensure that the dimension processes successfully.
What should you do?
A) Relate the Subcategory and Category attributes directly to the Product attribute.
B) Remove the Subcategory attribute.
C) Remove the duplicate data from the DimProduct table.
D) Delete the Products hierarchy.
3. DRAG DROP
You have a cube named Cube1 that contains the sales data for your company.
You plan to build a report based on the cube.
You need to write an MDX expression that returns the total sales from the first month of the 2009 fiscal year and the total sales from the same period of the 2008 fiscal year.
Which code segments should you insert at line 03 and line 05? To answer, drag the appropriate code segments to the correct lines. Each code segments may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
4. You are developing a SQL Server Analysis Services (SSAS) cube for the sales department at your company.
The sales department requires the following set of metrics:
- Unique count of customers
- Unique count of products sold - Sum of sales
You need to ensure that the cube meets the requirements while optimizing query response time.
What should you do? (Each answer presents a complete solution. Choose all that apply.)
A) Place the measures in a single measure group.
B) Use the Count and Sum measure aggregation functions.
C) Use the additive measure group functions.
D) Use the semiadditive measure group functions.
E) Use the Distinct Count and Sum measure aggregation functions.
F) Place the distinct count measures in separate measure groups.
5. 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 creating a SQL Server Analysis Services (SSAS) cube.
You need to create a time dimension. It must be linked to a measure group named Sales at the day granularity level. It must also be linked to a measure group named Salary at the month granularity level.
What should you do?
A) Use the Business Intelligence Wizard to define dimension intelligence.
B) Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.
C) Use role playing dimensions.
D) Add a measure that uses the DistinctCount aggregate function to an existing measure group.
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 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.
G) Create several dimensions. Add each dimension to the cube.
H) Add a measure that uses the Count aggregate function to an existing measure group.
I) 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.
J) 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.
K) 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.
L) Add a measure group that has one measure that uses the DistinctCount aggregate function.
M) Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.
N) Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes.
O) Create a dimension. Then add a cube dimension and link it several times to the measure group.
質問と回答：
| 質問 # 1 正解： F | 質問 # 2 正解： A | 質問 # 3 正解： メンバーにのみ表示されます | 質問 # 4 正解： E、F | 質問 # 5 正解： J |
1279 お客様のコメント
品質保証JPexamはIT認定試験のシラバスに従って、試験問題の範囲を正確に絞って、的中率が99％の最新問題集を捧げます。
1年間の無料更新サービスJPexamは1年以内に問題集の無料更新サービスを提供し、お客様がいつでも最新版の問題集を持つことを保証いたします。もし試験の内容が変更されたら、弊社は直ちにお客様にお知らせします。それに、弊社の問題集が更新されたら、早速メールで最新バージョンを送付いたします。
全額返金JPexamの問題集を利用すると、短時間で勉強しても試験に合格できるのを保証いたします。試験に不合格になってしまった場合、弊社は全額返金いたします。(
ご購入前のお試しJPexamは問題集のサンプルを無料で提供いたします。ご購入前にサンプルを試用して製品の品質を確認することができます。ご遠慮なく利用してください。
