Name: Score:
154 Multiple choice questions
Term 1 of 154
You need to create a bar chart showing the percentage of internet access for equal age
ranges of 10 years.
Which four actions should you perform in sequence?
Remove the PO prefix from the PO Number column and change the data type to Whole
Number.
Add a new column to the Purchase Order table and perform a lookup to set the Vendor
Id from Vendor column
Select Apply security filter in both directions
Set the Cross filter direction option to Both.
Power Query
Azure Data Lake Gen2
Common Data Model folders
Right click on the Age column and select New Group.
Set Group type to Bin.
Set the Bin type to Number of Bins.
Set the Bin count to 7.
,Term 2 of 154
Hide specific filters:
No
Yes
No
No
No
Yes
Yes
Yes
Yes
Yes
No
No
Yes
,Term 3 of 154
To use scikit-learn machine learning in visuals:
To take actions from within a report:
To use JavaScript to create visuals:
Viewer Contributor Member
Power Bi Service 48 Import
Promoted
Python
Power Apps
D3
, Term 4 of 154
You need to create visualizations that display the total price of orders for each quarter, based
on both the OrderDate and the ShippingDate columns.
How should you create the measure for sales by shipping date?
COLUMN DISTRIBUTION
CALCULATE
SUM
USERELATIONSHIP
AMOUNT
TYPENAME
CALCULATE
DATEADD
YEAR
_PREV_YEAR
154 Multiple choice questions
Term 1 of 154
You need to create a bar chart showing the percentage of internet access for equal age
ranges of 10 years.
Which four actions should you perform in sequence?
Remove the PO prefix from the PO Number column and change the data type to Whole
Number.
Add a new column to the Purchase Order table and perform a lookup to set the Vendor
Id from Vendor column
Select Apply security filter in both directions
Set the Cross filter direction option to Both.
Power Query
Azure Data Lake Gen2
Common Data Model folders
Right click on the Age column and select New Group.
Set Group type to Bin.
Set the Bin type to Number of Bins.
Set the Bin count to 7.
,Term 2 of 154
Hide specific filters:
No
Yes
No
No
No
Yes
Yes
Yes
Yes
Yes
No
No
Yes
,Term 3 of 154
To use scikit-learn machine learning in visuals:
To take actions from within a report:
To use JavaScript to create visuals:
Viewer Contributor Member
Power Bi Service 48 Import
Promoted
Python
Power Apps
D3
, Term 4 of 154
You need to create visualizations that display the total price of orders for each quarter, based
on both the OrderDate and the ShippingDate columns.
How should you create the measure for sales by shipping date?
COLUMN DISTRIBUTION
CALCULATE
SUM
USERELATIONSHIP
AMOUNT
TYPENAME
CALCULATE
DATEADD
YEAR
_PREV_YEAR
