PL-300 Exam Questions and Answers [2025 Edition]

NEW QUESTION 1

(Edutechnolab 1)

You need to create a visualization to meet the reporting requirements of the sales managers.

How should you create the visualization? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

 

 

1. Mastered
2. Not Mastered

 

Answer: A

Explanation:

Scenario: The sales managers require a visual to analyze sales performance versus sales targets. Box 1: KPI

A Key Performance Indicator (KPI) is a visual cue that communicates the amount of progress made toward a measurable goal. Box 2: Sales[sales_amount]

Box 3: Date[month]

Time > FiscalMonth. This value will represent the trend. Box 4: Targets[sales_target]

NEW QUESTION 2

You merge data from Sales.Region, Region_Manager, Sales_Manager, and Manager into a single table named Region. What should you do next to meet the reporting requirements of the executives?

 

1. Apply row-level security (RLS) to the Region table based on the sales manager username.
2. Configure a bi-directional relationship between Region and Sales.Region.
3. Create a DAX calculated column that retrieves the region manager from the Weekly.Returns table based on the sales.regionjd column.
4. In the Region table, create a hierarchy that has the manager name, and then the sales manager name.

Answer: C

NEW QUESTION 3

You need to provide a solution to provide the sales managers with the required access. What should you include in the solution?

 

1. Create a security role that has a table filter on the Sales_Manager table where username = UserName()
2. Create a security role that has a table filter on the Region_Manager table where sales_manager_id = UserPrincipalName().
3. Create a security role that has a table filter on the Sales_Manager table where name = UserName().
4. Create a security role that has a table filter on the Sales_Manager table where username = sales_manager_id.

 

Answer: A

Explanation:

https://powerbi.microsoft.com/en-us/blog/using-username-in-dax-with-row- level-security/

 

NEW QUESTION 4

You need to create a calculated column to display the month based on the reporting requirements. Which DAX expression should you use?

1. FORMAT('Date'[date], "MMM YYYY")
2. FORMAT('Date' [date], "M YY")
3. FORMAT('Date'[date_id], "MMM") & "" & FORMAT('Date'[year], "#")
4. FORMAT('Date' [date_id], "MMM YYYY")

 

Answer: A

NEW QUESTION 5

You need to address the data concerns before creating the data model. What should you do in Power Query Editor?

1. Select Column distribution.
2. Select the sales_amount column and apply a number filter.
3. Select Column profile, and then select the sales_amount column.
4. Transform the sales_amount column to replace negative values with 0.

Answer: C

NEW QUESTION 6

You need to ensure that the data is updated to meet the report requirements. The solution must minimize configuration effort. What should you do?

 

1. From each report in powerbi.co
2. select Refresh visuals
3. From Power Bl Desktop, download the PBIX file and refresh the data.
4. Configure a scheduled refresh without using an on-premises data gateway.
5. Configure a scheduled refresh by using an on-premises data gateway

 

Answer: C

NEW QUESTION 7

DRAG DROP - (Edutechnolab 2)

Once the profit and loss dataset is created, which four actions should you perform in sequence to ensure that the business unit analysts see the appropriate profit and loss data? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

 

 

1. Mastered
2. Not Mastered 

Answer: A Explanation:

 

 

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-build-permissions

 

NEW QUESTION 8

You need to recommend a strategy to consistently define the business unit, department, and product category data and make the data usable across reports. What should you recommend?

 

1. Create a shared dataset for each standardized entity.
2. Create dataflows for the standardized data and make the dataflows available for use in all imported datasets.
3. For every report, create and use a single shared dataset that contains the standardized data.
4. For the three entities, create exports of the data from the Power Bl model to Excel and store the data in Microsoft OneDrive for others to use as a source.

 

Answer: B

NEW QUESTION 9

HOTSPOT - (Edutechnolab 2)

You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table. Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

 

 

1. Mastered
2. Not Mastered

 

Answer: A

Explanation:

Box 1: A DAX Calculated measure

Box 2: Date.EndofQuarter(#date([Year],[Mont],1))

ENDOFQUARTER returns the last date of the quarter in the current context for the specified column of dates. The following sample formula creates a measure that returns the end of the quarter, for the current context.

= ENDOFQUARTER(DateTime[DateKey])

 

 

NEW QUESTION 10

HOTSPOT - (Edutechnolab 2)

How should you distribute the reports to the board? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

 

 

 

 

 

1. Mastered
2. Not Mastered

Answer: A

Explanation:

Box 1: Using a workspace membership Scenario:

The company wants to provide a single package of reports to the board that contains custom navigation and links to supplementary information.

Note: Workspace is a shared environment for a group of people. You can have multiple Power BI content in a workspace. One workspace can have hundreds of dashboards, reports, and datasets in it.

Box 2: A mail-enabled security group Scenario: Security Requirements

The reports must be made available to the board from powerbi.com. A mail-enabled security group will be used to share information with the board.

 

NEW QUESTION 10

Which DAX expression should you use to get the ending balances in the balance sheet reports?

 

1. CALCULATE (SUM( BalanceSheet [BalanceAmount] ), DATESQTD( 'Date'[Date] ))
2. CALCULATE (SUM( BalanceSheet [BalanceAmount] ), LASTDATE( 'Date'[Date] ))
3. FIRSTNONBLANK ( 'Date' [Date]SUM( BalanceSheet[BalanceAmount] ))

 

Answer: A

Explanation:

Scenario: At least one of the balance sheet reports in the quarterly reporting package must show the ending balances for the quarter, as well as for the previous quarter.

DATESQTD returns a table that contains a column of the dates for the quarter to date, in the current context. Reference:

https://docs.microsoft.com/en-us/dax/datesqtd-function-dax

 

 

NEW QUESTION 12

You need to create the relationship between the product list and the revenue results. The solution must minimize the time it takes to render visuals. What should you set as the relationship cardinality?

 

1. One to one
2. Many to one
3. One to many
4. Many to many

 

Answer: C

 

NEW QUESTION 13

What is the minimum number of datasets and storage modes required to support the reports?

 

1. two imported datasets
2. a single DirectQuery dataset
3. two DirectQuery datasets
4. a single imported dataset

 

Answer: D

 

Explanation:

"The analysts responsible for each business unit must see all the data the board sees, except the profit and loss data, which must be restricted to only their business unit's data. The analysts must be able to build new reports from the dataset that contains the profit and loss data" => one dataset and two separate workspaces Reason: All data can be imported into one dataset also if these are two logical models. Shared dimensions can be reconsumed in both models. Reports and additional materials can be shared to the board with an app. The "profit and loss" data model needs RLS for the analysts and the analysts must have just read access to the original workspace. In a separate workspace with contributer (or more rights) they can create new reports (with live connection to the dataset). It is also stated that the new reports mustn't be shared so therefore no need to include them into the app. Import vs. DirectQuery: Due to RLS requirements an imported dataset is needed. It is not possible with file sources and Sharepoint lists.

 

 

NEW QUESTION 17

HOTSPOT - (Edutechnolab 3)

You need to create the Top Customers report.

Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

 

 

 

 

 

1. Mastered
2. Not Mastered

Answer: A

Explanation:

Box 1: Top N

Scenario: The Top Customers report will show the top 20 customers based on the highest sales amounts in a selected order month or quarter, product category, and sales region.

Once you drag to SKU to Visual level filter you should get Top N option Note: The two most common filter types: automatic and manual.

 

 

 

Then there are more advanced filters.

Box 2: Visual

Once you drag to SKU to Visual level filter you should get Top N option.

 

NEW QUESTION 22

You need to design the data model to meet the report requirements. What should you do in Power BI Desktop?

 

1. From Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of the OrderDate column, the calendar quarter of the ShippedDate column, and the calendar month of the ShippedDate column.
2. From Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column.
3. From Power Bl Desktop, use the Auto date/time option when creating the reports.
4. From Power Query, add a date tabl
5. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table.

 

Answer: B

 

Explanation:

Use Power Query to calculate calendar quarter and calendar month. Scenario:

? A single dataset must support all three reports:

• The Top Customers report will show the top 20 customers based on the highest sales amounts in a selected order month or quarter, product category, and sales region.
• The Top Products report will show the top 20 products based on the highest sales amounts sold in a selected order month or quarter, sales region, and product category.

? The data model must minimize the size of the dataset as much as possible, while meeting the report requirements and the technical requirements.

 

 

NEW QUESTION 25

HOTSPOT - (Edutechnolab 3)

You need to create a solution to meet the notification requirements of the warehouse shipping department.

 

 

What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct select is worth one point:

 

 

1. Mastered
2. Not Mastered 

Answer: A 

 

 

 

NEW QUESTION 29

You need to create the dataset. Which dataset mode should you use?

 

1. DirectQuery
2. Import
3. Live connection
4. Composite

 

Answer: D

Explanation:

Composite Model means now you can have a model, that very large tables of that are coming from the DirectQuery connection, without the need for importing, and small tables to be imported to be accessible quickly.

 

 

NEW QUESTION 33

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

 

 

 

You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.

You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition. Solution: You create a new query that references DataSourceExcel. Does this meet the goal?

 

1. Yes
2. No

 

Answer: B

 

Explanation:

Instead modify the source step of the queries to use DataSourceExcel as the file path.

Note: Parameterising a Data Source could be used in many different use cases. From connecting to different data sources defined in Query Parameters to load different combinations of columns.

Reference:

https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/

 

 

NEW QUESTION 38

You have a Power Bl report

You have a table named Dalai that contains 10 million rows. Data is used in the following visuals:

• A card that shows the number of records
• A bar chart that snows total transaction amount by territory
• A scatter plot that shows transaction amount and profit amount on the axes and points colored by territory

You need to modify the scatter plot to make it easier for users to identify meaningful patterns. The solution must not affect the accuracy of the other visuals-What should you do?

 

1. Apply a row filter to the Dalai query in Power Query Editor.
2. Add a trend line to the scatter plot
3. Enable high-density sampling on the scatter plot
4. Add a count field of the transaction amount to the size bucket of the scatter plot

 

Answer: B

 

 

NEW QUESTION 43

You are creating a Power Bl report by using Power Bi Desktop.

You need to include a visual that shows trends and other useful information automatically. The visual must update based on selections in other visuals. Which type of visual should you use?

 

1. key influencers
2. decomposition tree
3. Q&A
4. smart narrative

 

Answer: D

 

 

NEW QUESTION 48

 

 

You have the Power Bl model shown in the following exhibit.

There are four departments in the Departments table.

You need to ensure that users can see the data of their respective department only. What should you do?

 

1. Create a row-level security (RLS) role for each department, and then define the membership of the role.
2. Create a DepartmentID parameter to filter the Departments table.
3. To the ConfidentialData table, add a calculated measure that uses the currentgroup DAX function.
4. Create a slicer that filters Departments based on DepartmentID.

 

Answer: A

 

 

NEW QUESTION 51

You have a Power Bl model that contains two tables named Population and Date. The Population table contains two columns named Population Amount and Date Key.

DateKey contains date values that represent the first day of a year and are used to create a many-to

The Power Bl model contains two measures that have the following definitions. Total Population = Sum ('Population'[Population Amount])

 

 

 

2023 Population = CALCULATE ([Total Population]"Date'[Year] = 2023) You create a table visual that displays Date[Year] and [2023 Population]. What will the table visual show?

 

1. one row per year that contains blank values for every year except 2023
2. one row per date that contains the population value for the corresponding year repeated in each row
3. a single row for the year 2023 that contains the related population value
4. one row per year that contains the same value repeated for each year

 

Answer: C

 

 

NEW QUESTION 54

Your company has employees in 10 states.

The company recently decided to associate each state to one of the following three regions: East, West, and North.

You have a data model that contains employee information by state. The model does NOT include region information.

You have a report that shows the employees by state.

You need to view the employees by region as quickly as possible. What should you do?

 

1. Create a new aggregation that summarizes by employee.
2. Create a new group on the state column and set the Group type to List.
3. Create a new group on the state column and set the Group type to Bin.
4. Create a new aggregation that summarizes by state.

 

Answer: B

 

Explanation:

https://www.mssqltips.com/sqlservertip/4720/binning-and-grouping-data-with- power-bi/

 

 

NEW QUESTION 59

HOTSPOT - (Edutechnolab 4)

 

 

You view a query named Transactions as shown in the following exhibit.

The query gets CSV files from a folder.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.

 

 

 

 

1. Mastered
2. Not Mastered

 

Answer: A

 

Explanation:

Box 1: 9

Box 2: 10

https://pediaa.com/what-is-the-difference-between-unique-and-distinct-in- sql/#:~:text=Unique%20and%20Distinct%20are%20two%20SQL%20constraints.,the%20re cords%20from%20a%20table.

 

NEW QUESTION 62

FILL IN THE BLANK - (Edutechnolab 4)

You have the Power Bi dashboard shown in the Dashboard exhibit (Click the Dashboard tab.)

You need to ensure that when users view the dashboard on a mobile device, the dashboard appears as shown in the Mobile exhibit. (Click the Mobile tab.) What should you do? To answer, select the appropriate options m the answer area NOTE: Each correct selection is worth one point.

 

1. Mastered
2. Not Mastered

 

Answer: A

 

Explanation:

 

 

Answer as selected

NEW QUESTION 67

You maintain a Power Bl workspace that contains a supplier quality dashboard. The dashboard contains 10 card visuals, two map visuals and five bar chart visuals.

The dashboard mobile layout is shown in the exhibit. (Click the Exhibit tab.)

 

 

You need to modify the dashboard mobile layout to meet the following requirements:

• Only show single-value visuals.
• Minimize scrolling.

What should you do?

 

1. Remove the card visual, increase the size of the map and bar chart visuals
2. Decrease the size of the map and bar chart visuals Move all the card visuals to the top of the layout.
3. Move the bar chart visuals to the top of the layout Remove the map visual
4. Decrease the size of the card visuals.
5. Decrease the size of the card visual
6. Remove the map and bar chart visuals.

 

Answer: D

 

NEW QUESTION 72

You have more than 100 published datasets.

Ten of the datasets were verified to meet your corporate quality standards.

You need to ensure that the 10 verified datasets appear at the top of the list of published datasets whenever users search for existing datasets. What should you do?

 

1. Publish the datasets in an app.
2. Promote the datasets.
3. Feature the dataset on the home page.
4. Certify the datasets.

 

Answer: D

NEW QUESTION 74

HOTSPOT - (Edutechnolab 4)

You are creating an analytics report that will consume data from the tables shown in the following table.

 

 

There is a relationship between the tables.

There are no reporting requirements on employeejd and employee_photo. You need to optimize the data model

 

 

What should you configure for employeejd and employee.photo? To answer, select the appropriate options in the answer area.

 

 

1. Mastered
2. Not Mastered

 

Answer: A

 

Explanation:

Box 1: Hide

Optimize data by hiding fields and sorting visualization data Box 2: Delete

The fastest way to optimize your Power BI report is to limit the number of columns to only the ones you need in your data model. Go through your tables in Power Query and determine what fields are being used. Delete these columns if they are not being used in any of your reports or calculations.

 

 

NEW QUESTION 76

DRAG DROP - (Edutechnolab 4)

You plan to create a report that will display sales data from the last year for multiple regions You need to restrict access to individual rows of the data on a per region-basis by using roles.

Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

 

 

1. Mastered
2. Not Mastered Answer: A Explanation:

 

 

 

 

 

NEW QUESTION 77

 

 

You are creating a query to be used as a Country dimension in a star schema. A snapshot of the source data is shown in the following table.

You need to create the dimension. The dimension must contain a list of unique countries. Which two actions should you perform? Each correct answer presents part of the solution.

 

1. Remove duplicates from the Country column.
2. Remove duplicates from the City column.
3. |Remove duplicates from the table.
4. Delete the City column.
5. Delete the Country column.

 

Answer: AD

 

Explanation:

To create a dimension table for Country from your source data, you need to perform these two actions34:

? Delete the City column. You don’t need this column for your Country dimension, as

it is not a descriptive attribute of Country. You can create another dimension table for City if you want to use it in your analysis.

? Remove duplicates from the Country column. You want to have a list of unique

countries in your dimension table, so you need to remove any duplicate values from this column.

 

 

NEW QUESTION 80

DRAG DROP - (Edutechnolab 4)

You receive revenue data that must be included in Microsoft Power Bl reports.

 

 

You perform an initial load of the data from a Microsoft Excel source as shown in the following exhibit.

You plan to create several visuals from the data, including a visual that shows revenue split by year and product.

You need to transform the data to ensure that you can build the visuals. The solution must ensure that the columns are named appropriately for the data that they contain.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

 

 

1. Mastered
2. Not Mastered

 

Answer: A

 

Explanation:

Step 1: Select Use Header as First Row.

Step 2: Select Department and Product and Unpivot Other Columns

Unpivot Other Columns: This command unpivots unselected columns. Use this command in a query when not all columns are known. New columns added during a refresh operation are also unpivoted.

Step 3: Rename the Attribute column to Year and the Value column to Revenue.

You might want to unpivot data, sometimes called flattening the data, to put it in a matrix format so that all similar values are in one column. This is necessary, for example, to create a chart or a report.

Chart Description automatically generated with medium confidence

When you unpivot, you unpack the attribute-value pairs that represent an intersection point of the new columns and re-orient them into flattened columns:

Values (in blue on the left) are unpivoted into a new column (in blue on the right). Attributes (in green on the left) are unpivoted into a new column (in green on the right) and

duplicates are correspondingly mapped to the new Values column.

 

NEW QUESTION 81

You have a Power BI report that contains four pages. All the pages contain a slicer for a field named Country,

You need to ensure that when a user selects a county on page l, the selection is retained on page 2 and page 3. The solution must prevent page 4 from being affected by

selections on the other pages, What should you do?

 

1. Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the report-level filters.
2. Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the page-level filters.
3. Sync the Country slicer on page 1, page 2, and page 3,
4. Move the Country slicer from page 2 and page 3 to page 1.

Answer: B

 

NEW QUESTION 83

HOTSPOT - (Edutechnolab 4)

You have a table that contains a column named Phone. The following is a sample of the data in the Phone column.

 

 

You need to add a new column that contains the data in the format of nnn-nnn-nnnn. How should you complete the Query Editor formula? To answer, select the appropriate

options in the answer area.

NOTE: Each correct selection is worth one point.

 

 

 

 

 

1. Mastered
2. Not Mastered

 

Answer: A

 

Explanation:

References:

https://docs.microsoft.com/en-us/powerquery-m/text-replace https://docs.microsoft.com/en-us/powerquery-m/text-end

 

 

NEW QUESTION 84

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:

• Due Date
• Order Date
• Delivery Date

You need to support the analysis of sales over time based on all three dates at the same time.

Solution; You create measures that use the uSEREIATIOHSHIP DAX function to filter sales on the inactive relationships between the sales table and the date table.

Does this meet the goal?

 

1. Yes
2. No

 

Answer: B

 

 

NEW QUESTION 87

HOTSPOT - (Edutechnolab 4)

You have two CSV files named Products and Categories. The Products file contains the following columns:

? ProductID

? ProductName

? SupplierID

? CategoryID

The Categories file contains the following columns:

? CategoryID

? CategoryName

? CategoryDescription

From Power BI Desktop, you import the files into Power Query Editor.

You need to create a Power BI dataset that will contain a single table named Product. The Product will table includes the following columns:

? ProductID

? ProductName

? SupplierID

? CategoryID

? CategoryName

? CategoryDescription

How should you combine the queries, and what should you do on the Categories query? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

 

 

 

1. Mastered
2. Not Mastered Answer: A Explanation:

 

 

NEW QUESTION 88

You have a large dataset that contains more than 1 million rows. The table has a datetime column named Date.

You need to reduce the size of the data model. What should you do?

 

1. Round the hour of the Date column to startOfHour.
2. Change the data type of the Date column to Text.
3. Trim the Date column.
4. Split the Date column into two columns, one that contains only the time and another that contains only the date.

 

Answer: D

 

Explanation:

We have to separate date & time tables. Also, we don’t need to put the time into the date table, because the time is repeated every day.

Split your DateTime column into a separate date & time columns in fact table, so that you can join the date to the date table & the time to the time table. The time need to be converted to the nearest round minute or second so that every time in your data corresponds to a row in your time table.

Reference:

https://intellipaat.com/community/6461/how-to-include-time-in-date-hierarchy-in-power-bi

 

 

NEW QUESTION 91

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.

You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition. Solution: You add a Power Apps custom visual to the report. Does this meet the goal?

 

1. Yes
2. No

 

Answer: A

 

 

NEW QUESTION 93

 

 

You have a Q&A visual that displays information from a table named Carriers as shown in the following exhibit.

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?

 

1. Add a duplicate query named Airline.
2. Add airline as a synonym of carrier.

 

 

 

3. Rename the carrier column as airline in the Carriers query.
4. Rename the query from Carriers to airlines.

 

Answer: B

 

Explanation:

Add synonyms to tables and columns: This step applies specifically to Q&A (and not to Power BI reports in general). Users often have a variety of terms they use to refer to the same thing, such as total sales, net sales, total net sales. You can add these synonyms to tables and columns in the Power BI model.

This step can be important. Even with straightforward table and column names, users of Q&A ask questions using the vocabulary that first comes to them. They're not choosing

from a predefined list of columns. The more sensible synonyms you add, the better your users' experience is with your report. Reference:

https://docs.microsoft.com/en-us/power-bi/natural-language/q-and-a-best-practices

 

 

NEW QUESTION 95

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.

You need to create a reference line to show which employees are above the median salary.

Solution: You create an average line by using the Salary measure. Does this meet the goal?

 

1. Yes
2. No

 

Answer: B

 

Explanation:

Instead create a percentile line by using the Salary measure and set the percentile to 50%. Note: The 50th percentile is also known as the median or middle value where 50 percent of

observations fall below.

Reference:

https://dash-intel.com/powerbi/statistical_functions_percentile.php

 

 

NEW QUESTION 98

In Power Bi Desktop, you are creating visualizations in a report based on an imported dataset

You need to allow Power Bi users to export the summarized data used to create the visualizations but prevent the users from exporting the underlying data What should you do?

 

1. From Power BI Desktop, configure the Data Load settings for the current file.
2. From the Power BI service, configure the dataset permissions.
3. From Power BI Desktop, configure the Report settings for the current file.
4. From Power BI Desktop, modify the data source permissions.

 

Answer: C

 

Explanation:

https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization- export-data?tabs=powerbi-desktop

The export functionality can be disabled on several levels. First, Power BI Service admins can disable this functionality on tenant level. With that, nobody will be able to export the data. More about that later. Second, as a dataset owner you can decide if you allow your users to export the data. This is managed in dataset settings, but only changeable in Power BI desktop.

No matter what settings are applied in Power BI desktop, the tenant settings will overrule this. In the end the Power BI Service admin decides what options are possible to use.

https://data-marc.com/2020/04/13/power-bi-governance-why-you-should-consider-to- disable-export-to-excel/

 

NEW QUESTION 99

FILL IN THE BLANK - (Edutechnolab 4)

You need to create a relationship in the dataset for RLS.

What should you do? To answer select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

 

1. Mastered
2. Not Mastered

 

Answer: A

 

Explanation:

Answer as below

 

 

 

NEW QUESTION 104

You have a report that contains a donut chart and a clustered column chart. Interactions between the visuals use the default settings.

You need to modify the report so that when you select a column m the column chart, the donut chart redraws by using the data from the selected column. What should you do?

 

1. Select the column chart and set the donut chart interaction to None.
2. Select the column chart and set the donut chart interaction to Filter.
3. Select the donut chart and set the column chart interaction to Filter.
4. Select the donut chart and set the column chart interaction to None.

 

Answer: B

 

 

NEW QUESTION 106

HOTSPOT - (Edutechnolab 4)

You are creating a Microsoft Power Bl imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories.

 

 

You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.)

The related dimension tables are imported into the model.

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

 

 

1. Mastered
2. Not Mastered Answer: A Explanation:

 

 

 

NEW QUESTION 109

HOTSPOT - (Edutechnolab 4)

You need to create a Power Bl report. The first page or the report must contain the following two views:

• Sales By Postal Code
• Sales by Month

 

 

 

Both views must display a slicer to select a value for a field named Chain.

 

 

The Sales By Postal Code view must display a map visual as shown in the following exhibit.

 

 

1. Mastered
2. Not Mastered Answer: A Explanation:

 

 

NEW QUESTION 112

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.

You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition. Solution: You modify the source step of the queries to use DataSourceExcel as the file path.

Does this meet the goal?

 

1. Yes
2. No

 

Answer: A

 

Explanation:

Parameterising a Data Source could be used in many different use cases. From connecting to different data sources defined in Query Parameters to load different combinations of columns.

Reference:

https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/

 

NEW QUESTION 114

You have data in a Microsoft Excel worksheet as shown in the following table.

 

 

 

You need to use Power Query to clean and transform the dataset. The solution must meet the following requirements:

• If the discount column returns an error, a discount of 0.05 must be used.
• All the rows of data must be maintained.
• Administrative effort must be minimized. What should you do in Power Query Editor?

 

1. Select Keep Errors
2. Edit the query in the Query Errors group.
3. Select Replace Errors
4. Select Remove Errors.

Answer: C

 

NEW QUESTION 116

You have a Microsoft Power Bl dashboard.

You need to ensure that consumers of the dashboard can give you feedback that will be visible to the other consumers of the dashboard. What should you use?

 

1. Feedback
2. Subscribe
3. Comments
4. Mark as favorite

Answer: C

 

Explanation:

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-comment

 

NEW QUESTION 118

You have an Azure SQL database that contains sales transactions. The database is updated frequently.

You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update. How should you configure the data connection?

 

1. Add a SQL statement.
2. Set Data Connectivity mode to DirectQuery.
3. Set the Command timeout in minutes setting.
4. Set Data Connectivity mode to Import.

Answer: B

 

Explanation:

With Power BI Desktop, when you connect to your data source, it's always possible to

import a copy of the data into the Power BI Desktop. For some data sources, an alternative approach is available: connect directly to the data source using DirectQuery.

DirectQuery: No data is imported or copied into Power BI Desktop. For relational sources, the selected tables and columns appear in the Fields list. For multi- dimensional sources like SAP Business Warehouse, the dimensions and measures of the selected cube appear in the Fields list. As you create or interact with a visualization, Power BI Desktop queries the underlying data source, so you’re always viewing current data.

Reference:

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery

 

NEW QUESTION 123

HOTSPOT - (Edutechnolab 4)

You have a folder of monthly transaction extracts.

You plan to create a report to analyze the transaction data.

You receive the following email message: "Hi. I've put 24 files of monthly transaction data onto the shared drive. File Transactions201901.csv through Transactions201912.csv have the latest set of columns, but files Transactions201801.csv to Transactions201812.csv have an older layout without the extra fields needed for analysis. Each file contains 10 to 50 transactions."

 

 

You get data from the folder and select Combine & Load. The Combine Files dialog box is shown in the exhibit. (Click the Exhibit tab.)

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

 

 

1. Mastered
2. Not Mastered

 

Answer: A

Explanation:

Graphical user interface, text, application Description automatically generated

Box 1: Yes

The four columns used in the 2018 transactions are already displayed. Box 2: Yes

The columns used are based on the entire dataset. The additional columns in the 2019 files will be detected. Box 3: Yes

Note: Under the hoods, Power BI will automatically detect which delimiter to use, and may even promote the first row as headers. You can manually change the delimiter, or define how Power BI should handle data types. You can set it to automatically detect data types based on first 200 rows, or the entire dataset or you can even opt out the detection of data types.

 

 

NEW QUESTION 126

You have a Microsoft Excel file on a file server.

You create a Power BI report and import a table from the Excel file. You publish the report. You need to ensure that the data refreshes every four hours. What should you do first?

 

1. Upload the Excel file to a Power BI workspace.
2. Create a subscription to the report.
3. Deploy an on-premises data gateway.
4. Edit the data source credentials.

 

Answer: C

 

NEW QUESTION 127

You plan to create a dashboard in the Power BI service that retrieves data from a Microsoft SQL Server database. The dashboard will be shared between the users in your organization.

You need to ensure that the users will see the current data when they view the dashboard. How should you configure the connection to the data source?

 

1. Deploy an on-premises data gateway (personal mode). Import the data by using the Import Data Connectivity mode.
2. Deploy an on-premises data gatewa
3. Import the data by using the Import Data Connectivity mode.
4. Deploy an on-premises data gatewa
5. Import the data by using the DirectQuery Data Connectivity mode.
6. Deploy an on-premises data gateway (personal mode). Import the data by using the DirectQuery Data Connectivity mode.

 

Answer: D

 

Explanation:

References: https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about#power-bi-connectivity-modes

 

NEW QUESTION 132

HOTSPOT - (Edutechnolab 4)

You are creating a column chart visualization.

 

 

You configure groups as shown in the Groups exhibit. {Click the Groups tab.)

The visualization appears as shown in the Chart exhibit. (Click the Chart tab.)

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

 

 

1. Mastered
2. Not Mastered Answer: A Explanation:

 

 

 

NEW QUESTION 133

Note: This question is a part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.

Start of repeated scenario

 

 

You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)

You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit).

You plan to use Power BI to import data from 2013 to 2015. Product Subcategory [Subcategory] contains NULL values. End of repeated scenario.

You implement the Power BI model.

You need to add a new column to the Product Subcategory table that uses the following formula.

=if [Subcategory] =null then “NA” else [Subcategory] Which command should you use in Query Editor?

 

1. Column From Examples
2. Custom Column
3. Invoke Custom Function
4. Conditional Column

 

Answer: D

 

Explanation:

References: http://community.powerbi.com/t5/Desktop/if-then-else/td-p/117999

 

NEW QUESTION 135

You have a Power Bl model that contains the following data.

 

 

 

 

 

 

The Date table relates to the Sales table by using the Date columns. The model contains the following DAX measure. Total Sales = SUM(Sales[Sale])

You need to create another measure named Previous Quarter to display the sales one quarter before the selected period. Which DAX calculation should you use?

 

1. CALCULATE < [Total Sales], OATEADD (Date[Date], -1, QUARTER))
2. CALCULATE ([Total Sales], DATESQTD (Date[Date]))
3. TOTALQTD ([Total Sales], Date[Date])
4. CALCULATE < [Total Sales], PARALLELPERIOO (Date[Date], 1, QUARTER))

 

Answer: A

 

 

NEW QUESTION 136

You have a Power Bl workspace named Inventory that contains a dataset a report and a dashboard.

You need to add an additional tile to the dashboard. The tile must show inventory by location. This information is NOT visualized in the report. The solution must minimize the impact on the report.

Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

 

1. Use quick insights on the dashboard.
2. Hide the report page.
3. Ask a question by using Q&A.
4. Add the visual to the report.
5. Pin the visual to the dashboard.

Answer: CE

 

NEW QUESTION 140

DRAG DROP - (Edutechnolab 4)

You create a data model in Power BI.

 

 

Report developers and users provide feedback that the data model is too complex. The model contains the following tables.

The model has the following relationships:

*There is a one-to-one relationship between Sales_Region and Region_Manager.

*There are more records in Manager than in Region_Manager, but every record in Region_Manager has a corresponding record in Manager.

*There are more records in Sales_Manager than in Sales_Region, but every record in Sales_Region has a corresponding record in Sales_Manager. You need to denormalize the model into a single table. Only managers who are associated to a sales region must be included in the reports.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

 

 

NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
 

1. Mastered
2. Not Mastered

 

Answer: A

 

Explanation:

* 1.Merge [Region_Manager] and [Manager] by using an inner join. 3.Merge [Sales_Region] and [Sales_Manager] by using an inner join. 6.Merge [Sales_Region] and [Region_Manager] by using an inner join.

 

NEW QUESTION 145

You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned.

You build a report analyzing the internal networks of employees based on whom they send emails to.

You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size. What should you do?

 

1. Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent.
2. Remove the Subject and Body columns during the import.
3. From Model view, set the Subject and Body columns to Hidden.

Answer: B

NEW QUESTION 149

 

 

You have a Power Bl query named Sates that imports the columns shown in the following table.

Usees only use the dale part of the Sales.Date field. Only rows with a Status of Finished are used in analysis. You need to reduce the load times of the query without affecting the analysis.

Which two actions achieve this goal? Each correct answer presents a complete solution. NOTL Each correct selection is worth one pant.

 

1. Remove the rows in which sales [status] has a value of Canceled.
2. Change the data type of sale [Delivery_Time] to Integer
3. Removes (Canceled Date).
4. Split Sales [Sale_Date] into separate date and time columns.
5. Remove sales [Sales_Date].

 

Answer: AD

 

 

NEW QUESTION 154

 

 

You have the tables shown in the following table.

The Impressions table contains approximately 30 million records per month. You need to create an ad analytics system to meet the following requirements:

? Present ad impression counts for the day, campaign, and Site_name. The analytics for the last year are required.

? Minimize the data model size.

Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

 

1. Group the impressions by Ad_id, Site_name, and Impression_dat
2. Aggregate by using the CountRows function.
3. Create one-to-many relationships between the tables.
4. Create a calculated measure that aggregates by using the COUNTROWS function.
5. Create a calculated table that contains Ad_id, Site_name, and Impression_date.

 

Answer: AB

 

Explanation:

Grouping in power query reduces the number of rows in the impression table that is gonna be loaded in the model. Creating relationships doesn't increase the size of the model.

NEW QUESTION 157

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?

 

1. Create a text box for each business question and insert a link.
2. Create a button for each business question and set the action type to Bookmark.
3. Create a Power Apps visual that contains a drop-down lis
4. The drop-down list will contain the businessquestions.

 

Answer: B

 

Explanation:

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

 

NEW QUESTION 161

HOTSPOT - (Edutechnolab 4)

Your company has affiliates who help the company acquire customers.

You build a report for the affiliate managers at the company to assist them in understanding affiliate performance.

The managers request a visual showing the total sales value of the latest 50 transactions for each affiliate. You have a data model that contains the following tables.

You need to develop a measure to support the visual.

How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

 

 

1. Mastered
2. Not Mastered

Answer: A

Explanation:

Box 1: CALCULATE

Start with CALCULATE and use a SUMX.

CALCULATE evaluates an expression in a modified filter context. Box 2: SUM

Box 3: TOPN

TOPN returns the top N rows of the specified table. Box 4: [TransactionDate]

TOPN Syntax: TOPN(<n_value>, <table>, <orderBy_expression>, [<order>[,

<orderBy_expression>, [<order>]]…])

The orderBy_expression: Any DAX expression where the result value is used to sort the table and it is evaluated for each row of table.

 

NEW QUESTION 164

You have a Power BI dashboard that monitors the quality of manufacturing processes. The dashboard contains the following elements:

? A line chart that shows the number of defective products manufactured by day.

? A KPI visual that shows the current daily percentage of defective products manufactured.

You need to be notified when the daily percentage of defective products manufactured exceeds 3%. What should you create?

 

1. a Q&A visual
2. a subscription
3. a smart narrative visual
4. an alert

 

Answer: D

 

NEW QUESTION 167

You have a Power Bl report that uses row-level security (RLS).

You need to transfer RLS membership maintenance to an Azure network security team. The solution must NOT provide the Azure network security team with the ability to manage reports, datasets. or dashboards.

What should you do?

 

1. Add the Azure network security team as members of the RLS role.
2. Instruct the Azure network security team to create security group
3. Configure RLS to use the groups.
4. Configure custom instructions for the Request access feature that instructs users to contact the Azure network security team.
5. Grant the Read and Build permissions for the Power Bl datasets to the Azure network security team.

 

Answer: B

 

Explanation:

It is common practice that the PBI developer creates RLS groups and instructs the network team to create the corresponding AD roles. Then the developer assigns the AD groups to the RLS groups.

 

 

NEW QUESTION 172

You have four sales regions. Each region has multiple sales managers.

You implement row-level security (RLS) in a data model. You assign the relevant distribution lists to each role.

You have sales reports that enable analysis by region. The sales managers can view the sales records of their region. The sales managers are prevented from viewing records from other regions.

A sales manager changes to a different region.

You need to ensure that the sales manager can see the correct sales data. What should you do?

 

1. From Microsoft Power Bl Desktop, edit the Row-Level Security setting for the reports.
2. Change the Microsoft Power Bl license type of the sales manager.
3. Manage the permissions of the underlying dataset
4. Request that the sales manager be added to the correct Azure Active Directory group.

 

Answer: D

 

Explanation:

Using AD Security Groups, you no longer need to maintain a long list of users.

All that you will need to do is to put in the AD Security group with the required permissions and Power BI will do the REST! This means a small and simple security file with the permissions and AD Security group.

Note: Configure role mappings

Once published to Power BI, you must map members to dataset roles.

Members can be user accounts or security groups. Whenever possible, we recommend you map security groups to dataset roles. It involves managing security group memberships in Azure Active Directory. Possibly, it delegates the task to your network administrators.

Reference:

https://www.fourmoo.com/2018/02/20/dynamic-row-level-security-is-easy-with-active-directory-security-groups/ https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance

 

NEW QUESTION 173

You have a Power BI tenant.

You have reports that use financial datasets and are exported as PDF files. You need to ensure that the reports are encrypted. What should you implement?

 

1. dataset certifications
2. row-level security (RLS)
3. sensitivity labels
4. Microsoft Intune policies

 

Answer: C

 

Explanation:

General availability of sensitivity labels in Power BI.

Microsoft Information Protection sensitivity labels provide a simple way for your users to classify critical content in Power BI without compromising productivity or the ability to collaborate. Sensitivity labels can be applied on datasets, reports, dashboards, and dataflows. When data is exported from Power BI to Excel, PowerPoint or PDF files, Power BI automatically applies a sensitivity label on the exported file and protects it according to the label’s file encryption settings. This way your sensitive data remains protected no matter where it is.

Reference:

https://powerbi.microsoft.com/en-us/blog/announcing-power-bi-data-protection-ga-and-introducing-new-capabilities/

 

NEW QUESTION 178

DRAG DROP - (Edutechnolab 4)

You have a Microsoft Excel workbook that contains two tables.

From Power BI, you create a dashboard that displays data from the tables. You update the tables each day. You need to ensure that the virtualizations in the dashboard are updated daily.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to answer area and arrange them in the correct order.

 

 

 

 

 

 

1. Mastered
2. Not Mastered

 

Answer: A

 

Explanation:

References: https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh

NEW QUESTION 181

DRAG DROP - (Edutechnolab 4)

You have a Microsoft Exert spreadsheet named Excel1 that contains survey results. You have a Power Bl dashboard named DashboardA that has Q&A enabled. You need to ensure that users who can access DashboardA can ask Questions based on the contents of Excel 1 and pm visuals based on their queries to DashboardA. The solution must minimize development time.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

 

 

1. Mastered
2. Not Mastered

Answer: A

 

 

 

Explanation:

 

NEW QUESTION 182

You publish a Microsoft Power BI dataset to powerbi.com. The dataset appends data from an on-premises Oracle database and an Azure SQL database by using one query.

You have admin access to the workspace and permission to use an existing On-premises data gateway for which the Oracle data source is already configured. You need to ensure that the data is updated every morning. The solution must minimize configuration effort.

Which two actions should you perform when you configure scheduled refresh? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

 

1. Configure the dataset to use the existing On-premises data gateway.
2. Deploy an On-premises data gateway in personal mode.
3. Set the refresh frequency to Daily.
4. Configure the dataset to use the personal gateway.

 

Answer: AC

 

Explanation:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode

 

NEW QUESTION 186

FILL IN THE BLANK - (Edutechnolab 4)

 

 

You have a Power Bl visual that uses indicators to show values that are out of range as shown in the following exhibit.

 

 

1. Mastered
2. Not Mastered Answer: A Explanation:

 

NEW QUESTION 187

You have a sales system that contains the tables shown in the following table.

 

 

 

 

 

 

The Date table is marked as a date table.

DatelD is the date data type. You need to create an annual sales growth percentage measure. Which DAX expression should you use?

 

1. SUM(sales[sales_amount]) - CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR('Date'[DateID])
2. (SUM(‘Sales’[sales_amount]) - CALCULATE(SUM(‘Sales’[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[DateID])))/ CALCULATE(SUM(‘Sales’[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[DateID]))
3. CALCULATE(SUM(sales[sales_amount]), DATESYTD(‘Date’[DateID]))
4. CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[DateID]))

 

Answer: B

 

Explanation:

SAMEPERIODLASTYEAR returns a table that contains a column of dates shifted one year back in time from the dates in the specified dates column, in the current context.

Reference:

https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax

 

 

NEW QUESTION 188

FILL IN THE BLANK - (Edutechnolab 4)

You have a Power 31 data model that contains a table named Stores. The table has the following columns:

• Store Name
• Open Date
• Status
• State
• City

You need to create a calculated column named Active Store Name that meets the following requirements:

 

1. Mastered
2. Not Mastered

 

Answer: A

 

Explanation:

Answer is as below

 

 

NEW QUESTION 192

You are developing a report page. Some users will navigate the report by using a keyboard, and some users will consume the report by using a screen reader. You need to ensure that the users can consume the content on a report page in a logical order. What should you configure in Microsoft Power Bl Desktop?

 

1. the bookmark order
2. the layer order
3. the tab order
4. the X position

 

Answer: C

 

Explanation:

If you find yourself unable to navigate to an object or visual while using a keyboard, it may be because the report author has decided to hide that object from the tab order. Report authors commonly hide decorative objects from the tab order. If you find that you cannot tab through a report in a logical manner, you should contact the report author. Report authors can set the tab order for objects and visuals.

Reference:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-accessibility-consuming- tools

NEW QUESTION 197

DRAG DROP - (Edutechnolab 4)

You are preparing a financial report in Power BI.

 

 

You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit.

You need to prepare the data to support the following:

? Visualizations that include all measures in the data over time

? Year-over-year calculations for all the measures

Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

 

 

1. Mastered
2. 

Not Mastered 

Answer: A 

 

 

NEW QUESTION 202

DRAG DROP - (Edutechnolab 4)

In Power Query Editor, you have three queries named ProductCategory, ProductSubCategory, and Product. Every Product has a ProductSubCategory.

Not every ProductsubCategory has a parent ProductCategory.

You need to merge the three queries into a single query. The solution must ensure the best performance in Power Query.

How should you merge the tables? To answer, drag the appropriate merge types to the correct queries. Each merge type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

 

 

 

 

1. Mastered
2. Not Mastered Answer: A Explanation:

 

 

NEW QUESTION 207

DRAG DROP - (Edutechnolab 4)

You are modeling data in table named SalesDetail by using Microsoft Power Bl.

You need to provide end users with access to the summary statistics about the SalesDetail data. The users require insights on the completeness of the data and the value

distributions.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

 

 

1. Mastered
2. Not Mastered Answer: A Explanation:

 

 

 

 

 

NEW QUESTION 211

 

 

You have the visual shown in the Original exhibit. {Click the Original tab.)

You need to configure the visual as shown in the Modified exhibit. (Click the Modified tab.)

What should you add to the visual?

 

1. a measure
2. a trendline
3. a forecast
4. an Average line

 

Answer: C

Explanation:

Explore forecast results by adjusting the desired confidence interval or by adjusting outlier data to see how they affect results.

 

 

Timeline Description automatically generated with low confidence Reference:

https://powerbi.microsoft.com/fr-fr/blog/introducing-new-forecasting-capabilities-in-power-view-for-office-365/

 

 

NEW QUESTION 214

You have a Microsoft Power Bl dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source. The dashboard is shown in the exhibit. (Click the Exhibit tab.)

What occurred at 12:03:06 PM?

 

1. A user pressed F5
2. A new transaction was added to the data source.
3. A user added a comment to a tile.
4. The dashboard tile cache refreshed.

 

Answer: A

Explanation:

Reference:

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data

 

 

NEW QUESTION 218

HOTSPOT - (Edutechnolab 4)

You are using Power Bi Desktop to connect to an Azure SQL database The connection is configured as shown in the following exhibit.

 

 

 

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic NOTE: Each correct solution is worth one point

 

 

 

 

1. Mastered
2. Not Mastered

 

Answer: A

 

Explanation:

https://docs.microsoft.com/en-us/power-query/connectors/azuresqldatabase

The following table lists all of the advanced options you can set in Power Query Desktop and Power Query Online. Advanced option Description

Command timeout in minutes

If your connection lasts longer than 10 minutes (the default timeout), you can enter another value in minutes to keep the connection open longer. This option is only available in Power Query Desktop.

SQL statement

For information, go to Import data from a database using native database query. Include relationship columns

If checked, includes columns that might have relationships to other tables. If this box is cleared, you won’t see those columns. Navigate using full hierarchy

If checked, the navigator displays the complete hierarchy of tables in the database you're connecting to. If cleared, the navigator displays only the tables whose columns and rows contain data.

Enable SQL Server Failover support

If checked, when a node in the Azure SQL failover group isn't available, Power Query moves from that node to another when failover occurs. If cleared, no failover occurs.

 

 

NEW QUESTION 222

FILL IN THE BLANK - (Edutechnolab 4)

You need to create a measure that will return the percentage of late orders.

How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

 

 

 

1. Mastered
2. Not Mastered

 

Answer: A

 

Explanation:

 

 

Answer as below

 

 

 

NEW QUESTION 227

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?

 

1. area chart
2. donut chart
3. scatter plot
4. pie chart

 

Answer: C

 

Explanation:

Outliers are those data points that lie outside the overall pattern of distribution & the easiest way to detect outliers is though graphs. Box plots, Scatter plots can help detect them easily.

Reference:

https://towardsdatascience.com/this-article-is-about-identifying-outliers-through-funnel-plots-using-the-microsoft-power-bi-d7ad16ac9ccc

 

 

NEW QUESTION 228

In Power BI Desktop, you are creating a report that will contain three pages. You need to create a custom tooltip page and prepare the page for use.

Which three actions should you perform? Each correct answer presents part of the solution.

 

1. Configure filters on the target visual.
2. For the target page, set Allow use as tooltip to On.
3. Add and configure visuals on the tooltip page.
4. For the tooltip page, set Allow use as tooltip to On.
5. For the tooltip page, configure filters.

 

Answer: BCD

 

Explanation:

You can create a custom tooltip page that shows more details about the selected category, such as this: To create a custom tooltip page and prepare it for use, you need to perform these three actions34:

? Add and configure visuals on the tooltip page. You can add any visuals, images, or

other items that you want to show on the tooltip page. You can also format them as you like.

? For the tooltip page, set Allow use as tooltip to On. This will enable Power BI to

recognize this page as a tooltip page. You can also change the Page size to Tooltip to fit your content better.

? For the target visual, set Tooltip type to Report page. This will allow you to select

which report page you want to use as a custom tooltip for your visual. You can also filter your tooltip by fields from your target visual.

 

 

NEW QUESTION 231

HOTSPOT - (Edutechnolab 4)

You have a column named UnitslnStock as shown in the following exhibit

 

 

 

 

 

 

UnitsInStock has 75 non-null values, of which 51 are unique.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct

 

 

selection is worth one point.

 

 

1. Mastered
2. Not Mastered Answer: A Explanation:

 

 

 

 

 

NEW QUESTION 235

HOTSPOT - (Edutechnolab 4)

You have a dataset that contains revenue data from the past year.

You need to use anomaly detection in Power Bl to show anomalies in the dataset.

 

 

What should you configure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

 

 

1. Mastered
2. Not Mastered Answer: A Explanation:

 

 

 

NEW QUESTION 238

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have several reports and dashboards in a workspace.

You need to grant all organizational users read access to a dashboard and several reports. Solution: You publish an app to the entire organization. Does this meet the goal?

 

1. Yes
2. No

 

Answer: B

 

Explanation:

https://docs.microsoft.com/es-es/power-bi/collaborate-share/service-create- distribute-apps

 

 

NEW QUESTION 242

You have an on-premises Power BI Report Server.

You plan to create a report in Power BI Desktop and publish the report to the report server. Which data source should the report use?

 

1. Microsoft Azure SQL Database
2. a Microsoft SQL Server database
3. a Microsoft SQL Server Analysis Services (SSAS) database
4. Microsoft Excel

 

Answer: C

 

Explanation:

References:

https://docs.microsoft.com/en-us/power-bi/report-server/quickstart-create-powerbi-report https://docs.microsoft.com/en-us/power-bi/report-server/connect-data- sources

 

 

NEW QUESTION 247

HOTSPOT - (Edutechnolab 4)

 

 

You create a Power Bl dataset that contains the table shown in the following exhibit.

You need to make the table available as an organizational data type In Microsoft Excel.

How should you configure the properties of the table? To answer select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

 

 

1. Mastered
2. Not Mastered

 

 

 

Answer: A

 

 

 

 

NEW QUESTION 248

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.

You need to create a reference line to show which employees are above the median salary. Solution: You create a median line by using the Salary measure. Does this meet the goal?

 

1. Yes
2. No

 

Answer: A

 

Explanation:

The 50th percentile is also known as the median or middle value where 50 percent of observations fall below. Reference:

https://dash-intel.com/powerbi/statistical_functions_median.php

 

NEW QUESTION 251

HOTSPOT - (Edutechnolab 4)

You are profiling data by using Power Query Editor.

 

 

You have a table that contains a column named column1. Column statistics and Value distribution for column1 are shown in the following exhibit.
 

 

 

 

1. Mastered
2. Not Mastered 

Answer: A 

 

NEW QUESTION 254

You are creating a Power BI report to analyze consumer purchasing patterns from a table named Transactions. The Transactions table contains a numeric field named Spend. You need to include a visual that identifies which fields have the greatest impact on Spend. Which type of visual should you use?

 

1. decomposition tree
2. Q&A
3. smart narrative
4. key influences

 

Answer: D

 

 

NEW QUESTION 255

You have a Power BI report. The report contains visualizations that have interactions. You need to identify which visualizations take the longest to complete. What should you use?

 

1. SQL Server Profiler
2. Performance Analyzer in Power BI Desktop
3. Query Diagnostics in Power BI
4. Microsoft Edge DevTools

 

Answer: B

 

Explanation:

Use Power BI Desktop Performance Analyzer to optimize reports.

In Power BI Desktop you can find out how each of your report elements, such as visuals and DAX formulas, are performing. Using the Performance Analyzer, you can see and record logs that measure how each of your report elements performs when users interact with them, and which aspects of their performance are most (or least) resource intensive.

Reference:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-performance-analyzer

 

NEW QUESTION 259

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.

You have a Microsoft SQL Server database that contains the following tables.

 

 

The following columns contain date information:

• Date[Month] in the mmyyyy format
• Date[Date_ID] in the ddmmyyyy format
• Date[Date_name] in the mm/dd/yyyy format
• Monthly_returns[Month_ID] in the mmyyyy format The Order table contains more than one million rows.

The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables. You plan to use Power BI Desktop to create an analytics solution for the data.

You need to create a relationship between the Monthly_returns table and Date[Date_ID]. What should you do before you create the relationship?

 

1. In the Date table, create a new calculated column named MonthJD that uses the yyyydd format.
2. In the Monthly_returns table, create a new calculated column named DateJD that uses the ddmmyyyy format.
3. To the Order table, add a calculated column that uses the RELATED(Monthly_returns[Month_ID]) DAX formula.
4. To the Date table, add a calculated column that uses the RE LATE D(Monthly_ret urns [MonthJD]) DAX formula.

Answer: B

Explanation:

References:

https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

 

 

NEW QUESTION 261

You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATED and RELATEDTABLE functions.

You need to recommend a solution to minimize the use of the RELATED and RELATEDTABLE functions. What should you recommend?

 

1. Merge tables by using Power Query.
2. Hide unused columns in the model.
3. Split the model into multiple models.
4. Transpose.

 

Answer: A

 

Explanation:

Combining data means connecting to two or more data sources, shaping them as needed, then consolidating them into a useful query. When you have one or more columns that you’d like to add to another query, you merge the queries.

Note: The RELATEDTABLE function is a shortcut for CALCULATETABLE function with no logical expression.

CALCULATETABLE evaluates a table expression in a modified filter context and returns A table of values.

Reference:

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data

 

NEW QUESTION 263

You are using the key influencers visual to identify which factors affect the quantity of items sold in an order. You add the following fields to the Explain By field:

• Customer Country
• Product Category
• Supplier Country
• Sales Employee
• Supplier Name
• Product Name
• Customer City

The key influencers visual returns the results shown in the following exhibit.

 

 

 

What can you identify from the visual?

 

1. Customers in Austria order 18.8 more units than the average order quantity.
2. Customers in Boise order 20.37 percent more than the average order quantity.
3. Product Category positively influences the quantity per order.
4. Customers in Cork order lower quantities than average.

 

Answer: A

 

 

NEW QUESTION 264

HOTSPOT - (Edutechnolab 4)

 

 

You have a Power Bl report. You have the following tables.

You have the following DAX measure.

 

 

 

1. Mastered
2. Not Mastered 

Answer: A 

 

 

 

 

 

NEW QUESTION 266

HOTSPOT - (Edutechnolab 4)

You have two Azure SQL databases that contain the same tables and columns.

For each database, you create a query that retrieves data from a table named Customers. You need to combine the Customer tables into a single table. The solution must minimize

the size of the data model and support scheduled refresh in powerbi.com.

 

 

What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

 

 

1. Mastered
2. Not Mastered

 

Answer: A

 

Explanation:

Graphical user interface, text

Description automatically generated with medium confidence Box 1: Append Queries as New.

There are two primary ways of combining queries: merging and appending.

? When you have one or more columns that you’d like to add to another query, you merge the queries.

? When you have additional rows of data that you’d like to add to an existing query, you append the query. Box 2: Disable loading the query to the data model

For every query that loads into model memory will be consumed. and Memory is our asset in the Model, less memory consumption leads to better performance in most of the cases. The best approach is to disable loading.

 

 

NEW QUESTION 271

You have a Power Bl report hosted on powerbi.com that displays expenses by department for department managers. The report contains a line chart that shows expenses by month.

You need to enable users to choose between viewing the report as a line chart or a column chart. The solution must minimize development and maintenance effort.

What should you do?

 

1. Add a column chart, a bookmark, and a button for users to choose a visual.
2. Create a mobile report that contains a column chart.
3. Create a separate report page for users to view the column chart.
4. Enable report readers to personalize visuals.

 

Answer: C

 

 

NEW QUESTION 272

You have a Power Bl report that contains five pages. Pages 1 to 4 are visible and page 5 is hidden.

You need to create a solution that will enable users to quickly navigate from the first page to all the other visible pages. The solution must minimize development and maintenance effort as pages are added to the report.

What should you do first?

 

1. Add a blank button to page 1.
2. Add a bookmark navigation button to page 1.
3. Create a bookmark for each page.
4. Add a page navigation button to page 1.

Answer: A

 

NEW QUESTION 273

You have a Microsoft Excel file in a Microsoft OneDrive folder. The file must be imported to a Power Bi dataset You need to ensure that the dataset can be refreshed in powefbi.com.

Which two connectors can you use to connect to the file? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

1. Text/CSV
2. Folder
3. Excel Workbook
4. SharePoint folder
5. Web

 

Answer: BC

 

Explanation:

• Copy and edit Path of the Excel file then use "Web" Connector: Option E
• Copy and edit Path of the OneDrive folder then use "Sharepoint Folder" connector: Option D Source: https://www.youtube.com/watch?v=GGHbbg6yi-A

 

NEW QUESTION 275

HOTSPOT - (Edutechnolab 4)

You have a report in Power BI Desktop.

 

 

You add a key influencers visual as shown in the exhibit. (Click the Exhibit tab.)

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.

 

 

1. Mastered
2. Not Mastered

Answer: A

Explanation:

- 3

https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers?tabs=powerbi-desktop

 

NEW QUESTION 276

You have a Power BI data model that contains a table named Employees. The table has the following columns:

• Employee Name
• Email Address
• Start Date

You are implementing dynamic row-level security (RLS).

You need to create a table filter to meet the following requirements:

• Users must see only their own employee data
• The DAX expression must work in both Power 81 Desktop and the Power BI service. Which expression should you use?

 

Option A

1. Option B
2. Option C
3. Option D

Answer: B

 

NEW QUESTION 279

You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps. You need to create a Power BI report that connects to the project management app. Which connector should you select?

 

1. Microsoft Teams Personal Analytics
2. SQL Server database
3. Dataverse
4. Dataflows

Answer: C

 

NEW QUESTION 282

DRAG DROP - (Edutechnolab 4)

You have a Power B1 data model that contains two tables named Products and Sales. A one-to-many relationship exists between the tables. You have a report that contains a report-level filter for Products.

You need to create a measure that will return the percent of total sales for each product. The measure must respect the report-level filter when calculating the total. How should you complete the DAX measure? To answer drag the appropriate DAX functions to the correct targets- Each function may be used once, more than once, or not at all the spirt bar between panes or scroll to view content

 

 

NOTE: Each correct selection is worth one point

 

 

1. Mastered
2. Not Mastered 

Answer: A 

 

 

 

NEW QUESTION 285

You have a query that returns the data shown in the following exhibit.

 

 

 

You need to configure the query to display the data as shown in the following exhibit.

Which step should you use in the query?

 

A. =Table.ExpandListColum(Table.TransformColunins(Source, {{"classes". Splitter.SplitTextByDelimiter('','', QuoteStyle.None), let itemType - (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "classes")

B. = Table.Unpivot(Source, {"classes"}, "Attribute", "Value")

C. = Table.SplitColumn(Source, "classes". Splitter.SplitTextByDelimiterf",", QuoteStyle.None), {"classes.1"})

D. = Table.SplitColumn(Source, "classes". Splitter.SplitTextByPositions({10}), {"classes.1"})

 

Answer: B

 

Explanation:

Power Query Unpivot columns: You might want to unpivot data, sometimes called flattening the data, to put it in a matrix format so that all similar values are in one column. This is necessary, for example, to create a chart or a report.

Chart Description automatically generated Note:

Syntax: Table.Unpivot(table as table, pivotColumns as list, attributeColumn as text, valueColumn as text) as table Table.Unpivot translates a set of columns in a table into attribute-value pairs, combined with the rest of the values in each row. Reference:

https://docs.microsoft.com/en-us/power-query/unpivot-column https://docs.microsoft.com/en-us/powerquery-m/table-unpivot

NEW QUESTION 288

You are creating a dashboard by using the Power Bl service. You have an existing report page that contains three charts. You need to add the charts to the dashboard while maintaining the interactivity between the charts.

What should you do?

 

1. Pin each chart as a tile.
2. Edit interactions in the report and set all interactions to Filter
3. Edit the dashboard theme and pin each chart as a file.
4. Pin the report page as a live tile.

Answer: D

NEW QUESTION 293

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? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

 

1. Open the Advanced Editor.
2. Select Column quality.
3. Enable Column profiling based on entire dataset.
4. Select Column distribution.
5. Select Column profile.

Answer: CE

Explanation:

In Power query, the load preview by default is 1000 row. By default, the column quality also only looks at the first 1000 row. You can verify this by the status bar at the bottom of the Power query window. To change the profiling so it analyses the entire column of data, select the profiling status in the status bar. Then select Column profiling based on the entire data set.

https://theexcelclub.com/data-profiling-views-in-power-query-excel-and-power-bi/

 

NEW QUESTION 297

You have a Power Bi report. The report contains a visual that snows gross sales by date The visual has anomaly detection enabled. No anomalies ate detected

You need to increase the likelihood that anomaly detection will identify anomalies in the report. What should you do?

 

1. Add a data field to the Secondary values field weft
2. Increase the Sensitivity setting.
3. Increase the Expected range transparency setting,
4. Add a data field to the Legend field well

 

Answer: B

 

Explanation:

If you increase the sensitivity, the algorithm is more sensitive to changes in your data. In that case, even a slight deviation is marked as an anomaly. If you decrease the sensitivity, the algorithm is more selective on what it considers an anomaly. reference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi- visualization-anomaly-detection

 

NEW QUESTION 301

You create a report by using Microsoft Power BI Desktop.

The report uses data from a Microsoft SQL Server Analysis Services (SSAS) cube located on your company’s internal network. You plan to publish the report to the Power BI Service.

What should you implement ta ensure that users who consume the report from the Power BI Service have the most up-to-date data from the cube?

 

1. a subscription
2. a scheduled refresh of the dataset
3. an OData feed
4. an On-premises data gateway

 

Answer: D

 

Explanation:

When you’ve created dynamic reports in Power BI Desktop, you can share them by publishing to your Power BI site. When you publish a Power BI Desktop file with a live connection to a tabular model to your Power BI site, an on-premises data gateway must be installed and configured by an administrator.

 

NEW QUESTION 303

DRAG DROP - (Edutechnolab 4)

You plan to use Power BI to create a quarterly profit report that meets the following requirements:

• Emphasizes the percentage of total profits contributed by each product category in dollars and as a percentage
• Compares profit margins across sales regions

Which type of visual should you use for each requirement? To answer, drag the appropriate visuals to the correct requirements. Each visual may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

 

 

 

 

 

 

1. Mastered

Not Mastered Answer: A 

 

 

 

 

NEW QUESTION 307

 

 

You use Power 81 Desktop to load data from a Microsoft SQL Server database. While waiting for the data to load, you receive the following error.

You need to resolve the error.

What are two ways to achieve the goal? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point.

 

1. Split long running queries into subsets Of columns and use power Query to the queries
2. Disable query folding on long running queries
3. Reduce number of rows and columns returned by each query.
4. Use Power Query to combine long running queries into one query.

 

Answer: BD

 

NEW QUESTION 311

You have a Power BI dashboard that displays different visualizations of company sales. You enable Q&A on the dashboard.

You need to provide users with sample questions that they can ask when using Q&A. Which settings should you modify from the Power BI Settings?

 

1. Subscriptions
2. Dashboards
3. Datasets
4. Workbooks

 

Answer: C

 

Explanation:

References: https://docs.microsoft.com/en-us/power-bi/service-q-and-a-create-featured- questions

 

 

NEW QUESTION 315

DRAG DROP - (Edutechnolab 4)

You receive annual sales data that must be included in Power Bl reports.

From Power Query Editor, you connect to the Microsoft Excel source shown in the following exhibit.

 

 

You need to create a report that meets the following requirements:

• Visualizes the Sales value over a period of years and months
• Adds a slicer for the month
•    
  Adds a slicer for the year

 

 

 

1. Mastered

Not Mastered 

Answer: A 

 

NEW QUESTION 320

DRAG DROP - (Edutechnolab 4)

You use Power Query Editor to preview customer feedback data.

You need to use Al Insights to add a column of enhanced data based on the customer feedback. The solution must identify the following:

• What the customers most often provide feedback about
• Whether the customers like your company’s product
• The language of the feedback

Which Al Insights service should you use for each output? To answer, drag the appropriate services to the correct outputs. Each service may be used once, more than once. or not at all. You may need to drag the split bar between panes or scroll to view content.

 

 

NOTE: Each correct selection is worth one point.

 

 

1. Mastered
2. 

Not Mastered 

Answer: A 

 

 

 

NEW QUESTION 325

You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product. The Sales table contains purchase and ship dates.

Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together.

You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source. Which data modeling design should you use?

 

1. Use the Auto Date/Time functionality in Microsoft Power BI and do NOT import the Datetable.
2. Duplicate the Date query in Power Query and use active relationships between both Date tables.
3. On the Date table, use a reference query in Power Query and create active relationships between Sales and both Date tables in the modeling view.
4. Create an active relationship between Sales and Date for the purchase date and an inactive relationship for the ship date.

Answer: D

Explanation:

Only one relationship can be active.

Note: If you query two or more tables at the same time, when the data is loaded, Power BI Desktop attempts to find and create relationships for you. The relationship options Cardinality, Cross filter direction, and Make this relationship active are automatically set.

Reference:

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage- relationships

 

NEW QUESTION 326

HOTSPOT - (Edutechnolab 4)

You have a dataset named Pens that contains the following columns:

? Item

? Unit Price

? Quantity Ordered

You need to create a visualization that shows the relationship between Unit Price and Quantity Ordered. The solution must highlight orders that have a similar unit price and ordered quantity.

Which type of visualization and which feature should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

 

 

1. Mastered
2. Not Mastered

 

Answer: A

 

Explanation:

Box 1: A scatter plot...

A scatter chart always has two value axes to show: one set of numerical data along a horizontal axis and another set of numerical values along a vertical axis. The chart displays points at the intersection of an x and y numerical value, combining these values into single data points. Power BI may distribute these data points evenly or unevenly across the horizontal axis. It depends on the data the chart represents.

Box 2: Automatically find clusters

Scatter charts are a great choice to show patterns in large sets of data, for example by showing linear or non-linear trends, clusters, and outliers.

 

 

NEW QUESTION 328

HOTSPOT - (Edutechnolab 4)

 

 

You have the data lineage shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.

 

 

1. Mastered
2. Not Mastered

 

Answer: A

Explanation:

Box 1: CONTOSO BIKES report Box 2: three datasets Images, tweets and the Contoso datasets.

 

NEW QUESTION 330

 

 

You have a Power B1 report that contains the visuals shown in the following table.

You need to modify the location of each visual. What should you modify for each visual?

 

1. the layer order
2. the padding
3. the position
4. the tab order

Answer: C

 

NEW QUESTION 331

Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power BI.

You need to recommend an application lifecycle strategy. The solution must minimize access to production assets and prevent end users from viewing the development assets.

What should you recommend?

 

1. Create production reports in a separate workspace that uses a shared dataset from the developmentworkspac
2. Grant the end users access to the production workspace.
3. Create one workspace for developmen
4. From the new workspace, publish an app for production.
5. Create a workspace for development and a workspace for productio
6. From the production workspace,publish an app.
7. In one workspace, create separate copies of the assets and append DEV to the names of the copied asset
8. Grant the end users access to the workspace.

Answer: C

Explanation:

Use different work stages (Development, Test, and Production). Deploy from the Development workspace. Reference:

https://visualbi.com/blogs/microsoft/powerbi/application-lifecycle-management-power-bi/

 

NEW QUESTION 336

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59.

You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. What should you do?

1. Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
2. Change the data type of the Logged column to Date.
3. Split the Logged column by using at as the delimiter.
4. Apply a transformation to extract the first 11 characters of the Logged column.

 

Answer: C

Explanation:

Simply create a custom table in Power Query, enter the date shown in the question into a column called Date, and then Split it by a delimiter. No need for spaces on either side of "at" Power BI takes care of the rest:

= Table.SplitColumn(#"Changed Type", "Date", Splitter.SplitTextByDelimiter("at", QuoteStyle.Csv), {"Date.1", "Date.2"}) It will even automatically change the type to Date:

= Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Date.1", type date},

{"Date.2", type time}})

 

NEW QUESTION 338

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?

 

1. Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.
2. Publish the reports to a different workspace other than the one hosting the datasets.
3. Publish the reports in an app and grant the HR managers access permission.
4. Add the HR managers as members of the existing workspace that hosts the reports and the datasets.

Answer: C

Explanation:

Note: Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles. In the Power BI service, members of a workspace have access to datasets in the workspace. RLS doesn't restrict this data access.

Reference:

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

NEW QUESTION 342

 

 

You need to create a visual that enables the adhoc exploration of data as shown in the following exhibit.

Which type of visual should you use?

 

1. Q&A
2. decomposition tree
3. smart narrative
4. key influencers

 

Answer: B

NEW QUESTION 343

HOTSPOT - (Edutechnolab 4)

You are building a financial report by using Power BI.

You have a table named financials that contains a column named Date and a column named Sales.

You need to create a measure that calculates the relative change in sales as compared to the previous quarter.

How should you complete the measure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

 

 

1. Mastered
2. Not Mastered

 

Answer: A

 

Explanation:

Box 1: CALCULATE

Box 2: DATEADD

Box 3: DIVIDE

Example: NET_SALES QoQ% = IF( ISFILTERED('Calendar'[Date]),

ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."), VAR PREV_QUARTER = CALCULATE(

SUM('research ra_qtr_template'[NET_SALES]), DATEADD('Calendar'[Date].[Date], -1, QUARTER)

) RETURN DIVIDE(

SUM('research ra_qtr_template'[NET_SALES]) - PREV_QUARTER, PREV_QUARTER

 

NEW QUESTION 347

You have the dataset shown in the following exhibit.

 

 

 

 

You need to ensure that the visual shows only the 10 cities that have the highest sales profit. What should you do?

 

1. Add a Top N filter to the visual.
2. Configure the Sales Profit measure to use the RANKX function.
3. Add a calculated column to the table that uses the TOPN functio
4. In the visual, replace Sales Profit with the calculated column.
5. Add a calculated column to the table that returns the city name if the city is in the top 10, otherwise thecalculated column will return "Not in Top 10". In the visual, replace Sales Profit with the calculated column.

 

Answer: A

Explanation:

Power BI Top N Filters are useful to display the top performing records, and Bottom N filters are helpful to display the least performing records. For example, we can display top or bottom 10 products by orders or sales.

Note:

? Select the Column you want to display the Top Sales Profit

? Then change the Filter Type of that Column to Top N

? Fill in Top / Bottom number field

? And lastly drag to the By Value filed your Sales Profit Reference:

https://www.tutorialgateway.org/power-bi-top-10-filters/

 

 

NEW QUESTION 352

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You are modeling data by using Microsoft Power Bl. 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: You add a WHERE clause to the SQL statement. Does this meet the goal?

 

1. Yes
2. No

 

Answer: A

 

NEW QUESTION 356

In Power BI Desktop, you have a dataset that contains a table.

 

 

You create a table visual on a Power BI report page as shown in the following exhibit

You need to configure the visual to display the referenced image instead of the URL in the Plant Image column. What should you do?

 

1. Set the Data category of the Plant Image field to Image URL
2. Set the Data type of the Plant Image field to Binary.
3. Set the Data category of the Plant Image field to Web URL.
4. From the Formatting ta
5. select Values, and then set URL icons to On for the table.

Answer: A

 

NEW QUESTION 361

You have a Power BI app named App1. The privacy for the App1 workspace is set to Private.

A user named User1 reports that App1 does not appear in the My organization AppSource. App1 appears in the My organization AppSource for your account. You need to ensure that User sees App1 from the My organization AppSource. What should you do?

 

1. From the app workspace, click Update app, configure the Content settings, and then click Update app.
2. From the app workspace settings, add a member.
3. From the app workspace, click Update app, configure the Access setting, and then click Update app.
4. From the app workspace, share the dashboard.

 

Answer: C

 

Explanation:

References: https://docs.microsoft.com/en-us/power-bi/service-organizational-content-pack-introduction#what-is-appsource

 

NEW QUESTION 366

The Sales table contains records of sales by day from the last five years up until today's date.

You plan to create a measure to return the total sales Of March 2021 when March 2022 is selected. Which DAX expression should you use?

 

 

1. Option A
2. Option B
3. option C
4. Option D

 

Answer: B

 

 

NEW QUESTION 369

DRAG DROP - (Edutechnolab 4)

You have a Power Bl table named Customer that contains a field named Email Address. You discover that multiple records contain the same email address. You need to create a calculated column to identify which records have duplicate email addresses.

How should you complete the OAX expression for the calculated column? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content

NOTE: Each correct selection is worth one point.

 

 

 

 

 

 

 

 

1. Mastered
2. Not Mastered

Answer: A

Explanation:

You are to count the number of rows having same email address.

• 1. Declare a variable and call it any name you prefer
• 2. Calculate the row count on the table
• 3. Apply filter to ALL of the values in the table under the column name email address and equate it to the variable. You may need to read up filter functions for a proper understanding of how it works.

 

 

NEW QUESTION 372

You need to create a visualization that compares revenue and cost over time. Which type of visualization should you use?

 

1. stacked area chart
2. donut chart
3. line chart
4. waterfall chart

 

Answer: C

 

Explanation:

A line chart or line graph displays the evolution of one or several numeric variables. Data points are connected by straight line segments. A line chart is often used to visualize a trend in data over intervals of time – a time series – thus the line is often drawn chronologically.

Example:

 

 

Reference:

https://www.data-to-viz.com/graph/line.html

 

NEW QUESTION 373

You have a collection of reports for the HR department of your company.

You need to create a visualization for the HR department that shows a historic employee counts and predicts trends during the next six months. Which type of visualization should you use?

 

1. scatter chart
2. ribbon chart
3. line chart
4. key influences

 

Answer: C

 

Explanation:

The best data for forecasting is time series data or uniformly increasing whole numbers. The line chart has to have only one line.

Try forecasting: Try the new forecasting capabilities of Power View today on your own data or with the sample report available as part of the Power BI report samples. To view your own data, upload a workbook with a Power View time series line chart to Power BI for Office 365.

Reference:

https://powerbi.microsoft.com/en-us/blog/introducing-new-forecasting-capabilities-in-power-view-for-office-365

 

NEW QUESTION 374

 

 

ion have a Power BI dataset that contains a table named Temperature Readings. Temperature Readings contains the columns shown in the following table.

The table has 12 million rows. All the columns are needed for analysis.

You need to optimize the dataset to decrease the model size. The solution must not affect the precision of the data. What should you do?

 

1. Split the DateTime column into separate date and time columns.
2. Disable the Power Query load.
3. Round the Longitude column two decimal places.
4. Change the data type of the TempCelsius column to Integer

Answer: B

Explanation:

Disable Power Query load.

Power Query queries that are intended support data integration with other queries should not be loaded to the model. To avoid loading the query to the model, take care to ensure that you disable query load in these instances.

Reference:

https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction#disable-power-query-query-load

 

NEW QUESTION 378

HOTSPOT - (Edutechnolab 4)

You need to create a Power BI report. The first page of the report must contain the following two views:

*Sales By Postal Code

*Sales by Month

Both views must display a slicer to select a value for a field named Chain.

 

 

The Sales By Postal Code view must display a map visual as shown in the following exhibit.

The Sales By Month view must display a column chart visual as shown in the following exhibit.

 

 

 

 

Users must be able to switch between the views by using buttons on the report page. The selected Chain field must be maintained when switching between views. What is the minimum number of bookmarks required, and which property should you apply to each bookmark? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

 

 

1. Mastered
2. Not Mastered

Answer: A

Explanation:

Box 1: 2

Box 2: Display

 

NEW QUESTION 379

You import two Microsoft Excel tables named Customer and Address into Power Query Customer contains the following columns:

• Customer ID
• Customer Name
• Phone
• Email Address
• Address ID

Address contains the following columns:

• Address ID
• Address Line 1
• Address Line 2
• City
• State/Region
• Country
• Postal Code

 

Each Customer ID represents a unique customer m the Customer table. Each Address ID represents a unique address m the Address table. You need to create a query that has one row per customer. Each row must contain City. State/Region, and Country for each customer. What should you do?

 

1. Append the Customer and Address tables.
2. Transpose the Customer and Address tables.
3. Group the Customer and Address tables by the Address ID column.
4. Merge the Customer and Address tables.

 

Answer: D

 

NEW QUESTION 383

Your organization has a team of power users who recently created 20 Power BI dashboards. The power users share the dashboards with other users in the organization.

 

 

When the users attempt to access the dashboards, they receive the error message shown in the exhibit. (Click the Exhibit.)

You need to ensure that all the users can access the dashboards. What should you do first?

 

1. From the Microsoft Office 365 Admin center, and the Power BI (free) subscription, and then assign a license to each user.
2. From the Power BI Admin portal, modify the Privacy Settings.
3. From the properties of each dashboard, modify the Share dashboard settings.
4. Instruct each user to install Microsoft Office 2016.

 

Answer: A

 

Explanation:

References: http://www.nubo.eu/en/blog/2016/12/Enable-PowerBI-On-Office-365/

 

NEW QUESTION 388

You build a Power Bi report that displays loT temperature data streaming from a refrigerator. You publish the report to the Power BI service.

You need to be notified when the temperature rises above four degrees Celsius. What should you do?

 

1. Set an alert on a KPI visual in the report.
2. Pin a card visual to a dashboard and create a subscription.
3. Pin a card visual to a dashboard and set an alert on the tile.
4. Pin a report page to a dashboard and set an alert on the page.

 

Answer: A

 

NEW QUESTION 392

You are building a Power Bl report.

Users will view the report by using their mobile device.

You need to configure the report to display data based on each user s location.

Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

 

1. For the relevant columns, set synonyms to match common geographical terms.
2. From Power Query Editor, detect the data types of the relevant columns.
3. Use the columns of the geography data type in all visuals.
4. Create a hierarchy for columns of the geography data type.
5. In Data Category, set the geographic data category for the relevant columns.

Answer: CE

 

---