70-466 Exam test answers and questions

70-466 Exam
Exam Number/Code : 70-466
Exam Name : Implementing Data Models and Reports w/MS SQL Server 2012
70-466 exam is an important Microsoft other Certification certification which can test your professional skills. Candidates want to pass the exam successfully to prove their competence. Passokay Microsoft other Certification technical experts have collected and certified 246 questions and answers of 70-466 exam which are designed to cover the knowledge points of the Interconnecting Microsoft other Certification Networking Devices Part 1 and enhance candidates' abilities. With Passokay 70-466 preparation tests you can pass the 70-466 exam easily, get the CCENT certification and go further on Microsoft other Certification career path.
Questions and Answers : 180 Q&As
Update Time: 2014-06-05
http://www.passokay.com/70-466.html
http://www.passokay.com/pdf/70-466.pdf

Question: 1
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
•PercentageOfOwnership, which is a regular attribute When users browse the dimension, four hierarchies are visible to them. You need to ensure that the Organization and PercentageOfOwnership hierarchies are not visible to users. What should you do?
A. Delete the Organization and the PercentageOfOwnership attributes.
B. Set the AttributeHierarchyVisible property to False for the Organization and PercentageOfOwnership attributes.
C. Set the AttributeHierarchyEnabled property to False for the Organization and PercentageOfOwnership attributes.
D. Set the AttributHierarchyDisplayFolder property to Null for the Organization and PercentageOfOwnership attributes.
Answer: B

Question: 2
You are designing a SQL Server Analysis Services (SSAS) cube based on a Microsoft Azure SQL Database data warehouse. You need to implement a degenerate dimension. What should you do?
A. Use the fact table as the data source for the dimension.
B. Add a surrogate key to the fact table and use it as the degenerate dimension key.
C. Create snowflake dimension tables based on normalized views of the fact table in the data source.
D. Create a junk dimension table based on the fact table in the data source.
Answer: A

Question: 3
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: 4
You are developing a SQL Server Analysis Services (SSAS) multidimensional database. The underlying data source does not have a time dimension table. You need to implement a time dimension. What should you do?
A. Add an existing SSAS database time dimension as a cube dimension.
B. Use the SQL Server Data Tools Dimension Wizard and generate a time table on the server.
C. Use the SQL Server Data Tools Dimension Wizard and generate a time table in the data source.
D. Use the SQL Server Data Tools Dimension Wizard and generate a time dimension by using the Use an existing table option.
E. Create a CSV file with time data and use the DMX IMPORT statement to import data from the CSV file.
F. Create a time dimension by using the Define time intelligence option in the Business Intelligence Wizard.
G. Create a time dimension by using the Define dimension intelligence option in the Business Intelligence Wizard.
H. Create a script by using a sample time dimension from a different multidimensional database. Then create a new dimension in an existing multidimensional database by executing the script.
Answer: B OR C

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