70-466 Question #155: Real Exam Question with Answer & Explanation

You have three databases named DB1. DB1 contains three tables named FactSales, DimCustomer, and DimEmployee. A sample from DimEmployee is shown in the following table:

EmployeeID	Name	Title	Managers
1	Kim Abercrombie	CEO	Not applicable
20	Brad Sutton	Sales Manager	1
31	Don Funk	Sales Supervisor	20
123	Diane Margheim	Sales Associate	31

A sample from DimCustomer is shown in the following table:

CustomerID	Name	City	State	Country
1	Contoso, Ltd.	Miami	FL	United States
2	Adventure Works	Montreal	QC	Canada
3	Woodgrove Bank	London		United Kingdom

A sample from FactSales is shown in the following table:

ID	Customer	Employee	Date	Amount
21	1	20	1/1/2012	2345.67
27	2	123	1/1/2012	23254.45
34	3	31	1/2/2012	43543.56

You create a cube named Sales that uses the three tables. FactSales is used as a fact table, DimCustomer is used to create a dimension named Customer, and DimEmployee is used to create a dimension named Employee. Users report the following issues:

• When browsing the Customer dimension, the users see a blank member in the state hierarchy under United Kingdom.
• When browsing the Employee dimension, the sales data for Sales Managers and Sales Supervisors is NOT displayed.

You need to resolve the issues by configuring the properties of the dimension attributes. What should you do? To answer, select the appropriate value for each property in the answer area.