Q.1
The topic of discussion of Power BI Session 4 is
  • Overview
  • Data Collection
  • Data Preparation
  • Introduction to DAX
Q.2
What is the common flow of activity in Power BI?
  • Create a report in Power BI mobile, share it to the Power BI Desktop, view and interact in the Power BI service.
  • Create a report in the Power BI service, share it to Power BI mobile, interact with it in Power BI Desktop.
  • Bring data into Power BI Desktop and create a report, share it to the Power BI service, view and interact with reports and dashboards in the service and Power BI mobile.
  • Bring data into Power BI mobile, create a report, then share it to Power BI Desktop.
Q.3
Contains transactional data or facts of a business process
  • Dimension table
  • Fact table
  • Query table
  • Power BI table
Q.4
Which of the following are building blocks of Power BI?
  • Tiles, dashboards, databases, mobile devices.
  • Visualizations, datasets, reports, dashboards, tiles.
  • Visual Studio, C#, and JSON files.
Q.5
What DAX function can be used to return a value in a column if a condition is met?
  • SUM
  • IF
  • VLOOKUP
  • COUNT
Q.6
A collection of data that you import or connect to
  • Datasets
  • Dashboards
  • Reports
  • All of the above
Q.7
A customer may purchase 1 or many products. So the relationship between the customer table and the products table will be
  • Many to One
  • One to Many
  • Many to Many
  • One to One
Q.8
A dimension is a descriptive information to help us slice the data. Examples of dimension includes customer name, customer age, product id, product descriptive etc
  • False
  • True
Q.9
What is the Power Bi file Format?
  • .pbix
  • .pbi
  • .xlsx
  • .xls
Q.10
What are the group of data sources can Power BI connect to?
  • Files, SQL, Azure
  • Files, Content Packs, Connectors
  • Databases, SQL, Azure
  • Content Packs, Connectors, SQL
Q.11
Power Query Editor is the platform we use to transform data like changing column data types and removing columns and rows
  • False
  • True
Q.12
Which is used to calculate the data in each row
  • Counting
  • Calculated Row
  • Measure
  • Calculated Column
Q.13
Which of the following statements is true about shaping data with Power BI Desktop?
  • The order in which you shape or transform data doesn't matter, it all comes out the same.
  • When shaping or transforming data in Power BI Desktop, the source data remains unchanged.
  • When shaping or transforming data in Power BI Desktop, the source data is also shaped and transformed.
Q.14
Which of the following tools let you shape data sources?
  • The Power BI Gateway
  • The Relationships view in Power BI Desktop
  • The Power BI admin portal
  • Power Query Editor in either Power BI Desktop or Power BI Service
Q.15
Contains reference data such as descriptive attributes
  • Dimension table
  • Fact table
  • Query table
  • Power BI table
Q.16
Type of data modeling in Power BI that Uses Data Analysis Expressions and similar to Excel formulas
  • M
  • Query
  • DAX
  • Model
Q.17
What symbol would you use for multiplication in Power BI in a DAX formula? (also in SQL)
  • *
  • +
  • -
  • /
Q.18
Only domains with a Power BI license (subscribed through Officecan embed the web link of a Power BI Report.
  • True
  • False
Q.19
Sometimes, referred to as Power BI online
  • Query Editor
  • Power BI
  • Power BI Service
  • Visual Market Place
Q.20
In the data view, we are able to view the tables that we have imported. Each table shown is from a specific excel worksheet.
  • False
  • True
0 h : 0 m : 1 s