Segundo Intento de Practica

Resumen de la respuesta
A continuación se incluye un resumen de sus respuestas.

Volver al informe
Pregunta 1 de 50
You plan to get data for a Power BI dataset from flat files.
You need a location type to store the files. The data must NOT automatically
synchronize between the original file and the dataset.
Which location type should you recommend?
Su respuesta
 local file
Esta respuesta es correcta.
Respuesta correcta
 local file
The local file option will result in importing the file contents without providing
automatic synchronization between the original file and the dataset. SharePoint –
Team Sites, personal OneDrive accounts, and OneDrive for Business provide the
ability to automatically synchronize flat files and Power BI datasets.
Get data from files - Training | Microsoft Learn
Pregunta 2 de 50
You plan to get data for a Power BI dataset from flat files.
You need a location type that requires you to provide credentials of a Microsoft
account.
Which location type should you recommend?
Su respuesta
 SharePoint – Team Sites
Esta respuesta es incorrecta.
Respuesta correcta
 personal OneDrive account
A personal OneDrive account provides the ability to automatically synchronize flat
files residing in a user's OneDrive and Power BI datasets. Since it relies on OneDrive
access, it requires the user's credentials of the corresponding Microsoft account.
The OneDrive - Business option uses Azure Active Directory credentials. The
SharePoint – Team Sites option uses the same Azure Active Directory credentials as
the ones used to access SharePoint Online. For the local file option, no additional
credentials are required to access them.
Pregunta 3 de 50
You need to make changes to your data sources.
Which three changes are supported by the Data Source Settings in the Power
Query interface? Each correct answer presents a complete solution.
Su respuesta
 editing permissions
 modifying the file path
 clearing permissions
Respuesta correcta
 editing permissions
 modifying the file path
 clearing permissions
The Data Source Settings in the Power Query interface supports editing
permissions, clearing permissions, and modifying the path of the data source file.
Any structural changes to a file, such as adding, removing, or renaming columns
are not supported by the Data Source Settings in the Power Query interface.
Pregunta 4 de 50
You have multiple Excel files stored in a folder synced with OneDrive for Business.
You need to import data from the files. The solution must NOT use a data gateway.
Which type of connector should you use?
Su respuesta
 SharePoint folder
Respuesta correcta
 SharePoint folder
A SharePoint folder is the only connector that will allow the import of multiple
Excel (or CSV) files stored in a OneDrive for Business folder, without using a data
gateway. While you can connect to the folder on an on-premises device, it would
require a data gateway to refresh in the service. An Excel workbook would only
connect to a single Excel file and would also require a data gateway. A SharePoint
list connector only connects to SharePoint lists and cannot connect to Excel files.
Power Query SharePoint folder connector - Power Query | Microsoft Learn
Pregunta 5 de 50
You plan to publish a dataset from Power BI Desktop.
You need to ensure that a server name can be changed after the dataset has been
published to the Power BI Service.
Which two actions should you perform? Each correct answer presents part of the
solution.
Su respuesta
 Update the Source applied step of all related queries to reference the server
name query.
 From the Data source settings in Power BI Desktop, update the permissions.
Respuesta correcta
 Create a parameter.
 From the Data source settings, update the server source to use a parameter.
A parameter is the only part of a query that can be updated or changed in the
Power BI service, by accessing the dataset settings. Updating the server source to
use a parameter will update all existing queries pointing to the current server to
instead use a parameter with that server name. This parameter can now be
changed once this dataset is published to the Power BI service.
Get data from relational data sources - Training | Microsoft Learn
Using parameters | Microsoft Learn
Pregunta 6 de 50
You create a Power BI data source which uses a SQL SELECT statement. The SQL
statement queries multiple tables in a SQL Server database and includes
subqueries.
When importing data from the data source into Power BI, you receive the following
error message: “Timeout expired.”
You verify that network connection to the SQL Server has sufficient available
bandwidth and low latency.
You need to minimize the occurrences of the timeout issues indicated by the
message.
What should you do?
Su respuesta
 Implement groupings in the SQL statement.
Respuesta correcta
 Divide the SQL statement into separate data sources.
Dividing the SQL statement into separate data sources would minimize the amount
of processing on the SQL Server side. This would minimize or even eliminate the
timeout issues. Groupings, aggregations, and using nested queries would either
have no impact on timeout issues or further increase the amount of processing on
the SQL Server side, resulting in more frequent timeout issues.
Resolve data import errors - Training | Microsoft Learn
Pregunta 7 de 50
From Power BI Desktop, you create a data source by importing an Excel file.
You plan to identify data anomalies within the data source.
Which interface should you use to display the column distribution and column
quality graphs?
Su respuesta
 Advanced Editor in Power Query Editor
Respuesta correcta
 Power Query Editor
Power Query Editor provides the ability to display the column distribution and
column quality graphs. Data view provides access to data within a dataset. Model
view provides access to the data model of a dataset. Advanced Editor of Power
Query Editor provides the ability to work with the M code used for shaping data in
Power Query Editor.
Profile data in Power BI - Training | Microsoft Learn
Pregunta 8 de 50
You import an Excel file into Power BI Desktop and begin to analyze the data in
Power Query Editor.
You need to identify outliers in a text column within the data source.
Which information should you use from Power Query Editor?
Su respuesta
 the value of the Unique entry in Column statistics.
Respuesta correcta
 the top and bottom entries in Value distribution
The top and bottom entries in Value distribution identify outliers, which appear,
respectively, the greatest and the smallest number of times in that column. The
value of the Distinct entry in Column statistics indicates the total count of different
values. The value of the Unique entry in Column statistics indicates the total count
of different values that appear only once. The min and max values in the Column
profile of a text column designate the entries which appear, respectively, first and
last in alphabetical order.
Profile data in Power BI - Training | Microsoft Learn
Pregunta 9 de 50
You have an Excel spreadsheet that contains three columns labeled Year, 2021, and
2012. The entries in rows for the first column consists of names of the individual
months in the year while the other two columns contain the sales amount for each
month for the corresponding year.
You import data from the Excel spreadsheet into Power BI Desktop.
You need to transform the data so it will consist of three columns, with the first one
containing month, the second containing year, and the third containing the sales
amount for that month and year.
Which transformation should you use first?
Su respuesta
 Unpivot
Respuesta correcta
 Unpivot
Selecting Unpivot will allow you to shape the current table into the one with the
year, month, and sales amount columns, which will need to be renamed afterwards.
Pivot would be applicable in the opposite scenario, in which flat data needs to be
reorganized into one containing aggregate values for each unique value in each
column. Transposing would switch tables and columns. Removing columns would
result in a table with insufficient data to perform unpivot.
Shape the initial data - Training | Microsoft Learn
Unpivot columns - Power Query | Microsoft Learn
Pregunta 10 de 50
You have a query named FactSales that retrieves data from a SQL Server table.
You need to update the query to prevent new columns that may be added to the
table in the future from getting imported during dataset refreshes.
Which two applied steps can you use in Power Query Editor to achieve the goal?
Each correct answer presents a complete solution.
Su respuesta
 Remove Columns
 Remove Other Columns
Respuesta correcta
 Choose Columns
 Remove Other Columns
Using the Choose Columns and Remove Other Columns options will allow you to
explicitly select the columns that you want to keep. Enforcing the requirement that
new columns will not be automatically added in the future. Using Remove Columns
will delete the selected columns in the table, but new columns that get added in
the future will still be imported automatically. Transpose treats rows as columns,
and columns as rows. It will not limit the number of columns being imported.
Choose or remove columns - Power Query | Microsoft Learn
Pregunta 11 de 50
You connect Power Query Editor to a database table.
You need to remove the Row ID column. Your solution must ensure that new
columns do NOT display in the table model during a scheduled refresh in the
future.
What transformation should you use?
Su respuesta
 Select Row ID, then use the Remove Other Columns command.
Respuesta correcta
 Use the Select Columns command and chose the columns to keep.
Only the Select Columns command will let you choose columns to keep, delete
the columns you do not want, and prevent new columns from showing up in the
table in the future.
Pregunta 12 de 50
You have a Power BI data source that contains the following tables:
 Category: Lists the product category
 Subcategory: Lists the product subcategory
 ProductName: Lists the name of the product
You need to optimize the star schema model for the Power BI dataset.
How should the tables be imported into the model?
Su respuesta
 Use the append command to create a single loaded table for product.
Respuesta correcta
 Use the combine command to create a single loaded table for product.
A star schema should have a single table for each dimension or product, so using
the combine command is what is required to create a single product table and aim
towards a star schema design.
Combine multiple tables into a single table - Training | Microsoft Learn
Pregunta 13 de 50
You have a fact table that contains sales data.
The fact table includes a SalesDate column formatted as a Date data type. Auto
date/time setting is disabled in both global and current file options.
You load the fact table into Power BI Desktop.
You need to ensure that you are able to analyze data on a yearly, quarterly,
monthly, weekly, and daily basis. Your solution must minimize the model size and
administrative effort.
What should you do?
Su respuesta
 Enable the Auto date/time current file option.
Respuesta correcta
 Add a separate date dimension table.
Adding a separate date dimension table that includes year, month, and week
information is the optimal approach which provides the required functionality,
while minimizing the model size and administrative effort. Adding a year, month,
and week columns to the fact table would increase the amount of administrative
effort. Enabling the Auto date/time global or current file option would increase the
model size. In addition, it would not provide the ability to describe weekly time
periods (only year, quarter, month, and day).
Evaluate and change column data types - Training | Microsoft Learn
Auto date/time guidance in Power BI Desktop - Power BI | Microsoft Learn
Pregunta 14 de 50
You have created a Power BI dataset and need to create multiple reports.
What is a benefit of using a Power BI dataset as a data source for multiple reports
compared to each report having a separate dataset?
Su respuesta
 It reduces the number of datasets, refreshes, and storage requirements in
the Power BI service.
Respuesta correcta
 It reduces the number of datasets, refreshes, and storage requirements in
the Power BI service.
When multiple reports use the same Power BI dataset vs each having their own
import model, you reduce the number of datasets that are needed to be published
to the Power BI service. Fewer datasets mean fewer refreshes, less storage space
requirements, and less overhead for admins.
Get data from Azure Analysis Services - Training | Microsoft Learn
Connect to datasets in the Power BI service from Power BI Desktop - Power BI |
Microsoft Learn
Pregunta 15 de 50
You have a Power BI Desktop dataset that includes a table named Salesperson. The
table includes a column named UPN. UPN contains the user principal name of the
salesperson’s Azure AD account.
You need to ensure that each salesperson will only be able to see the rows in the
Salesperson table where the UPN column value matches their User Principal Name.
Which two actions should you perform? Each correct answer presents part of the
solution.
Su respuesta
 Add a DAX expression filter to the Salesperson table.
 Add a calculated column to the Salesperson table.
Respuesta correcta
 Create a role.
 Add a DAX expression filter to the Salesperson table.
As part of setting up row-level security, it is necessary to create a role. In addition,
it is necessary to add a DAX expression filter to the Salesperson table. This
expression checks for a match between the salesperson's User Principal Name
attribute and the value in the UPN column. If the two match, the salesperson is
allowed to view the content of the corresponding row from the Salesperson table.
Configure row-level security with the dynamic method - Training | Microsoft Learn
Pregunta 16 de 50
You have designed a star schema to simplify your data.
You need to understand the relationship between the tables in the star schema.
What is the relationship between the fact tables and dimension tables?
Su respuesta
 many-to-one
Respuesta correcta
 many-to-one
There is a many-to-one relationship between a fact table and dimension table. For
each row in a dimension table there may be multiple matching rows in the fact
table.
Introduction - Training | Microsoft Learn
Pregunta 17 de 50
You create a Power BI Desktop dataset by importing and transforming a data
source based on multiple tables in a SQL Server database.
You need to modify the relationship between the tables.
Which interface should you use in the Power BI Desktop?
Su respuesta
 Model view
Respuesta correcta
 Model view
The relationship between tables is configurable from the Model view. The Data
view provides access to data within a dataset. The Report view provides the ability
to build reports. The Page view is an option available from within the Report view
and is intended to simplify designing and building reports.
Work with tables - Training | Microsoft Learn
Pregunta 18 de 50
You have a Power BI model.
You need to assign items to a display folder.
Which three items can be assigned to a display folder? Each correct answer
presents part of the solution.
Su respuesta
 Column
 Calculated column
 Measure
Respuesta correcta
 Column
 Calculated column
 Measure
Tables and reports cannot be assigned a display folder. Columns, calculated
columns, and measures can be assigned a display folder.
Lab - Model data in Power BI Desktop, Part 1 - Training | Microsoft Learn
Pregunta 19 de 50
You plan to use the calculated table functionality to add a duplicate table in Power
BI Desktop.
Which characteristics of the original table will be duplicated?
Su respuesta
 data only
Respuesta correcta
 data only
A calculated table only duplicates data. Any model configurations such as column
visibility or hierarchies must be recreated if needed.
Introduction - Training | Microsoft Learn
Pregunta 20 de 50
You need to develop a quick measure in Power BI Desktop.
Which two elements can you use? Each correct answer presents a complete
solution.
Su respuesta
 Calculations
 Fields
Respuesta correcta
 Calculations
 Fields
When creating a quick measure in Power BI Desktop, you apply calculations to
fields. You do not explicitly create a DAX query, but you choose calculations and
fields, which result in automatic generation of a DAX query. Conditional columns
are separate from quick measures. Unlike quick measures, they create a value for
each row in a table and are stored in the .pbix file. Power Query M functions are
not directly accessible from the Quick Measure interface.
Lab - Model data in Power BI Desktop, Part 1 - Training | Microsoft Learn
Introduction to DAX - Training | Microsoft Learn
Pregunta 21 de 50
In Power BI Desktop, you need to create a measure.
Which two interfaces can you use? Each correct answer presents a complete the
solution.
Su respuesta
 Data view
 Report view
Respuesta correcta
 Data view
 Report view
The Report view provides the ability to create measures. To create a measure, use
the context sensitive menu of the Fields list or the Calculations section of the
ribbon. The Data view provides access to data within a dataset and includes the
option to create a measure in the Calculations section of the ribbon. Model view,
Page view, and Power Query Editor do not include the option to create a measure.
Pregunta 22 de 50
You have a Power BI Desktop dataset that includes a table named Warehouse. The
Warehouse table includes a column named Inventory Count, which contains the
current number of items for each row of a particular type on a given day.
You have the following Data Analysis Expression (DAX) query that calculates the
sum of all values in the Inventory Count column of the Warehouse table:
Current Inventory Count =
CALCULATE (
SUM ( 'Warehouse'[Inventory Count] ))
You need to ensure that Current Inventory Count returns only the current total
number of inventory items, rather than the sum of all inventory items that includes
item counts from previous days.
What DAX function should you include in the query?
Su respuesta
 DISTINCTCOUNT
Respuesta correcta
 LASTDATE
The LASTDATE function will ensure that the SUM function applies only to the last date
of the time period, resulting in a semi-additive behavior. The DISTINCTCOUNT function
counts the number of distinct values in a column, which results in additive
behavior. The CALENDAR function returns a table with a column named Date that
contains a contiguous set of dates based on the start date and end date that you
specify. The CALENDARAUTO function returns a table with a column named Date that
contains a contiguous set of dates based on data in the model.
Create semi-additive measures - Training | Microsoft Learn
Pregunta 23 de 50
You need to enhance a data model by using Power BI Desktop.
Data for which two model items can be created using the DAX language? Each
correct answer presents a complete solution.
Su respuesta
 calculated table
 hierarchies
Respuesta correcta
 calculated table
 numeric range parameter
Calculated tables are generated with DAX queries. Numeric range parameters
create a table and measure, both generated with DAX queries. The enter data
button creates a manual table using the M language and Power Query. Display
folders are a way to visually organize measures, columns, or hierarchies. DAX is not
used to create them.
Pregunta 24 de 50
You need to use DAX quick measures to generate results to use in a report.
Which type of DAX quick measure calculations will NOT work against a DirectQuery
table?
Su respuesta
 time intelligence
Respuesta correcta
 time intelligence
Time intelligence functions have performance implications and are disabled for
quick measures against DirectQuery tables. Mathematical operations, aggregate
per category, and X-functions are all supported against DirectQuery.
Use quick measures for common and powerful calculations - Power BI | Microsoft
Learn
Pregunta 25 de 50
You need to reduce the size of a Power BI model that contains two dimension
tables named Date and Location, and one fact table named Temperatures. The
Temperatures table contains the following fields:
 Reading Time (datetime)
 DateKey (date)
 LocationKey (whole number)
 Temp C (decimal)
You have one row for every 5-minute interval for each location. The Temperatures
table is related to the Date and Location dimensions by using many-to-one
relationships.
You need to reduce the cardinality of the table. The solution must ensure that the
dataset supports reports that analyze average temperature by hour and location.
What two actions should you perform? Each correct answer presents part of the
solution.
Su respuesta
 Use the Group By functionality to aggregate the rows by DateKey, Reading
Time, and LocationKey and then create a max Temp C value per row.
 Remove the rows that occur exactly at 0 minutes and 0 seconds on the hour.
Respuesta correcta
 Create a column that contains the time values for the start of the hour of the
Reading Time value.
 Use the Group By functionality to aggregate the rows by hour, DateKey, and
LocationKey and then create an average Temp C value per row.
Creating a column that displays the hour is necessary to summarize by hour when
there is no Time or Hour dimension. Summarizing the table by using the Group By
functionality reduces the number of rows. Reporting requirements dictate that the
aggregated temperature value should be an average. The table should be
summarized by hour, DateKey, and LocationKey in order to support the required
reports. Removing rows that occur exactly on the hour removes data and does not
support the reporting requirements. Disabling the query load removes the table
from the model completely.
Reduce cardinality - Training | Microsoft Learn
Pregunta 26 de 50
You plan to optimize the performance of Power BI Desktop queries against a
remote data source.
You need to disable the default behavior that automatically applies cross
highlighting and filtering of visuals within the same report.
Which option should you configure in Power BI Desktop?
Su respuesta
 the Filters Query reduction settings
Respuesta correcta
 the Reduce number of queries sent by Query reduction setting
The Reduce number of queries sent by Query reduction setting disables the default
behavior that automatically applies cross highlighting and filtering of visuals within
the same report. The Slicers Query reduction settings allow you to instantly apply
slicer changes and add an Apply button to each slicer. The Filters Query reduction
settings allow you to instantly apply basic filter changes. The Persistent filters of
Report settings allow you to prevent users from saving filters in the Power BI
service.
Optimize DirectQuery models with table level storage - Training | Microsoft Learn
Pregunta 27 de 50
You are designing a data model for Power BI Desktop.
You need to reduce the model size.
Which technique should you use to reduce the model size?
Su respuesta
 Configure the Query reduction option Filters settings.
Respuesta correcta
 Set the Storage Mode property of tables to Direct Query.
Setting the Storage Mode property of tables to Direct Query reduces the model
size since only schema of the data source is stored locally. Setting the Storage
Mode property of tables to Import will import data into Power BI desktop,
effectively increasing the model size. Configuring the Query reduction option
Slicers or Filters settings has no effect on data model size.
Reduce cardinality - Training | Microsoft Learn
Pregunta 28 de 50
You decide to start using variables when creating DAX formulas.
What are two benefits of using variables in DAX measures over using original
expressions? Each correct answer presents a complete solution.
Su respuesta
 improves the overall readability of the resulting DAX measure
 improves the overall performance of the resulting DAX measure
Respuesta correcta
 improves the overall readability of the resulting DAX measure
 improves the overall performance of the resulting DAX measure
Variable names are often shorter than the original expressions, and the final
variable returned at the end of the measure will be more readable with variable
names included. Variables cache the defined calculation, allowing it to be
referenced multiple times without additional impacts from recalculations. The
functions in DAX are universal, and there are no specific functions that can only be
used within variables. The data source connection is set in the model and cannot
be changed from within a DAX measure.
Use variables to improve performance and troubleshooting - Training | Microsoft
Learn
Pregunta 29 de 50
You have a Power BI data source.
You need to analyze the data to meet the following requirements:
 Add a Top 10 filter to a visual.
 Ensure that the filter does NOT display in the Filters on this
visual display for that Visual Header icon.
 Title the visual “Top 10 Product Category by Sales Amount”.
What should you do?
Su respuesta
 Hide the visual header for this visual.
Respuesta correcta
 Hide the Top 10 filter in the visual level filters for this visual in
the Filters pane.
Only hiding the top 10 filter from the visual level filters in the filters pane will hide
just this filter but allow other filters to show under the Filters on this visual icon
for this visual.
Use advanced interactions and drill through - Training | Microsoft Learn
Pregunta 30 de 50
You plan to create a report in Power BI Desktop.
You need to create a visualization that displays data in a two or more dimensions
and cross-highlights with other visuals on the same report page.
Which type of visualization should you use?
Su respuesta
 matrix
Respuesta correcta
 matrix
A matrix visualization displays data in two or more dimensions and cross-highlights
with other visuals on the same report page. A card visualization displays a single
data point. A scatter visualization is a chart, not a grid. It has two value axes, with
one set of numerical data along a horizontal axis and another set of numerical
values along a vertical axis. A table visualization is a grid that contains related data
in a grid format, with support for two dimensions only.
Choose an effective visualization - Training | Microsoft Learn
Pregunta 31 de 50
You need to create a custom Python visual by using Power BI Desktop.
What do you need to do first?
Su respuesta
 Install Python on your computer.
Respuesta correcta
 Enable the script visuals option in the Visualization pane of Power BI
Desktop.
Enabling the script visuals option in the Visualization pane of Power BI Desktop is
required before creating custom Python visuals in Power BI Desktop. Installing
Python is not required. Configuring global Python scripting options in Power BI
Desktop is not required to create Python visuals. The ability to create a custom
Python visual by using Power BI Desktop has no dependency on enabling preview
features.
Add an R or Python visual - Training | Microsoft Learn
Pregunta 32 de 50
You need to create a bookmark that toggles the visibility of a visual.
This bookmark must only toggle the visibility state and perform no other action.
Which three configurations should you make? Each correct answer presents part of
the solution.
Su respuesta
 Enable the Display option.
 Disable the Display option.
Respuesta correcta
 Disable the Data option.
 Enable the Display option.
 Disable the Current Page option
The current page capture allows the bookmark to navigate back to the page of
capture. The data capture updates filters and drillthrough which should not occur
for this bookmark. The display capture updates visual visibility on the report page.
Add buttons, bookmarks, and selections - Training | Microsoft Learn
Overview of bookmarks in Power BI service reports - Power BI | Microsoft Learn
Pregunta 33 de 50
You implement the Q&A feature in a report, so users can get answers to their
questions on their own.
You need to improve your Q&A search capabilities for end-users.
Which two configurations can you add? Each correct answer presents a complete
solution.
Su respuesta
 Add synonyms to model fields.
 Add a linguistic schema to the dataset.
Respuesta correcta
 Add synonyms to model fields.
 Add a linguistic schema to the dataset.
Adding synonyms to model fields will help users search for them. For example, you
can give a synonym of (Actuals) for the (Sales) measure. A linguistic schema
describes terms and phrases that Q&A should understand for objects within a
dataset, including parts of speech, synonyms, and phrasings that relate to that
dataset. Composite models are not supported by Q&A today. Organizing fields by
display folders will not impact Q&A search capabilities.
Use the Q&A visual - Training | Microsoft Learn
Pregunta 34 de 50
You are modifying a report in Power BI Desktop. The report contains a single report
page that has three card visuals and one clustered bar chart.
You need to create a bookmark that displays only the clustered bar chart and hides
the cards. The solution must minimize development effort.
What should you do first?
Su respuesta
 Hide the three cards in the Selection Pane.
Respuesta correcta
 Hide the three cards in the Selection Pane.
Before you create a bookmark, you need to configure the report page to show the
state you want to capture in the bookmark. Visuals are visible by default, therefore,
you must mark them as hidden. To add a bookmark, you first need to update the
bookmark after hiding the visuals. Bookmarks can be created in Power BI without
publishing to the Power BI service. While spotlight does focus on the clustered bar
chart, it does not completely hide the cards.
Add buttons, bookmarks, and selections - Training | Microsoft Learn
Pregunta 35 de 50
From Power BI Desktop, you open a Power BI report that contains three pages
named Main, Error Rate, and On-time Rate.
You add a button to the Main page for navigation.
You need to implement a solution that meets the following requirements:
 The navigation destination must change based on the output of a DAX
measure named [Error Rate].
 If [Error Rate] is greater than 5%, the button must display the text
“Error Rate” and navigate to the Error Rate page.
 Otherwise, the button must display the text “On-time Rate” and
navigate to the On-Time Rate page.
What three actions should you perform? Each correct answer presents part of the
solution.
Su respuesta
 Create a DAX measure that outputs the correct page name based on the
value of [Error Rate].
 Set the button type to Page Navigation and then use conditional formatting
to specify the destination.
 Set the navigation destination to the Error Rate page.
Respuesta correcta
 Create a DAX measure that outputs the correct page name based on the
value of [Error Rate].
 Set the button type to Page Navigation and then use conditional formatting
to specify the destination.
 Use conditional formatting to set the button text.
To configure a button for conditional page navigation, you need to create a DAX
measure that outputs the correct destination page name. Then configure the
button to use page navigation and use the newly created DAX measure to specify
the navigation destination. 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. No bookmarks are necessary. It is not necessary to set the destination to
a specific page since conditional formatting is used to specify the destination.
Design report navigation - Training | Microsoft Learn
Pregunta 36 de 50
You plan to build a Power BI report and set up conditional formatting of data fields.
You need to identify two visuals that support the conditional formatting
functionality.
Which two types of visuals should you identify? Each correct answer presents a
complete solution.
Su respuesta
 matrix
 scatter chart
Respuesta correcta
 matrix
 table
Matrix and table visuals support conditional formatting. Gauge chart, scatter chart,
and treemap do not support conditional formatting.
Configure conditional formatting - Training | Microsoft Learn
Pregunta 37 de 50
You have a bar chart and column chart visual on a report page. Selecting any
column from the bar chart visual filters the column chart data to less than 1% of its
unfiltered value.
Which type of visual interaction should be used when the bar chart is filtering the
column chart to ensure that you can easily see the data?
Su respuesta
 highlight
Respuesta correcta
 filter
Filter will show you the filtered data in this visual. So even when showing filtered
data that is less than 1% of the unfiltered value, it will still display well in the
column visual. Highlight shows you both the unfiltered and filtered values in the
visual, for comparison purposes. Drillthrough is a page navigation experience that
takes you from one page to another plus applies a set of filters to page navigated
to. Expand is a way to navigate down a level using the hierarchy controls.
Use advanced interactions and drill through - Training | Microsoft Learn
Change how visuals interact in a report - Power BI | Microsoft Learn
Pregunta 38 de 50
You plan to create a report in Power BI Desktop that will display the relationship
between the number of orders and the number of orders shipped by product
category.
You need to identify the visual that will clearly identify outliers in the data set by
displaying them away from the bulk of data.
Which visual should you use?
Su respuesta
 scatter
Respuesta correcta
 scatter
A scatter visual displays a relationship between values associated with two axes:
one set of numerical data along a horizontal axis and another set of numerical
values along a vertical axis. It is particularly suitable for identifying outliers because
it displays them away from the bulk of data. A card visual displays a single data
point. A treemap visual displays data as a set of nested rectangles. A gauge visual
displays a circular arc including a single value that measures progress toward a
goal or target.
Identify outliers with Power BI visuals - Training | Microsoft Learn
Pregunta 39 de 50
You plan to use Power BI Desktop to analyze sales data of your company.
You need to identify two types of data you will be able to use for creating bins that
group the sales data.
Which two data types should you identify? Each correct answer presents a
complete solution.
Su respuesta
 Date/time
 Numeric
Respuesta correcta
 Date/time
 Numeric
Date/time and numeric data types support bins-based grouping. Binary, Boolean,
and text data types do not support bins-based grouping.
Group and bin data for analysis - Training | Microsoft Learn
Pregunta 40 de 50
You need to create a report in Power BI Desktop that will display the sales data of
your company such that customers of a similar age will be grouped into clusters.
Which visual should you add to the report?
Su respuesta
 treemap
Respuesta correcta
 scatter
Creating a scatter visual is the first step of applying the clustering technique that
groups data into clusters. Card, gauge, and treemap visuals do not support
clustering.
Apply clustering techniques - Training | Microsoft Learn
Pregunta 41 de 50
You need to create a histogram that will display ranges of integers in groups.
Which two resources do you need to create the histogram? Each correct answer
presents part of the solution.
Su respuesta
 a Numerical column
 a Bin group type
Respuesta correcta
 a Numerical column
 a Bin group type
The group is created against a numerical column using bins.
The Bin group type is an auto grouping of items into bucketed bins (groups). It will
display well as a histogram. A DateTime column isn’t required to display histogram
type data against a numerical column. A List group type is a manual grouping of
items into new group names/categories. It doesn’t create auto (binned) groups.
Explore statistical summary - Training | Microsoft Learn
Pregunta 42 de 50
Which native AI visual helps explain correlations for a metric within the dataset?
Su respuesta
 Key influencers visual
Respuesta correcta
 Key influencers visual
The Key influencers visual helps you understand correlated factors impacting a
particular metric. The Q&A visual allows end-users to ask natural language
questions to create AI generated charts based on the questions.
The Decomposition Tree visual lets you visualize data between multiple dimensions
and drill down in any order. The Smart Narrative visual lets you combine natural
language text with metrics from your model in sentence forms.
Find important factors with the Key influencers visual - Training | Microsoft Learn
Pregunta 43 de 50
You are evaluating whether you need to create a dashboard in Power BI.
In which scenario do you need a dashboard instead of a report in Power BI?
Su respuesta
 You need to display visuals that use different datasets.
Respuesta correcta
 You need to display visuals that use different datasets.
The ability to combine data from multiple datasets is one of the features that is
available in dashboards but not supported in reports. Dashboards do not include
the Filter, Visualization, and Fields panes that are available in Power BI Desktop
when working with dashboards. Dashboards, unlike reports, contain only a single
page.
Introduction to dashboards - Training | Microsoft Learn
Pregunta 44 de 50
You upload reports to the Power BI service and pin several visuals to a dashboard.
You plan to create alerts rules for several visuals.
What are two locations you can view the alerts? Each correct answer presents a
complete solution.
Su respuesta
 an email
 the Notification Center
Respuesta correcta
 an email
 the Notification Center
By default, notifications are available in the notification center. You also have the
option of sending notifications via email. A dashboard, Microsoft Teams channel,
and a report are not available as the locations of alerts.
Configure data alerts - Training | Microsoft Learn
Pregunta 45 de 50
You plan to create a Power BI workspace.
You need to ensure that you will be able to configure a Microsoft 365 group whose
SharePoint Online document library is available to workspace users once the
workspace is created.
Which setting should you configure when creating the workspace?
Su respuesta
 Workspace OneDrive
Respuesta correcta
 Workspace OneDrive
The Workspace OneDrive setting allows you to configure a Microsoft 365 group
whose SharePoint Online document library is available to workspace users once the
workspace is created. The Allow contributors to update the app for this workspace
setting is meant to provide additional permissions for workspace contributors. The
Develop a template app setting allows you to set up a template app workspace.
The license mode allows you to choose between Pro, Premium per user, Premium
per capacity, and Embedded licensing.
Distribute a report or dashboard - Training | Microsoft Learn
Create a workspace - Power BI | Microsoft Learn
Pregunta 46 de 50
You plan to certify a Power BI dataset.
You need to identify at which level within your organization the permissions to
certify a dataset are assigned.
Which level should you identify?
Su respuesta
 Tenant
Respuesta correcta
 Tenant
Admin users who have permissions to certify a dataset are defined in the Dataset
Certification tenant admin setting.
Manage and promote datasets - Training | Microsoft Learn
Pregunta 47 de 50
You manage a Power BI workspace in shared capacity. The workspace contains a
dataset named DS1. You plan to schedule the refresh of DS1.
What is the maximum number of data refreshes per day?
Su respuesta
 24
Respuesta correcta
 8
The maximum number of refreshes per day for a Power BI workspace in a shared
capacity is 8.
Configure a dataset scheduled refresh - Training | Microsoft Learn
Pregunta 48 de 50
You have a Power BI dataset.
You need to set the dataset as discoverable.
Which two configurations will allow the dataset to be marked as discoverable? Each
correct answer presents a complete solution.
Su respuesta
 Enable RLS on the dataset.
 Publish dataset to a Premium workspace.
Respuesta correcta
 Certify the dataset.
 Promote the dataset.
A certified dataset can be configured to be discoverable for users without access to
request permissions to access. A promoted dataset can be configured to be
discoverable for users without access to request permissions to access. RLS is not
required on a dataset to become discoverable. Premium (capacity or shared) is not
required to make a dataset discoverable.
Endorse your content - Power BI | Microsoft Learn
Create and manage workspaces in Power BI - Training | Microsoft Learn
Pregunta 49 de 50
You have a collection of datasets and reports.
You need to share the datasets and report together. This solution must NOT send
any email notifications to internal users after sharing.
What should you create in the Power BI Service?
Su respuesta
 an app
Respuesta correcta
 an app
Workspace apps can be installed automatically for any user in an organization, and
without requiring notifications of installation. Deployment pipelines are used for
moving artifacts between test, development, and production environments. Metrics
are where you can create goals based off existing datasets. You can add members
to a workspace, but they receive a notification that they’ve been added to the
workspace.
Distribute a report or dashboard - Training | Microsoft Learn
Pregunta 50 de 50
You have several on-premises Microsoft SQL Server databases.
You need to provide Power BI Service users access to the data sources without
exposing the database servers directly to the internet.
The solution must minimize the configurations that must be performed by each
user.
What should you deploy?
Su respuesta
 an on-premises data gateway
Respuesta correcta
 an on-premises data gateway
An on-premises gateway is designed to allow multiple users to access multiple data
sources. An on-premises data gateway only allows one user to access multiple data
sources. A virtual network data gateway is designed to allow multiple users to
access multiple online data sources. However, it isn’t installed locally and only
works with data sources secured by virtual networks.
Use a Power BI gateway to connect to on-premises data sources - Training |
Microsoft Learn
On-premises data gateway - Power BI | Microsoft Learn
Ir al contenido principal
 Learn
 Documentación
 Formación
 Certificaciones
 Q&A
 Ejemplos de código
 Evaluaciones
 Programa
 Evento
Certificaciones
 Examinar certificaciones
 Renovaciones de certificación
 P+F y ayuda
1. Learn

2. Certificaciones

3. Examinar certificaciones

4. Exam PL-300: Microsoft Power BI Data Analyst
Resultados de la evaluación de
práctica: 16 de junio de 2023
Practice Assessment for Exam PL-300: Microsoft Power BI Data Analyst
Ha tardado 15 minutos en completar esta evaluación.
Resultados generales
Para prepararte mejor para el examen, trata de lograr una puntuación de 80% o
superior varias veces.
Puntuación: 52%
Mostrar mis respuestas
Rendimiento por sección de la valoración
Para reforzar aún más sus conocimientos en las siguientes áreas, consulte la
sección Material de aprendizaje personalizado que se incluye a continuación.
Prepare the Data
Model the Data
Visualize and Analyze the Data
Deploy and Maintain Assets
¿Listo para hacer el examen?
Programar examen Realice otra evaluación de práctica.
Material de aprendizaje personalizado para mejorar sus aptitudes
Dado que tuvo una puntuación menor en "Prepare the Data":

o Limpieza, transformación y carga de datos en Power BI
o 121 min

oObtención de datos en Power BI
o 115 min
Dado que tuvo una puntuación menor en "Model the Data":

o Introducción a la creación de medidas con DAX en Power BI
o 160 min

o Incorporación de tablas y columnas calculadas a modelos de
Power BI Desktop
o 19 min

o Agregar medidas a los modelos de Power BI Desktop
o 13 min

o Diseño de un modelo de datos en Power BI
o 83 min

o Optimización de un modelo para rendimiento en Power BI
o 69 min

oImplementación de la seguridad de nivel de fila
o 9 min
Dado que tuvo una puntuación menor en "Visualize and Analyze the Data":

o Trabajo con objetos visuales de inteligencia artificial en Power BI
o 61 min

o Creación de una historia basada en datos con informes de
Power BI
o 104 min

o Realización de análisis en Power BI
o 51 min

oUso de objetos visuales de Power BI
o 73 min
Dado que tuvo una puntuación menor en "Deploy and Maintain Assets":

o Creación de paneles en Power BI
o 68 min

o Creación y administración de áreas de trabajo en Power BI
o 29 min

o Administración de conjuntos de datos en Power BI
o 32 min

o Implementación de la seguridad de nivel de fila
o 9 min
Guardar la colección personalizada
Español (México)
Tema
 Versiones anteriores
 Blog
 Colaborar
 Privacidad
 Términos de uso
 Marcas comerciales
 © Microsoft 2023

Segundo Intento de Practica

Uploaded by

Copyright:

Available Formats

Segundo Intento de Practica

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Segundo Intento de Practica

Uploaded by

Copyright:

Available Formats

Resumen de la respuesta

A continuación se incluye un resumen de sus respuestas.

You might also like