{br} STUCK with your assignment? {br} When is it due? {br} Get FREE assistance. Page Title: {title}{br} Page URL: {url}
UK: +44 748 007-0908, USA: +1 917 810-5386 [email protected]

QUESTION 1

  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
  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
  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
  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
  5. Power Pivot-driven PivotTables will allow you to create Calculated Fields.
    True
    False
    0.9 points
    QUESTION 6
  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
  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
  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
  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
  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
  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
  12. Using the file ImportText.txt, what is the sum of the TransCost column?

Sample Solution 

This question has been answered.

Get Answer
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, how can I help?