1.
Question
1
For the sales department of your organization, you publish a report that
imports data from Microsoft Excel located in a Microsoft SharePoint folder. The
data model contains several DAX measures. You must create a Power BI report
from the existing data with minimal development efforts. Which type of data
source should you use?
1 / 1 point
An Excel workbook
A Power BI dataset
A SharePoint folder
Power BI dataflows
Correct
That’s correct! You must select the SharePoint folder from the Get Data
and paste the SharePoint site URL where the data is hosted.
2.
Question
2
You are importing your Power BI project data from a SQL Server database.
Which Power BI desktop view can you use to change the storage mode of the
tables?
1 / 1 point
Page view
Model view
Report view
Data view
Correct
That’s correct! You need to navigate to the Model view of Power BI
desktop and use the Properties pane to change the
storage mode of tables.
3.
Question
3
Which tool should you use to create a custom connector to access data
from a third-party API?
1 / 1 point
Power BI
Power Automate
Power Apps
Power Query
Correct
That’s correct! You can use Power query to create and manage a custom
connector to retrieve data from third-party API.
4.
Question
4
You have a Power BI file that imports several tables from Azure SQL
database. The data will be migrated to another Azure SQL database. You need to
change the connections in the Power BI file. The solution must minimize the
administrative efforts. What should you do?
1 / 1 point
Modify the data source settings.
Create a Power BI file, open the file, and change the data source when
prompted.
Create new queries from the Power query editor.
Modify the source of each query in the Power query editor.
Correct
That’s correct! You need to modify the data source settings to change
the connection before creating reports in Power BI.
5.
Question
5
You have a CSV file that contains user complaints. The table contains a
column called Logged, which has data
and the time of each complaint. The data is logged in the following format:
2022-12-21 at 08:35. You want to analyze the complaints by the logged date and
utilize Power BI’s built-in date hierarchy. What should you do?
1 / 1 point
Apply transformation to extract the column's first characters that only
contain the date.
You can use the same column as the date hierarchy.
Change the data type of the logged column to Date.
Split the logged column using ‘at’ as a delimiter.
Correct
That’s correct! Changing the data type of the logged column to Date allows you to
utilize a built-in date hierarchy to analyze complaints by time and use
drill-down functionality to display granular details.
6.
Question
6
Your data model contains a huge dataset that you want to reduce. Which
Power BI interface can you use to reduce the data?
1 / 1 point
Data view of Power BI
desktop.
Power query editor.
Data modeler.
Advanced editor.
Correct
That’s correct! In the Power query editor, you can remove unnecessary
columns and rows, duplicates, and enact other transformation steps to reduce
the size and volume of the dataset before loading it to the Power BI model.
7.
Question
7
You have developed a query named Customers in Power BI
desktop to append the rows from three external tables having customer data into
a single customer table. You want to ensure each row in the new customer table
has a unique ID value. What is the best way to add an ID column to the customer table?
1 / 1 point
Change the data model by extending the Customers table with an index
column.
Change the data model by extending the Customers table with a
counter column.
Modify the data model by adding a counter column.
Modify the data model by adding an index column.
Correct
You can modify the model by adding an index column from the Power query
editor. The index column will assign a unique ID to each customer row.
8.
Question
8
How can you filter rows in Power BI based on specified conditions during
data transformation?
1 / 1 point
Use Filter rows and specify the
conditions.
Apply the Exclude values transformation.
Utilize the Sort option.
Apply the remove rows transformation operation.
Correct
That’s correct! In the power query editor, you can use Filter
rows and define the conditions to filter rows based on your required
conditions.
9.
Question
9
You have accessed the data from a SQL Server as DirectQuery. The dataset
contains millions of rows. The objective of the analysis is to group data by
year and region. Creating aggregated tables has the capacity to reduce the
dataset sourced through DirectQuery. Which Power BI
element allows you to create aggregations?
1 / 1 point
Page view of Power BI
desktop
Data view of Power BI
desktop
Model view of Power BI
desktop
Power query editor
Correct
That’s correct! You can create aggregated tables from the DirectQuery
sourced datasets from the Power Query editor and group by
defined columns.
10.
Question
10
You are designing a data model for hospital emergency visits. You want
to capture patient information like name, address, insurance details, email,
and phone number. Which type of table should you store this information?
1 / 1 point
Fact table
Measure table
Dimension table
Look up table
Correct
That’s correct! The information about the patients is descriptive in
nature therefore should be stored in the dimension table that will provide
context for the fact table of the data model.
11.
Question
11
Which Power BI interface do you need to use to identify the data
anomalies present within your imported dataset from an Excel workbook?
1 / 1 point
Advanced editor of Power query editor.
The Model view of Power BI
desktop.
The Data view of Power BI
desktop.
The Power query editor
Correct
That’s correct! The Power query editor displays the column distribution
and column quality graphs where you can identify any anomaly present within the
imported dataset.
12.
Question
12
True or False: In the context of data profiling, Unique
values and Distinct values represent the same
information.
1 / 1 point
True
False
Correct
That’s correct! Distinct means a total
number of different values regardless of how many times they appear in the
dataset. A name that appears multiple times in the list is counted as 1
distinct count. Whereas the Unique values are the total
number of values that only appear once.
13.
Question
13
You connect the Power query editor to a database table. You need to
remove the Row ID column. You need
to make sure that the new columns do not display in the table model during a
scheduled data refresh in the future. What transformation should you use?
0 / 1 point
Use the Select columns command to select
the columns to keep.
Use the Remove Column command on the Row ID column.
Select Row ID and use the Remove
Other Columns command.
Use the Transpose command, then
filter the rows to remove Row ID.
Incorrect
Not quite. Please review the video Introduction
to dataflows.
14.
Question
14
Which statement is true about reference queries in Power BI?
0 / 1 point
Reference queries allow you to integrate data efficiently.
Reference queries enable faster data load.
Reference queries allow you to combine tables with similar structures.
Reference queries allow you to reuse query logic and transformation.
Incorrect
Not quite. Please review the activity Using
reference queries.
15.
Question
15
You have a Power BI data model containing two tables Sales and Employees. The tables are
related via a one-to-many relationship based on the EmployeeID column. You want
to analyze the sales performance for each employee. Which cross-filter
direction will you choose?
1 / 1 point
Single
Both
None
Correct
That’s correct! To analyze sales performance for each employee, you need
to set a single cross-filter
direction which ensures selecting an employee will filter the sales amount for
that employee.
16.
Question
16
You have a Power BI data model where the fact table is related to the Calendar table via multiple
inactive relationships based on OrderDate, DeliveryDate, and ShipDate. How can you use
the inactive relationship while defining DAX measures?
1 / 1 point
Using the KEEPFILTERS function.
Using the USERRELATIONSHIP function.
Managing the relationship from the Manage
relationship window
Using the CROSSFILTER function.
Correct
That’s correct! The USERRELATIONSHIP function allows you
to utilize the inactive relationship between two tables by overriding the
active relationship for the current measure.
17.
Question
17
You want to create a date table starting from May 31, 2021, and ending
one year later. What M code will you use to create this table?
1 / 1 point
=List.Dates(#date(2021,05,31), 365,
#duration(0,0,0,1))
=List.Dates(#date(2021,05,31), 365,
#duration(1,0,0,0))
=List.Dates(#date(2021,05,31), 1,
#duration(1,0,0,0))
=List.Dates(#date(2021,05,31), 365,
#duration(1,0,1,0))
Correct
That’s correct! The #date designates the
starting date, 365 designates the duration and #duration(1,0,0,0) designates the
duration interval in days. Therefore, the formula results in listing days
starting on May 31, 2021 and ending 365 days later.
18.
Question
18
What is the default summarization of a numerical column in Power BI?
1 / 1 point
SUM
MIN
Count
Average
Correct
That’s correct! Power BI applies SUM summarization by
default to each numeric column that you can change according to your analytical
needs.
19.
Question
19
Which Power BI component lets you test the row-level security using
different security roles?
0 / 1 point
Power BI service.
Both Power BI desktop and Service.
Power BI mobile app.
Power BI desktop.
Incorrect
Not quite. Please review the video Dynamic
row-level security with DAX.
20.
Question
20
Which of the following statements about Measures in Power BI is
true? Select all that apply.
1 / 1 point
Measures can only be created using DAX in Power BI.
Measures can reference other measures during calculations.
Correct
That’s correct! You can reference previously computed measures to
calculate the new measures.
Measures can reference
columns directly.
Measures are dynamic calculations that do not take space in the data
model
Correct
That’s correct! Unlike Calculated columns, measures do not
take up space and compute the value on the fly.
21.
Question
21
You are working on a complex data model that requires various DAX
measures to define a range of business metrics. You decided to use variables
while creating DAX formulas. What are the benefits of using variables in DAX
expressions over using original expressions? Select all that apply.
1 / 1 point
Variables allow users to change the data source connection in the DAX
measure.
Variables improve the overall readability of the resulting DAX measure.
Correct
That’s correct! Variable names are often shorter than the original
expressions and used multiple times within the same DAX script therefore they
improve the readability of the expression.
Variables have additional functions that can be used in the DAX measure.
Variables improve the overall performance of the resulting DAX measure.
Correct
That’s correct! If an expression is used multiple times within the same
DAX code, instead of writing it each time, a variable improves the performance
by caching the defined calculation.
22.
Question
22
You have a warehouse Power BI data model that contains a table named Warehouse. The table has a
column named Inventory count, which contains
the current number of items for each row of a particular product type on a
given day.
The model has a DAX measure that calculates the sum of all values in the
Inventory count column of the Warehouse table:
Current Inventory =
CALCULATE ( SUM (
'Warehouse'[Inventory Count] ) )
You must ensure that the Current Inventory returns only the
current total number of inventory items, rather than the sum of all inventory
items. You also need to make sure the state holidays and weekends should be
excluded from the calculation. What additional DAX function should you include
in the query?
0 / 1 point
DISTINCTCOUNT
LASTNONBLANK
CALENDARAUTO
LASTDATE
Incorrect
Not quite. Please review the activity Create a
semi-additive measure.
23.
Question
23
You have a Power BI desktop data mode that you need to enhance. Which
model items can you add to the model using DAX? Select all that apply.
1 / 1 point
Measures
Correct
That’s correct! Measures are dynamic
calculations that enhance your data model that you can create using DAX.
Hierarchies
Calculated tables
Correct
That’s correct! You can add Calculated tables to your data model
using DAX.
Display folder
24.
Question
24
True or False: You cannot create quick measures in Power BI service
because only Power BI desktop supports the creation of quick measures.
0 / 1 point
True
False
Incorrect
Not quite. Please review the video Creatingquick
measures.
25.
Question
25
You have created a data model in Power BI desktop that contains
DAX-calculated columns and measures. You want to create a report from the
model.
Where can you use DAX-calculated columns, without being able to use
measures? Select all that apply.
1 / 1 point
As a filter in the Filters on this Page well of the Filters pane.
Correct
That’s correct! DAX measures cannot be placed in the Filters on
this page well of the report.
As an item in the Fields well of a slicer.
Correct
That’s correct! Unlike measures, calculated columns can be used in the slicer to place filter
options on the report page.
As an item in the Add drill-through fields here well of the Visualizationpane.
As a filter in the Filters on this visual well of the Filters pane.
26.
Question
26
You need to create aggregations to improve model performance of a DirectQuery
sourced dataset in Power BI. Which Power BI component allows you to
create aggregations?
1 / 1 point
Power BI desktop model view
Power BI desktop table view
Power query editor
Power BI desktop report view
Correct
That’s correct! You can only create aggregations in the Power Query
editor from a DirectQuery sourced dataset.
Remember you need to manage the aggregations after you create them. You can
manage aggregations in Power BI desktop model view.
27.
Question
27
You are working on an on-premises SQL Server dataset to develop a
real-time analytical solution. In addition to providing real-time analysis, you
need to optimize the query performance. What actions should you take to
optimize the query performance? Select all that apply.
0 / 1 point
Connect Power BI via DirectQuery mode.
Reduce the data volume by importing only necessary columns.
Correct
That’s correct! Reducing the data by importing only the columns needed
for analysis will reduce the model size thereby improving the query
performance.
Create aggregations based on DirectQuerysourced tables.
Correct
That’s correct! Aggregations on the DirectQuerysourced tables
improve the performance and efficiency of query.
Import the data to Power BI memory.
Query the original data source for all analytical requirements
You didn't select all the correct answers
28.
Question
28
Which of the following Data types offers an optimal
performance for the currency field of your data model?
1 / 1 point
Decimal number
Fixed decimal number
Text
Whole number
Correct
That’s correct! In the performance analyzer, you can inspect the
execution time of each DAX measure which helps you to identify the slow
performing measures and optimize them.
29.
Question
29
You need to visualize the running total of a company by fulfilling the
following criteria.
·
The initial and final value columns must start on the horizontal axis.
·
The intermediate values must be floating columns.
Which type of visualization should you choose?
1 / 1 point
Scatter plot
Funnel chart
Combo chart
Waterfall chart
Correct
That’s correct! A Waterfall visualization is a
chart that displays the running total, with the initial and final value columns
starting on the horizontal axis and the intermediate values are floating
columns.
30.
Question
30
You need to create a custom visual using Python from Power BI desktop.
What do you need to do first?
1 / 1 point
Configure the global Python scripting option in Power BI desktop.
Enable preview features in Power BI desktop.
Install Python on your computer
Enable the script visuals options in the Visualizations pane of Power BI
desktop.
Correct
That’s correct! To enable custom Python visuals using Power BI desktop,
you first need to install Python and its libraries on your computer.
Configuring global scripting and enabling script visuals might be required
after you install Python.
31.
Question
31
You have developed a CustomTheme in Power BI desktop
and created reports based on this theme. When you publish your reports to Power
BI service and create dashboards out of the reports, will Power BI service
alter the theme and adapt your reports to the dashboard default theme?
1 / 1 point
True
False
Correct
That’s correct! You can keep the original theme of your reports and its
visual elements while publishing and creating dashboards in Power BI service.
32.
Question
32
You have a Power BI report that uses a dataset imported from the
database. The report contains a Slicer that you need to
sync so that it can be used on other report pages. What is required to sync the
slicers between report pages?
1 / 1 point
Each Slicer must have the same
title.
Each Slicer must be visible.
Each Slicer must be the same
slicer type.
Each Slicer must use the same
column
Correct
That’s correct! The same column must be used to create a Slicer for them to
recognize each other in sync slicer settings.
33.
Question
33
Power BI desktop supports many accessibility tools. Which keyboard keys
let you access the accessibility features?
1 / 1 point
Alt
Alt + A
Tab
Tab + A
Correct
That’s correct! The Alt key displays the Keytips over each command
in the current view of the Ribbon with a letter
displayed on each tab which lets you navigate various tools via accessibility.
34.
Question
34
True or False: Power BI allows you to add visual elements and images to
your report tooltip.
1 / 1 point
True
False
Correct
That’s correct! Your report tooltip can contain visuals, images, and any
other collection of items you create on the report page.
35.
Question
35
Your task is to edit a Power BI report by adjusting the behavior of
report interactions. What type of interaction behavior can you change between
visuals? Select all that apply.
1 / 1 point
Highlight
Correct
That’s correct! Highlight is the default
interaction between the visual which shows you both unfiltered and filtered values
in the visual.
Expand
Filter
Correct
That’s correct! A Filter changes the
behavior by showing you the filtered data in the visual.
Drill through
36.
Question
36
You are working on a Power BI report that contains multiple Slicers. A new user of the
report might not be able to visualize the entire data because of the active
selection of Slicers. What should you
do to enhance the user experience?
1 / 1 point
Add a Bookmark
Duplicate the report page and remove the Slicers from the
duplicated page
Add a Button to clear all the Slicers
Correct
That’s correct! You can add a Button to the report page
to clear all Slicers from the report
which will enhance the user experience.
37.
Question
37
You have a Power BI dataset where each employee is reporting to multiple
managers in the organizational hierarchy. How does a PATH function of DAX
handle such a situation?
0 / 1 point
The PATH function cannot
handle multiple reporting relationships.
It chooses the shortest path for each employee.
It creates a separate path for each employee-manager relationship.
It concatenates all paths for each manager.
Incorrect
Not quite. Please review the reading Path Dax
functions.
38.
Question
38
How can you group layers of visual elements in your Power BI desktop
report? Select all that apply.
1 / 1 point
Select all visuals to be grouped, right-click on any visual, and select Group from the context
menu.
Correct
That’s correct! You need to select multiple visuals to be grouped by
holding the Ctrl key and selecting Group from the context
menu.
Select all visuals to be grouped, navigate to the Format
ribbon, and select Group.
Correct
That’s correct! You can also navigate to the Format
ribbon and select Groupafter selecting the
multiple visuals from the report canvas.
Right-click on any visual and select Group from the context
menu
Drag and drop the visual elements.
39.
Question
39
You have a Power BI report displaying a Column
chart of Sales on the Y-axis and Countries on the X-axis. When users hover
the cursor on any data point the tooltip displays the sales values along with
the name of the country. How can you display the sales breakdown by each
category within the same country?
0 / 1 point
Add a Category slicer where users can
select a category.
Add a visual for sales breakdown by category on a Tooltip.
Add a separate visual displaying sales breakdown by product category.
Create a separate report page for each product category.
Incorrect
Not quite. Please review the reading Activity:
Create custom tooltips.
40.
Question
40
In Power BI you can add symmetry shading along with x- and y-axis Constant
lines to which of the following visuals?
1 / 1 point
Waterfall chart
Line chart
Scatter chart
Area chart
Correct
That’s correct! You can add Constant x and y-axis lines with symmetry
shading only in the Scatter chart in Power BI.
41.
Question
41
True or False: In Power BI desktop, you can convert a Q&A visual to a fully
formatted visual element to display on your report canvas.
1 / 1 point
True
False
Correct
That’s correct! You can also define relationships between tables and
fields to help Q&A understand
questions about your data.
42.
Question
42
Anomaly detection is a powerful feature of Power BI where you can detect
anomalies within your time series data. Which of the following features are not
supported by anomaly detection? Select all that apply.
0 / 1 point
You cannot use drill down with anomaly detection.
Correct
That’s correct! Drilling down to the granular level of details with a
hierarchical structure is also not supported in anomaly detection.
Line charts are not supported.
DirectQuery connectivity is not
supported.
Live connection to the dataset is not supported.
Correct
That’s correct! Power BI’s anomaly detection feature does not support Live
connection to the dataset.
You didn't select all the correct answers
43.
Question
43
You manage a Power BI workspace. You need to delegate the task to update
workspace metadata. The solution must use the principle of least privilege.
Which role should you use?
0 / 1 point
Member
Admin
Viewer
Contributor
Incorrect
Not quite. Please review the video Workspaces
and workspace roles.
44.
Question
44
You are creating a workspace in Power BI service. You must ensure you
can configure a Microsoft 365 group whose SharePoint online document library is
available to workspace users after it is created. Which setting should you
configure when creating a workspace?
1 / 1 point
License mode
Allow contributors to update the app
Workspace OneDrive
Develop a template app
Correct
That’s correct! Workspace OneDrive settings allow you to configure the
Microsoft 365 group whose SharePoint Online document library is available to
workspace users once you have created the workspace.
45.
Question
45
You want to create Alerts to notify users if the data on the dashboard
changes above or below a certain threshold. Which Power BI visual allows you to
set and manage Alerts in Power BI service? Select all that apply:
0 / 1 point
Card visual
Python visual
KPI
Correct
That’s correct! Power BI service also allows you to set and manage
Alerts in KPI, a visual used to track performance
against a predefined target.
Gauge
Correct
That’s correct! You can set up and manage Alerts in the Gauge visual, within the
Power BI service.
Custom visuals
You didn't select all the correct answers
46.
Question
46
True or False: You can only subscribe to external users to a Power BI
report or dashboard if your report or dashboard is hosted in a Premium
capacity.
0 / 1 point
True
False
Incorrect
Not quite. Please review the video Subscriptions
and data alerts.
47.
Question
47
What is the primary advantage of deployment pipelines in Power BI?
1 / 1 point
Enhanced user access to BI report source data.
Less manual work and fewer errors.
Reports can be published from multiple workspace environments.
Semantic model (dataset) creation is streamlined.
Correct
That’s correct! Implementation of deployment pipelines reduces manual
work and errors.
48.
Question
48
Your company has a SharePoint server located in a data center in
Toronto. You are creating a report in Power BI service that uses Microsoft
Excel files stored on the SharePoint server. You need to recommend a solution
to ensure that the dataset for the report can automatically refresh daily. What
should you include in the recommendation?
1 / 1 point
Azure Data box
A virtual private network (VPN)
An on-premises data gateway
Correct
That’s correct! With an on-premises data gateway installed on your local
machine, you can achieve daily refresh of the data regardless of where the data
is hosted.
49.
Question
49
Which Power BI refresh options require you to set parameters?
1 / 1 point
Scheduled refresh
On-demand refresh
Incremental refresh
Correct
That’s correct! In incremental refresh you need to ensure the dataset is
partially refreshed according to the parameters you must define.
50.
Question
50
You are applying sensitivity labels to your Power BI reports, which of
the following are sensitivity labels in Power BI? Select all that apply.
0 / 1 point
Highly confidential
Confidential
Correct
That’s correct! Confidential is a sensitivity
label used for Power BI reports.
Certified
Personal
You didn't select all the correct answers
0 comments:
Post a Comment