PL300 Flashcards

Question 1

Q

You have a Power BI dashboard that is comprised of pinned visuals that are taken from a variety of reports.

Which three objects from a report page can be pinned to the dashboard?

Answer

A

custom visiual, ribbon chart, image

Question 2

Q

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.

Answer

A

email, notification center

Question 3

Q

You need to add a new visual to a Power BI Dashboard. This visual does NOT exist on a report in the workspace.

What should you do first?

Answer

A

select add a title

Question 4

Q

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?

Answer

A

workspace onedrive

Question 5

Q

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?

Question 6

Q

You manage a Power BI workspace in shared capacity. The workspace contains a report that uses a dataset named DS1.

You need to implement an incremental refresh of DS1.

What should you do first?

Answer

A

define filter parameter

Question 7

Q

You manage a Power BI workspace that includes a dataset with your company’s sales data. You create a report that displays the sales data grouped by department.

You need to use row-level security to ensure that, once the report is published, employees in each department can only see the sales data for their department.

What should you do first?

Answer

A

in PowerBI desktop, create a role

Question 8

Q

You plan to get data from flat files for a Power BI dataset.

You need to select a location to store the files.

Which location requires an on-premises data gateway?

Answer

A

shared folder on a local network

(local network requires gateway)

Question 9

Q

You plan to get data for a Power BI dataset from flat files.

You need to select a location for the files. The location must provide the ability to configure scheduled refresh for the dataset by using Microsoft 365 credentials.

Which two location types should you recommend? Each correct answer presents a complete solution.

Answer

A

One drive for business

Share Point - Team Sites

(local file does not require credential)

Question 10

Q

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?

Answer

A

SharePoint folder

(the trick is OneDrive from the question, in response, it needs online service, like SharePoint)

Question 11

Q

When importing data from an Excel workbook into Power BI, you receive the error message: “We couldn’t find any data formatted as a table.”

What should you do to resolve the error?

Answer

A

create a table in Excel workbook

The error message indicates that the Excel workbook does not contain a table. To create it, in the Excel workbook, you need to select the data you want to import, press Ctrl+T or choose the Table button, click OK and save the change. Using the Data Validation button in Excel does not create a table. Organizational and template apps provide a way to implement functionality within Power BI, but, in this case, the issue is caused by an absence of a table in the Excel workbook, so installing an app would have no effect on resolving the issue.

Question 12

Q

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?

Answer

A

Top and bottom

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.

Question 13

Q

You use Power BI Desktop to transform a query that retrieves data from an Excel spreadsheet.

You need to view and modify multiple steps in all the M code.

Which interface should you use?

Answer

A

Advanced Editor in PowerQuery (multiple steps)

The Advanced Editor in the Power Query Editor provides the ability to work with all the M code used for shaping data in a query at once. Data view provides access to data within a dataset. Model view provides access to the data model of a dataset. The Formula Bar in the Power Query Editor provides the ability to edit only one step at a time.

Question 14

Q

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?

Answer

A

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 rows and columns. Removing columns would result in a table with insufficient data to perform unpivot.

Question 15

Q

You have a query that has a column named Country and columns for each month of sales data. The names of the sales data columns use a format of Month Year, for example January 2022. The month columns contain the Sales Amount values for each month.

You need to reshape the table to have all sales amount values in a single column.

A new column should also be added and contain the relevant month year for each row of data.

What should you do from the Power Query Editor?

Answer

A

Select the Country column and then select Unpivot Other Columns.

Question 16

Q

From the Power Query Editor, you import data from a .csv file. The data includes a column named ZIP that contains postal codes from the United States.

You notice that Power Query Editor automatically applies the Whole Number data type to the ZIP column.

You need to ensure that the ZIP column uses the Text data type and that all values remain 5 characters long.

What should you do?

Answer

A

From Power Query Editor, update the current changed type step and replace convert from number to text for the ZIP column.

To correctly update the data to text you need to replace the number type conversion with a text conversion, and to keep all other data type column transformations. This needs to be done in the Power Query Editor. Adding a new applied step at the end of the query would result in loosing zip codes that start with 0. Changing the data type in Data View is equivalent to adding an applied step at the end of the query and would not preserve leading zeros. Deleting the changed type step would not set the data type to Text.

Question 17

Q

You have a table that contains a column named ProductID.

The ProductID column contains values that have a prefix of PD followed by five numbers. For example: pd15332.

You plan to convert the ProductID values to numbers (integer).

You need to remove the leading two letters from the current ProductID values.

Which command should you use?

Answer

A

replace values

Question 18

Q

You have a Power BI data source that contains the following tables:

ProductCategory: Lists the product category ID and category name
ProductSubcategory: Lists the product subcategory ID, subcategory name, and the related category ID
ProductList: Lists the product ID, name, and subcategory ID
You need to optimize the data to create a dimension for use in a star schema data model.

How should the tables be transformed before loading into the model?

Select only one answer.

Answer

A

Merge the queries 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.

Question 19

Q

From Power BI Desktop, you create a data source by importing a Cosmos DB for NoSQL item collection.

You connect to the Cosmos DB account, database, and collection, but the preview displays only a list of items named Record.

You need to select individual fields from items in the collection that you want to load into Power BI Desktop.

What should you do first?

Answer

A

Open Power Query Editor.

This behavior is by design. The Preview pane in Power BI shows a list of Record items when connecting to a collection of JSON formatted items. To view individual item fields, open the Power Query window and use the Expander button on the right side of the Column1 header to display the list of fields. Switching to the model view would not benefit us in any way, since the data has not been imported yet. Retrieving Cosmos DB account key or connection string at this point is meaningless, since that was required to connect to Cosmos DB account, which has been already completed.

Question 20

Q

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?

Answer

A

Add a separate date dimension table.

Question 21

Q

You have a Power BI model with the following fact tables and storage modes.

FactStoreSales (Import mode)
FactOnlineSales (DirectQuery mode)
You have a dimension table named DimCalendar that has a relationship to both fact tables.

You need to assign a storage mode for DimCalendar. The solution must minimize the time to execute queries that combine data from the dimension table and the fact tables.

Which storage mode should you use?

Answer

A

Dual

Using Dual mode means that either an import query can be run when accessing data from FactStoreSales, or a DirectQuery query can be run when accessing data from FactOnlineSales. Using Import mode means the queries are only optimized for FactStoreSales (Import). Using DirectQuery mode means the queries are only optimized for FactOnlineSales (DirectQuery). A storage mode of Import, DirectQuery, or Dual must be assigned.

Question 22

Q

You plan to create a report in Power BI Desktop.

You need to create a visualization to display a running total. The solution must meet the following requirements:

The initial and the final value columns must start on the horizontal axis.
The intermediate values must be floating columns.
Which type of visualization should you use?

Answer

A

waterfall

A waterfall visualization is a chart that displays a running total, with the initial and the final value columns starting on the horizontal axis while the intermediate values are floating columns. A combo visualization is a chart that combines a column chart and a line chart and can have one or two Y axes. A funnel visualization is a chart that has sequential connected stages, where items flow sequentially from one stage to the next. A scatter visualization is a chart with two value axes, with one set of numerical data along a horizontal axis and another set of numerical values along a vertical axis.

Question 23

Q

You plan to create a report in Power BI Desktop.

You need to identify the type of visualization that displays data as a set of nested rectangles.

Which visualization should you use?

Answer

A

Treemap

A treemap visualization displays data as a set of nested rectangles. A slicer visualization is available in different formats, including list, drop-down, and buttons, but not nested rectangles. A bar chart visualization presents data as horizontal bars. A column chart presents data as vertical columns.

Question 24

Q

You plan to create a report in Power BI Desktop that will display sales opportunities by five sales stages, including lead, prospect, qualified, committed, and transacted.

You need to identify the type of visualization that will display a linear process with sequentially connected stages, with one stage transitioning to the next.

Which visualization should you use?

Answer

A

Funnel

A funnel visualization displays a linear process with sequentially connected stages, with one stage transitioning to the next. A slicer visualization is available in different formats, including list, drop-down, and buttons, but not sequentially connected stages, with one stage transitioning to the next. A treemap visualization displays data as a set of nested rectangles. A waterfall visualization displays a running total as values are added or subtracted.

Question 25

Q

You need to create a custom Python visual by using Power BI Desktop.

What do you need to do first?

Answer

A

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.

Question 26

Q

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

Answer

A

Disable the Data option.
Disable the Current Page
Enable the Display 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.

Question 27

Q

You need to create a visual that displays sales by employees, trending over months.

The visual must clearly show how employees are performing against each other and have a ranking for each period.

Which visual should you use?

Answer

A

Ribbon chart

A ribbon chart places the highest (ranked) value at the top of the stacked column each month and shows those ranked changes over time. A treemap is not meant for displaying changes over time and wouldn’t easily show ranked comparisons between employees. The clustered bar chart can be used to show changes over time, and a clustered bar chart will show comparisons between employees, but no ranking data is provided between employees. A scatterplot is typically used to compare a relationship between two (or more) calculations and their categorical distribution between each other.

Question 28

Q

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.

Answer

A

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.

Question 29

Q

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.

Answer

A

Matrix
Table

Question 30

Q

You have a visual that is being cross-highlighted.

By default, what data will be displayed in a report tooltip?

Answer

A

the filtered (cross-highlighted) data

By default, report tooltips will apply the filter from the cross-highlighted data into the tooltip. Report page tooltips need to be manually created and are not assigned to a visual by default.

Question 31

Q

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?

Answer

A

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.

Question 32

Q

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?

Answer

A

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.

Question 33

Q

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.

Answer

A

a bin group type
a numerical column

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.

Question 34

Q

You need to add an analytics line to a visual. The value for the line must equal the result of a DAX measure that always returns a consistent single value. The DAX measure must only be used to populate the analytics line.

Which type of analytics line should you use?

Answer

A

constant line

Either the X- or Y-axis constant line allows a DAX measure to be used to provide this value for the visual. The Min line populates the minimum value for a series already present in the visual. The Max line populates the maximum value for a series already present in the visual. The Average line populates the average value for a series already present in the visual.

Question 35

Q

You plan to use Power BI Desktop to analyze sales data for products sold by your company.

You need to create a DAX formula that will list 10 best-selling products sorted by their total sales.

Which DAX function should you use?

Answer

A

TOPN

The TOPN function returns Top N rows of the specified table, such as, for example, top 10 best-selling products sorted by their total sales. The MAXA function returns the largest value in a column. The MAXX function evaluates an expression for each row and returns the largest value. The RANKX function returns ranking of a number in a list of numbers for each row of a target table.

Question 36

Q

You have a fact table that contains sales data and the following two date columns:

OrderDate
ShipDate

Both columns have a relationship to the Date column in the Calendar table, and DAX measures have been configured to use these relationships for calculations related to order or ship dates.

You need to ensure that by default, the Calendar table does NOT filter the fact table, unless it is using a DAX measure that uses these relationships.

What should you do?

Answer

A

Disable Make this relationship active for both relationships.

You can have multiple inactive relationships between two tables in Power BI datasets. DAX measures can then use the USERELATIONSHIP function to activate a relationship for calculations. Relationship direction is not required for either the relationships or measures to work in this model setup. Only one active relationship can exist between two tables in a Power BI dataset. Applying a security filter in both directions isn’t required for this model setup.

Question 37

Q

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.

Answer

A

Calculated Column
Column
Measure

Tables and reports cannot be assigned a display folder. Columns, calculated columns, and measures can be assigned a display folder.

Question 38

Q

You create a data model in Power BI Desktop that contains DAX calculated columns and measures. You now need to create a report.

In which two places can a DAX calculated column be used, but a DAX calculated measure cannot be used? Each correct answer presents a complete solution.

Answer

A

as an item in the Fields well of a slicer
as a filter in the “Filters on this page” well of the Filters pane

Unlike a measure, a calculated column can be used in a slicer to place filter options on the report page. DAX measures cannot be placed in the “Filters on this page” well. They can only be placed per visual, in the “Filters on this visual” well of the Filters Pane. Both DAX columns and measures may be used as a visual-level filter. Both DAX columns and measures can be used in the drillthrough well.

Question 39

Q

You need to create a row level security (RLS) role for a dataset.

What should you do first?

Answer

A

Manage Role

RLS roles are created or modified from the Manage roles space. You can assign AD users/groups to an existing role in the security settings, but new RLS roles must be created in Power BI desktop or other model authoring external tool. RLS configurations cannot be accessed from any Power Query window. Before you can assign users to a security group, it first needs to be created for the model in Power BI Desktop.

Question 40

Q

You need to develop a quick measure in Power BI Desktop.

Which two elements can you use? Each correct answer presents a complete solution.

Answer

A

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.

Question 41

Q

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?

Answer

A

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.

Question 42

Q

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.

Select all answers that apply.

Answer

A

Calculated table
numerical parameter range

Calculated tables are generated with DAX queries. Numeric range parameters create a table and measure, both generated with DAX queries. Hierarchies are helpful for drilldown and are defined as part of the data model, but they are not generated by using DAX. Display folders are a way to visually organize measures, columns, or hierarchies. DAX is not used to create them.

Question 43

Q

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?

Answer

A

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.

Question 44

Q

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.

Select all answers that apply.

Answer

A

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.

Question 45

Q

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?

Answer

A

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.

Question 46

Q

You decide to remove unnecessary columns from your data model.

What are two potential performance benefits of doing this? Each correct answer presents a complete solution.

Answer

A

increasing the refresh speed
reducing the size of the data model

Question 47

Q

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.

Answer

A

improves the overall performance of the resulting DAX measure
improves the overall readability 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.

Question 48

Q

You have a Power BI Desktop PBIX file that contains a single page report with multiple visuals.

You plan to use Performance Analyzer to evaluate the performance of the visuals.

You need to eliminate the impact of visual caching during the evaluation.

What should you do first?

Answer

A

Add a blank page to the PBIX file.

To eliminate the impact of visual caching during a performance evaluation when using Performance Analyzer to evaluate the visuals, you must first add a blank page to the report, select that page, and then reopen the PBIX file. Connecting DAX Studio to the data model is the first step to clear the data engine cache. Recording should not be started until both the visual cache and the data engine cache are cleared.

Question 49

Q

In Power BI Desktop, you plan to use M-language to define a common date table spanning a period of 10 years.

You need identify the M language function that would allow you to specify that rows in the table should represent consecutive days within the date range you designated. Your solution must minimize administrative effort.

Which syntax should you use?

Answer

A

Duration

The #duration function of the M language allows you to specify the datetime values that will be entered into individual rows of a date table. The #date function creates a date value based on the date parameters you specify. The List.Combine() combines multiple lists into one. List.Durations returns a list of count duration values, rather than dates.

Question 50

Q

You need to create a dashboard from a published report in Power BI.

Which option in the report should you use?

Select only one answer.

Copy visual as image
Export data
Pin visual
Spotlight

Answer

A

Pin visual

The Pin visual option allows you to pin the visual to an existing dashboard or create a new one. The Copy visual as image option allows you to copy a visual as an image to Clipboard. The Export data option allows you to export data in the xlsx or csv formats, but not create a dashboard. The Spotlight option allows you to highlight a visual on the report page, but not create a dashboard.

Question 51

Q

You plan to build a Power BI dashboard and set up alerts that will notify you when data presented in the visuals on the dashboard reach specific thresholds.

Which three types of visuals support the alert functionality? Each correct answer presents a complete solution.

Select all answers that apply.

card

gauge

KPI

treemap

waterfall

Answer

A

Card, gauges, KPI visuals.

Alerts are available with KPI visuals, gauges, and cards. Treemaps and waterfall visuals do not support alerts.

Question 52

Q

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.

Select all answers that apply.

a report

an email

Microsoft Teams

the Notification Center

Answer

A

Notification Center

Email

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.

Question 53

Q

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?

Dataset

Tenant

Workbook

Workspace

Answer

A

Tenant

Admin users who have permissions to certify a dataset are defined in the Dataset Certification tenant admin setting.

Question 54

Q

Your company has a SharePoint server located in a datacentre in Montreal.

You plan to create a report in the Power BI service that will use 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?

Select only one answer.

a Point to Site virtual private network (VPN)

a Site-to-Site virtual private network (VPN)

an on-premises data gateway

Azure Data Box

Answer

A

an on-premises data gateway

An on-premises SharePoint server requires the use of a Power BI gateway since it’s an on-premises data source. VPN-based solutions would provide connectivity to an Azure virtual network, but not Power BI service. Azure Data Box is a solution for migrating data to Azure, which is not applicable in this scenario.

Question 55

Q

You have a row level security role (RLS) in a dataset called User Security Group. This role needs to filter a RLS table that contains a column with the emails of users in the following format:

name@company.com

Which function should be used in the code for the RLS role to match the users Microsoft Entra ID login credentials with the emails contained in the RLS table column?

Select only one answer.

NAMEOF

TREATAS

USEROBJECTID

USERPRINCIPALNAME

Answer

A

USERPRINCIPALNAME

USERPRINCIPALNAME would return the Microsoft Entra ID login in the format of “name@company.com”. USEROBJECTID would not return the Microsoft Entra ID login in the same format. NAMEOF is a function that is used for Field Parameters. TREATAS is a function related to column filtering.

Question 56

Q

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.

Select all answers that apply.

Certify the dataset.

Enable RLS on the dataset.

Promote the dataset.

Answer

A

Certified and Promo

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.

Question 57

Q

You need to assign an app workspace role for users who consume reports.

Users should only have permissions to examine the report.

Which role should you assign to users?

Admin role

Contributor role

Member role

Viewer role

Answer

A

Viewer

The Viewer role only has reader access to view reports and dashboards. The Contributor role can create, update, or publish content. The Member role has many edit permissions in a workspace, similar to an admin. The Admin role has all the edit permission in a workspace.

Question 58

Q

You have the following Power Query M formula that generates a range of dates.

= List.Dates(#date(2020,05,31), 365, #duration(1,0,0,0))

What is the resulting date range?

a list of days ending on May 31, 2020 and starting 365 days earlier

a list of days starting on May 31, 2020 and ending 365 days later

a list of months ending in May 2020 and starting 12 months earlier

a list of months starting in May 2020 and ending 12 months later

Answer

A

a list of days starting on May 31, 2020 and ending 365 days later

The #date element designates the starting date, 365 designates the duration counter, and #duration(1,0,0,0) designates the duration interval in days, so this formula results in a listing of days starting on May 31, 2020 and ending 365 days later.

Question 59

Q

You are designing a data model in Power BI.

You need to avoid introducing ambiguity into your data model design.

Which type of cardinality should you avoid?

many-to-many

many-to-one

one-to-many

one-to-one

Answer

A

many-to-many

Many-to-many cardinality in Power BI should be avoided due to ambiguity, resulting from the presence of non-unique values. One-to-one cardinality in Power BI should be avoided and, if present, should be eliminated by combining the related tables. However, this type does not introduce ambiguity. One-to-many and many-to-one cardinality are two common cardinality types, used for the relationships between a fact and dimension tables.

Question 60

Q

You need to prevent hidden date tables from being auto generated by Power BI Desktop for every date or datetime data type column in a dataset.

What two tasks should you perform? Each correct answer presents a complete solution

Select all answers that apply.

Enable Mark as date table for the Calendar table.
From the Current File options in Power BI Desktop, disable Auto Date/Time
From the Global options in Power BI Desktop, disable Auto Date/Time for new files.
Set the Data Category to None for all Date and DateTime fields.

Answer

A

1 & 2

Disabling Auto Date/Time for new files from the Current File options will disable all Auto Date/Time tables in this dataset. Enabling Mark as date table for the Calendar table will also disable the auto datetime tables in the dataset. Disabling the Global option Auto Date/Time for new files means that new files will no longer have Auto Date/Time enabled, but the file containing the current dataset will still have it enabled until it is disabled. Changing the data category will not impact the auto date table feature.

Question 61

Q

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.

Select all answers that apply.

Calculated column

Column
Measure
Report
Table

Answer

A

1,2,3

Tables and reports cannot be assigned a display folder. Columns, calculated columns, and measures can be assigned a display folder.

Question 62

Q

You need to create a new hierarchy in Power BI Desktop.

What should you do first?

Select only one answer.

From the Model view, drag-and-drop one column onto another column in the Fields pane.

From the Model view, right-click and select Create hierarchy.

From the Report view, drag-and-drop one column onto another column in the Fields pane.

Answer

A

From the Model view, right-click and select Create hierarchy.

To create a new hierarchy in Power BI Desktop, you must select Create hierarchy from the Model view or Report view. The option to create hierarchies by dragging and dropping was removed as an option in 2021 because too many hierarchies were being accidentally created during development. You cannot drag-and-drop one field onto another to create a new hierarchy. You can only use this method to add additional fields to an already existing hierarchy.

Question 63

Q

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?

Select only one answer.

data and column visibility only

data and hierarchies only

data, hierarchies, and column visibility

data only

Answer

A

data only

A calculated table only duplicates data. Any model configurations such as column visibility or hierarchies must be recreated if needed.

Question 64

Q

You have a Power BI Desktop model.

You need to determine when to use implicit and explicit measures.

What is a feature of an implicit measure that explicit measure does NOT have?

Select only one answer.

End-users can change the aggregation type of implicit measure from the Values well of a visual.
Implicit measures can be used as a Drillthrough field.
Implicit measures can be used to create Quick measures.
implicit measures can be used with Field Parameters.

Answer

A

1

Implicit measures can select from one of nine aggregations when placed in the Values well of a visual. Both Implicit and Explicit measures can be used as a Drillthrough field, to create quick measures, and with Field Parameters.

Answer 64

A

DAX Studio

DAX Studio, once connected to the data model, can be used to clear the data engine cache. The Clear Cache function can be invoked from DAX Studio, once you connect it to the data model. The Refresh Metadata function can be invoked from DAX Studio to update the metadata of the currently selected model. Adding a blank page to the .pbix file and selecting it is the first step in clearing the visual cache, not the data engine cache.

Answer 65

A

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.

Answer 66

A

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.

Answer 67

A

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.

Answer 68

A

From the query window, select Column profiling on the entire dataset.

Selecting column profiling for the entire dataset will change the column profiler to analyze the entire query dataset. Adding a Table.Buffer applied step will only cache the entire query in memory during refresh. The query load type in the model will not impact how many rows are used by the column profiler. Using a Top N row count applied step or applying a parameter will not change how the column statistics feature calculates.

Answer 69

A

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. This enforces the requirement that new columns will not be automatically added in the future. Using Remove Columns will delete the existing columns in the table, and 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.

Answer 70

A

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.

Answer 71

A

Use the Performance analyzer.

The Performance analyzer will show the query timings for each object on a report page. Session diagnostics measures Power Query query performance as it relates to refresh times. It is unrelated to measuring DAX performance or report page query timings. The Best Practices analyzer reviews the model for best practices around things like model design, relationships, field naming conventions, and measures. But is unrelated to any query timings for report page visuals.

Answer 72

A

3 &4

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.

Answer 73

A

3 &4

DirectQuery minimizes local disk space use and eliminates the need for data refresh. DirectQuery is not fully supported with the Q&A and Quick Insights Power BI services. Both the DirectQuery and Import storage modes support per table configuration.

Answer 74

A

Advanced Editor in the Power Query Editor

The Advanced Editor in the Power Query Editor provides the ability to work with all the M code used for shaping data in a query at once. Data view provides access to data within a dataset. Model view provides access to the data model of a dataset. The Formula Bar in the Power Query Editor provides the ability to edit only one step at a time.

Answer 75

A

Slicer

The slicer visualization can be used to filter the other visuals on the page. You can enable a search box in a slicer where users can search for values to filter. A funnel visualization is a chart that that has sequential connected stages, where items flow sequentially from one stage to the next. A matrix visualization displays data in two or more dimensions and cross-highlights with other visuals on the same report page. A scatter chart visualization is a chart with one set of numerical data along a horizontal axis and another set of numerical values along a vertical axis. The matrix, scatter chart, and funnel do not offer a search box.

Brainscape's Knowledge GenomeTM

PL300 Flashcards

Brainscape's Knowledge Genome^TM