연습문제부터 모의고사, 업데이트까지 Microsoft Transition Your MCITP: Business Intelligence Developer 2008 to MCSE: Business Intelligence 준비에 필요한 모든 것을 DumpTOP에서 한 번에 해결하실 수 있습니다. 070-460 시험 대비 자료 82 문항과 함께라면 계획적인 학습이 가능합니다.

Microsoft 070-460 시험 개요:

Microsoft 070-460 시험 요강 주제:

Microsoft 070-460 응시 전 꼭 확인해야 할 질문들

최신 MCITP 070-460 무료샘플문제

문제 #1

You are deploying the Research model.
You need to ensure that the data contained in the model can be refreshed.
What should you do?

A. Upload MarketResearch.xIsx to Library1.
B. Assign the Tabular instance service account permissions to the MarketResearch.xlsx network location.
C. Import MarketResearch.xIsx to a new tabular database on the Tabular instance.
D. Create a SQL Server Integration Services (SSIS) package that imports data from MarketResearch.xIsx nightly. Load the data to CUBE1,

문제 #2

You are developing a SQL Server Analysis Services (SSAS) cube. The cube contains several dimensions, a local measure group, and a linked measure group. Both measure groups use MOLAP partitions.
You need to write-enable one of the linked measure group partitions to support Microsoft Excel 2010 PivotTable What-If Analysis.
What should you do before the partition can be write-enabled?

A. Implement the linked measure group as a local measure group.
B. Implement the cube as a local cube.
C. Ensure that the measure group measures only use nonadditive aggregation functions
D. Ensure that the measure group measures only use semiadditive aggregation functions.

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

문제 #4

The Sales database includes a table named Products that contains 42 columns, and two tables that record all product sales transactions. The database does not store aggregated data. The database is continually maintained to provide optimal indexing. The database server is sized appropriately.
The Marketing department requests a delimited text file that includes seven fields containing product information from the Products table. You have the following requirements:
- Display the ProductID in the first column. Organize the remaining columns alphabetically by column heading.
---
Sort rows in ProductID order.
Aggregate product units sold.
Minimize the time required to return the results.
You create a SQL Server Integration Services (SSIS) package and add the appropriate connection managers and a Data Flow task.
You need to develop the Data Flow task.
What should you add to the Data Flow task? (More than one answer choice may achieve the goal. Select the BEST answer.)

A. A table-based OLE DB source; a Script component and a Flat File destination.
B. A table-based OLE DB source; Lookup, Aggregate, and Sort transformations; and a Flat File destination.
C. Only a SQL command-based OLE DB source and a Flat File destination.
D. A SQL command-based OLE DB source; Aggregate and Sort transformations; and a Flat File destination.

문제 #5

You need to implement the aggregation designs for the cube.
What should you do?

A. Use the Aggregation Design Wizard.
B. Implement cache warming in SSAS via an SSIS package.
C. Partition the cube by month.
D. Use the Usage-Based Optimization Wizard.

질문과 대답: