Latest PL-300 Exam Questions and Answers – Microsoft Power BI Data Analyst Prep

NEW QUESTION 1

-  (Exam Topic 1)

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?

A.  Apply row-level security (RLS) to the Region table based on the sales manager username.

B.  Configure a bi-directional relationship between Region and Sales.Region.

C.  Create a DAX calculated column that retrieves the region manager from the Weekly.Returns table based on the sales.regionjd column.

D.  In the Region table, create a hierarchy that has the manager name, and then the sales manager name.

Answer: C

NEW QUESTION 2

-  (Exam Topic 1)

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

A.  FORMAT('Date'[date], "MMM YYYY")

B.  FORMAT('Date' [date], "M YY")

C.  FORMAT('Date'[date_id], "MMM") & "" & FORMAT('Date'[year], "#")

D.  FORMAT('Date' [date_id], "MMM YYYY")

Answer: A

NEW QUESTION 3

-  (Exam Topic 1)

You publish the dataset to powerbi.com.

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

A.  Mastered

B.  Not Mastered

Answer: A

Explanation:

Graphical user interface, text, application, email Description automatically generated

NEW QUESTION 4

-  (Exam Topic 1)

What should you create to meet the reporting requirements of the sales department?

A.  a measure that uses a formula of SUM (Sales [sales_id])

B.  a calculated column that use a formula of COUNTA(sales [sales_id])

C.  a measure that uses a formula of COUNTROWS (Sales)

D.  a calculated column that uses a formula of SUM (Sales [sales_id])

Answer: C

Explanation:

The sale department requires reports that contain the number of sales transactions.

The COUNTROWS function counts the number of rows in the specified table, or in a table defined by an expression. Reference:

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

NEW QUESTION 5

-  (Exam Topic 1)

You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do?

A.  In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the calculated column to create a relationship to the Date table.

B.  Add the Weekly_Returns data to the Sales table by using related DAX functions.

C.  Create a new table based on the Date table where date-id is unique, and then create a many-to-many relationship to Weekly_Return.

Answer: A

Explanation:

Scenario: Region managers require a visual to analyze weekly sales and returns. To relate the two tables we need a common column.

NEW QUESTION 6

-  (Exam Topic 2)

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

A.  two imported datasets

B.  a single DirectQuery dataset

C.  two DirectQuery datasets

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

-  (Exam Topic 2)

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?

A.  Create a shared dataset for each standardized entity.

B.  Create dataflows for the standardized data and make the dataflows available for use in all imported datasets.

C.  For every report, create and use a single shared dataset that contains the standardized data.

D.  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 8

-  (Exam Topic 3)

You need to configure access for the sales department users. The solution must me meet the security requirements. What should you do?

A.  Add the sales department as a member of the reports workspace

B.  Add the Azure Active Directory group of the sales department as an Admin of the reports workspace.

C.  Distribute an app to the users in the Azure Active Directory group of the sales department.

D.  Share each report to the Azure Active Directory group of the sales department.

Answer: B

NEW QUESTION 9

-  (Exam Topic 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.

A.  Mastered

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

-  (Exam Topic 4)

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

A.  Mastered

B.  Not Mastered

Answer: A

NEW QUESTION 10

-  (Exam Topic 4)

You have multiple dashboards.

You need to ensure that when users browse the available dashboards from powerbi.com. they can see which dashboards contain Personally Identifiable Information (Pll). The solution must minimize configuration effort and impact on the dashboard design.

What should you use?

A.  Active Directory groups

B.  tiles

C.  data classifications

D.  comments

Answer: A

NEW QUESTION 15

-  (Exam Topic 4)

You have the Power BI data model shown in the following exhibit. Select the appropriate yes or no.

A.  Mastered

B.  Not Mastered

Answer: A

Explanation:

Graphical user interface, text, application, email Description automatically generated

NEW QUESTION 20

-  (Exam Topic 4)

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 BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.

During the development process, you need to import a sample of the data from the Order table. Solution: You add a WHERE clause to the SQL statement. Does this meet the goal?

A.  Yes

B.  No

Answer: A

Explanation:

The WHERE clause has its effects before the data is imported. Reference:

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

NEW QUESTION 25

-  (Exam Topic 4)

Each employee has one manager as shown in the ParentEmployeelD column, All reporting paths lead to the CEO at the top of the organizational hierarchy. You need to create a calculated column that returns the count of levels from each employee to the CEO. Which DAX expression should you use?

A.  Option A

B.  Option B

C.  option C

D.  Option D

Answer: B

NEW QUESTION 29

-  (Exam Topic 4)

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 edit the Product Category table query to match the desired Power BI model.

How should you complete the advanced query? 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 frag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

A.  Mastered

B.  Not Mastered

Answer: A

Explanation:

Graphical user interface, application Description automatically generated References:

https://msdn.microsoft.com/en-us/library/mt260776.aspx https://msdn.microsoft.com/en-us/library/mt260808.aspx

NEW QUESTION 34

-  (Exam Topic 4)

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?

A.  Feedback

B.  Subscribe

C.  Comments

D.  Mark as favorite

Answer: C

Explanation:

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

NEW QUESTION 38

-  (Exam Topic 4)

You plan to develop a Power BI report that has a bar chart to display the number of customers by location. You have a table named Customer that has the following columns:

•  Customer ID

•  CustomerName

•  Address

•  City

•  ProvState

•  Country

You need to allow users to drill down by location. The report will display the number of each customer by Country, and drill down to ProvState, and then to City. How should you configure the drill down in the bar chart?

A.  In the Value field, add Countr

B.  In the Legend field, add ProvState at the top, followed by City.

C.  In the Legend field, add Countr

D.  In the Axis field, add ProvState at the top, followed by City.

E.  In the Axis field, add Country at the top, followed by ProvState, and then City.

F.  In the Value field, add Country at the top, followed by ProvState, and then City.

Answer: C

Explanation:

References:

https://docs.microsoft.com/en-us/power-bi/guided-learning/visualizations#step-18 https://docs.microsoft.com/en-us/power-bi/power-bi-visualization-drill-down

NEW QUESTION 40

-  (Exam Topic 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.

A.  Mastered

B.  Not Mastered

Answer: A

Explanation:

Table Description automatically generated 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.

Reference:

https://tessellationtech.io/optimizing-power-bi-reports/

NEW QUESTION 43

-  (Exam Topic 4)

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

A.  stacked area chart

B.  donut chart

C.  line chart

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

Reference:

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

NEW QUESTION 46

-  (Exam Topic 4)

The table has the following columns.

You need to add a column that will be used to sort the Year Month column chronologically.

A.  Mastered

B.  Not Mastered

Answer: A

Explanation:

Answer as.

Graphical user interface, application Description automatically generated

NEW QUESTION 49

-  (Exam Topic 4)

You open a query in Power Query Editor.

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

A.  Show whitespace

B.  Column profile

C.  Column distribution

D.  Column quality

Answer: D

Explanation:

Column quality: In this section, we can easily see valid, Error and Empty percentage of data values associated with the Selected table. Note: In Power Query Editor, Under View tab in Data Preview Section we can see the following data profiling functionalities:

https://community.powerbi.com/t5/Community-Blog/Data-Profiling-in-Power-BI-Power-BI-Update-April-2019/

NEW QUESTION 51

-  (Exam Topic 4)

You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com. The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.

The report is a single page that contains 15 AppSource visuals and 10 default visuals.

Users say that the report is slow to load the visuals when they access and interact with the report. You need to recommend a solution to improve the performance of the report.

What should you recommend?

A.  Change any DAX measures to use iterator functions.

B.  Replace the default visuals with AppSource visuals.

C.  Change the imported dataset to DirectQuery.

D.  Remove unused columns from tables in the data model.

Answer: C

Explanation:

DirectQuery: No data is imported or copied into Power BI Desktop.

Import: The selected tables and columns are imported into Power BI Desktop. As you create or interact with a visualization, Power BI Desktop uses the imported data.

Benefits of using DirectQuery

There are a few benefits to using DirectQuery:

DirectQuery lets you build visualizations over very large datasets, where it would otherwise be unfeasible to first import all the data with pre-aggregation. Underlying data changes can require a refresh of data. For some reports, the need to display current data can require large data transfers, making reimporting data unfeasible. By contrast, DirectQuery reports always use current data.

The 1-GB dataset limitation doesn't apply to DirectQuery. Reference:

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

NEW QUESTION 56

-  (Exam Topic 4)

You have a Power BI workspace named BI Data that contains a dataset named BI Finance.

You have the Build permission for the 81 Finance dataset but you do NOT have permissions for the workspace, You need to connect to BI Finance and create a report.

Which actions should you perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

A.  From the Power BI service, create a dataflow to the dataset by using DirectQuery.

B.  From Power BI Desktop, connect to a Dataverse data source.

C.  From the Power BI service, create a new report and select a published dataset

D.  From Power Bl Desktop, connect to a shared dataset

Answer: BC

NEW QUESTION 57

-  (Exam Topic 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.

A.  Mastered

NEW QUESTION 61

-  (Exam Topic 4)

You manage a Power BI model has a table named Sales and product.

You need to ensure that a sales team can view only data that has a CountryRegionName value of United States and a ProductCategory value of Clothing. What should you do from Power BI Desktop?

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

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

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

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

Answer: D

Explanation:

References: https://docs.microsoft.com/en-us/power-bi/power-bi-how-to-report-filter

NEW QUESTION 64

-  (Exam Topic 4)

You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.

You need to load only the manufacturing reports to a table for analysis. What should you do in Microsoft Power Bl Desktop?

A.  Get data from a SharePoint Online folder, enter the site URL, and then select Combine & Load.

B.  Get data from a SharePoint Online list and enter the site UR

C.  Edit the query and filter by the path to the manufacturing reports library.

D.  Get data from a SharePoint Online folder and enter the site UR

E.  Edit the query and filter by the path to the manufacturing reports library.

F.  Get data from a SharePoint Online list, enter the site URL, and then select Combine & Load.

Answer: B

Explanation:

We have to import Excel files from SharePoint, so we need the connector SharePoint folder which is used to get access to the files stored in the library. SharePoint list is a collection of content that has rows and columns (like a table) and is used for task lists, calendars, etc. Since we have to filter only on manufacturing reports, we have to select Transform and then filter by the corresponding folder path.

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

NEW QUESTION 66

-  (Exam Topic 4)

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?

A.  Create a row-level security (RLS) role for each department, and then define the membership of the role.

B.  Create a DepartmentID parameter to filter the Departments table.

C.  To the ConfidentialData table, add a calculated measure that uses the currentgroup DAX function.

D.  Create a slicer that filters Departments based on DepartmentID.

Answer: A

NEW QUESTION 70

-  (Exam Topic 4)

You need to create a Power BI theme that will be used in multiple reports. The theme will include corporate branding for font size, color, and bar chart formatting. What should you do?

A.  From Power Bl Desktop, customize the current theme,

B.  From power Bl Desktop, use a built in report theme.

C.  Create a theme as a JSON file and import the theme into Power Bl Desktop.

D.  Create a theme as a PBIVlZ file and import the theme into Power Bl Desktop.

Answer: B

NEW QUESTION 73

-  (Exam Topic 4)

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?

A.  Option A

B.  Option B

C.  option C

D.  Option D

Answer: B

NEW QUESTION 75

-  (Exam Topic 4)

In the Power BI service, you create an app workplace that contains several dashboards.

You need to provide a user named user1@contoso.com with the ability to edit and publish dashboards. What should you do?

A.  Modify the members of the app workspace.

B.  Configure security for the dataset used by the app.

C.  Share the dashboard, and then modify the Access settings of the dashboard.

D.  From the app workspace, click Update app, and then configure the Access settings.

Answer: C

NEW QUESTION 80

-  (Exam Topic 4)

You attempt to connect Purer 81 Desktop to a Cassandra database.

From the Get Data connector list you discover that there is no specific connector for the Cassandra database, You need to select an alternate data connector that will connect to the database.

Which of connector should you choose?

A.  Microsoft SQL Server database

B.  ODBC

C.  OData

D.  OLE DB

Answer: B

NEW QUESTION 84

-  (Exam Topic 4)

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?

A.  Yes

B.  No

Answer: A

NEW QUESTION 86

-  (Exam Topic 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.

A.  Mastered

B.  Not Mastered

Answer: A

Explanation:

Graphical user interface, text, application, email Description automatically generated References: https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh

NEW QUESTION 89

-  (Exam Topic 4)

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?

A.  Yes

B.  No

Answer: A

Explanation:

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

NEW QUESTION 92

-  (Exam Topic 4)

You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields:

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.

A.  Open the Advanced Editor.

B.  Select Column quality.

C.  Enable Column profiling based on entire dataset.

D.  Select Column distribution.

E.  Select Column profile.

Answer: 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 96

-  (Exam Topic 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: see the explanation for answer.

A.  Mastered

NEW QUESTION 100

-  (Exam Topic 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.

A.  Mastered

NEW QUESTION 101

-  (Exam Topic 4)

You plan to embed multiple visualization in a public website.

Your Power BI infrastructure contains the visualizations configured as shown in the following table.

Which two visualizations can you embed into the website? Each correct answer presents a complete the solution. NOTE: Each correct selection is worth one point.

A.  Visual1

B.  Visual2

C.  Visual3

D.  Visual4

E.  Visual5

Answer: BD

Explanation:

References: https://docs.microsoft.com/en-us/power-bi/service-publish-to-web

NEW QUESTION 103

-  (Exam Topic 4)

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 Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets.

You need to recreate the Power View sheets as reports in the Power Bl service.

Solution: Copy the workbook to Microsoft OneDrive for Business. From Excel, click Publish to Power Bl, and then click Upload Does this meet the goal?

A.  Yes

B.  No

Answer: B

NEW QUESTION 108

-  (Exam Topic 4)

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 percentile line by using the Salary measure and set the percentile to 50%. Does this meet the goal?

A.  Yes

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

NEW QUESTION 109

-  (Exam Topic 4)

You have a line chart that shows the number of employees in a department over time. You need to see the total salary costs of the employees when you hover over a data point. What is possible way to achieve this goal?

A.  Add a salary to the tooltips.

B.  Add a salary to the visual filters.

C.  Add salary to the drillthrough fields.

Answer: A

Explanation:

Reference:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-tooltips https://technovids.com/power-bi-filters/

NEW QUESTION 111

-  (Exam Topic 4)

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

You have the following DAX measure.

A.  Mastered

NEW QUESTION 114

-  (Exam Topic 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.

A.  Mastered

B.  Not Mastered

Answer: A

Explanation:

Answer as selected

NEW QUESTION 118

-  (Exam Topic 4)

You are creating a Power Bi model and report.

You have a single table in a data mode) named Product Product contains the following fields:

•  ID

•  Name

•  Color

•  Category

•  Total Sales

You need to create a calculated table that shows only the top eight products based on the highest value in Total Sales.

How should you complete the DAX expression? To answer, drag the appropriate values to the coned 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.

A.  Mastered

NEW QUESTION 120

-  (Exam Topic 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.

A.  Mastered

NEW QUESTION 122

-  (Exam Topic 4)

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 add another table named Territory to the model. A sample of the data is shown in the following table.

You need to create a relationship between the Territory table and the Sales table.

Which function should you use in the query for Territory before you create the relationship?

A.  Table.RemoveMatchingRows

B.  Table.Distinct

C.  Table.InDistinct

D.  Table.ReplaceMatchingRows

Answer: B

Explanation:

References: https://msdn.microsoft.com/en-us/library/mt260775.aspx

NEW QUESTION 125

-  (Exam Topic 4)

You have a Power BI report.

You need to create a calculated table to return the 100 highest spending customers.

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.

A.  Mastered

B.  Not Mastered

Answer: A

Explanation:

Box 1: TOPN

TOPN returns the top N rows of the specified table. Box 2: SUMMARIZE

SUMMARIZE returns a summary table for the requested totals over a set of groups. Box 3: DESC Sort in descending order.

It is last in the TOPN command. TOPN syntax:

TOPN(<n_value>, <table>, <orderBy_expression>, [<order>[, <orderBy_expression>, [<order>]]…]) Reference: https://docs.microsoft.com/en-us/dax/topn-function-dax

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

NEW QUESTION 130

-  (Exam Topic 4)

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?

A.  Add a data field to the Secondary values field weft

B.  Increase the Sensitivity setting.

C.  Increase the Expected range transparency setting,

D.  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 133

-  (Exam Topic 4)

You build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success. Which type of visualization should you use?

A.  Key influences

B.  Funnel chart

C.  Q&A

D.  Line and clustered column chart

Answer: A

Explanation:

The key influencers visual helps you understand the factors that drive a metric you're interested in. It analyzes

your data, ranks the factors that matter, and displays them as key influencers. The key influencers visual is a great choice if you want to: See which factors affect the metric being analyzed.

Contrast the relative importance of these factors. For example, do short-term contracts have more impact on churn than long-term contracts? Reference:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers

NEW QUESTION 134

-  (Exam Topic 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

A.  Mastered

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

-  (Exam Topic 4)

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?

A.  Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the report-level filters.

B.  Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the page-level filters.

C.  Sync the Country slicer on page 1, page 2, and page 3,

D.  Move the Country slicer from page 2 and page 3 to page 1.

Answer: C

NEW QUESTION 140

-  (Exam Topic 4)

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?

A.  From the Microsoft Office 365 Admin center, and the Power BI (free) subscription, and then assign a license to each user.

B.  From the Power BI Admin portal, modify the Privacy Settings.

C.  From the properties of each dashboard, modify the Share dashboard settings.

D.  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 144

-  (Exam Topic 4)

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?

A.  Yes

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

-  (Exam Topic 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.

A.  Mastered

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

Reference:

https://docs.microsoft.com/en-us/power-query/append-queries

https://community.powerbi.com/t5/Power-Query/Append-vs-Append-as-new-for-performance/td-p/1822710

NEW QUESTION 151

-  (Exam Topic 4)

You have a Power Bl report for the marketing department. The report reports on web traffic to a blog and contains data from the following tables.

There is a one-to-many relationship from Posts to Traffic that uses the URL and URL Visited columns. The report contains the visuals shown in the following table. The dataset takes a long time to refresh.