Power BI - PL 300 - Pt 2

Question 1

You have a table ‘Sales’ that contains the columns ‘SalesID’, ‘Number_of_Units’, ‘PurchaseValue’, and ‘DiscountRate’. You want to calculate the minimum number of units that have been sold. Identify the correct formula that can be used.

A. MinOrder = MIN(Sales[‘Number_of_Units’])
B. MinOrder = MIN(Sales[Number_of_Units])
C. MinOrder = MINIMUM(Sales[Number_of_Units])
D. MinOrder = MINIMUM(Sales[‘Number_of_Units’])

Answer 1

B. MinOrder = MIN(Sales[Number_of_Units])

Question 2

You have a table ‘Sales’ that contains the columns ‘SalesID’, ‘Number_of_Units’, ‘PurchaseValue’, and ‘DiscountRate’. You want to calculate the Top 5 purchases based on the PurchaseValue. Identify the correct option that can be used.

A. Use the Q&A visual to identify the Top 5 PurchaseValue
B. Use the TOPN DAX function
C. Use the TOPN filter type
D. Use any of the three -TOPN DAX function, TopN filter type or Q&A visual

Answer 2

D. Use any of the three -TOPN DAX function, TopN filter type or Q&A visual

Question 3

What does the “Analyze” feature assist users with?

A. Conducting Time Series analysis
B. Reviewing Quick Insights
C. Exploring statistical summary
D. Identifying outliers with visuals

Answer 3

D. Identifying outliers with visuals

The Analyze feature helps users identify and highlight outliers in the data using various visuals and interactive capabilities.

It does not specifically assist with time series analysis but provides insights and outlier identification.

Quick insights are generated automatically by Power BI, while the Analyze feature allows manual exploration of data insights.

Exploring statistical summary is done through various visuals, but the Analyze feature does not specifically focus on this.

Question 4

Which technique can be used to identify natural groupings within a dataset?

A. Grouping
B. Binning
C. Clustering
D. Time Series Analysis

Answer 4

C. Clustering

Question 5

What is the primary benefit of using the Key influencers visual in Power BI?

A. Discovering data anomalies
B. Creating data hierarchies
C. Identifying data correlations
D. Finding important factors impacting a measure

Answer 5

D. Finding important factors impacting a measure

The primary benefit of the Key influencers visual is to identify and display the important factors that significantly impact a specific measure.

The Key influencers visual does not create data hierarchies but instead identifies the most influential factors impacting a measure.

While Key influencers can identify influential factors , it does not explicitly focus on identifying data correlations or discovering data anomalies.

Question 6

In the Decomposition Tree visual, what does each level of the tree represent?

A. Hierarchical categories
B. Individual data points
C. Aggregated data summaries
D. Statistical significance of factors

Answer 6

A. Hierarchical categories

Each level of the tree represents hierarchical categories, allowing users to break down the measure into its contributing factors in a structured manner.

The Decomposition Tree visual does provide aggregated data summaries, but that is not the primary representation at each level.

The Decomposition Tree visual focuses on hierarchical representation rather than the statistical significance of factors.

Question 7

How can users interact with the Q&A visual in Power BI to explore data insights?

A. Drag and drop data fields
B. Apply clustering techniques
C. Set up scheduled data refresh
D. Access advanced analytics custom visuals

Answer 7

A. Drag and drop data fields

Users can interact with the Q&A visual by asking natural language questions and exploring data insights through the use of specific data fields

Question 8

You open a query in Power Query Editor. You need to identify the percentage of empty values in each column as quickly as possible.
Which Data Preview option should you select?

A. Show whitespace
B. Column Profile
C. Column Distribution
D. Column Quality

Answer 8

D. Column Quality

The Column quality checks the quality of the data in terms of Valid, Error & Empty and is expressed as a percentage.

Question 9

You discover a quality data source on your company’s Azure SQL database. You decide to connect using a direct query to the database. What two things are necessary to successfully connect?

A. Specify the fully qualified server name when connecting

B. Ensure firewall rules for the database are configured to “allow access to Azure services”

C. Select automatic schema change detection

D. Tiles are refreshed once per day, so you must configure the scheduled refresh

Answer 9

A. Specify the fully qualified server name when connecting

B. Ensure firewall rules for the database are configured to “allow access to Azure services”

You must specify the full server name when connecting to the Azure SQL database. You can find your fully qualified server name and database name in the Azure portal. Make sure you have configured the firewall rules to ‘allow access to Azure service’ or you may not be able to access your database.

Question 10

You work for a microbrewery as head of data visualization. You have a Power BI data model that relies on several Excel files that reside on your company’s internal server.

You are emailed a new Excel workbook from the CEO that contains updated data. You place the new Excel workbook on your server and append the text ‘v1.2’ to the name.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

1. The new excel file must have the same structure as the original workbook. (Y/N)
2. The new excel workbook will only work if it has the exact same name and path as the previous file. (Y/N)
3. You can refresh the local Excel file by pressing F5 in Power BI. (Y/N)

Answer 10

1. Yes
2. No
3. No

The new Excel file must have the same schema as the original Excel file. If there are fewer columns, more columns or differently named columns, the report will not work.

The new file can have a different name and a different file path. In Power Query Editor, you can change the source path and filename for the new file.

You cannot refresh the local Excel file by pressing F5 in Power BI. If you need to be able to refresh the data for reports published to Power BI Server, you will need a data gateway. Otherwise, you can host the file on a cloud platform such as OneDrive.

Question 11

Which term best describes the process of transforming a table by turning distinct column values into rows?

A. Pivot
B. Unpivot
C. Transpose
D. Select Columns

Answer 11

B. Unpivot

Question 12

What is the function of Pivot in Power BI

Answer 12

Pivot turns rows into columns by splitting unique values from the selected column into additional columns. In general, to pivot means to turn or rotate around a central point.

https://medium.com/@faith_oseghale/transpose-pivot-and-unpivot-in-power-query-29d674c08dcc

Question 13

What is the function of unpivot in Power BI

Answer 13

It’s a data transformation function that converts data from a wide format (columns) to a long format (rows), essentially turning column headers into rows

https://medium.com/@faith_oseghale/transpose-pivot-and-unpivot-in-power-query-29d674c08dcc

Question 14

What is the function of Transpose in Power BI

Answer 14

Transpose changes the orientation of the table without rearranging the values.

https://medium.com/@faith_oseghale/transpose-pivot-and-unpivot-in-power-query-29d674c08dcc

Question 15

What is the function of Select Columns in Power BI

Answer 15

Select columns allows us to select desired columns from the dataset

Question 16

Column 1 data points: 1, 2, 3, 4, 5, 1, 2, 3

You have connected to a data source and column 1 contains the data points (numbers) noted above. You switch on Column distribution in the Data Preview section of the View menu.

What values for distinct and unique are returned for Column 1?

Answer 16

5 distinct, 2 unique

Question 17

You work for an eCommerce company that sells ergonomic office products. You are tasked with creating a Power BI report from your company’s transactional sales data in a table called ‘ergoSales’. Before you do anything with the data, you want to check that there are no negative amounts in the ‘ergoSales’[quantity] field.

What is the most efficient way to check your data for negatives before creating the data model?

A. Select Column Profile and click on ‘ergoSales’[quantity]
B. Select Column Quality and click on ‘ergoSales’[quantity]
C. Click on ‘ergoSales’[quantity] and select Replace Values
D. Create a custom column using a conditional statement to filter negatives out

Answer 17

A. Select Column Profile and click on ‘ergoSales’[quantity]

The Column profile view shows a column distribution chart of values as well as the minimum and maximum values. You can quickly see if your data has negative values by checking the distribution or by viewing the minimum value.

Question 18

When connecting to an Excel workbook in Power BI, what does the “Enable Load” option do?

A. Loads the entire workbook into Power BI
B. Enables loading specific worksheets from the workbook
C. Allows data transformations within Power Query
D. Disables loading data from the workbook

Answer 18

B. Enables loading specific worksheets from the workbookB. Enables loading specific worksheets from the workbook

The “Enable Load” option allows you to choose specific worksheets from the Excel workbook to load into Power BI. “Enable Load” allows for selective loading of worksheets.

Question 19

What is the difference between a calculated column and a measure?

A. A calculated column is created using DAX, while a measure is created using M Formula

B. A calculated column is stored in memory, while a measure is calculated on-the-fly

C. A calculated column can only be used in visuals, while a measure can be used in both visuals and tables

D. A calculated column can only be used for aggregation, while a measure can be used for both aggregation and filtering

Answer 19

B. A calculated column is stored in memory, while a measure is calculated on-the-fly

Question 20

You are a Power BI consultant and you are doing some remote work for a mining company in Western Australia. You need to build a date table that starts from November 2010 and ends in December 2025. You decide you will use DAX to create a table.

How should you create the DAX expression?

A. DATE(2010/11/01, 2025/12/31)
B. CALCULATE(CALENDAR(‘2010/11/01’, ‘2025/12/31’)
C. CALENDAR(DATE(2010,11,30), DATE(2025,12,01))
D. CALENDAR(2010/11/01, 2025/12/31)

Answer 20

C. CALENDAR(DATE(2010,11,30), DATE(2025,12,01))

Use the CALENDAR function with a start and end date. For each date, use the DATE function and add in the three parameters for year, month and day.

Question 21

What is the purpose of using hierarchies in a data model?

A. To improve performance by reducing the amount of data that needs to be processed
B. To enable drill-down and drill-up functionality in visualizations
C. To link tables together based on common columns
D. To import data from external sources

Answer 21

B. To enable drill-down and drill-up functionality in visualizations

Question 22

You have a dashboard that is an important part of collaborative planning in your organization. Since the team is remote, you have been asked to allow users to provide feedback on the dashboard that will be visible to other team members.

How would you achieve this goal?

A. Add sticky notes
B. Add comments
C. Add to group mail
D. Add alerts

Answer 22

B. Add comments

Comments can be added to an entire dashboard, to individual visuals on a dashboard and can be seen by colleagues. Additionally, when you add a comment to a report, Power BI captures the current filter and slicer values and creates a bookmark. This means that when you select or respond to a comment, the report page or report visual may change to show you the active filter and slicer selections when the comment was first added

Question 23

You work for a consulting company that has a contract with a large government department. Part of the requirements for the report is to configure the page for use with a screen reader for sight-impaired users.

What should you configure in your report such that the page follows a logical sequence?

A. Bookmarks
B. Layer order
C. Tab order
D. Filter on all pages

Answer 23

C. Tab order

The tab order is used by keyboard users to navigate the report page. Screen reader and accessibility software follow the sequence of the tab order.

Question 24

What are some best practices for Tab Order?

Answer 24

1. Logical Flow: Arrange items in a natural order, such as left-to-right and top-to-bottom, to match the layout of the report.
2. Focus on Key Elements: Prioritize interactive elements like slicers, filters, and buttons early in the order.
3. Avoid Redundancy: Exclude decorative shapes, images, or elements that do not need to be interacted with.
4. Test Navigation: Use the Tab key to navigate through the report and ensure the sequence feels intuitive.
5. Assistive Technology: Test with screen readers or other accessibility tools to verify usability

Question 25

What are the 4 roles in Power BI?

Answer 25

Admin Role - Has the most control over the service, including user accounts, data, and workspaces. They can create, edit, delete, copy, and publish content, configure data refresh schedules, and add or remove users.

Member Role - Has the same capabilities as an Admin, except they can’t add or remove users, or delete the workspace. They can add other users to the Viewer or Contributor roles.

Contributor Role - Can create, edit, delete, copy, and publish content, and modify data refresh schedules. They can’t add or remove users.

Viewer Role - Can only view reports or dashboards, and read data stored in workspace dataflows. They can’t add or remove users.

Question 26

You have a table that contains sales data and approximately 1,000 rows. You need to identify outliers in the table. Which type of visualization should you use?

A. Scatter Plot
B. Donut chart
C. Pie Chart
D. Area chart

Answer 26

A. Scatter Plot

Scatter plots are useful for visualizing the relationship between two variables and identifying any unusual observations or outliers

Donut charts are used to show the proportions of a whole, not to identify outliers.

Similar to donut charts, pie charts are used to show the proportions of a whole, not to identify outliers.

Area charts are used to show changes over time, not to identify outliers.

Question 27

Which of the following filter options applies only to the specific visual in which it is defined?

A. Visual Level
B. Page Level
C. Report Level
D. Drill Through

Answer 27

A. Visual Level

Question 28

On which of the following chart types can you add a forecast based on a specific number of periods?

A. Line Chart
B. Scatter chart
C. Clustered Column Charts
D. All of the above

Answer 28

A. Line Chart

You can add a forecast to a line chart based on a specific number of periods. This allows you to predict future values based on historical data.

Question 29

You need to create a relationship between two tables named Sales and Sales Detail in a Power BI data model. For every row in the Sales Detail table, there is at least one row. In the Sales table there are possibly multiple rows.

How should you configure the relationship?

A. One-to-One from Sales table to Sales Detail table
B. One-to-Many from Sales table to Sales Detail table
C. One-to-One from Sales Detail table to Sales table
D. One-to-Many from Sales Detail Table to Sales table

Answer 29

D. One-to-Many from Sales Detail Table to Sales table

Question 30

Which of the following functions modifies and overrules any competing filter context?

A. CALCULATE
B. RELATED
C. SUMX
D. REPLACE

Answer 30

A. CALCULATE

How CALCULATE Works:
1. Evaluate Filters: CALCULATE first evaluates all the filter arguments provided.
2. Modify Context: It applies these filters to the current filter context of the report.
3. Evaluate Expression: Finally, it computes the result of the expression within the modified context..

Question 31

Which of the following is NOT true about CALCULATE modifiers?

A. They are used to change filter context
B. They are used to access inactive table relationships
C. They allow you to drag and drop fields rather than write DAX from scratch
D. They are used to change the way filters propagate

Answer 31

C. They allow you to drag and drop fields rather than write DAX from scratch

Question 32

Which of the following statements does NOT pertain to a 1:1 relationship?

A. 1:1 relationship is a relationship where only one instance of a value is common between both tables

B. 1:1 relationship between two tables is not recommended as this relationship stores redundant information

C. It is better to combine tables that have a 1:1 relationship

D. 1:1 relationship does not require unique values in either tables

Answer 32

D. 1:1 relationship does not require unique values in either tables

Question 33

Which of the following could represent a valid hierarchy?

A. Peach > Pear > Plum
B. Country > City > State
C. Day > Month > Year
D. Product Category > Product Name > Product Description

Answer 33

D. Product Category > Product Name > Product Description

Question 34

Which type of Data model is Power BI optimized for?

A. Star Schema
B. Snowflake Schema
C. Supernova Schema
D. None of the options

Answer 34

A. Star Schema

Question 35

You are using Power BI Desktop to create a report. You open a data extract that has a coll free text field. The frequency distribution of the string lengths in col1 has to be examined. The size of the model must not be impacted by the solution. What ought you to do?

A. Include a DAX computed column in the report that determines the length of col1

B. Include a DAX function that determines the average length of col1 in the report

C. Add a column that determines the length of col. 1

D. From Power Query Editor, change the distribution for the Column profile to group by length for col1

Answer 35

C. Add a column that determines the length of col. 1

Adding a calculated column in Power Query Editor ensures that the length calculation is performed during the data transformation process, and it won’t impact the size of the Power BI model.

Question 36

You have a number of reports for your company’s HR division. Row-level security is used with the datasets (RLS). The business has several sales territories. An HR mgr oversees each sales territory. The HR mgrs should only be able to deal with data from their region, you must make sure of that. The layout of the reports cannot be altered by the HR mgrs. How should you grant the HR mgrs access to the reports?

A. Upload the reports to an app and allow access for the HR mgrs

B. A new workspace should be created, the datasets and reports copied, and the HR managers added as workspace members

C. Publish the reports to a workspace separate from the one that houses the datasets

D. Include the HR managers as users in the workspace that already houses the datasets and reports

Answer 36

A. Upload the reports to an app and allow access for the HR managers

When you publish reports in an app, you can control access to the app and grant permissions to specific users or groups.

Question 37

A user must have the option to add individuals to a workspace. The least privilege principle must be applied to the solution. Which role ought to you give the user?

A. Viewer
B. Admin
C. Contributor
D. Member

Answer 37

D. Member

Question 38

You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com. The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00. The report is a single page that contains 15 AppSource visuals and 10 default visuals. Users say that the report is slow to load the visuals when they access and interact with the report. You need to recommend a solution to improve the performance of the report. What should you recommend?

A. Increase the number of times that the dataset is refreshed.
B. Split the visuals onto multiple pages
C. Change the imported dataset to DirectQuery
D. Implement row-level security (RLS)

Answer 38

B. Split the visuals onto multiple pages

This will reduce the number of visuals to load per time, hence increase performance

Question 39

You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records. During the development process, you need to import a sample of the data from the Order table.

Solution: From Power Query Editor, you import the table and then add a filter step to the query. Does this meet the goal?

A. Yes
B. No

Answer 39

No

Adding a filter step in Power Query Editor (PQE) after importing the entire table doesn’t meet the goal of importing only a sample of the data. When you import the table first and then apply a filter, the entire table is still loaded into PBI, and then the filter is applied locally in PQE.

To meet the goal of importing only a sample of the data and reducing the amount of data loaded into PBI, you should apply the filter during the import process in PQE This can be done by using the “Source” step in PQE to filter the data at the source before importing it into PBI.

So, to achieve the objective of importing a sample of the data during the development process, you need to apply the filter at the source in PQE during the import process, not by adding a filter step after importing the entire table.

Question 40

You are using Microsoft Power BI to model data. A sizable Microsoft SQL Server table named Order that contains more than 100 million records is a component of the data model. You must import a portion of the Order table’s data during the development process.

The FILTER function is incorporated into a DAX expression as the solution. Does this meet the goal?

A. Yes
B. No

Answer 40

B. No

Using the FILTER function in a DAX expression does not affect the amount of data imported into Power BI during the data loading process. DAX functions, including FILTER, are applied within the data model after the data has been loaded.

You would need to apply a filter at the data source level, not within a DAX expression.

Question 41

You are using Microsoft Power BI to model data. A sizable Microsoft SQL Server table named Order that contains more than 100 million records is a component of the data model. You must import a portion of the Order table’s data during the development process.

Solution: You modify the SQL statement by including a WHERE clause. Does this meet the goal?

A. Yes
B. No

Answer 41

A. Yes

Modifying the SQL statement by including a WHERE clause directly impacts the data imported into Power BI during the data loading process.

Question 42

Your company has a dataset that contains 5 million rows. The dataset contains relevant information for stock movement prediction from portfolio analysis and historical stock prices for blue-chip companies. A few of these companies are your customers. Your dataset should meet the following requirements:

• The data source should be restricted to users who have authorized access. Data should not be folded into other private data sources within the organization. * Data should not be folded into other data sources within the organization, including private data sources as well.

You need to assign the correct privacy level to the data in Power BI Desktop. Which privacy level should you apply?

A. Organizational
B. Public
C. Private
D. None

Answer 42

C. Private

By selecting the Private setting, the data source will be restricted to users who have authorized access, and the data from this data source will not be folded into other private data sources within the organization.

Question 43

You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions that each has an HR manager.

You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports.

How should you provision access to the reports for the HR managers?

A. Publish the reports to a different workspace other than the one hosting the datasets.

B. Publish the reports in an app and grant the HR managers access permission

C. Add the HR managers as members of the existing workspace that hosts the reports and the datasets.

D. Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.

Answer 43

B. Publish the reports in an app and grant the HR managers access permission

By publishing the reports within an app and providing HR managers with access, you can assign them specific roles and permissions. This setup restricts their access to the underlying data while still allowing them to view and interact with the reports.

Question 44

You have a Q&A visual that displays information from a table named Carriers. You need to ensure that users can ask questions by using the term airline or carrier.

The solution must minimize changes to the data model. What should you do?

A. Add a duplicate query named Airline
B. Add airline as a synonym of carrier
C. Rename the carrier column as airline in the Carriers query
D. Rename the query from Carriers to airlines

Answer 44

B. Add airline as a synonym of carrier

Question 45

You need to grant all organizational users read access to a dashboard and several reports.

Solution: You assign all the users the Viewer role to the workspace. Does this meet the goal?

A. True
B. False

Answer 45

A. True

Question 46

You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City.

There is a one-to-many relationship between Date and Orders and between City and Orders. The model contains two RLS roles named Role1 and Role2.

Role1 contains the following filter. City[State Province] = “Kentucky” Role2 contains the following filter. Date[Calendar Year] = 2020

If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model?

A. The user will see data for which the State Province value is Kentucky or the Calendar Year is 2020.
B. The user will see only data for which the State Province value is Kentucky.
C. The user will receive an error and will not be able to see the data in the report

Answer 46

A. The user will see data for which the State Province value is Kentucky or the Calendar Year is 2020.

Question 47

You use Power BI with Premium capacity assigned. You have a dataset containing employee key performance indicators (KPIs). You create a Power BI report with a visual that shows employees with low-scoring KPIs.

You pin the visual to a dashboard and share the dashboard with users in Human Resources (HR). HR users need to be able to generate a list of employees to investigate for poor performance and import that list into their HR system. What should you do?

A. Configure Cloud App Security.
B. Grant HR users the Reshare permission on the dataset.
C. Grant HR users the Build permission on the dataset.
D. Apply a sensitivity label in the dashboard settings.

Answer 47

C. Grant HR users the Build permission on the dataset.

If a user has the Read permission on a workspace and dataset, then they can export the data. The Build permission allows you to control whether users can download data from visuals without having to give access to the workspace.

Question 48

Company A is a consulting firm specialized in HR processes for large retail companies in Europe. Company A manages an HR solution that uses multiple Azure SQL Server databases. Each retail company has its own database provisioned in an Azure subscription managed by Company A.

The data engineers are interested in building a report to measure employee turnover using Power BI Desktop. Each retail company may have different requirements for building the report.

Each data engineer should work to build a report for a specific company, using a different database from their peers. You need to support the data engineers to connect to the correct database.

Solution: Create a new parameter in the report with the database connection details. Does this solution meet the goal?

A. True
B. False

Answer 48

A. True

You can create a parameter with the database details, such as the server address and the database name, and allow the data engineers to change to different data sources from Power Query

Question 49

You are using the Power Query Editor to transform your data by creating several queries before importing the data to Power BI. You want to reduce both the data size as well as minimize the transformation steps.

Which option should you use in each of the following scenario?:

Copy a query with all of the transformation steps but only changing the data source.

A. Copy
B. Copy or Duplicate
C. Duplicate
D. Reference

Answer 49

B. Copy or Duplicate

You should use either Copy or Duplicate to copy a query with all of the transformation steps but only changing the data source. Both of these options do the same job by cloning a query with all of its steps while creating a query that is completely independent from the original one.

Once you create a copy or duplicate of a query you can modify any specific step such as changing the data source.

Question 50

You are analyzing data quality on a set of data that you imported with Power Query. You need to use the correct Data Preview options to analyze the data.

Which Data Preview option should you use on the scenario: To find the number of distinct and unique rows for all columns

A. Column distribution
B. Column Profile
C. Column Quality
D. Show whitespace
E. Monospaced

Answer 50

A. Column distribution

Question 51

What does Column Distribution show and how many rows are included?

Answer 51

It shows the number of DISTINCT and UNIQUE values. It shows up to 1000 rows.

Question 52

You are analyzing data quality on a set of data that you imported with Power Query. You need to use the correct Data Preview options to analyze the data.

Which Data Preview option should you use on the scenario: To find the number of distinct, unique, and empty rows for a single column

A. Column distribution
B. Column Profile
C. Column Quality
D. Show whitespace
E. Monospaced

Answer 52

B. Column Profile

Column profile shows all statistics and the distribution of data for a single column (count, error, min, max, avg. etc.) . You should be aware that the preview is based on the first 1,000 rows

Question 53

You have a prospective customer list that contains 1,500 rows of data.

The list contains the following fields: -
First name
Last name
Email address
State/Region
Phone number

You import the list into Power Query Editor. You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign. Which two actions should you perform?

A. Open the Advanced Editor.
B. Select Column quality.
C. Enable Column profiling based on entire dataset.
D. Select Column distribution.
E. Select Column profile

Answer 53

C. Enable Column profiling based on entire dataset.
E. Select Column profile

The dataset have 1500 rows, if you don’t enable the column profiling for the entire dataset, the column profiling will be only based on top 1000 rows. So first enable for entire dataset and after that run column profiling for the entire dataset.

Question 54

You build a Power Bl report that displays 10T temperature data streaming from a refrigerator. You publish the report to the Bl service. You need to be notified when the temperature rises above four degrees Celsius.

What should you do?

A. Pin a report page to a dashboard and set an alert on the page
B. Set an alert on a KPI visual in the report
C. Pin a card visual to a dashboard and set an alert on the tile
D. Pin a card visual to a dashboard and create a subscription

Answer 54

C. Pin a card visual to a dashboard and set an alert on the tile

This will ensure that you receive notifications when the temperature exceeds 4°C, either via email or a notification within Power BI.

Question 55

You create the following step by using Power Query Editor:

= Table.ReplaceValue(SalesLT_Address,”1318”,”1319”,Replacer.ReplaceText,{“AddressLine1”}).

A row has a value of 21318 Lasalle Street in the AddressLine1 column. What will the value be when the step is applied?

A. 1318
B. 1319
C. 21318 Lasalle Street
D. 21319 Lasalle Street

Answer 55

D. 21319 Lasalle Street

Question 56

You have a Microsoft Power Bl report. The size of PBIX file is 550 MB.

The report is accessed by using an App workspace in shared capacity of powerbi.com. The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows.

The dataset is scheduled to refresh twice a day at 08:00 and 17:00. The report is a single page that contains 15 custom visuals and 10 default visuals. Users say that the report is slow to load the visuals when they access and interact with the report.

You need to recommend a solution to improve the performance of the report. What should you recommend?

A. Split the visuals onto multiple pages.
B. Implement row-level security (RLS).
C. Replace the default visuals with custom visuals.
D. Increase the number of times that the dataset is refreshed.

Answer 56

A. Split the visuals onto multiple pages.

Question 57

You have a report that contains a bar chart and a column chart. The bar chart shows customer count by customer segment. The column chart shows sales by month.

You need to ensure that when a segment is selected in the bar chart, you see which portion of the total sales for the month belongs to the customer segment.

How should the visual interactions be set on the column chart when the bar chart is selected?

A. No Impact
B. Highlight
C. Filter
D. No answer text provided.

Answer 57

B. Highlight

Question 58

You manage a Power BI model has a table named Sales and product.
You need to ensure that a sales team can view only data that has a CountryRegionName value of United States and a ProductCategory value of Clothing.

What should you do from Power BI Desktop?

A. From Power BI Desktop, create a new role that has the following filter.[countryRegionName]= “United States” && [ProductCategory]= “Clothing”

B. Add the following filters in Query Editor.CountryRegionName is United StatesProductCategory is Clothing

C. From Power BI Desktop, create a new role that has the following filters.[CountryRegionName]= “United States”

D. Add the following filters to a report.CountryRegionName is United SatesProductCategory is Clothing

Answer 58

D. Add the following filters to a report.CountryRegionName is United SatesProductCategory is Clothing

The correct answer is to add filters to the report because the goal is to ensure that the sales team can view only specific data (i.e., CountryRegionName is “United States” and ProductCategory is “Clothing”) when interacting with the report.

Question 59

Which visual is more suited for identifying outliers in a dataset?

A. Scatter Plot
B. Pie Chart
C. Area Chart
D. Histogram

Answer 59

A. Scatter Plot

Scatter plots display individual data points and their distribution, making them suitable for identifying outliers.

Histograms show data distribution but do not highlight outliers.

Area charts represent the cumulative sum of data over time, not ideal for outlier detection.

Pie charts show proportions of a whole but do not specifically identify outliers in data.

Question 59

You are developing a sales report that will have multiple pages. Each page will answer a different business question. You plan to have a menu page that will show all the business questions.

You need to ensure that users can click each business question and be directed to the page where the question is answered. The solution must ensure that the menu page will work when deployed to any workspace. What should you include on the menu page?

A. Create a text box for each business question and insert a link
B. Create a button for each business question and set the action type to Bookmark
C. Create a Power Apps visual that contains a drop-down list
D. The drop-down list will contain the business questions

Answer 59

B. Create a button for each business question and set the action type to Bookmark

When you create a bookmark, the following elements are saved with the bookmark: - The current page - Filters - Slicers, including slicer type (for example, dropdown or list) and slicer state - Visual selection state (such as cross-highlight filters) - Sort order - Drill location - Visibility of an object (by using the Selection pane) - The focus or Spotlight modes of any visible object

Question 59

You have a Power BI data source that contains the following tables:
1. Category: Lists the product category
2. Subcategory: Lists the product subcategory
3. 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?

A. Import all three tables into the data model and connect them using relationships

B. Use the Combine command to create a single loaded table for product

C. Import only the ProductName table into the model

D. Use the Append command to create a single loaded table for product

Answer 59

B. 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

Question 59

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?

A. Report builder can change the aggregation type of implicit measure from the Values well of a visual
B. Implicit measures can be used to create Quick Measures
C. Implicit measures can be used as a Drillthrough field
D. Implicit measures can be used with Field Parameters

Answer 59

A. Report builder can change the aggregation type of implicit measure from the Values well of a visual

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