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
A Power BI dataset
A SharePoint folder
Power BI dataflows
An Excel workbook
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 need to create a data source that
external users can access. Which type of data source should you use?
1 / 1 point
SQL Server
Common data services
OneDrive
SharePoint
Correct
That’s correct! Common data services
allow users to securely store and manage data from various sources, including
Office 365 and custom applications. It is a suitable option for creating data
sources that external users can access because it provides a secure and
scalable platform for managing data.
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 Query
Power Apps
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 created a Power BI data
source that uses SQL SELECT statements. The SQL statement queries
multiple tables in a SQL Server database and includes subqueries. When you
import the data to Power BI, you receive the error message “Timeout expired”.
You have checked the SQL connection and confirmed the Server has sufficient
bandwidth and low latency. To minimize the timeout occurrence issue, what
should you do?
1 / 1 point
Break down the SQL statement into
separate data sources.
Implement groupings in SQL statement.
Replace subqueries with nested
queries.
Implement aggregations in SQL
statement.
Correct
That’s correct! Dividing the SQL
statement into separate data source would minimize the amount of processing on
SQL Server side. This would minimize or even eliminate the timeout issues.
5.
Question 5
How can you ensure data accuracy
before analysis?
1 / 1 point
Use data visualization tools
Using data profiling tools
Use data modeling tools
Use data transformation tools
Correct
That’s correct! Data profiling tools
are designed to analyze and assess the data quality and help identify any data
inconsistencies, errors, and missing data in the datasets.
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 modeler.
Advanced editor.
Data view of Power BI desktop.
Power query 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 two Excel sheets with data
from separate reporting units. Both spreadsheets contain the same column names
and structure. What Power query editor feature will you use to create a unified dataset?
1 / 1 point
Group
Append
Merge
Manage
Correct
That’s correct! Append queries allow you to combine two tables with
similar column names and structures into a single unified data table.
8.
Question 8
How can you filter rows in Power BI
based on specified conditions during data transformation?
1 / 1 point
Apply the remove rows transformation
operation.
Utilize the Sort option.
Apply the Exclude
values transformation.
Use Filter
rows and specify the conditions.
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 want to add a new column to the
Power BI table that categorizes customers as high value if their total sales
are above $10,000. Which transformation in the query editor allows you to
create such a column without using the DAX expression?
1 / 1 point
Custom column
Conditional split
Group by
Extract
Correct
That’s correct! In the query editor,
you can add a custom column and define the conditions for the column based on
the sales values for each customer.
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
Measure table
Fact 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
You have a dataset representing each
month (January, February, March) as individual columns. What transformation in
the query editor can you use to rearrange the data, making months appear as
rows instead of columns?
1 / 1 point
Reverse rows
Transpose
Extract
Pivot
Correct
That’s correct! The Transpose function in the query editor converts rows to
columns and columns to rows.
12.
Question 12
You developed a query in Power BI
desktop that retrieves data from an Excel spreadsheet. During the data
analysis, you identify the need to view and modify multiple steps of data
transformation in the entire M code. Which Power BI interface allows you to
accomplish that?
0 / 1 point
Advanced editor of Power query editor
The Model view of Power BI desktop.
The Formula
bar of the query editor.
The Power query editor.
Incorrect
Not quite. Please review the video Profiling Data in Power BI.
13.
Question 13
You are importing data from a SQL
Server database that contains two tables named SalesOrderDetails (left table) and SalesOrders (right table). You load both tables to Power BI
desktop and the tables have a relationship based on theSalesOrderID column. You need to combine two tables into one
and you must meet the following requirements:
·
There is a row for every SalesOrderDetails row in the resulting table, even if there is no
corresponding SalesOrder row.
·
For every SalesOrderDetails row, the row in the resulting table includes the
corresponding SalesOrder row data if the SalesOrder exists.
·
Any SalesOrder row data that does not have a corresponding SalesOrderDetailsrow is not included in the resulting table.
What should you do to combine the
tables?
1 / 1 point
Merge the tables using left outer
join kind based on the SalesOrderID.
Merge the tables using inner join
based on the SalesOrderID.
Append the tables.
Merge the tables using full outer
join kind based on the SalesOrderID.
Correct
That’s correct! To meet the
requirements, the resulting table must contain all the rows from the SalesOrderDetails table with only matching rows from the SalesOrder table. This can be achieved by using a left outer
join type while merging the tables.
14.
Question 14
What happens when you make changes to
the source query of a referenced query in Power BI?
1 / 1 point
The changes are automatically applied
to all referencing queries
The reference queries do not change.
The changes only affect the current
report.
The referencing queries become
read-only.
Correct
That’s correct! In reference query
you can use an existing query in another query. All changes made to the primary
query are automatically applied to the referenced query ensuring data
consistency and avoiding the repetition of data transformation steps.
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
None
Both
Single
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
Your Power BI data model has a Sales fact table and a Date
table. The Sales table contains two date columns: ShipDate and OrderDate.
Both date columns have a relationship
to the Date column in the Date table, and DAX measures have been defined to use
these relationships for calculations related to order date or ship date.
You need to make sure that the Date
table does not filter the Sales table unless it is using DAX measures that use
these relationships. What should you do?
1 / 1 point
Enable Make
this relationship active for both relationships.
Enable a security filter in both
directions for both relationships.
Set the cross-filter direction to Both for both relationships.
Disable Make
this relationship active for both
relationships.
Correct
That’s correct! In the Power BI data
model, you can have multiple inactive relationships between two tables. DAX
measures use the USERRELATIONSHIP function to compute the required analysis by
activating the relationship necessary for the calculation.
17.
Question 17
You want to create a common date
table within your Power BI data model. The start and end of the date table must
match the date range available in the fact table of the data model. How can you
create this table?
1 / 1 point
Use CALENDARAUTO and specify the dates.
Use CALENDAR with MIN and MAX to specify the dates.
Use CALENDARAUTO
with MIN
and MAX
to specify the dates.
Use the CALENDAR function and specify the dates.
Correct
That’s correct! In the CALENDAR
function, you can use MIN and MAX functions to extract the minimum and maximum dates
from the fact table.
18.
Question 18
Which of the following Power BI
components can you use to configure the column and table properties of your
data model? Select all that apply.
1 / 1 point
Visualizations pane of Power BI desktop.
Advanced editor.
The Power query editor.
Correct
That’s correct! You can configure
fundamental table and column properties in the query editor of Power BI
desktop.
The Model view of Power BI desktop.
Correct
That’s correct! The Model
view of Power BI desktop allows you
to configure and format the properties of tables and columns in depth.
19.
Question 19
You have implemented role-based
security that restricts access to a Power BI desktop dataset for users who are
assigned the role named Salespersons. You need to validate that the
implementation works properly. What should you do?
1 / 1 point
In the Report view, activate the view as a feature.
In the Report view, create a what-if
parameter.
In Power query editor, add a
conditional column to the Salesperson table.
In the Report view, add a DAX expression filter to the Salesperson
table.
Correct
That’s correct! Activating the view
as a feature allows you to test the row-level security as someone with the Salesperson
role.
20.
Question 20
You have a Power BI data model
containing a Sales table. The Sales table has Quantity and Unit price columns. You want to create a Total
sales measure instead of a calculated
column by optimizing the data model for
storage. Which aggregation function will you use to compute the measure?
1 / 1 point
SUM
CALCULATE and SUM
CALCULATE
SUMX
Correct
That’s correct! SUMX
will iterate each row of the table to
compute the total sales by implementing the calculations of the measure.
21.
Question 21
You have a Power BI desktop model
that contains a Sales fact table and Product dimension table. You want to compute the total
sales by product category by implementing the condition: "Only products
that have a total sale of over $20K should be displayed." What combination
of DAX functions should you use to compute the measure?
1 / 1 point
FILTER and CALCULATE.
FILTER and SUM.
SUM
and CALCULATE.
FILTER and SUMX.
Correct
That’s correct! The FILTER
function narrows down the sales
values for the product according to the defined criteria and CALCULATE
modifies the filter context to
compute the final measure.
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 Current
Inventory returns only the current total
number of inventory items, rather than the sum of all inventory items.
What additional DAX function should
you include in the query?
1 / 1 point
DISTINCTCOUNT
CALENDARAUTO
LASTDATE
CALENDAR
Correct
That’s correct! The LASTDATE
function ensures that the SUM function applies only to the last date of the
period resulting in a semi-additive behavior.
23.
Question 23
You have a Power BI model of a
marketing company. The data model contains two tables: Socials and Calendar. The Socials table has a column recording website visits and
the Calendar table has a Date column.
You want to compute the total number
of visits during the last month. Which DAX expression can you use to compute
this value?
1 / 1 point
= CALCULATE ( SUM ( Socials[Website
Visits] ), LASTMONTH ( Calendar[Date] ) )
= CALCULATE ( SUM ( Socials[Website
Visits] ), PREVIOUSMONTH ( Calendar[Date] ) )
= CALCULATE ( Socials[Website Visits]
), LASTMONTH ( Calendar[Date] )
= CALCULATE ( Socials[Website Visits]
), PREVIOUSMONTH ( Calendar[Date] )
Correct
That’s correct! CALCULATE
and SUM computes the total number of website visits and PREVIOUSMONTH
compares the dates to the previous
month.
24.
Question 24
You are working on a Power BI data
model that contains three data tables. A Salestable containing sales transactions, a Date table, and a Producttable.
You want to create a summary table to
display the following:
·
The total sales by each product
category per year.
·
Total quantity of each product within
the category.
You have created the following DAX
measure:
Annual Sales Summary =
ADDCOLUMNS (
SUMMARIZE ( Sales, Date.[Year],
'Product'[Category] ),
"Total Quantity", SUM (
Sales[Quantity] ) )
)
Which of the following DAX functions
you should include in the DAX expression to compute accurate results?
1 / 1 point
TOPN
FILTER
CALCULATETABLE
CALCULATE
Correct
That’s correct! You need to add CALCULATE
before SUM
to compute accurate results. Remember
CALCULATE alters
the filter context of the DAX calculations.
25.
Question 25
A Power BI data model has measures
and calculated columns. What is the benefit of using measures over calculated
columns?
1 / 1 point
Measures can be used for data transformation
operations.
Measures can assist in data load
operations.
Measures can be used in the
calculated columns to create complex calculations.
Measures are dynamic calculations and
are not stored in the data model.
Correct
That’s correct! Measures are
calculated at the query level, so they do not require memory. The calculations
are executed on the fly.
26.
Question 26
You have imported a large data model
to Power BI desktop, and you want to reduce the model size. Which technique
should you use to reduce the model size?
1 / 1 point
Set the storage mode property of
tables to DirectQuery.
Set the storage mode property of
tables to import.
Configure the Query reduction option
Slicer settings.
Configure the Query reduction option
filter settings.
Correct
That’s correct! Setting the storage
mode property to DirectQuery reduces the model size since only the schema of
the data is stored locally to Power BI memory.
27.
Question 27
True or False: You have imported a
Power BI data model from a huge Excel spreadsheet. You need to create
aggregations to improve model performance but creating and managing
aggregations is limited to DirectQuery sourced datasets.
1 / 1 point
True
False
Correct
That’s correct! You can create and
manage aggregations for model optimization based on any dataset even if it is
an Excel workbook.
28.
Question 28
You have a Power BI data model with a
bunch of complex DAX measures. The report is responding very slowly. You need
to optimize the report performance for which you want to know the performance
of DAX measures. Which Power BI tool can you use to inspect the performance of
DAX calculations?
1 / 1 point
Power BI data Modeler.
Power query profiling tool.
Visualizationpane.
Performance analyzer.
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 are creating a report to
visualize sales by salespersons, trending over months. The visual must clearly
show how salespersons are performing against each other and have a ranking for
each period.
Which visual from Power BI core
visualization should you choose?
1 / 1 point
Ribbon chart
Treemap
Scatter plot
Clustered bar chart
Correct
That’s correct! A Ribbon chart places the highest value at the top of the stacked
column each month and shows those ranked changed over time, so it’s the best
option to fulfill the requirements.
30.
Question 30
You need to create a Power BI report
visualizing the sales data of a company so that customers of similar age will
be grouped together. Which type of visual should you use from the visualization
pane of Power BI desktop?
1 / 1 point
A Waterfall
chart
Card visual
A KPI
A Scatter
plot
Correct
That’s correct! A Scatter
plot is the first step of applying the
clustering technique that groups data into clusters.
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 are developing a Power BI desktop
report to visualize the sales performance of salespeople. The sales team is
comprised of over 20 salespeople. You also need to make sure the sales values
are visualized monthly. What should you do?
1 / 1 point
Create a Column
chart displaying the month on the X-axis.
Create a Bar
chart displaying the salesperson on the Y-axis.
Create a Column
chart displaying Date
hierarchy on the X-axis and create a Slicer drop-down for salespersons.
Create a Column
chart displaying salespersons on the X-axis and create a Slicer for data hierarchy.
Correct
That’s correct! Creating a Date
hierarchy on the horizontal axis makes it
easier to drill down to visualize the granular sales values and the slicer
drop-down will interactively display the sales performance for each salesperson
eliminating the clutter from the report.
33.
Question 33
You are using Power BI desktop to
configure a Stacked column chart that displays gross sales data with Date
hierarchy. The hierarchy levels are Year, Quarter, Month, and Day. You need to prevent users from viewing the
hierarchy based on the Year. What should you do?
0 / 1 point
In the Format
pane, modify the maximum range
settings.
In the Visualizations pane, remove the Year from the Date hierarchy field in the horizontal axis
In the Filters
pane, add a filter based on the Year.
In the Filters
pane, add a filter based on the Quarter, Month, and Day.
Incorrect
Not quite. Please review the video Pagination and exporting reports.
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
In Power BI desktop, what types of
fields can you use to create a data hierarchy enabling users to drill down to
granular details of analysis?
1 / 1 point
Hierarchies can only be created with Data/time data fields
Only numerical values
Only text-based data
Both categorical and numerical data
fields can be used
Correct
That’s correct! To create a
hierarchical structure and enable the drill-down function, you can use both
numerical and categorical data fields in your visuals.
36.
Question 36
You have a Power BI desktop report
containing three pages: Main, Delayed Response,
and On-time Response. You have added a Button to the Main page for navigation.
You need to implement a solution that
meets the following criteria:
·
The navigation destination must
change based on the output of a DAX measure name [Delayed Response].
·
If [Delayed Response] is greater than
5%, the Button must display the text “Delayed Response” and
navigate to the Delayed Response page.
·
Otherwise, the Button displays the text “On-time Response” and navigates
to the On-time Response page.
What actions should you perform? Select
all that apply.
1 / 1 point
Create a DAX measure that outputs the
correct page name based on the value of [Delayed response].
Correct
That’s correct! First, you need to
create a DAX measure that outputs the correct destination page name.
Use Conditional
formatting to set the Button text.
Correct
That’s correct! To change the Button text to match the page name, conditional
formatting must be used to set the text to equal the newly created DAX measure.
Set the Button type to page navigation and then use Conditional
formatting to specify the destination.
Correct
That’s correct! Then you need to
configure the Button to use page navigation and use the newly created
DAX measure to specify the navigation.
Set the button type to Bookmark
and then use Conditional
formatting to specify the destination.
37.
Question 37
A fundamental principle of data
storytelling is a cohesive report page and visuals should be placed in a
logical order. Which Power BI element allows you to visualize the order of visuals
in the report page and configure them according to the narrative of your data
story?
1 / 1 point
Selection pane from the query editor.
Page navigator from Power BI desktop.
Selection pane from Power BI desktop.
Visualizations pane of Power BI desktop.
Correct
That’s correct! The Selection
pane of Power BI desktop enlists all the
visuals present in the report canvas, where you can simply re-arrange the
visuals by dragging and dropping them in an order that complements your data
story.
38.
Question 38
How can you group layers of visual
elements in your Power BI desktop report? Select all that apply.
1 / 1 point
Right-click on any visual and select Group
from the context menu
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.
Drag and drop the visual elements.
39.
Question 39
A Power BI desktop report needs to be
optimized for cellular devices. Which Power BI component can you use to
optimize the report for mobile devices? Select all that apply.
1 / 1 point
Power BI report builder
Power BI desktop
Correct
That’s correct! You can optimize
reports in Power BI desktop from the view tab. Later versions of Power BI have
a mobile icon on the bottom left corner of the interface.
Power BI mobile app
Power BI service
Correct
That’s correct! Power BI service also
allows you to optimize your reports for cellular devices.
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
Area chart
Scatter chart
Waterfall chart
Line 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
AI visuals are Power BI components
designed to provide advanced analytics and insights by leveraging machine
learning models and techniques. You are a sales manager of the company and want
to analyze the revenue by region, category, and sales channel. Which of the
following AI visuals is used to break down a specific value (revenue in this
case) into its components?
1 / 1 point
Q&A visual
Key influencer visual
Decomposition tree
Waterfall chart
Correct
That’s correct! With the Decomposition
tree, AI visual of Power BI, you can
break down a single value into its components like Sales revenue into regions,
categories, and sales channels which can reveal the strengths and weaknesses of
your business operation.
43.
Question 43
You manage a Power BI workspace. You
need to delegate the task to schedule data refreshes. The solution must use the
principle of least privilege. Which role should you use?
1 / 1 point
Contributor
Member
Viewer
Admin
Correct
That’s correct! The Contributor role
is the least privileged role that grants permission to schedule data refreshes.
44.
Question 44
Which of the following features are
not supported in Power BI dashboards? Select all that apply.
0 / 1 point
Natural language queries
Creation of multiple pages
Setup of data Alerts
This should not be selected
Not quite. Please review the video What is a dashboard?
Use of slicers and filters
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:
1 / 1 point
Gauge
Correct
That’s correct! You can set up and
manage Alerts in the Gauge visual, within the Power BI service.
Python visual
Card visual
Correct
That’s correct! The Card
visual is the third visual element
where you can set and manage Alerts within the Power BI service.
Custom visuals
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.
46.
Question 46
Sensitivity labels are a way to
classify critical content and protect your sensitive data without losing
productivity. Which of the following components can you apply Sensitivity
labels to in Power BI Service? Select all that apply:
1 / 1 point
Workbooks
Dataflows
Correct
That’s correct! Dataflows support the
use of sensitivity labels in Power Bi service.
Paginated reports
Correct
That’s correct! Paginated reports
support the use of sensitivity labels in Power Bi service.
Semantic models (Datasets)
Correct
That’s correct! Semantic models
support the use of sensitivity labels in Power Bi service.
47.
Question 47
What feature in Power BI service can
you use to troubleshoot the flow of data from the source to destination?
1 / 1 point
Query caching
Quick insights
Usage metrics report
Lineage view
Correct
That’s correct! Lineage
view in Power BI service allows you to
view and troubleshoot the data flow from its source to destination.
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?
0 / 1 point
An on-premises data gateway
Azure Data box
A virtual private network (VPN)
Incorrect
Not quite. Please review the video Data gateways.
49.
Question 49
You have applied changes in the data
source structure including renaming, remove, and add columns.
True or False: The refresh can only
be applied to Power BI desktop.
0 / 1 point
True
False
Incorrect
Not quite. Please review the activity
Configure a dataset scheduled refresh.
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
Certified
Confidential
Correct
That’s correct! Confidential is a sensitivity label used for Power BI reports.
Personal
Highly confidential
Correct
That’s correct! Highly confidential
is a sensitivity label used for Power BI reports.
You didn't select all the correct
answers
0 comments:
Post a Comment