QUESTION 1
- You have US census figures for population by year, income bracket, and state. You want to see a 2 dimensional table of just income bracket and state for the calendar year 2000. Which OLAP operation would you use?
pivot/Rotate
drill Down
roll Up
slice
none of the given choices describe this
0.9 points
QUESTION 2 - You have US census figures for population by year, income bracket, and state. You want to see a 2 dimensional table of just income bracket and state for the calendar year 2000. Which OLAP operation would you use?
pivot/Rotate
drill Down
roll Up
slice
none of the given choices describe this
0.9 points
QUESTION 3 - Which of the following is generally true of MOLAP tables?
They require more hard drive capacity than ROLAP tables.
They require more processing power than ROLAP tables.
Both A and B are true
None of the given choices are true
1.4 points
QUESTION 4 - When creating a Power Pivot-driven PivotTable, you may either create it on a new worksheet or an existing one.
True
False
0.9 points
QUESTION 5 - Power Pivot-driven PivotTables will allow you to create Calculated Fields.
True
False
0.9 points
QUESTION 6 - In the brewery.xlsx file, which of the following is the primary index key for table2?
Product Name
Debut
Style
ProductID
ABV%
1.4 points
QUESTION 7 - Use the Brewery.xlsx file to answer the following question: What’s the name of the product with the highest total revenue?
Black Manatee
Evil Squid
Bruin
Extended Puppy
Rearview
0.9 points
QUESTION 8 - Use the Brewery.xlsx file to answer the following question: What’s the name of the product with the lowest total cost (not unit cost, but cost of all units consumed)?
Flyin Squirrel
Mud Guard
Lotus
Former Weasel
Subatomic Glove
0.9 points
QUESTION 9 - Use the Brewery.xlsx file to answer the following question: What’s the sum of revenue for those beers whose product name contains the letter “I”?
251698.5
321017.5
147895.21
159823.25
400256.89
1.4 points
QUESTION 10 - Which button in the Power Pivot Home Ribbon allows you to load data from an external excel file?
From Database
From Data Service
From Other Sources
Existing Connections
None of the Above
0.9 points
QUESTION 11 - Which button in the Power Pivot Home Ribbon allows you to load data from a text file?
From Database
From Data Service
From Other Sources
Existing Connections
None of the Above
0.9 points
QUESTION 12 - Using the file ImportText.txt, what is the sum of the TransCost column?
Sample Solution