MCSA 70-778 Study Guide

  1. When you connect to an Access database, which entities are shown in the Navigator window?
    Tables from the Access database
  2. Explain the "Applied Steps" area of the Query Editor window.
    • - The recorded list follows the sequence of steps applied to the data source
    • - It records the list of steps from connecting to the data source to all the steps applied to the data
    • - You can modify the connection to the data source by modifying the Source step settings
  3. Name three transformations available when you right-click a column header in the Query Editor window
    Remove, Change Type, Duplicate Column
  4. When using the "Split Column by Delimited" transformation, which option may result in more than two new columns?
    Delimited "at each occurrence of the delimiter."
  5. Which three views are available in Power BI Desktop?
    Report, Data, and Relationships
  6. How do refreshes work when you append two queries together?
    Both queries you're appending will be refreshed.
  7. Which transformation option converts rows as columns and columns as rows?
    Transpose
  8. You should totally look up "Calculated Tables" and learn more about them.
    You should totally look up "Calculated Tables" and learn more about them.
  9. Which two cross filter directions are available in Power BI table relationships?
    "Single" and "Both"
  10. How do you hide a field in the "Data" view?
    Right-click the column header and click "Hide in Report View"
  11. How do you hide a field in the "Relationships" view?
    Right-click the field on the respective table and click "Hide in Report View"
  12. Name three reasons to use calculated tables
    • 1. To union tables
    • 2. To perform different types of merge joins
    • 3. To create a table based on the result of a function or formula
Author
tjneal
ID
348038
Card Set
MCSA 70-778 Study Guide
Description
Studying for my exam
Updated