Calculated Columns Tables Quiz

5 questions • Pass: 70% • +25 pts

Quiz covering Design and Implement a Data Model

Calculated Columns Tables Quiz

5 questions | Pass: 70% | Earn 25 points

Questions in this quiz

A preview of the 5 questions covered. Start the quiz above to answer them, check your score, and read the explanations.

  1. 1

    Which of the following best describes the primary purpose of a calculated column in a data model?

  2. 2

    When should you choose to create a calculated column instead of a measure?

  3. 3

    You have a 'Sales' table with 'Quantity' and 'Price' columns. You want to create a 'Total Cost' column for every row. What is the main drawback of creating this as a calculated column?

  4. 4

    If you create a calculated column using a DAX formula that references another table, what must exist for the calculation to work correctly?

  5. 5

    You are creating a calculated column that performs a lookup to another table using RELATED(). What happens if the relationship between the tables is deleted after the column is created?