70-466 Exam Questions with Answers

Product Description
70-466 Exam
Implementing Data Models and Reports w/MS SQL Server 2012
Exam Number/Code : 70-466
Exam Name : Implementing Data Models and Reports w/MS SQL Server 2012
Questions and Answers : 180 Q&As
Update Time: 2014-11-11
Price: $ 99.00
http://www.exam1pass.com/70-466-exam.html
http://www.exam1pass.com/Microsoft-series.html


Question: 1
You are developing a SQL Server Analysis Services (SSAS) cube. You must create a four-level hierarchy for the employee dimension. Each level must be associated with an attribute in the employee dimension table. Two thirds of the dimension data contain values for all four attributes. The remainder of the dimension data contains values for the first three of the four attributes only. You need to create the hierarchy so that logically missing members will not be shown by the reporting tool. Which type of hierarchy should you create?
A. a ragged hierarchy
B. a sparse hierarchy
C. a balanced hierarchy
D. a parent-child hierarchy
Answer: A

Question: 2
You are conducting a design review of a multidimensional project. In the Customer Geography dimension, all non-key attributes relate directly to the key attribute. The underlying data of the Customer Geography dimension supports relationships between attributes. You need to increase query and dimension processing performance. What should you do?
A. For the Customer Geography dimension, set the ProcessingPriority property to 1.
B. For the Customer Geography dimension, set the ProcessingMode property to LazyAggregations.
C. For the dimension attributes of the Customer Geography dimension, set the GroupingBehavior property to EncourageGrouping.
D. For the dimension attributes of the Customer Geography dimension, define appropriate attribute relationships.
Answer: D

Question: 3
You are developing a multidimensional project that includes a dimension named Organization. The dimension is based on the DimOrganization table in the data warehouse. The following diagram illustrates the table design.
The Organization dimension includes a parent-child hierarchy named Organizations. The dimension includes the following dimension attributes:
?Organization, which is a key attribute
?Organizations, which defines the parent-child hierarchy
?Currency Code, which is a regular attribute When users browse the dimension, three hierarchies are visible to them. You need to ensure that the Organization hierarchy is not visible to users. What should you do?
A. Delete the Organization attribute.
B. Set the AttributeHierarchyVisible property to False for the Organization attribute.
C. Set the AttributeHierarchyEnabled property to False for the Organization attribute.
D. Set the AttributeHierarchyDisplayFolder property to Null for the Organization attribute.
Answer: B

Question: 4
You need to modify the Sales Regions hierarchy to meet the reporting requirements. Which SSAS feature should you use?
A. Action
B. Calculation
C. Perspective
D. Translation
Answer: D

Question: 5
You need to meet the browsing requirements for the Products hierarchy. Which property should you modify?
A. HideMemberIf
B. RootMemberIf
C. AttributeHierarchyDisplayFolder
D. DefaultMember
Answer: A

Question: 6
You need create the data source view for the StandardReports project. What should you do?
A. Create a new data source view and then use the Import from Table wizard.
B. Create a data source, connect it to the data warehouse, and then use the Data Source View wizard.
C. Execute the Import from Table wizard and then use the Data Source View wizard.
D. Generate a relational schema from the dimensions and cubes by using the Schema Generation wizard.
Answer: B