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?
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
Support mcqgeeks.com by disabling your adblocker.
Please disable the adBlock and continue. Thank you.