Part-1
1.
Question
1
Multiple Microsoft Excel files are saved in a folder and synced with
Microsoft’s OneDrive for Business. You need to import data from files without
using the data gateway. Which type of Power BI data connector should you use?
1 / 1 point
Excel workbook
OneDrive for business
SharePoint folder
SharePoint list
Correct
That’s correct! A SharePoint folder is the only connector that allows
you to import multiple Excel files stored in a OneDrive for Business folder
without using a data gateway.
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
Report view
Data view
Page view
Model 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
You have an Azure SQL database that contains sales transactions. The
database is updated frequently. You are asked to create a report from the data
to detect fraudulent transactions. The data must be visible within five minutes
of any update. How will you configure the data connection?
1 / 1 point
By setting data connectivity to DirectQuery.
By setting a command timeout in minutes.
By setting data connectivity to import mode.
By adding a SQL statement.
Correct
That’s correct! With DirectQuery, you can ensure
the data is refreshed within the required time frequency. Your reports will be
automatically updated as the new data is updated to the source database.
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
Implement aggregations in SQL statement.
Replace subqueries with nested queries.
Break down the SQL statement into separate data sources.
Implement groupings 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
Your data model contains a sales table with an OrderDate column. You want
to analyze and visualize the sales data grouped by month. What transformation
command of the Power query editor lets you create a month column without using
DAX expression?
1 / 1 point
Trim
Group By
Date
Extract
Correct
That’s correct! From the Power query editor, you need to
select the Date and choose Name of
the month from the drop-down option. A new column with the month name is added to
the table that you will use to visualize sales by month.
6.
Question
6
One of your columns in the data model contains information about the
mailing address's city, state, and postal code. You must separate the fields to
access the geospatial elements for map visualization. What transformation
should you apply?
1 / 1 point
Split column
Modify data category
Replace values
Modify data type
Correct
That’s correct! You can split the column based on the delimiter present
in the original column and use the resulting columns for geospatial
visualization.
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?
0 / 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 an index column.
Modify the data model by adding a counter column.
Incorrect
Not quite. Please review the video Combining
tables with merge.
8.
Question
8
Your Power BI dataset has a table where each row represents a city, and
there are columns for the population in different years like Population_2019, Population_2020, and so on. You
want to display the data with a single column for the year and another column
for the population. What transformation step can you achieve in Power BI?
1 / 1 point
Unpivot columns
Merge queries
Split columns
Pivot column
Correct
That’s correct! Unpivot columns is the most
suitable transformation operation in the query editor to convert multiple
columns into rows, allowing you to reshape the data as per the requirements.
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
Data view of Power BI
desktop
Model view of Power BI
desktop
Power query editor
Page view of Power BI
desktop
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 imported an Excel workbook in Power BI, and during import, you
received the following message: "We could not find any data formatted as a
table." What should you do to resolve this error?
0 / 1 point
In Power BI, add an organizational app.
In the Excel workbook, select the data you want to import, create a
table, and save the changes.
In Power BI, add a template app.
In the Excel workbook, select the data you want to import, select the Data
validation button, and save the change.
Incorrect
Not quite. Please review the video Understanding
fact and dimension tables.
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
Extract
Reverse rows
Transpose
Pivot
Correct
That’s correct! The Transpose function in the
query editor converts rows to columns and columns to rows.
12.
Question
12
In the Power query editor, the column statistics show a count of 1000
rows, but your query is retrieving data from a data source that contains 5000
rows. What should you do for the column statistics to show the statistics based
on entire data rows?
1 / 1 point
Change the query load from Import to DirectQuery.
Create a Top N row count parameter for the
query.
From the query window, select Column profiling on the entire
dataset.
Add a Table.Buffer applied step using
M in the query.
Correct
That’s correct! Selecting the Column profiling for the entire
dataset will change the column profiler to analyze the entire query dataset.
13.
Question
13
Which Power BI component allows you to create and manage dataflows?
1 / 1 point
Power BI desktop interface
Power query from Power BI desktop
Power BI Service
Power BI data modeler
Correct
That’s correct! You can only create and manage dataflows in the Power BI
service and use them from Power BI desktop.
14.
Question
14
You have a Power BI project with a large dataset. You have applied an
extensive set of transformation operations to the dataset for analysis and
visualization. You need to duplicate the data table for some additional
analytical tasks. What transformation can you do to avoid repeating the
transformation steps you already performed on the query?
1 / 1 point
Reference query from the query editor
Duplicate query from the query editor.
Duplicate the data model.
Duplicate and save Power BI file with a different name.
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 that contains three data tables: Sales, Products, and Date.
Both the Product and Date table are related
to the Sales table via
one-to-many relationships. You want to analyze products sold by year. What
should you do to analyze annual product sales? Select all that apply.
1 / 1 point
Set up a Both cross-filter
direction between the Product and Sales tables.
Correct
That’s correct! Changing the cross-filter direction between the Product and the Sales tables will display
the correct sales amount for each product sold per year.
Set up a many-to-many relationship between the Date and the Sales tables.
Set up cross filter direction to Both between Date and Sales tables.
Set up a many-to-many relationship between the Product and the Sales tables.
Use USERRELATIONSHIP to handle the
cross-filter direction.
Correct
That’s correct! The use of the USERRELATIONSHIP function while
defining a DAX measure will not change the cross-filter direction for the
entire data model and only temporarily switch the cross-filter direction for
the calculations under consideration.
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 USERRELATIONSHIP function.
Using the CROSSFILTER function.
Using the KEEPFILTERS function.
Managing the relationship from the Manage
relationship window
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 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?
0 / 1 point
Use the CALENDAR function 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 CALENDARAUTO and specify the
dates.
Incorrect
Not quite. Please review the video Setting
up a common date 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.
0 / 1 point
The Power query editor.
Correct
That’s correct! You can configure fundamental table and column
properties in the query editor of Power BI desktop.
Visualizations pane 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.
Advanced editor.
This should not be selected
Not quite. Please review the activity Configuring
the table and column properties.
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 Power query editor, add a conditional column to the Salesperson
table.
In the Report view, activate the
view as a feature.
In the Report view, create a what-if
parameter.
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
Which of the following statements about Measures in Power BI is
true? Select all that apply.
1 / 1 point
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.
Measures can reference other measures during calculations.
Correct
That’s correct! You can reference previously computed measures to
calculate the new measures.
Measures can only be created using DAX in Power BI.
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?
0 / 1 point
FILTER and SUM.
FILTER and SUMX.
FILTER and CALCULATE.
SUM and CALCULATE.
Incorrect
Not quite. Please review the video Using
CALCULATE with filters.
22.
Question
22
Profit margin is a non-additive
measure, which DAX function should you use to handle this?
0 / 1 point
AVERAGE
FIRSTNONBLANK
SUMX
DIVIDE
Incorrect
Not quite. Please review the video Additive,
semi-additive and non-additive measures.
23.
Question
23
You have a hospital emergency Power BI data model, and you want to know
the emergency visits for the last 30 days. Which of the two DAX functions can
you use to compute this measure? Select all that apply.
1 / 1 point
DATESINPERIOD
Correct
That’s correct! This function takes today's date as a parameter. You
then need to define the number of intervals which is 30 for the current
measure.
TOTALYTD
DATESBETWEEN
Correct
That’s correct! You can define the two time periods as the start and the
end to compute the hospital visits.
SAMEPERIODLASTMONTH
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.
1 / 1 point
True
False
Correct
That’s correct! Power BI service does not support the creation of quick
measures. You need to go back to Power BI desktop to create a quick measure for
your analysis.
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 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 a filter in the Filters on this visual well of the Filters pane.
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 Add drill-through fields here well of the Visualizationpane.
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.
Configure the Query reduction option Slicer settings.
Configure the Query reduction option filter settings.
Set the storage mode property of tables to import.
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
What are the potential performance benefits of removing unnecessary
columns from the data model? Select all that apply.
0 / 1 point
Increasing the refresh speed.
Correct
That’s correct! Fewer columns mean reducing the data model size and it
takes less time to refresh the model.
Decreasing report page load times.
This should not be selected
Not quite. Please review the walkthrough Optimizing
a direct query model.
Increasing DAX performance.
This should not be selected
Not quite. Please review the walkthrough Optimizing
a direct query model.
Reducing the size of data model.
Correct
That’s correct! Fewer columns mean there is less data to import
therefore reducing the model size.
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
Visualizationpane.
Power query profiling tool.
Performance analyzer.
Power BI data Modeler.
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 planning to create a report in Power BI desktop to visualize the
relationship between the number of orders received and the number of orders
shipped by product category. You must identify the visual that will clearly
identify the outliers in the dataset by displaying them away from the cluster
of data.
Which visual should you choose?
1 / 1 point
Treemap
Scatter plot
Gauge
Card
Correct
That’s correct! A Scatter plot displays a
relationship between values associated with two axes: one set of numerical data
along a horizontal axis and another set of numerical data along the vertical
axis. It displays outliers away from the bulk of the data.
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 KPI
A Scatter plot
A Waterfall chart
Card visual
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 Date
hierarchy on the X-axis and create a Slicer drop-down for
salespersons.
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
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
When might you choose to use a Paginated report over an interactive
report in Power BI?
1 / 1 point
For real-time data analysis.
When designing for mobile devices.
When you need to print the report in tabular format
For ad-hoc queries.
Correct
That’s correct! The major advantage of paginated reports is you can
print all the data in a table, no matter how long it is.
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.
0 / 1 point
Expand
Filter
Correct
That’s correct! A Filter changes the
behavior by showing you the filtered data in the visual.
Highlight
Correct
That’s correct! Highlight is the default
interaction between the visual which shows you both unfiltered and filtered
values in the visual.
Drill through
This should not be selected
Not quite. Please review the video Report
hierarchies.
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
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.
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 Bookmark and then use Conditional
formatting to specify the destination.
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.
37.
Question
37
You have a Power BI dataset where each employee is reporting to multiple
managers in the organizational hierarchy. How can you handle such a situation?
1 / 1 point
Implement only the most important employee-manager relationship in your
report.
Utilize the PATH DAX function to
handle the organizational hierarchy.
Utilize the PATHLENGTH DAX function to
handle the organizational hierarchy.
Create a separate report for each employee-manager relationship.
Correct
That’s correct! You can use the PATH function to handle
parent-child hierarchy which creates a separate path for each employee-manager
relationship.
38.
Question
38
The Analyze in Excel feature allows you to summarize data in Excel with
a live connection. What is the maximum row limit of summarized data with a live
connection?
1 / 1 point
You cannot analyze data in Excel as summarization with a live
connection.
Five hundred thousand
Three hundred thousand
The same as the source dataset.
Correct
That’s correct! Power BI allows you to analyze in Excel with
summarization for a maximum of five hundred thousand rows.
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 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 report builder
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
Line chart
Scatter chart
Area chart
Waterfall 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
What features can you configure in the Q&A feature of Power
BI desktop? Select all that apply.
0 / 1 point
Modeling
Synonyms
Correct
That’s correct! You can add synonyms for the fields present in your
datasets to let Power BI Q&A understand various
terms users can use to ask questions.
Relationships
Visual formatting
This should not be selected
Not quite. Please review the readings Activity: Add the Q&A
feature to a dashboard and Activity
Using the Q&A feature for reports.
Review Questions
Correct
That’s correct! You can review the questions users have asked about your
data and you can fix the misunderstanding for better user experience.
42.
Question
42
In Power BI where can you find time series charts?
0 / 1 point
The Fields pane contains the time
series charts.
In the Filter pane of Power BI
Desktop.
Time series charts are in the Visualizations pane.
You need to import time series charts from AppSource.
Incorrect
Not quite. Please review the reading Activity:
using the Play axis visualization.
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
Viewer
Admin
Member
Correct
That’s correct! The Contributor role is the least privileged role that
grants permission to schedule data refreshes.
44.
Question
44
You have a Power BI data model from which you need to create reports and
dashboards. In which scenario do you need a dashboard for a report in Power BI?
1 / 1 point
You need to add filters.
You need to add slicers.
You need to display visuals from multiple pages.
You need to display visuals that use different datasets.
Correct
That’s correct! Power BI dashboards can combine data from multiple
datasets and do not support reports.
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
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.
Custom visuals
Gauge
Correct
That’s correct! You can set up and manage Alerts in the Gauge visual, within the
Power BI service.
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.
46.
Question
46
True or False: Only Power BI administrators can promote content in Power
BI service.
1 / 1 point
True
False
Correct
That’s correct! Any content owner or user with the Write permission can
promote the content in Power BI Service.
47.
Question
47
What is the primary advantage of deployment pipelines in Power BI?
1 / 1 point
Less manual work and fewer errors.
Semantic model (dataset) creation is streamlined.
Reports can be published from multiple workspace environments.
Enhanced user access to BI report source data.
Correct
That’s correct! Implementation of deployment pipelines reduces manual
work and errors.
48.
Question
48
You are creating and managing dataflows for your organization. The
company’s data is hosted in on-premises SQL Server.
True or False: To create the dataflows, you do not need to install and
configure data gateways.
1 / 1 point
True
False
Correct
That’s correct! To create dataflows in Power BI service, you must
install and configure data gateway to retrieve data from on-premises SQL server
to the dataflows.
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.
1 / 1 point
True
False
Correct
That’s correct! If you delete, add, or rename a column in the table
structure of schema, the changes only can be applied to Power BI desktop upon
data refresh.
50.
Question
50
Which of the following security groups cannot add to row-level security
in Power BI?
0 / 1 point
Mail-enabled group
Distribution group
Azure Active Directory Security Group
Microsoft 365 Group
Incorrect
Not quite. Please review the video Row level
security.
0 comments:
Post a Comment