A. house numbers, street names B. geospatial data C. city names, country names D. longitude, latitude1.
A, B, C, D
2.
A, C, D
3.
B, C, D
4.
D
Q 1 / 67
A. Click New Visual on the Home tab. B. Select a chart visual in the Visualizations pane. C. Click New Visual on the Data Tools tab. D. Select a field that contains values.1.
A, B, or D
2.
B or D
3.
B orC
4.
A or B
Q 2 / 67
`CALCULATE(SUM([Sales]) ,DATESMTD([Date] ))`1.
running total sales in each month that starts over each month
2.
total sales for the entire month
3.
running total in entire year for the entire month
4.
rolling average over 12 months of sales
Q 3 / 67
1.
a directive
2.
a custom column
3.
an indexed column
4.
a parameter
Q 4 / 67
1.
They are easier to create than other visualizations.
2.
They require fewer resources than more complex visualizations.
3.
They are also used in Excel, so they feel familiar to users.
4.
They are free to use.
Q 5 / 67
1.
midnight of the day on which they are deleted
2.
the next billing cycle
3.
you empty the Recycle Bin
4.
the report has been saved
Q 6 / 67
1.
Click the color in the visual (e.g., the bars) and right-click to select the color.
2.
You cannot select custom colors in a bar chart or related visual.
3.
Select the value closest to this color from the color formatting options.
4.
Enter the hex value into the color formatting options.
Q 7 / 67
1.
SWITCH
2.
IF
3.
IFX
4.
IFS
Q 8 / 67
1.
stored in SQL Server
2.
written to an OLAP cube
3.
assigned a data type
4.
sorted by primary key
Q 9 / 67
A. blog posts B. email messages C. web sites D. text messages1.
A,C
2.
C
3.
A, B, C
4.
A, B, C, D
Q 10 / 67
Q 11 / 67
A. Rename a query step. B. Delete a query step. C. Delete from one query step to the end. D. Reorder the steps.1.
B, C, D
2.
A, B, C, D
3.
A, B, D
4.
A, B, C
Q 12 / 67
Q 13 / 67
1.
filter and group
2.
sort and filter
3.
sort, filter, and group
4.
sort and group
Q 14 / 67
1. [proof link1](https://docs.microsoft.com/en-us/power-bi/visuals/service-tips-and-tricks-for-color-formatting) 2. [link2](https://www.edureka.co/community/26060/how-do-i-undo-something-in-power-bi)1.
Press Ctrl+Z.
2.
Select Undo from the toolbar.
3.
You cannot undo the deletion of a dashboard.
4.
Recover it from the Recycle Bin.
Q 15 / 67
1.
dimension; fact
2.
lookup; data
3.
data; lookup
4.
data; supporting
Q 16 / 67
A. columns B. tables C. functions D. data sources1.
B,C
2.
A, C, D
3.
C,D
4.
A, B, C
Q 17 / 67
1.
A tile on your dashboard contains data from that dataset.
2.
The dataset is already being used in a published app.
3.
A report contains data from that dataset.
4.
The dataset is in your workspace.
Q 18 / 67
1.
Replace values
2.
Split column
3.
Modify data type
4.
Best fit geospatial
Q 19 / 67
1.
the visualization you are formatting
2.
the editor you use
3.
the visualization group
4.
your permissions
Q 20 / 67
1.
report editor
2.
Power Query Editor
3.
dashboard
4.
data modeler
Q 21 / 67
1.
Azure data
2.
file data
3.
relationships data
4.
database data
Q 22 / 67
1.
Excel files
2.
comma-separated value (CSV) files
3.
Power BI Desktop files
4.
all of these answers
Q 23 / 67
1.
Power BI Report Server
2.
report sharing without a per-user licens
3.
all of these answers
4.
dedicated capacity for your company
Q 24 / 67
1.
views
2.
filters
3.
bookmarks
4.
slicers
Q 25 / 67
1.
all of these answers
2.
Remove unnecessary field labels.
3.
Select the most appropriate visualization.
4.
Use borders.
Q 26 / 67
1.
landscape mode
2.
none of these answers
3.
Shrink to Fit
4.
templates
Q 27 / 67
1.
Spotlight
2.
Highlight
3.
Magnify
4.
None of the answers
Q 28 / 67
1.
Visualizations and a fields list
2.
Toolbars and preferences
3.
Workbooks and visualizations
4.
Dashboards and reports
Q 29 / 67
1.
Drill up
2.
Drill down
3.
Expand to next level
4.
Collapse
Q 30 / 67
1.
Visual level
2.
Page level
3.
Drillthrough
4.
Expand down
Q 31 / 67
1.
online services
2.
Wiki data sources
3.
database data sources
4.
File data sources
Q 32 / 67
1.
everyone in your environment
2.
anyone on the internet
3.
everyone in your organization
4.
only you
Q 33 / 67
1.
for Power BI mobile apps
2.
in Power BI service rather than Power BI desktop
3.
in the context of a record
4.
for very large datasets
Q 34 / 67
1.
Right Outer Join
2.
Left Outer Join
3.
Left Inner Join
4.
Right Inner Join
Q 35 / 67
1.
Power KPI
2.
funnel chart
3.
waterfall chart
4.
ArcGIS map
Q 36 / 67
A. They must be stored in the same folder. B. They must have the same schema. C. They must have the same file type. D. They must have no duplicate data rows.1.
B, C
2.
A, B, C
3.
A, B, D
4.
B, C, D
Q 37 / 67
1.
They will be stored as static dashboards and reports.
2.
They will be deleted.
3.
They will be converted to image files.
4.
Nothing—they will be unchanged.
Q 38 / 67
1.
COMPARE
2.
FINDUNIQUE
3.
EXCEPT
4.
SWITCH
Q 39 / 67
1.
Orders; DISTINCTCOUNT
2.
Customers; COUNT
3.
Orders; COUNT
4.
Customers; DISTINCTCOUNT
Q 40 / 67
1.
short and wide
2.
long and skinny
3.
short and skinny
4.
long and wide
Q 41 / 67
**Explanation:** As both of the columns have numeric data, we will use a scatter chart and apply them in X-axis and Y-axis1.
bar chart
2.
bubble chart
3.
line chart
4.
scatter chart
Q 42 / 67
1.
Add more information to a visualization.
2.
All of these tasks can be done with drag and drop.
3.
Create a new visualization.
4.
Rearrange and resize visualizations.
Q 43 / 67
1.
User a star schema.
2.
Load all tables from the data source.
3.
all of these answers
4.
Include multiple objects in each data table.
Q 44 / 67
1.
CALCULATE
2.
SUM
3.
PICARD
4.
COMPARE
Q 45 / 67
1.
usage metrics
2.
organization visuals
3.
Dashboard Manager
4.
audit logs
Q 46 / 67
1.
RECOUNT
2.
COUNTUNIQUE
3.
COUNTX
4.
COUNTROWS
Q 47 / 67
1.
Save it.
2.
Name it.
3.
Refresh it.
4.
Publish it.
Q 48 / 67
1.
Dynamics 365
2.
SharePoint
3.
all of these answers
4.
SQL Server Analysis Services
Q 49 / 67
`ProductCount = COUNT(Products[ProductID])`1.
It is part of the documentation
2.
It creates and formats a measure called ProductCount
3.
It creates a measure called ProductCount
4.
It calculates the value for an existing measure named ProductCount
Q 50 / 67
1.
DATEDIFF and SUM
2.
DATEDIFF and SUMX
3.
TIMEDIFF and SUM
4.
TIMEDIFF and SUMX
Q 51 / 67
1.
error dialogs
2.
autocomplete
3.
all of these answers
4.
tooltips
Q 52 / 67
1.
It sends the data to the Power BI service
2.
It returns an error
3.
It sends the data to Bing
4.
It substitutes a column chart
Q 53 / 67
A. sorting B. filtering C. current selection D. properties of visuals1.
A, B
2.
A, B, C
3.
A, B, C, D
4.
A, B, D
Q 54 / 67
A. Add a geographic filter to City. B. Add a geographic filter to State. C. Add a geographic filter to Street Address. D. Add a geographic filter to Country.1.
A, B, D
2.
A, B, C, D
3.
A, B, C
4.
A, B
Q 55 / 67
A. the person who built the dashboard B. other people who share the dashboard C. users who consume the dashboard in a content pack D. individual user downloads of the dashboard1.
A, B, C, D
2.
A, B, C
3.
A, D
4.
B, C, D
Q 56 / 67
1.
Add a date field to the report filter area and set filtering to Relative date filtering.
2.
all of these answers
3.
Add a date field to the page filter area, set filtering to Relative date filtering and click Extend.
4.
Add a slicer for a date field to the report. Click the upper right corner and select Relative.
Q 57 / 67
1.
remove users from the group
2.
manage group membership
3.
add users to the group
4.
remove users from Power BI
Q 58 / 67
1.
all of these answers
2.
Create the columns in Power Query during data load
3.
Create a measure instead
4.
Have it added to the data source
Q 59 / 67
1.
the ability to see all of the dataset only in Power BI cloud services, but not in Power BI Desktop
2.
front-end access to all data queries within this source without the ability to make back-end changes
3.
connections to all the data queries and the ability to make ETL modifications to existing data
4.
the option to select a single query from within the dataset and build new ETL processes form it
Q 60 / 67
1.
Prompt the user before load
2.
Allow any extension to load without warning
3.
Allow only certified extensions to load
4.
Load certified extensions and prompt the user for noncertified extensions
Q 61 / 67
A. Combine City, State, and Country into one lookup table B. Move City, State, and Country to the Member table C. Combine City and State into one lookup table and remove the Country table D. Leave the model as it is.1.
A or C
2.
A
3.
D
4.
A or B
Q 62 / 67
1.
download; upload
2.
purchase; import
3.
purchase; upload
4.
upload; download
Q 63 / 67
1.
Unify
2.
Append
3.
Merge
4.
Group
Q 64 / 67
1.
column; map
2.
line; map
3.
timeline; map
4.
line; column
Q 65 / 67
1.
A snowflake schema cannot be modeled in Power BI.
2.
A snowflake schema can be modeled only in Power BI service.
3.
A snowflake schema is much less efficient for Power BI.
4.
A snowflake schema has more levels of lookup tables.
Q 66 / 67
A. You can track the changes you make. B. It is less error prone than manual editing. C. It will not affect other users of the spreadsheet. D. It "locks down" the spreadsheet columns in Excel.1.
A, B, C
2.
A, B, C, D
3.
A, C, D
4.
B, D
Q 67 / 67